创建directory并执行expdp/impdp/create user

最新推荐文章于 2024-08-27 22:01:29 发布

iteye_5649

最新推荐文章于 2024-08-27 22:01:29 发布

阅读量968

点赞数

分类专栏： DateSource 文章标签：数据库

本文链接：https://blog.csdn.net/iteye_5649/article/details/82637095

版权

DateSource 专栏收录该内容

105 篇文章 0 订阅

订阅专栏

select * from dba_directories;
create or replace directory jacfdj_data as 'D:\jac_fdj\auto_oracl_bak'
grant read,write on directory jacfdj_data to fdjtest
drop directory dump_dir
------------------
--本地备份
expdp fdjother/fdjother directory=jacfdj_data 
dumpfile=fdjother_001.dmp logfile=fdjother_001.log
--本地导入
impdp fdjother/fdjother directory=jacfdj_data dumpfile=fdjother_001.dmp
------------------
sqlplus /nolog;   
connect / as sysdba; 
alter user sys identified by sys;   
alter user system identified by system;

create user jac_scl identified by jac_scl;
alter user jac_scl default tablespace JAC_SCL;
grant create session,create table,create view,
create sequence,unlimited tablespace to jac_scl;