SQL Invoking Export

We can use Export in three different ways as listed below:

Interactive method
Parameter File method
Command line method

Interactive method

We can use Export more interactively by letting it to prompt for the information it needs. One can accomplish this by entering 'exp' in the command line. An example follows, to illustrate the Interactive method.

In this example let us take a back up of one database user. To accomplish this, we need to use exports in User mode. Follow the steps in the same order as given below.

Example I

Enter 'exp' in the command line as shown below and press ENTER
$ exp
It will prompt for the user name and password. Enter user name and Oracle pass word in the corresponding prompt and press ENTER to view the following statement.

ENTER ARRAY FETCH BUFFER SIZE :4096 >
It determines the space available to buffer rows, the default is adequte, so press ENTER)

Export file :EXPDAT.DMP>
It indicates the name of the export file, by default it is EXPDAT.DMP. Accept the default or change it to a more meaningful name like BACKUP.DMP)

U(sers) or T(ables) (Y/N) : Y >
at indicates the Export modes Since we want a back up of database user, accept the default.)

Export Grants (Y/N): Y> (Accept the default, to export grants)

Compress extents
(Accept the default to compress table data to one extent)
We will now observe the following output for the user JOHN
about to export john's objects ....
exporting snapshots
exporting snapshot logs
exporting job queues
exporting refresh groups and children
exporting database links
exporting sequence numbers
exporting cluster definitions
about to export john's tables
exporting table accounts - 2 rows exported
exporting table admin - 8 rows exported
exporting table mktg - 0 rows exported
exporting synonyms
exporting views
exporting stored p rocedures
exporting referential integrity constraints
exporting triggers exporting posttable actions
exporting terminated successfully without warnings

Parameter file method

In the parameter file method, as the name suggests we can specify Export parameters in a file. This is the most preferred method because of its reusability. In the command line we need to mention the following.

Exp parfile - filename (The parfile option allows us to specify export parameters in a file)

Let us have a look at the following example. It is equivalent to interactive method.

Example 2 Create a file named param and specify the following parameters in the file.

file = backup.dmp
grants = y
indexes - y
compress = y
owner = john
Then, in the command line enter yhe following
$ exp parfile - parm

Command line method

The parameters that are specified in a parameter file can also be specified on the command line.

$ exp used - john/jim file - backup.dmp grants = y indexes= y compress = y

Domain Name Search