Your second step
2)alter user scott default tablespace tools,(before it's users)
isn't that I explained in previous mail.
In this case You have to
1) drop emp table
2) either alter user scott with another default tablespace or specify
another tablespace in create table clause
3) create emp table again (of course check all constraints, triggers,
indexes etc.)
You can check tablespace of your tables in tablespace_name column of data
dictionary view user_tables
Gints Plivna
IT Sist�mas, Mer�e�a 13, LV1050 R�ga
http://www.itsystems.lv/gints/
Nirmal Kumar
Muthu Kumaran To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<NIRMALK@qtel. cc:
com.qa> Subject: RE: Move table to another
tablespace
Sent by:
[EMAIL PROTECTED]
om
2001.10.25
15:25
Please respond
to ORACLE-L
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).
--
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).
