Реинкарнация O7_DICTIONARY_ACCESSIBILITY.
Несколько лет назад эта конфа перекачалась из 11-го в 18-й.
По-моему, я создал юзеров и перекачал данные двумя отдельными операциями.
Нельзя impdp дать указание "alter session" ?
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
SQL> select value from v$parameter where name = '_oracle_script';
VALUE
--------------------------------------------------------------------------------
TRUE
SQL> exit
Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
-------------
;;;
Import: Release 18.0.0.0.0 - Production on Sun May 2 14:19:22 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
;;; **************************************************************************
;;; Parfile values:
;;; parfile: exclude=TABLESPACE
;;; parfile: full=Y
;;; parfile: logfile=db_import.log
;;; parfile: dumpfile=auto.dmp
;;; parfile: directory=BACKUP
;;; parfile: userid=system/ ********@//localhost/XE
;;; **************************************************************************
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system@//localhost/XE parfile=import.par
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-39083: Object type USER:"BIG3" failed to create with error:
ORA-65096: invalid common user or role name
Failing sql is:
CREATE USER "BIG3" IDENTIFIED BY VALUES 'S:66477A3F...10' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"
=====================================
[oracle@zeta ~]$ sqlplus system@XE
SQL*Plus: Release 18.0.0.0.0 - Production on Sun May 2 16:05:10 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter password:
Last Successful login time: Sun May 02 2021 14:25:54 +03:00
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
SQL> create user USER1 identified by "1";
create user USER1 identified by "1"
*
ERROR at line 1:
ORA-65096: invalid common user or role name
SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
SQL> create user USER1 identified by "1";
User created.
Предлагать изучать CDB/PDB тоже можно :).
