Database Administration (MOSC)

MOSC Banner

ORA-00902 INVALID DATATYPE

edited Jan 23, 2014 12:12AM in Database Administration (MOSC) 9 commentsAnswered
 I encountered ORA-00902 when I was trying to run below

  ALTER TABLE TEST_TEMP ADD PARTITION BY RANGE (TESTNUMDATE) (PARTITION P201401 VALUES LESS THAN (20140201))

I also tried to modify the statement to use other fields instead but the same error occurred

  ALTER TABLE TEST_TEMP ADD PARTITION BY RANGE (TESTNUM1) (PARTITION P100 VALUES LESS THAN (101))

Here is the table structure

create table TEST_TEMP
(
  TESTPKID    VARCHAR2(7),
  TESTSTR1    VARCHAR2(10),
  TESTNUM1    NUMBER,
  TESTDATE1   DATE,
  TESTNUMDATE 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