alter table ADD PERIOD FOR was failed on ORA-00604 and ORA-00904
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, |