oracle数据库备份

exp smeimp/superb2017@orcl file=c:\backup\smeimp.dmp owner=smeimp log=c:\backup\smeimp.dmp.log 

imp smeimp_01/superb2017@orcl fromuser=smeimp touser=smeimp_01 file=f:/upload/smeimp.dmp log=f:/upload/smeimp.imp.log

CREATE USER smeimp_tt_0620 IDENTIFIED BY superb2017;

GRANT CONNECT,RESOURCE,DBA TO smeimp_tt_0620;

 

posted @ 2018-08-13 11:46  根须  阅读(127)  评论(0编辑  收藏  举报