oracle数据库导入导出

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 

--