Table almost twice as large after CTAS on original table
Hi
Oracle 12.1.0.2.0
When I am doing CTAS on original table, then this new table is almost twice as large. I have checked storage specs through "dbms_metadata.get_ddl", and everything is the same, except table name. How is this possible..?
drop table ETOIMIK_OSA.SMQUERY_7703_NEW purge;create table ETOIMIK_OSA.SMQUERY_7703_NEW tablespace osa as (select * from ETOIMIK_OSA.SMQUERY_7703);-- New table DDL is as follows, and evrything is the same for original table, except table_name. CREATE TABLE "ETOIMIK_OSA"."SMQUERY_7703_NEW" ( "SMKEY" CHAR(38 CHAR) NOT NULL ENABLE, "SMCMDNUM" CHAR(4 CHAR) NOT NULL ENABLE, "SMCMDNAME" CHAR(12 CHAR) NOT NULL ENABLE, "SMDATE" CHAR(8 CHAR) NOT NULL ENABLE, "SMTIME" CHAR(9 CHAR) NOT NULL ENABLE, "SMSTOP" CHAR(9 CHAR) NOT NULL ENABLE, "SMELAPTIME" FLOAT(126) NOT NULL ENABLE, "SMCPUTIME" FLOAT(126) NOT NULL ENABLE, "SMWAITTIME" FLOAT(126) NOT NULL ENABLE, "SMIOS" FLOAT(126) NOT NULL ENABLE, "SMRECORDS" FLOAT(126) NOT NULL ENABLE, "SMTRANS" FLOAT(126) NOT NULL ENABLE,