Database Administration (MOSC)

MOSC Banner

Table almost twice as large after CTAS on original table

edited May 1, 2019 1:35AM in Database Administration (MOSC) 3 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center