重庆思庄Oracle、Redhat认证学习论坛

标题: 创建pdb的表空间 [打印本页]

作者: 郑全 时间: 2017-2-23 17:31
标题: 创建pdb的表空间
SQL> conn system/oracle@sztech1
Connected.
SQL> select * from v$tablespace;
   TS# NAME                         INC BIG FLA ENC    CON_ID
---------- ------------------------------ --- --- --- --- ----------
      0 SYSTEM                      YES NO  YES             4
      1 SYSAUX                      YES NO  YES             4
      2 UNDOTBS1                      YES NO  YES             4
      3 TEMP                         NO  NO  YES             4
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/orcl/datafile/sztech1/system01.dbf
/u01/app/oracle/orcl/datafile/sztech1/sysaux01.dbf
/u01/app/oracle/orcl/datafile/sztech1/undotbs01.dbf
SQL> create tablespace ts_users datafile '/u01/app/oracle/orcl/datafile/sztech1/ts_users01.dbf' size 100m autoextend on;
Tablespace created.
SQL> select * from v$tablespace;
   TS# NAME                         INC BIG FLA ENC    CON_ID
---------- ------------------------------ --- --- --- --- ----------
      0 SYSTEM                      YES NO  YES             4
      1 SYSAUX                      YES NO  YES             4
      2 UNDOTBS1                      YES NO  YES             4
      3 TEMP                         NO  NO  YES             4
      5 TS_USERS                      YES NO  YES             4
SQL>

--要看所有的表空间
--登陆sys
SQL> conn / as sysdba
Connected.
SQL>

SQL> r
  1* select TABLESPACE_NAME,con_id from cdb_tablespaces order by 2
TABLESPACE_NAME                   CON_ID
------------------------------ ----------
SYSTEM                               1
USERS                                  1
TEMP                                  1
UNDOTBS1                               1
SYSAUX                               1
SYSTEM                               4
SYSAUX                               4
UNDOTBS1                               4
TEMP                                  4
TS_USERS                               4
SYSTEM                               5
TABLESPACE_NAME                   CON_ID
------------------------------ ----------
TEMP                                  5
UNDOTBS1                               5
SYSAUX                               5
14 rows selected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)