-----Original Message-----
hi ari,
             been to your homepage and i just wanted to know whether you
could send me a copy of an export script file. It would help me a great

----- Reply -------------

I have written some good examples of this in the "Using Oracle8" and "Special Edition Using Oracle8", both by Que.

Oracle can give you the syntax by typing "exp help=Y" or "exp80 help=Y" (depending on your OS):

exp help=y

Export: Release - Production on Thu Sep 17 17:11:20 1998

(c) Copyright 1998 Oracle Corporation.  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 file (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)
ROWS     export data rows (Y)         PARFILE      parameter filename
CONSTRAINTS export constraints (Y)    CONSISTENT   cross-table consistency
LOG      log file of screen output    STATISTICS   analyze objects (ESTIMATE)
DIRECT   direct path (N)
FEEDBACK display progress every x rows (0)
POINT_IN_TIME_RECOVER   Tablespace Point-in-time Recovery (N)
RECOVERY_TABLESPACES    List of tablespace names to recover
VOLSIZE  number of bytes to write to each tape volume

So, an example could be:

exp userid=system/manager full=y

This will export the entire database.

exp userid=system/manager owner=ADAM tables=EMPLOYEE log=export.log

This will export the EMPLOYEE table from the ADAM schema, and maintain a log of the export session in the export.log file.

Hope this helps!

-Ari Kaplan

Back to Ari Kaplan's Home Page ht="18"> Back to Ari Kaplan's Home Page