Export / Import

 

Here I am creating a user and directory to export and import.

Creating a sample table and a row

Exporting  emp table to dba_directory as a dumpfile

Importing into same DB and Schema with new table name

New table created with export dump

Now I am updating a row

And adding a new row

====================================================================

Now exporting modified table with New dumpfile name 

Importing into the same table with option table_exists_action=append

We can see It has created duplicate records 

Again I am inserting a row in the same table

Exporting the table 

Importing the table into same table with data_option

Result

Now I am adding another row to the source table

Exported with New Dumpfile name

Importing into same target table

Result 

Importing with no options in the same table

Result