9.2开始建立新用户
重新创建用户
createtablespace ORCTSTU
logging
datafile'/home/oradata/powerdes/orctstu01.dbf'
size50m
autoextendon
next50m
extentmanagement local;
CREATEUSER orctstu PROFILE "DEFAULT" IDENTIFIED BY "testpd2015" DEFAULT TABLESPACE ORCTSTU ACCOUNTUNLOCK;
GRANTconnect,resource TO orctstu;
grantdba to orctstu;
SQL>create tablespace ORCTSTU
logging
datafile'/home/oradata/powerdes/orctstu01.dbf'
size50m
autoextendon
next50m
extentmanagement local; 2 3 4 5 6 7
Tablespacecreated.
SQL>
SQL>CREATE USER orctstu PROFILE "DEFAULT" IDENTIFIED BY "testpd2015"DEFAULT TABLESPACE ORCTSTU ACCOUNT UNLOCK;
Usercreated.
SQL>GRANT connect,resource TO orctstu;
Grantsucceeded.
SQL>grant dba to orctstu;
Grantsucceeded.
SQL>
9.3 开始导入备份的数据
导入命令：
impdporctstu/testpd2015@PD1 directory=dir_dump_t1 dumpfile=TEST2_PD_20150518.dmpnologfile=y
?
导入过程如下：
......
Processingobject type SCHEMA_EXPORT/EVENT/TRIGGER
ORA-39082:Object type TRIGGER:"ORCTSTU"."LOGON_DENIED_TO_ALERT" createdwith compilation warnings
ORA-39082:Object type TRIGGER:"ORCTSTU"."LOGON_DENIED_TO_ALERT"created with compilation warnings
Processingobject type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processingobject typeSCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processingobject type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processingobject type SCHEMA_EXPORT/JOB
Processingobject type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Job"ORCTSTU"."SYS_IMPORT_FULL_01" completed with 45 error(s)at 20:36:08
?
[oracle@edustu4admin]$
?
PS:impdp导入的时候，是从最大的表开始导入的，先导入数据，最后重建索引，导入各种其它objects。
?
?
10，报错记录
SQL> drop user orctstu cascade;
drop user orctstu cascade
*
ERROR at line 1:
ORA-04098: trigger 'ORCTSTU.LOGON_DENIED_TO_ALERT'is invalid and failed
re-validation
ORA-01940: cannot drop a user that iscurrently connected
SQL>
?
解决办法：直接lsnrctl stop;然后重新执行drop user操作