Re: exporting data oracle 8.1.6

In our last gripping episode "Alex S Blinetskiy" <admin_at_scorpions.net> wrote:
> What's the right syntaxt to export data from user table using system
> account?
>
> Thanks,
> Alex
>
>

I shall presume you wish to export a specific user's objects from the database. The basic syntax is:

exp system/<password> file=<user>.dmp owner=<user>

This will export all objects for <user> in a file named <user>.dmp, taking default values for other specifiable parameters.

The other parameters that can be passed to exp:

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)
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)              TRIGGERS     export triggers (Y)
FEEDBACK display progress every x rows (0)
FILESIZE maximum size of each dump file
QUERY    select clause used to export a subset of a table

The following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE export transportable tablespace metadata (N)
TABLESPACES list of tablespaces to transport

I hope this helps.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/