The SQL syntax elements for Oracle Version 7 and MaxDB in SQL mode ORACLE differ, among other things, in the definition of names for objects.
If MaxDB assigns names for objects, these names differ from the names generated by Oracle.
The following keywords are reserved in Oracle 7 but not in MaxDB:
ACCESS |
COMPRESS |
ELSE |
FILE |
IMMEDIATE |
INCREMENT |
INITIAL |
MAXEXTENTS |
NOAUDIT |
NOCOMPRESS |
OFFLINE |
ONLINE |
PRIOR |
SIZE |
START |
SUCCESSFUL |
THEN |
VALIDATE |
|
|
If possible, these key words should not be used to designate objects in MaxDB.
You can find a list of all the keywords reserved in MaxDB in the section reserved_key_word of the Reference Manual.
You can find a list of all the keywords not reserved in MaxDB in the section not_reserved_key_word of the Reference Manual.