OraFAQ Forum: Server Administration » Moving table to new tablespace

Home » RDBMS Server » Server Administration » Moving table to new tablespace

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

Moving table to new tablespace [message #55460]

Fri, 24 January 2003 23:58

kiran kumar
Messages: 17
Registered: June 2001

Junior Member

Can I move a table from one tablespace to another in Oracle 8.0.5?
Please reply, this is urgent.

Thanks,
kiran

Report message to a moderator

Re: Moving table to new tablespace [message #55461 is a reply to message #55460]

Sat, 25 January 2003 07:06

Mohd Samiuddin
Messages: 2
Registered: January 2003

Junior Member

To move table from one tablespace to another do the following

1. Export the table.
2. Drop the table.
3. Create the table manually in proper tablespace.
4. Import the rows of the table with ignore=y option.

If you have 8i then you can simply give the following
command.
alter table emp move tablespace
users_data;

Report message to a moderator

Re: Moving table to new tablespace [message #55472 is a reply to message #55461]

Sun, 26 January 2003 21:50

kareka
Messages: 18
Registered: January 2003

Junior Member

will this move command also move the attached triggers and other objects

Report message to a moderator

Re: Moving table to new tablespace [message #55478 is a reply to message #55461]

Mon, 27 January 2003 03:57

Mike
Messages: 417
Registered: September 1998

Senior Member

A trigger is not a data segment like a table or a index, it is just a code like a view.

The trigger definitions are stored in SYS tables and those are always stored on the system tablespace.

HTH
Mike

Report message to a moderator

Re: Moving table to new tablespace [message #55507 is a reply to message #55461]

Tue, 28 January 2003 03:24

kareka
Messages: 18
Registered: January 2003

Junior Member

thanks.....so can i move tables among tablespaces without affecting data integrity and user access...or will these codes and triggers will have to be recompiled.....

i would also like to know if there is provision to export schema including all objects (sequences etc.)

Report message to a moderator

Previous Topic:	Deleting dba_tablespaces
Next Topic:	Oracle Installation problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:52:31 CDT 2024