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
13:00
Please respond
to ORACLE-L
Hallo,
Can you please tell how to move one table from one tablespace to another? I
have data inthistable.
Thanks in advance
Roland Sk�ldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
