OraFAQ Forum: Server Administration » moving few tables from on tablespace to another

Home » RDBMS Server » Server Administration » moving few tables from on tablespace to another

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

moving few tables from on tablespace to another [message #57426]

Sun, 15 June 2003 22:34

Srinivas
Messages: 138
Registered: June 2000

Senior Member

hi experts,
i want to move some tables (not all) from one tablespace to another tablespace in the same database.
i am working oracle 9i. Is there any mehod for this other than export,recreation,import?
please help me.
thanks in advance
Srinivas

Report message to a moderator

Re: moving few tables from on tablespace to another [message #57430 is a reply to message #57426]

Mon, 16 June 2003 01:20

Jürgen Lange
Messages: 2
Registered: June 2003

Junior Member

You could use the "Reorganisation Assistant" of of the Enterprise Manager !

Report message to a moderator

Re: moving few tables from on tablespace to another [message #57436 is a reply to message #57426]

Mon, 16 June 2003 05:51

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

Senior Member
Account Moderator

please followup with this posting.

http://www.orafaq.net/msgboard/sql/messages/20896.htm

and it would be followed with the post by a Steven Karam.
Please go through that also.

Report message to a moderator

Re: moving few tables from on tablespace to another [message #57446 is a reply to message #57426]

Mon, 16 June 2003 12:21

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi,
alter table tablename move tablespace Tblspace_name;
would do the job...
as what mahesh said :)

sai

Report message to a moderator

Previous Topic:	Fragmentation
Next Topic:	Can I install Oracle 8.1.7 on Solaris without a monitor?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:26:59 CDT 2024