Export/Import Strategies For Backing-Up An Oracle Database

Export/Import Strategies For Backing-Up An Oracle Database

Article Oracle

Export/Import

Exports are “logical” database backups in that they extract logical definitions and data from the database to a file.

Export

The syntax for Export Command.

exp username/passward@connection_name file=file_name.dmp tables= table_name log=log_name.log

Example

Export the table

Command

exp hr/hr@xe file=emp.dmp tables=employees log=l1.log

Export/Import Strategies For Backing-Up An Oracle Database

Import

The syntax for Export Command.

Imp username/passward@connection_name file=export_file_name.dmp tables= table_name log=log_name.log

Example

Import the table

Command

imp obiee_user/obiee_user@xe file=emp.dmp tables=employees log=l2.log

Export/Import Strategies For Backing-Up An Oracle Database

Aastha Sharma
Latest posts by Aastha Sharma (see all)

Leave a Reply

Your email address will not be published. Required fields are marked *