OraFAQ Forum: Server Administration » Remove tables from one tablespace to another

Home » RDBMS Server » Server Administration » Remove tables from one tablespace to another

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

Remove tables from one tablespace to another [message #58519]

Thu, 04 September 2003 09:48

June Wang
Messages: 5
Registered: August 2003

Junior Member

I try to use command 'alter table xxx move tablespace ttt' to move tables from one tablespace to another. It will remain all grants and the objects depend on those tables. But it has only a single thread when move parallel degree tables (slow) and also gets errors if table has long type column(s). Is there any better way to do it? Thanks.

Report message to a moderator

Re: Remove tables from one tablespace to another [message #58522 is a reply to message #58519]

Thu, 04 September 2003 11:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is true that it is slower.
But i always prefer it becuase, it does the job neatly.
You cannot move a table with long column and that is restriction with long column.
try to export and re-import in another tablespace~

Report message to a moderator

Re: Remove tables from one tablespace to another [message #58526 is a reply to message #58522]

Thu, 04 September 2003 13:00

June Wang
Messages: 5
Registered: August 2003

Junior Member

Export/import also will not do parallel. Only SQL load or create new table and insert into, of cause you have a lot of to do, create indexes, grants, etc.

Report message to a moderator

Re: Remove tables from one tablespace to another [message #58555 is a reply to message #58526]

Tue, 16 September 2003 18:34

Peter
Messages: 62
Registered: August 2000

Member

Create an indexfile (using the import utility) to get table definition. drop and re-create the tables(in the new tablespaces) and import the data. If you want to use sqlload just pre-create the tables run the load and then afterward run and import with rows=n this will import all the grant constraint and indexes etc.

Report message to a moderator

Re: Remove tables from one tablespace to another [message #58567 is a reply to message #58555]

Wed, 17 September 2003 09:15

June
Messages: 2
Registered: November 2001

Junior Member

Thanks.

Report message to a moderator

Previous Topic:	ARCHIVE and NO ARCHIVE !?!?!
Next Topic:	Any other ways of doing same?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:37:27 CDT 2024