Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: EXPORT questions

Re: EXPORT questions

From: <Ravinder_Bahadur_at_singaporeair.com.sg>
Date: Tue, 19 Jun 2001 04:10:19 -0700
Message-ID: <F001.0032E65D.20010619033523@fatcity.com>

Dear Seema,

           If you take export using sys user you will be exporting the base tables also which is not good when recreating your database from scratch and using import to transfer database accross. To avoid this we use the system user which only exports the views and not the base tables.

Regards

                                                                                       
        
                    "Seema Singh"                                                      
        
                    <oracledbam_at_ho        To:     Multiple recipients of list ORACLE-L 
        
                    tmail.com>            <ORACLE-L_at_fatcity.com>                       
        
                    Sent by:              cc:                                          
        
                    root_at_fatcity.c        Subject:     EXPORT questions                
        
                    om                                                                 
        
                                                                                       
        
                                                                                       
        
                    19-Jun-2001                                                        
        
                    03:48 AM                                                           
        
                    Please respond                                                     
        
                    to ORACLE-L                                                        
        
                                                                                       
        
                    Sender Info:                                                       
        
                    No Sender Info                                                     
        
                    found in the                                                       
        
                    address Book                                                       
        
                                                                                       
        
                                                                                       
        




hi
What is diffrent between the full export taken by sys user and system user? Why people prefer the system user to take full export? If any one can take full export with sys user in FGAC case then how to import incase of recovery means from sys user itself likefollowing command. imp userid=sys/chane-on-install file=test.exp fromuser=one touser=one Thanks in advance.
-Seema



Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  INET: oracledbam_at_hotmail.com

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). ______________________________________________________________________________________ Visit us at www.singaporeair.com. ______________________________________________________________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Ravinder_Bahadur_at_singaporeair.com.sg 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).
Received on Tue Jun 19 2001 - 06:10:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US