Home » RDBMS Server » Server Utilities » Export of Database
Export of Database [message #72879] Sat, 29 November 2003 07:18 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
In oracle 8i for exporting the database, we use a command exp username/password full = y.
My doubt is what is this 'Y ' and for what it stands for.
Re: Export of Database [message #72881 is a reply to message #72879] Sat, 29 November 2003 16:33 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
Y stands for yes. When used in full=y it means yes, export in full database mode, export the entire database. If you do not specify full=y, then the default is full=n, where n stands for no. Please see the highlighted excerpts from Oracle on-line documentation below:

Export provides online help. Enter exp help=y on the command line to invoke it. 

Export: Release 8.1.6.0.0 - Production on Wed Oct 6 15:23:43 1999

(c) Copyright 1999 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            <b>FULL         export entire file (N)</b>
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
VOLSIZE  number of bytes to write to each tape volume

<b>FULL
Default: N 

Indicates that the Export is a full database mode Export (that is, it exports the entire database). Specify FULL=Y to export in full database mode. You need the 
EXP_FULL_DATABASE role to export in this mode. 
</b>
Previous Topic: Cold Backup
Next Topic: import of TAB table from backup
Goto Forum:
  


Current Time: Sat Jun 29 06:39:32 CDT 2024