CREATE TABLE "DBMT"."JUSTFORTEST2"
( "TEST1" VARCHAR2(2)
)
TABLESPACE DATA123;
SQL> @p deferred_segment_creation;
NAME VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation TRUE
SQL>
SQL> CREATE TABLE "DBMT"."JUSTFORTEST2"
2 ( "TEST1" VARCHAR2(2)
3 )
4 TABLESPACE DATA123;
表已创建。
SQL> @seg DBMT.JUSTFORTEST2
未选定行
SQL> @p deferred_segment_creation
NAME VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation FALSE
SQL> CREATE TABLE "DBMT"."JUSTFORTEST"
2 ( "TEST1" VARCHAR2(2)
3 ) SEGMENT CREATION DEFERRED
4 TABLESPACE DATA123;
表已创建。
SQL> @seg DBMT.JUSTFORTEST
未选定行
SQL> insert into DBMT.justForTest values('1');
已创建 1 行。
SQL> rollback
2 ;
回退已完成。
SQL> @seg DBMT.JUSTFORTEST
SEG_MB OWNER SEGMENT_NAME SEG_PART_NAME SEGMENT_TYPE SEG_TABLESPACE_NAME BLOCKS HDRFIL HDRBLK
---------- -------------------- ------------------------------ ------------------------------ -------------------- ------------------------------------------------------------------------------------------ ---------- ---------- ----------
0 DBMT JUSTFORTEST TABLE DATA123 8 54 3064194
SQL> CREATE TABLE "DBMT"."JUSTFORTEST1"
2 ( "TEST1" VARCHAR2(2)
3 )
4 TABLESPACE DATA123;
表已创建。
SQL> @seg DBMT.JUSTFORTEST1
SEG_MB OWNER SEGMENT_NAME SEG_PART_NAME SEGMENT_TYPE SEG_TABLESPACE_NAME BLOCKS HDRFIL HDRBLK
---------- -------------------- ------------------------------ ------------------------------ -------------------- ------------------------------------------------------------------------------------------ ---------- ---------- ----------
0 DBMT JUSTFORTEST1 TABLE DATA123 8 54 3064226
SQL> exit
从 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0 断开
[oracle@peach:/home/oracle]$ export ORACLE_PATH=~/scifmation/scripts:~/sdbo/scripts
[oracle@peach:/home/oracle]$ export SQLPATH=~/scifmation/scripts
[oracle@peach:/home/oracle]$ alias ora="sqlplus / as sysdba"
[oracle@peach:/home/oracle]$ alias ll="ls -lrt "
[oracle@peach:/home/oracle]$ ora
SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 12月 15 14:38:07 2020
Version 19.7.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0
USERNAME INST_NAME HOST_NAME SID SERIAL# VERSION STARTED SPID OPID CPID SADDR PADDR
-------------------- -------------------- ------------------------- ----- -------- ---------- -------- --------------- ----- --------------- ---------------- ----------------
SYS fruits peach 33 5760 19.0.0.0.0 20201215 20781 34 20780 000000008011CD30 00000000815738B8
SQL> alter session set container=wxoadb;
会话已更改。
SQL> @p show parameter deferred_segment_creation;
NAME VALUE
---------------------------------------- ----------------------------------------
_show_login_pdb_sessions FALSE
_show_mgd_recovery_state FALSE
_sql_show_expreval FALSE
SQL> @p deferred_segment_creation;
NAME VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation TRUE
SQL>
SQL> CREATE TABLE "DBMT"."JUSTFORTEST2"
2 ( "TEST1" VARCHAR2(2)
3 )
4 TABLESPACE DATA123;
表已创建。
SQL> @seg DBMT.JUSTFORTEST2
未选定行