Home » RDBMS Server » Server Utilities » Exports (2003)
Exports [message #349808] Tue, 23 September 2008 03:36 Go to next message
Messages: 9
Registered: July 2008
Junior Member
I am new to oracle dba, in the below statement what is the use of log=emp.log.

exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no
exp scott/tiger file=emp.dmp tables=(emp,dept)

Also please tell me the syntax for exporting the whole database???

Thank you
Re: Exports [message #349814 is a reply to message #349808] Tue, 23 September 2008 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Export is NOT a backup strategy.

C:\Oracle\ora102\RDBMS\ADMIN>exp help=y

Export: Release - Production on Tue Sep 23 10:51:13 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

You can let Export prompt you for parameters by entering the EXP
command followed by your username/password:

     Example: EXP SCOTT/TIGER

Or, you can control how Export runs by entering the EXP command followed
by various arguments. To specify parameters, you use keywords:

     Format:  EXP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
               or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

Keyword    Description (Default)      Keyword      Description (Default)
USERID     username/password          FULL         export entire file (N)
BUFFER     size of data buffer        OWNER        list of owner usernames
FILE       output files (EXPDAT.DMP)  TABLES       list of table names
COMPRESS   import into one extent (Y) RECORDLENGTH length of IO record
GRANTS     export grants (Y)          INCTYPE      incremental export type
INDEXES    export indexes (Y)         RECORD       track incr. export (Y)
DIRECT     direct path (N)            TRIGGERS     export triggers (Y)
LOG        log file of screen output  STATISTICS   analyze objects (ESTIMATE)
ROWS       export data rows (Y)       PARFILE      parameter filename
CONSISTENT cross-table consistency(N) CONSTRAINTS  export constraints (Y)

OBJECT_CONSISTENT    transaction set to read only during object export (N)
FEEDBACK             display progress every x rows (0)
FILESIZE             maximum size of each dump file
FLASHBACK_SCN        SCN used to set session snapshot back to
FLASHBACK_TIME       time used to get the SCN closest to the specified time
QUERY                select clause used to export a subset of a table
RESUMABLE            suspend when a space related error is encountered(N)
RESUMABLE_NAME       text string used to identify resumable statement
TTS_FULL_CHECK       perform full or partial dependency check for TTS
TABLESPACES          list of tablespaces to export
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TEMPLATE             template name which invokes iAS mode export

Export terminated successfully without warnings.

Re: Exports [message #349820 is a reply to message #349808] Tue, 23 September 2008 03:59 Go to previous messageGo to next message
Messages: 9
Registered: July 2008
Junior Member
Thanks a lot
Re: Exports [message #349853 is a reply to message #349808] Tue, 23 September 2008 05:25 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is "2003" in your topic's title? Oracle database version? Operating system version? A year you remember for great holidays you had?

I'm just kidding; however, perhaps you'd want to read the OraFAQ Forum Guide. It would help you ask questions and - at the same time - other Forum members answer them much more easy.

Although command prompt help helps, you might be interested in reading the documentation; this is the Oracle 10g Utilities book; as you deal with Export and Import, check chapter 19: Original Export and Import.
Previous Topic: SQL LOADER
Next Topic: Original Export with Query Parameter
Goto Forum:

Current Time: Thu Aug 17 08:50:44 CDT 2017

Total time taken to generate the page: 0.14070 seconds