Home » RDBMS Server » Server Administration » Moving objects to a new tablespace (Oracle 9.2.0.4.0)
Moving objects to a new tablespace [message #335654] Wed, 23 July 2008 02:51 Go to next message
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.

Re: Moving objects to a new tablespace [message #335657 is a reply to message #335654] Wed, 23 July 2008 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Moving objects to a new tablespace [message #338011 is a reply to message #335654] Sat, 02 August 2008 04:49 Go to previous messageGo to next message
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
Re: Moving objects to a new tablespace [message #338012 is a reply to message #338011] Sat, 02 August 2008 05:37 Go to previous messageGo to next message
pablolee
Messages: 2834
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'
icon4.gif  Re: Moving objects to a new tablespace [message #338242 is a reply to message #335654] Mon, 04 August 2008 05:28 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Shocked How we can move a tablespace?
Re: Moving objects to a new tablespace [message #338247 is a reply to message #338242] Mon, 04 August 2008 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Moving objects to a new tablespace [message #338251 is a reply to message #335654] Mon, 04 August 2008 05:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Is not it datafile moving?
Re: Moving objects to a new tablespace [message #338260 is a reply to message #338251] Mon, 04 August 2008 05:59 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Creating TableSpace
Next Topic: Purge logs
Goto Forum:
  


Current Time: Sun Dec 04 04:48:57 CST 2016

Total time taken to generate the page: 0.12094 seconds