I have created a heap table,
then an IOT with CTAS from above table
and then altered the IOT to rename it.
as soon as i ran a select on dba_tables, i noticed the Truncating commands and was little scared.
Since the issue is not reproducible, didn't open any SR with Oracle and still wonder why that strange output was shown. If anybody noticed the similar behavior and got the reason, please let me know.
19:56:51 SQL> conn raj/***
Connected.
19:56:54 SQL> CREATE TABLE test123
19:56:55 2 ( asd NUMBER(6)
19:56:55 3 , first_name VARCHAR2(20)
19:56:55 4 , CONSTRAINT test123_pk
19:56:55 5 PRIMARY KEY (asd)
19:56:55 6 );
Table created.
Elapsed: 00:00:00.60
19:57:09 SQL> create table test321 (asd, first_name,
19:57:09 2 constraint new_pk
19:57:09 3 primary key (asd))
19:57:09 4 organization index
19:57:09 5 as select * from test123;
Table created.
Elapsed: 00:00:00.03
19:57:49 SQL>
19:57:54 SQL> alter table test321 rename to testraj;
Table altered.
Elapsed: 00:00:00.96
19:59:31 SQL> select * from dba_tables where table_name ='TESTRAJ';
truncating (as requested) before column MAX_TRANS
truncating (as requested) before column INITIAL_EXTENT
truncating (as requested) before column NEXT_EXTENT
truncating (as requested) before column MIN_EXTENTS
truncating (as requested) before column MAX_EXTENTS
truncating (as requested) before column PCT_INCREASE
truncating (as requested) before column FREELISTS
truncating (as requested) before column FREELIST_GROUPS
truncating (as requested) before column NUM_ROWS
truncating (as requested) before column BLOCKS
truncating (as requested) before column EMPTY_BLOCKS
truncating (as requested) before column AVG_SPACE
truncating (as requested) before column CHAIN_CNT
truncating (as requested) before column AVG_ROW_LEN
truncating (as requested) before column AVG_SPACE_FREELIST_BLOCKS
truncating (as requested) before column NUM_FREELIST_BLOCKS
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME STATUS PCT_FREE PCT_USED INI_TRANS LOG B D
---------- ------------------------------ --------------- ------------------------------ ------------------------------ -------- -------------------- -------------------- -------------------- --- - -
RAJ TESTRAJ VALID 0 0 0 N
Elapsed: 00:00:00.36
20:00:25 SQL>
then an IOT with CTAS from above table
and then altered the IOT to rename it.
as soon as i ran a select on dba_tables, i noticed the Truncating commands and was little scared.
Since the issue is not reproducible, didn't open any SR with Oracle and still wonder why that strange output was shown. If anybody noticed the similar behavior and got the reason, please let me know.
19:56:51 SQL> conn raj/***
Connected.
19:56:54 SQL> CREATE TABLE test123
19:56:55 2 ( asd NUMBER(6)
19:56:55 3 , first_name VARCHAR2(20)
19:56:55 4 , CONSTRAINT test123_pk
19:56:55 5 PRIMARY KEY (asd)
19:56:55 6 );
Table created.
Elapsed: 00:00:00.60
19:57:09 SQL> create table test321 (asd, first_name,
19:57:09 2 constraint new_pk
19:57:09 3 primary key (asd))
19:57:09 4 organization index
19:57:09 5 as select * from test123;
Table created.
Elapsed: 00:00:00.03
19:57:49 SQL>
19:57:54 SQL> alter table test321 rename to testraj;
Table altered.
Elapsed: 00:00:00.96
19:59:31 SQL> select * from dba_tables where table_name ='TESTRAJ';
truncating (as requested) before column MAX_TRANS
truncating (as requested) before column INITIAL_EXTENT
truncating (as requested) before column NEXT_EXTENT
truncating (as requested) before column MIN_EXTENTS
truncating (as requested) before column MAX_EXTENTS
truncating (as requested) before column PCT_INCREASE
truncating (as requested) before column FREELISTS
truncating (as requested) before column FREELIST_GROUPS
truncating (as requested) before column NUM_ROWS
truncating (as requested) before column BLOCKS
truncating (as requested) before column EMPTY_BLOCKS
truncating (as requested) before column AVG_SPACE
truncating (as requested) before column CHAIN_CNT
truncating (as requested) before column AVG_ROW_LEN
truncating (as requested) before column AVG_SPACE_FREELIST_BLOCKS
truncating (as requested) before column NUM_FREELIST_BLOCKS
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
OWNER TABLE_NAME TABLESPACE_NAME CLUSTER_NAME IOT_NAME STATUS PCT_FREE PCT_USED INI_TRANS LOG B D
---------- ------------------------------ --------------- ------------------------------ ------------------------------ -------- -------------------- -------------------- -------------------- --- - -
RAJ TESTRAJ VALID 0 0 0 N
Elapsed: 00:00:00.36
20:00:25 SQL>
No comments:
Post a Comment