主页 / dba / 问题 / 344006
Accepted
Baalback
Asked: 2024-12-05 04:03:08 +0800 CST

表空间创建成功后未显示在 dba_tablepsaces 中的原因是什么

  • 772

我已经执行了以下命令，并且可以在目录中找到它。但是查询“select * from dba_tablespaces”时我找不到它。我试图在这个表空间上创建一个新的模式，但抛出了错误tablessoace不存在。我的错误是什么？

CREATE BIGFILE TABLESPACE ESC_SCHEMA_DATA DATAFILE  '/datafiles/CDB1/O19/ESC_SCHEMA_DATA.DBF' SIZE 536870912000 AUTOEXTEND ON NEXT 1073741824 MAXSIZE 33554431M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT  NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO
oracle

1 个回答

  1. Best Answer

    查看视图CDB_。您可能在可插拔数据库 (PDB) 中创建了表空间，然后DBA_从根容器查询视图。在那里，您只会找到 CDB 的表空间。如果导航到 PDB，您可以询问视图DBA_或CDB_视图。应该会列出表空间。您也可以转到根容器并询问视图CDB_。将列出多租户数据库中的所有表空间。

    登录到根容器（CDB）

    sqlplus sys/Welcome_#1@localhost/FREE as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 4 22:22:45 2024
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.5.0.24.07

sys@FREE>  col file_name for a100
sys@FREE> select file_name from cdb_data_files;

FILE_NAME
----------------------------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/users01.dbf
/opt/oracle/oradata/FREE/undotbs01.dbf
/opt/oracle/oradata/FREE/system01.dbf
/opt/oracle/oradata/FREE/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf

8 rows selected.

Elapsed: 00:00:00.30
sys@FREE> select file_name from dba_data_files;

FILE_NAME
----------------------------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/users01.dbf
/opt/oracle/oradata/FREE/undotbs01.dbf
/opt/oracle/oradata/FREE/system01.dbf
/opt/oracle/oradata/FREE/sysaux01.dbf

Elapsed: 00:00:00.01
sys@FREE>

    登录可插拔数据库（PDB）：

    sqlplus sys/Welcome_#1@localhost/FREEPDB1 as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Dec 4 22:24:04 2024
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.5.0.24.07

sys@FREEPDB1> select file_name from dba_data_files;

FILE_NAME
----------------------------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf

Elapsed: 00:00:00.08
sys@FREEPDB1> select file_name from cdb_data_files;

FILE_NAME
----------------------------------------------------------------------------------------------------
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf

Elapsed: 00:00:00.10

    祝你好运！

    • 1

相关问题