RE: Move table to another tablespace

Robertson Lee - lerobe Thu, 25 Oct 2001 06:45:34 -0700

Title: RE: Move table to another tablespace

Nirmal,

You need to use import with the indexfile option. Edit the file created at this step to change the location of the tablespace, run this file against the DB to create the objects then import the data with ignore=y.

Lee

-----Original Message-----
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 14:25
To: Multiple recipients of list ORACLE-L
Subject: RE: Move table to another tablespace

hi...

can you give the exact steps for ur 2nd option.

1)exp scott/tiger tables=emp,
2)alter user scott default tablespace tools,(before it's users)
3)imp scott/tiger fromuser=scott touser=scott

But still oracle imports to users tablespace itself.
i made users tablespace off, before import, that case, i kicked away by an error, as tablepsace is in offline.

Expecting your answer.

Rgds,
Nirmal.,

-----Original Message-----
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, October 25, 2001 3:25 PM
To:     Multiple recipients of list ORACLE-L
Subject:        Re: Move table to another tablespace

above 8.<something>
alter table <table_name> move tablespace <tablespace_name>;

Or always you can
1. export table
2. recreate in another tablespace
3. import data in table created in step 2.

Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/


                    Roland.Skoldbl
                    [EMAIL PROTECTED]            To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
                    Sent by:             cc:
                    [EMAIL PROTECTED]       Subject:     Move table to another tablespace
                    om


                    2001.10.25





The information contained in this communication is

confidential, is intended only for the use of the recipient

named above, and may be legally privileged. If the reader 

of this message is not the intended recipient, you are

hereby notified that any dissemination, distribution or

copying of this communication is strictly prohibited.  

If you have received this communication in error, please 

re-send this communication to the sender and delete the 

original message or any copy of it from your computer

system.

RE: Move table to another tablespace

Reply via email to