A - is wrong
Segment creation is not deferred for partitioned tables, index organized tables, clustered tables, global temporary tables, session specific temporary tables, internal tables, typed tables, AQ tables, partitioned indexes, bitmap join indexes, domain indexes and tables owned by SYS, SYSTEM, PUBLIC, OUTLN or XDB.
B and D are correct:
B - DEFERRED_SEGMENT_CREATION default value is true
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DEFERRED_SEGMENT_CREATION.html#GUID-29066C9A-1CC7-48E4-A278-BB9678EE3362
D- "Index segment creation is deferred when the associated table defers segment creation. This is because index segment creation reflects the behavior of the table with which it is associated."
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-EF7459D8-6396-4275-A73F-75BBF2A7EC2C
There's no documentation supporting C.
A is correct, tested as follows:
-- as sys
CONN sys/senha@orclpdb as sysdba
CREATE TABLESPACE tbs_local DATAFILE SIZE 50M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
alter user hr quota 10m on tbs_local;
-- as hr
conn hr/hr@orclpdb
CREATE TABLE countries_iot(
country_id CHAR(2) NOT NULL,
country_name VARCHAR2(40),
currency_name VARCHAR2(25),
currency_symbol VARCHAR2(3),
region VARCHAR2(15),
CONSTRAINT country_iot_id_pk_demo PRIMARY KEY (country_id )
)
SEGMENT CREATION DEFERRED
ORGANIZATION INDEX
TABLESPACE tbs_local;
CONN sys/senha@orclpdb as sysdba
SELECT TABLESPACE_NAME, EXTENT_MANAGEMENT, SEGMENT_SPACE_MANAGEMENT FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='TBS_LOCAL';
COL OWNER FOR A5
COL TABLE_NAME FOR A20
SELECT OWNER, TABLE_NAME, IOT_TYPE, SEGMENT_CREATED FROM DBA_TABLES WHERE TABLE_NAME='COUNTRIES_IOT';
select segment_name, bytes/1024/1024 MB from dba_segments where segment_name='COUNTRIES_IOT';
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rafafm
2 months, 3 weeks agopiontk
1 year, 5 months agopiontk
1 year, 5 months ago[Removed]
1 year, 2 months agoauwia
1 year, 6 months agoRaNik69
1 year, 7 months agopiontk
1 year, 10 months agodianiss1050
1 year, 10 months ago