exp NESTLECRM2011/NESTLECRM2011@orcl file=C:\NESTLECRM_217_0919.dmp full=yes log=c:\NESTLECRM_217_0919.log
20120223:
D:\20120223_备份
password: manager
====================================
step1 :
---查看是否有人正在连接数据库用户---
select osuser,machine from v$session where username is not null and username ='NESTLECRM2011'
---删掉该用户---
drop user NESTLECRM2011 CASCADE;
---------------------------------------
step2:
---创建用户---
CREATE USER "NESTLECRM2011" PROFILE "DEFAULT"
IDENTIFIED BY "NESTLECRM20110601" DEFAULT TABLESPACE
"NESTLECRM" ACCOUNT UNLOCK;
---给用户DBA授权---
GRANT "CONNECT" TO "NESTLECRM2011";
GRANT "DBA" TO "NESTLECRM2011";
--授予用户其他权限
grant select any table to NESTLECRM2011;
grant select any dictionary to NESTLECRM2011;
--------------------------------------------------------------------------------------------
step3:
---导入用户对象
imp NESTLECRM2011/NESTLECRM20110601@orcl file=D:\JTA\DataBackUp\20120415_1600_BackUP\Nestle_20120415.dmp fromuser=NESTLECRM2011 touser=NESTLECRM2011
--