- 最后登录
- 2013-11-28
- 在线时间
- 13 小时
- 威望
- 32
- 金钱
- 150
- 注册时间
- 2011-12-22
- 阅读权限
- 10
- 帖子
- 19
- 精华
- 0
- 积分
- 32
- UID
- 118
|
1#
发表于 2012-7-23 22:38:16
|
查看: 3629 |
回复: 1
软件环境: centos 5.7 x64 oracle 11.2.0.3 x64
A数据库中,有个名叫JZTEORDER 的schema,曾被赋予另一个schema为jzt下几个表的select权限。
现在将JZTEORDER 在A数据库 drop 掉。
并且在A数据库查询
select * from dba_tab_privs
where grantee='JZTEORDER'
已无任何记录返回;
jzt 是A数据库的另一个schema,并且含有数据,现在使用数据泵将 jzt 下的对象全部导出,但后在B数据库进行导入,
B数据库已经建立好名为jzt的schema,并被赋予了connect,resource 系统权限。
eg:
A库执行导出:expdp jzt/123 dumpfile=1.dp directory=dp job_name=jzt1;
B库执行导入:impdp jzt/123 dumpfile=1.dp directory=dp schemas='JZT' remap_schema="JZT:JZT"
但是导入过程中:
(节选了部分)
. . imported "JZT"."SYSTEM_NOTE" 0 KB 0 rows
. . imported "JZT"."TAGREEMENTMERCHANDISE" 0 KB 0 rows
. . imported "JZT"."TASESQL" 0 KB 0 rows
. . imported "JZT"."TEMPORGMERCH" 0 KB 0 rows
. . imported "JZT"."TSTORAGESEARCH" 0 KB 0 rows
. . imported "JZT"."USERVSDEPT" 0 KB 0 rows
. . imported "JZT"."VENDEEVSDEPT" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."EORDER" TO "JZTEORDER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."EORDERITEM" TO "JZTEORDER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."MANUFACTURER" TO "JZTEORDER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."ORG" TO "JZTEORDER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."ORGMERCHANDISE" TO "JZTEORDER"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'JZTEORDER' does not exist
Failing sql is:
GRANT SELECT ON "JZT"."VENDEE" TO "JZTEORDER"
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
请问:
虽然不影响数据,但是为何对象权限还在? 我不打算建立JZTEORDER,如何解决这个问题? |
|