OraFAQ Forum: Server Administration » Moving objects to a new tablespace

Home » RDBMS Server » Server Administration » Moving objects to a new tablespace (Oracle 9.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving objects to a new tablespace [message #335654]

Wed, 23 July 2008 02:51

saharookiedba
Messages: 56
Registered: September 2007
Location: PUNE

Member

Hi,

I have created a new tablespace say X and assined all the users in system other than sys, to X.

now i have to move the objects under these users to X and rebuild the indexes..

i will move the tables unser these user using

ALTER TABLE <<table_name>> MOVE TABLESPACE <<tablespace_name>>

what should be done with objects like VIEWS, SYNONYMS, PROCEDURES.

Report message to a moderator

Re: Moving objects to a new tablespace [message #335657 is a reply to message #335654]

Wed, 23 July 2008 03:05

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

These other objects are not segments that is they are just code or definition and have no storage, so they can't be moved.

Regards
Michel

Report message to a moderator

Re: Moving objects to a new tablespace [message #338011 is a reply to message #335654]

Sat, 02 August 2008 04:49

malikjee
Messages: 80
Registered: May 2007
Location: lahore

Member

Hi there!

When you move tablespace then all its object automatically move to new location mostly.

Regards,
Malik

Report message to a moderator

Re: Moving objects to a new tablespace [message #338012 is a reply to message #338011]

Sat, 02 August 2008 05:37

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

malikjee wrote on Sat, 02 August 2008 10:49

Hi there!

When you move tablespace then all its object automatically move to new location mostly.

Regards,
Malik

Well for a start, the OP is not asking about 'moving a tablespace'

Report message to a moderator

Re: Moving objects to a new tablespace [message #338242 is a reply to message #335654]

Mon, 04 August 2008 05:28

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

How we can move a tablespace?

Report message to a moderator

Re: Moving objects to a new tablespace [message #338247 is a reply to message #338242]

Mon, 04 August 2008 05:38

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

alter tablespace ... offline
!cp file
alter database datafile '...' rename '...'
alter tablespace .. online

Regards
Michel

Report message to a moderator

Re: Moving objects to a new tablespace [message #338251 is a reply to message #335654]

Mon, 04 August 2008 05:47

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Is not it datafile moving?

Report message to a moderator

Re: Moving objects to a new tablespace [message #338260 is a reply to message #338251]

Mon, 04 August 2008 05:59

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Tablespace is just a set of files.
If you want to strictly speak then there is no table move.

Regards
Michel

Report message to a moderator

Previous Topic:	Creating TableSpace
Next Topic:	Purge logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 14:55:10 CDT 2024