Export e Import - Oracle

Import:

imp system/123456 file=/u01/dmps/xx_yyy.dmp log=/u01/dmps/xx_yy.log fromuser=XX_YY touser=XX

imp system/123456 file= /u01/dmps/xx_yyy.dmp  full=yes ignore=yes log= /u01/dmps/xx_yy.log  buffer=1000000

impdp system/password@db10g full=Y directory=DATA_PUMP_DIR   dumpfile=DB10G.dmp logfile=impdpDB10G.log

SQL> grant select on v_$session to system;

Export:

expdp  system/renata0505@vipa full=y directory=DATA_PUMP_DIR  dumpfile=bd-total-vipa_$FECHA_ACTUAL.dmp logfile=bd-total-vipa_$FECHA_ACTUAL.log

URL: http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php