SQL Language (MOSC)

MOSC Banner

What could be the cause of the below failure please?

edited Aug 10, 2015 1:40AM in SQL Language (MOSC) 4 commentsAnswered ✓

CREATE TABLE TAB

(

  SOURCE               VARCHAR2(4000 BYTE),

  JOB                  VARCHAR2(4000 BYTE),

  LDATE         DATE

)

NOCOMPRESS

TABLESPACE USERS

PARTITION BY RANGE (LDATE)

SUBPARTITION BY HASH (JOB)

SUBPARTITION TEMPLATE

  (SUBPARTITION MAL_JOB1 TABLESPACE USERS,

   SUBPARTITION MAL_JOB2 TABLESPACE USERS,

   SUBPARTITION MAL_JOB3 TABLESPACE USERS,

   SUBPARTITION MAL_JOB4 TABLESPACE USERS,

   SUBPARTITION MAL_JOB5 TABLESPACE USERS,

   SUBPARTITION MAL_JOB6 TABLESPACE USERS,

   SUBPARTITION MAL_JOB7 TABLESPACE USERS,

   SUBPARTITION MAL_JOB8 TABLESPACE USERS

  )

  PARTITION JUL252015_06 VALUES LESS THAN (TO_DATE(' 2015-07-25 06:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

  ( SUBPARTITION JUL252015_06_MAL_JOB1      TABLESPACE USERS,

    SUBPARTITION JUL252015_06_MAL_JOB2      TABLESPACE USERS,

    SUBPARTITION JUL252015_06_MAL_JOB3      TABLESPACE USERS,

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