SLTechnology News&Howtos › Database ›

Oracle Import and Export dmp Fil

Shulou Source: shulou.com Published: 2022-06-01 21:24:06 11月14日 Update

create oracle directory, log in sqlplus with user

create or replace directory dpdata1 as '/A/B';

Give permissions, dba login sqlplus

grant read,write on directory dpdata1 to user;

Export dmp

a. Export by table, under bin directory

./ expdp user/pwd@SID TABLES=table1,table2 dumpfile=expdp.dmp DIRECTORY=dpdata1;

b. Export by user

./ expdp user/pwd@SID schemas=user dumpfile=expdp.dmp DIRECTORY=dpdata1;

Import dmp

a. Import dmp exported by table under bin directory

./ impdp user/pwd@SID DIRECTORY=dpdata1 DUMPFILE=expdp.dmp full=y logfile=impdlog.log ;

b. Import dmp exported per user

./ impdp user/pwd@SID DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=user logfile=impdlog.log ;