12C -- ORA-65048 ORA-65048

最新推荐文章于 2025-05-22 14:17:32 发布

转载最新推荐文章于 2025-05-22 14:17:32 发布 · 756 阅读

文章标签：

#数据库

本文记录了在Oracle 12c中创建commonuser时遇到ORA-65048错误的过程及解决办法。该错误提示指定的默认表空间不存在。通过在对应的可插入数据库中创建所需的表空间并设置正确的容器上下文，最终成功创建了用户。

创建common user的时候报错：

$ 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>

原因：

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

解决方法：

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>