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>

Increase heap memory in Oracle DB for data import/export

You may encounter "Out of memory" when copy Database or import/export data in SQL Developer tool, go to:

<oracle_product_domain>sqldeveloper\sqldeveloper\bin

Open file: sqldeveloper.conf, add more line:

AddVMOption -Xmx1024M

(defaullt is 128M)