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操作