SQL Language (MOSC)

MOSC Banner

error in partition creation

edited Sep 22, 2013 10:17PM in SQL Language (MOSC) 1 commentAnswered ✓
 am trying to create a table with partitioning as follows :

Create TABLE TEST123

(

     time_stamp                                NOT NULL NUMBER(20),

     rollup_interval                           NOT NULL NUMBER(1),

     cellsite_id                               NOT NULL VARCHAR2(64),

     intervals_total                           NOT NULL NUMBER(10),

     intervals_unavail                         NOT NULL NUMBER(10),

     intervals_unknown                         NOT NULL NUMBER(10),

     trailing_path1_empty                               NUMBER(2),

     trailing_path2_empty                               NUMBER(2),

     tx_frames_total                           NOT NULL NUMBER(20),

     lost_frames_total                         NOT NULL NUMBER(20),

     rx_fd_avg_total                           NOT NULL NUMBER(20),

     rx_fdv_avg_total                          NOT NULL NUMBER(20),

     fd_max_total                              NOT NULL NUMBER(20),

     fdv_max_total                             NOT NULL NUMBER(20),

     intervals_total_path1                              NUMBER(10),

     intervals_total_path2                              NUMBER(10),

     intervals_unavail_path1                            NUMBER(10),

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