国产精品天干天干,亚洲毛片在线,日韩gay小鲜肉啪啪18禁,女同Gay自慰喷水

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

重慶思莊oracle技術(shù)分享-ora-39083/01917報錯

2023-04-07 13:16 作者:D-Cycle  | 我要投稿

報錯信息:
Import: Release 11.2.0.4.0 - Production on Wed Dec 7 17:59:59 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates.??All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
Master table "SYS"."SYS_IMPORT_TABLE_03" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLE_03":??"/******** AS SYSDBA" directory=impdp_asm_dir dumpfile=TERMINALACTIVELOGS_20200115.dmp logfile=impdp_log_dir:TERMINALACTIVELOGS_20200115.log tables=COM.TERMINALACTIVELOGS_20200115 cluster=n
r
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "COM"."TERMINALACTIVELOGS_20200115"? ?? ?? ?28.89 GB 139222130 rows
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'GAB_XPLBD' does not exist
Failing sql is:
GRANT SELECT ON "COM"."TERMINALACTIVELOGS_20200115" TO "GAB_XPLBD"
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX


解決方案
既然導入的時候報錯了,說明源數(shù)據(jù)庫中是存在該對象的,那么首先要做的是,去源庫中查詢該角色的權(quán)限信息,然后在新的數(shù)據(jù)庫中,在sys用戶下,建一個角色?GAB_XPLBD,并賦給和源數(shù)據(jù)庫中相同的數(shù)據(jù)庫操作權(quán)限,然后再重新執(zhí)行導入操作。

重慶思莊oracle技術(shù)分享-ora-39083/01917報錯的評論 (共 條)

分享到微博請遵守國家法律
个旧市| 正宁县| 渑池县| 嘉荫县| 宁南县| 永和县| 壶关县| 随州市| 莎车县| 来安县| 武隆县| 白沙| 漳平市| 德钦县| 根河市| 双柏县| 深水埗区| 唐海县| 宿迁市| 栖霞市| 乐业县| 商南县| 南汇区| 共和县| 江阴市| 东明县| 册亨县| 虹口区| 克什克腾旗| 鹤壁市| 阜新| 阜城县| 射阳县| 察哈| 丹阳市| 新化县| 土默特右旗| 额尔古纳市| 高青县| 思茅市| 台中县|