-----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
deal.
Adam
----- Reply -------------
Adam,
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 8.0.5.0.0 - 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)
Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
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
www.arikaplan.com
Back to Ari Kaplan's Home Page