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?

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: TNS:listener could not hand off client connection
Next Topic: How to designate a file for use
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:40:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.