Forum Stats

  • 3,744,061 Users
  • 499,421 Discussions
  • 1,599,913 Comments

Discussions

DEFAULT_LENGTH changed for column with CTAS

User_K78HC
User_K78HC Posts: 3 Newbie

Hi,

My database version is 11.2.0.4

I have created a table with CTAS from existing table and then applied default constraints on three column having data type TIMESTAMP(6). When compared default_length column from dba_tab_cols shows difference for original table and new table. For new table default_length is reduced. Does it has any impact on data insertion and how can I fix that.

Steps I did

1) Created new table using existing one.

create table tst_default_length_issue as select * from my_table where 1=2;

2) Set default values for column on new table

ALTER TABLE tst_default_length_issue MODIFY EFFECTIVE_FROM TIMESTAMP(6) DEFAULT TO_DATE('01-Jan-0001');

Tagged:

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.

New to My Oracle Support Community? Visit our Welcome Center