Published by : Obay Salah , November 19, 2024

 Oracle support for this type of export is not recent, but this type of backup is still available, and the options available in this type of backup are:

1- Export specific tables.

2- Export user data and objects.

3- Export Tablespace.

4- Export the entire database, taking into account the following:-

Base Tables are not exported.

Temporary Tablespace is not exported.

Undo Segment is not exported.

Physical File such as (Control files & Redo Log Files) are not exported.

Among the options available during the export process are:-

1- [Rows=[Y||N: This option means do you want to export the table as a structure without data or do you want to export the data with it? The original is the Y option meaning exporting the structures and data.

2- [Indexes=[Y||N: Do we export the indexes of the tables during the export of the tables or not?

Origin Y.

3- [Grants=[Y||N:Do you want to export permissions as well when exporting objects and users?

Origin Y.

4- File: To specify where to create the file containing the exported data.

5- Log: To specify where to create the File Log file that will contain information about the export process.

6- [Constraints=[Y||N]: Do you want to export the constraints while exporting the tables.

7- [ :Compress=[Y||N: Do you want to compress the data to reduce the size of the original file Y.

8- [Buffer=[Value: Here we specify the size of the buffer.

9- Tables: To specify the tables that I want to export.

10- [Inctype=[Incremental||Cumulative||Complete: To specify the export type, this option is available when exporting the database:-

Complete: To export the entire database.

Incremental: The incremental version, which means exporting the data that has changed after the last export operation.

Cumulative: The cumulative version means exporting data that has changed after the last cumulative or complete export.

11- Owner: The name of the user whose data we want to export

12- [Triggers=[Y||N: Do you want to export the trigger during the export process? The original is the Y option.

31-Filesize: To specify the maximum size of the Dump File.

In general, the export options can be reviewed by EXP HELP=Y.

The export process is done through Export Utilities, where the database is connected via the Server Process, then Select Statements are made for the required data, and then the data is passed via the Server Process to the Export User Process.

By the way, the procedures mentioned in the previous paragraph can be ignored using the Direct=y option, so that the data is read from the disk to the Cach Buffer and then the data is returned to the Export Client.

This method may improve performance.

Tags : Backup and Recovery

You May Also Like

Comments

no comment yet!