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, |