Data Modeling Import DDL file
Hello,
The Import functions works fine except when I add a "default to_timestamp" function to my column.
The following will make the Data Modeling application hang.
CREATE TABLE "PATH"
(
"NUMFILES" NUMBER(38,0) DEFAULT 0
"MTIME" TIMESTAMP (0) DEFAULT to_timestamp('01011970 00:00:00', 'DDMMYYYY HH24:MI:SS'),
"ATIME" TIMESTAMP (0) DEFAULT to_timestamp('01011970 00:00:00', 'DDMMYYYY HH24:MI:SS')
) ;
and like this imports fine;
CREATE TABLE "PATH"
(
"NUMFILES" NUMBER(38,0) DEFAULT 0
"MTIME" TIMESTAMP (0) ,
"ATIME" TIMESTAMP (0)
) ;
I am not sure if this is a feature or it's my code.
Appropriate your inputs.
Robert
The Import functions works fine except when I add a "default to_timestamp" function to my column.
The following will make the Data Modeling application hang.
CREATE TABLE "PATH"
(
"NUMFILES" NUMBER(38,0) DEFAULT 0
"MTIME" TIMESTAMP (0) DEFAULT to_timestamp('01011970 00:00:00', 'DDMMYYYY HH24:MI:SS'),
"ATIME" TIMESTAMP (0) DEFAULT to_timestamp('01011970 00:00:00', 'DDMMYYYY HH24:MI:SS')
) ;
and like this imports fine;
CREATE TABLE "PATH"
(
"NUMFILES" NUMBER(38,0) DEFAULT 0
"MTIME" TIMESTAMP (0) ,
"ATIME" TIMESTAMP (0)
) ;
I am not sure if this is a feature or it's my code.
Appropriate your inputs.
Robert
0