Shulou(Shulou.com)06/01 Report--

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 ;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.