转载至:https://www.cnblogs.com/abclife/p/6726909.html
创建common user的时候报错:
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
|
$ sqlplus
'/as sysdba'
SQL*Plus: Release 12.2.0.1.0 Production
on
Tue Apr 18 11:05:00 2017
Copyright (c) 1982, 2016, Oracle.
All
rights reserved.
Connected
to
:
Oracle
Database
12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>
create
user
c##backup_admin identified
by
backup_admin
default
tablespace users;
create
user
c##backup_admin identified
by
backup_admin
default
tablespace users
*
ERROR
at
line 1:
ORA-65048: error encountered
when
processing the
current
DDL statement
in
pluggable
database
PLUG_TEST
ORA-65048: tablespace
'USERS'
does
not
exist
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
alter
session
set
container=plug_test;
Session altered.
SQL>
select
tablespace_name,status,contents
from
user_tablespaces;
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------------------
SYSTEM ONLINE PERMANENT
SYSAUX ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP
ONLINE
TEMPORARY
UNDO_2 ONLINE UNDO
SQL>
|
原因:
1
2
3
4
5
6
|
While creating a common
user
,
any
default
tablespace,
temporary
tablespace,
or
profile specified using the following clauses must exist
in
all
the containers belonging
to
the CDB:
DEFAULT
TABLESPACE
TEMPORARY
TABLESPACE
QUOTA
PROFILE
|
解决方法:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
SQL>
alter
session
set
container=plug_test;
Session altered.
SQL>
create
tablespace users datefile
'+da'
size
133m autoextend
on
next
640k maxsize unlimited;
SQL>
alter
session
set
container=cdb$root;
Session altered.
SQL>
create
user
c##backup_admin identified
by
backup_admin
default
tablespace users;
User
created.
SQL>
|