SQL Language (MOSC)

MOSC Banner

modifying a non-partition table to partition table

edited Nov 29, 2017 4:10AM in SQL Language (MOSC) 8 commentsAnswered

Hi

I"m trying to modify a non-partition table to partition table, it's empty

SQL> desc CWMDM_TRANSACT

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

ID                                        NOT NULL NUMBER

PERS_ID                                   NOT NULL NUMBER

LAST_NAME                                          VARCHAR2(30)

FIRST_NAME                                         VARCHAR2(30)

MID_NAME                                           VARCHAR2(30)

NAME_SUFFIX_CODE                                   VARCHAR2(3)

DOB                                                DATE

SSN                                                VARCHAR2(9)

CIN_NUM_IDENTIF                                    VARCHAR2(50)

GENDER_CODE                                        VARCHAR2(3)

DRIVE_LIC_NUM_IDENTIF                              VARCHAR2(50)

DECEAS_DATE                                        DATE

MAIDEN_NAME                                        VARCHAR2(30)

OTHER_LAST_NAME                                    VARCHAR2(30)

OTHER_FIRST_NAME                                   VARCHAR2(30)

OTHER_MID_NAME                                     VARCHAR2(30)

LINE_1_ADDR                                        VARCHAR2(50)

LINE_2_ADDR                                        VARCHAR2(50)

CITY_NAME                                          VARCHAR2(50)

STATE_CODE                                         VARCHAR2(3)

ZIP_CODE_NUM                                       VARCHAR2(32)

HOME_PH_NUM                                        NUMBER

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