RE: Move table to another tablespace

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 
<ORACLE-L_at_fatcity.com>       
                    <NIRMALK_at_qtel.       cc:                                           
                            
                    com.qa>              Subject:     RE: Move table to another 
tablespace                         
                    Sent by:                                                           
                            
                    root_at_fatcity.c                                                     
                            
                    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:   G.Plivna_at_itsystems.lv [SMTP:G.Plivna_at_itsystems.lv]
     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

                         om_at_ica.se            To:     Multiple recipients
     of list ORACLE-L <ORACLE-L_at_fatcity.com>
                         Sent by:             cc:

                         root_at_fatcity.c       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: Roland.Skoldblom_at_ica.se


     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: ListGuru_at_fatcity.com (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: G.Plivna_at_itsystems.lv


     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: ListGuru_at_fatcity.com (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: G.Plivna_at_itsystems.lv

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: ListGuru_at_fatcity.com (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).