Home » RDBMS Server » Server Administration » Move objects between tablespaces
Move objects between tablespaces [message #189470] Thu, 24 August 2006 14:26 Go to next message
dmunaretto
Messages: 7
Registered: August 2006
Junior Member
Is it possible move objects between tablespaces?

[Updated on: Thu, 24 August 2006 14:30]

Report message to a moderator

Re: Move objects between tablespaces [message #189471 is a reply to message #189470] Thu, 24 August 2006 14:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Sure...which objects do you have in mind?
Re: Move objects between tablespaces [message #189474 is a reply to message #189471] Thu, 24 August 2006 14:47 Go to previous messageGo to next message
dmunaretto
Messages: 7
Registered: August 2006
Junior Member
In the truth, I carried through one import full of one schema and the objects of this import had been to a wrong tablespace.
Re: Move objects between tablespaces [message #189476 is a reply to message #189474] Thu, 24 August 2006 14:52 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you don't want to re-import the objects, you can ALTER TABLE ... MOVE and ALTER INDEX ... REBUILD and specify the new tablespace.
Previous Topic: TNS:listener could not hand off client connection
Next Topic: How to designate a file for use
Goto Forum:
  


Current Time: Fri Dec 09 10:06:36 CST 2016

Total time taken to generate the page: 0.08550 seconds