Export of full database

 Overview:

This article is a comprehensive guide for taking full export of Database.

The Export utility provides a simple way for us to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.

Please do keep in mind that this article should not be considered a substitution of the official guide from Oracle (http://www.oracle.com). The below mentioned link can be used to download the official guide for Oracle Database Users Management:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm 

Objective of the Article:

By the time we finish this article, we should be able to understand the following:

(1)Various Exporting Options.

(2)Invoking Export.

Exporting Options:

In command prompt, type the command "exp -help".As shown below:
[oracle@asmpc]$ exp -help

 For the screenshots. Please visit the link:: http://www.sensehaze.com/ 

Oracle export utility enables the user to specify many parameters, as shown in the above screenshot.

We are going to discuss few of the paramenters.

• constraints : Specifies whether table constraints should be exported with Oracle table data.
• file : The name of the export file. The default extension is .dmp, but you can specify any extension.
• compress :Specifies how Export and Import manage the initial extent for table data.
• filesize :The maximum file size, specified in bytes.
• full :The entire Oracle database is exported with a full Oracle export.
• grants :Specifies object grants to Oracle export.
• log :The filename used by Oracle export to write messages.
• owner :Indicates that the Export is a user-mode Export and lists the users whose objects will be exported.

Invoking Export:

For invoking export, type the below mentioned command.
[oracle@asmpc]$ exp system/sys@mydb file=exp.dmp grants=y full=y buffer=1000000

Here we have used basic options, as per our requirement we can use various options.

For the screenshots. Please visit the link:: http://www.sensehaze.com/