SQL Language (MOSC)

MOSC Banner

alter table ADD PERIOD FOR was failed on ORA-00604 and ORA-00904

edited Apr 25, 2017 7:21AM in SQL Language (MOSC) 3 commentsAnswered

alter table APPOINTMENT ADD PERIOD FOR EXPIRATION_PERIOD (ENTRY_DATE,EXPIRATION_DATE)

Error report -

SQL Error: ORA-00604: error occurred at recursive SQL level 1

ORA-00904: "EXPIRATION_PERIOD": invalid identifier

00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement

           (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack

           can be corrected, do so; otherwise contact Oracle Support.

Table APPOINTMENT has the stricture like it:

("PATIENTID" VARCHAR2(21 CHAR),
"DATEOFAPPOINTMENT" DATE,
"DATEAPPOINTMENTGIVEN" DATE,
"CANCELLED" NUMBER(*,0),
"NOTES" VARCHAR2(255 CHAR),
"IMPORTFILE" VARCHAR2(15 CHAR),
"FACILITY" NUMBER,
"ENTRY_DATE" DATE DEFAULT sysdate,

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