Use expdp(data pump export ) & impdp utilities

These utilities are useful for moving data from one database to another database..Here are the steps how to do this:


Exporting:
1. SQL> create directory expdp_dir as 'C:\dump_exports';
2. SQL> grant read,write on directory expdp_dir to hr,user1,user2;
3.C:\>expdp hr/hr tables=table1,table2,table3 directory=expdp_dir dumpfile=tables_exp.dmp logfile=tables_exp.log

*directory->location where log and dump files are located

Importing:
1. C:\>impdp hr/hr tables=table1,table2,table3 directory=expdp_dir dumpfile=tables_exp.dmp logfile=tables_imp.log

remap_tablespace option is useful if we don't have the tablespace which was used during the export,in this case you can use remap_tablespace=EXAMPLE:USERS and the contents will be imported from example tablespace into users tablespace

Note that: this utilities are similar to exp&imp but:

• expdp&impdp are server-based when exp&imp are client-based.
• dump files generated by exp can not be imported by impdp and vice-versa.