Database Utilities (MOSC)

MOSC Banner

Data Modeling Import DDL file

edited Oct 8, 2009 12:27AM in Database Utilities (MOSC) 6 commentsAnswered
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

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