Import/Export large data in Oracle DB

Export:

C:\Oracle\Database\product\11.2.0\dbhome_1\BIN>exp test/123456@db_name1 file=export_data.dump log=log.txt buffer=10485867 statistics=none tables=(table1,table2)


Import:

C:\Oracle\Database\product\11.2.0\dbhome_1\BIN>imp test/123456@db_name1 file=export_data.dump full=yes


Using Pump Export/Import

    Export:

    expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp

    with "dmpdir" created by:

    CREATE DIRECTORY dmpdir AS '/opt/oracle';

    Import:

    impdp system/oracle DIRECTORY=dmpdir DUMPFILE=scott.dmp 

                        REMAP_SCHEMA=<OLD_SCHEMA>:<NEW_SCHEMA>