Oracle-L: RE: full exp/imp of user to new tablespace; same user

From: MURAT BALKAS <murat.balkas_at_o2.net.tr>
Date: Thu, 07 Nov 2002 22:48:27 -0800
Message-ID: <F001.004FE90A.20021107224827@fatcity.com>

Hi,

is there anything else to do if moved tables have some indexes.

Murat

                                                                                                                                       
                      Stephen Lee                                                                                                      
                      <slee_at_dollar.com>        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      Sent by:                 cc:                                                                                     
                      root_at_fatcity.com         Subject:  RE: full exp/imp of user to new tablespace; same user                         
                                                                                                                                       
                                                                                                                                       
                      11/07/2002 05:14                                                                                                 
                      PM                                                                                                               
                      Please respond to                                                                                                
                      ORACLE-L

-----Original Message-----
I have a full export of user to where I need to import all his objects/grants
but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.

I have done many export/imports of user schemas without any problems in getting the entire schema. You shouldn't need to do anything special.

To change the objects to a new tablespace: Drop the objects from the old tablespace; set the new tablespace to be the schema's default tablespace; set the schema's quota on the old tablespace(s) to be 0.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: MURAT BALKAS
  INET: murat.balkas_at_o2.net.tr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Fri Nov 08 2002 - 00:48:27 CST