Import and Export in Oracle

Question

Hi.... I want to know about import and export in oracle 10g ? How to implement this in oracle ? Please explain with an example ? thanks.....

Chintan Rathod · Answer

================== To export ================== SQL > CREATE DIRECTORY dmpdir AS '/opt/oracle'; Directory created. SQL > GRANT read write ON DIRECTORY dmpdir TO scott; Grant succeeded Oracle introduced a default directory from 10g R2 called DATA_PUMP_DIR that can be used: SQL > SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR'; DIRECTORY_PATH -------------------------------------------------------------------------------- /app/oracle/product/10.2.0/rdbms/log/ $ expdp scott/tiger DIRECTORY=dmpdir DUMPFILE=scott.dmp =================== To import =================== $ impdp system/oracle DIRECTORY=dmpdir DUMPFILE=scott.dmp Thank You.

Chintan Rathod · Answer

My Pleasure Mr. Vinnet

Vineet Kumar Saini · Answer

Thanks Chintan and Nayak Ji.....

Satyapriya Nayak · Answer

Hi Vineet  Please refer the below link http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm Thanks