Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question regarding import and export
oops:
D:\Oracle\product\8.1.7\BIN>exp help=y
Export: Release 8.1.7.4.1 - Production on Mon Dec 5 12:31:15 2005
(c) Copyright 2000 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)
The following keywords only apply to transportable tablespaces TRANSPORT_TABLESPACE export transportable tablespace metadata (N) TABLESPACES list of tablespaces to transport
Export terminated successfully without warnings.
Transportable tablespaces are supported in 8.1.7.
-bdbafh Received on Mon Dec 05 2005 - 11:33:08 CST