Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > Oracle > exp     

Example exp parfile for Oracle full export


Here's an example of parfile for exporting the whole database without data (no rows):

FILE=DBNAME.dmp
COMPRESS=N
ROWS=N
LOG=DBNAMEexp.log
FULL=Y


Run from command line:

$ . oraenv
$ ORACLE_SID = [DBNAME] ?
$
$ exp parfile=DBNAMEexp.par
Export: Release 8.1.7.4.0 - Production on Wed May 10 10:20:48 2006

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Username: / as sysdba


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

     (Average: 3.6 / Votes: 5)   Rate this tip:    

Start discussion or add comment to this tip

  Details
Tip reference : #101
views : 24905
Added on : 05/10/06
Submited by : h8dk97
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (202)
 
 
<< Previous Next >>
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Mobile Phones / Tablets | Office Software
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com