| Oracle® Enterprise Manager Grid Control Installation and Basic Configuration 10g Release 3 (10.2.0.3.0) Part Number B40103-01  | 
  | 
  | 
View PDF | 
This appendix provides a complete list of Oracle reserved words.
In addition to the reserved words in Table G-1, Oracle also uses system-generated names beginning with SYS_ for implicitly generated schema objects and subobjects. Oracle discourages you from using this prefix in the names you explicitly provide to your schema objects and subobjects to avoid possible conflicts in name resolution.
Table G-1 List of Oracle Reserved Words
| Oracle Reserved Words and Keywords | ||
|---|---|---|
| 
 ACCESS  | 
 ACCOUNT  | 
 ACTIVATE  | 
| 
 ADD  | 
 ADMIN  | 
 ADVISE  | 
| 
 AFTER  | 
 ALL  | 
 ALL_ROWS  | 
| 
 ALLOCATE  | 
 ALTER  | 
 ANALYZE  | 
| 
 AND  | 
 ANY  | 
 ARCHIVE  | 
| 
 ARCHIVELOG  | 
 ARRAY  | 
 AS  | 
| 
 ASC  | 
 AT  | 
 AUDIT  | 
| 
 AUTHENTICATED  | 
 AUTHORIZATION  | 
 AUTOEXTEND  | 
| 
 AUTOMATIC  | 
 BACKUP  | 
 BECOME  | 
| 
 BEFORE  | 
 BEGIN  | 
 BETWEEN  | 
| 
 BFILE  | 
 BITMAP  | 
 BLOB  | 
| 
 BLOCK  | 
 BODY  | 
 BY  | 
| 
 CACHE  | 
 CACHE_INSTANCES  | 
 CANCEL  | 
| 
 CASCADE  | 
 CAST  | 
 CFILE  | 
| 
 CHAINED  | 
 CHANGE  | 
 CHAR  | 
| 
 CHAR_CS  | 
 CHARACTER  | 
 CHECK  | 
| 
 CHECKPOINT  | 
 CHOOSE  | 
 CHUNK  | 
| 
 CLEAR  | 
 CLOB  | 
 CLONE  | 
| 
 CLOSE  | 
 CLOSE_CACHED_OPEN_CURSORS  | 
 CLUSTER  | 
| 
 COALESCE  | 
 COLUMN  | 
 COLUMNS  | 
| 
 COMMENT  | 
 COMMIT  | 
 COMMITTED  | 
| 
 COMPATIBILITY  | 
 COMPILE  | 
 COMPLETE  | 
| 
 COMPOSITE_LIMIT  | 
 COMPRESS  | 
 COMPUTE  | 
| 
 CONNECT  | 
 CONNECT_TIME  | 
 CONSTRAINT  | 
| 
 CONSTRAINTS  | 
 CONTENTS  | 
 CONTINUE  | 
| 
 CONTROLFILE  | 
 CONVERT  | 
 COST  | 
| 
 CPU_PER_CALL  | 
 CPU_PER_SESSION  | 
 CREATE  | 
| 
 CURRENT  | 
 CURRENT_SCHEMA  | 
 CURREN_USER  | 
| 
 CURSOR  | 
 CYCLE  | 
|
| 
 DANGLING  | 
 DATABASE  | 
 DATAFILE  | 
| 
 DATAFILES  | 
 DATAOBJNO  | 
 DATE  | 
| 
 DBA  | 
 DBHIGH  | 
 DBLOW  | 
| 
 DBMAC  | 
 DEALLOCATE  | 
 DEBUG  | 
| 
 DEC  | 
 DECIMAL  | 
 DECLARE  | 
| 
 DEFAULT  | 
 DEFERRABLE  | 
 DEFERRED  | 
| 
 DEGREE  | 
 DELETE  | 
 DEREF  | 
| 
 DESC  | 
 DIRECTORY  | 
 DISABLE  | 
| 
 DISCONNECT  | 
 DISMOUNT  | 
 DISTINCT  | 
| 
 DISTRIBUTED  | 
 DML  | 
 DOUBLE  | 
| 
 DROP  | 
 DUMP  | 
 EACH  | 
| 
 ELSE  | 
 ENABLE  | 
 END  | 
| 
 ENFORCE  | 
 ENTRY  | 
 ESCAPE  | 
| 
 EXCEPT  | 
 EXCEPTIONS  | 
 EXCHANGE  | 
| 
 EXCLUDING  | 
 EXCLUSIVE  | 
 EXECUTE  | 
| 
 EXISTS  | 
 EXPIRE  | 
 EXPLAIN  | 
| 
 EXTENT  | 
 EXTENTS  | 
 EXTERNALLY  | 
| 
 FAILED_LOGIN_ATTEMPTS  | 
 FALSE  | 
 FAST  | 
| 
 FILE  | 
 FIRST_ROWS  | 
 FLAGGER  | 
| 
 FLOAT  | 
 FLOB  | 
 FLUSH  | 
| 
 FOR  | 
 FORCE  | 
 FOREIGN  | 
| 
 FREELIST  | 
 FREELISTS  | 
 FROM  | 
| 
 FULL  | 
 FUNCTION  | 
 GLOBAL  | 
| 
 GLOBALLY  | 
 GLOBAL_NAME  | 
 GRANT  | 
| 
 GROUP  | 
 GROUPS  | 
 HASH  | 
| 
 HASHKEYS  | 
 HAVING  | 
 HEADER  | 
| 
 HEAP  | 
 IDENTIFIED  | 
 IDGENERATORS  | 
| 
 IDLE_TIME  | 
 IF  | 
 IMMEDIATE  | 
| 
 IN  | 
 INCLUDING  | 
 INCREMENT  | 
| 
 INDEX  | 
 INDEXED  | 
 INDEXES  | 
| 
 INDICATOR  | 
 IND_PARTITION  | 
 INITIAL  | 
| 
 INITIALLY  | 
 INITRANS  | 
 INSERT  | 
| 
 INSTANCE  | 
 INSTANCES  | 
 INSTEAD  | 
| 
 INT  | 
 INTEGER  | 
 INTERMEDIATE  | 
| 
 INTERSECT  | 
 INTO  | 
 IS  | 
| 
 ISOLATION  | 
 ISOLATION_LEVEL  | 
 KEEP  | 
| 
 KEY  | 
 KILL  | 
 LABEL  | 
| 
 LAYER  | 
 LESS  | 
 LEVEL  | 
| 
 LIBRARY  | 
 LIKE  | 
 LIMIT  | 
| 
 LINK  | 
 LIST  | 
 LOB  | 
| 
 LOCAL  | 
 LOCK  | 
 LOCKED  | 
| 
 LOG  | 
 LOGFILE  | 
 LOGGING  | 
| 
 LOGICAL_READS_PER_CALL  | 
 LOGICAL_READS_PER_SESSION  | 
 LONG  | 
| 
 MANAGE  | 
 MASTER  | 
 MAX  | 
| 
 MAXARCHLOGS  | 
 MAXDATAFILES  | 
 MAXEXTENTS  | 
| 
 MAXINSTANCES  | 
 MAXLOGFILES  | 
 MAXLOGHISTORY  | 
| 
 MAXLOGMEMBERS  | 
 MAXSIZE  | 
 MAXTRANS  | 
| 
 MAXVALUE  | 
 MIN  | 
 MEMBER  | 
| 
 MINIMUM  | 
 MINEXTENTS  | 
 MINUS  | 
| 
 MINVALUE  | 
 MLSLABEL  | 
 MLS_LABEL_FORMAT  | 
| 
 MODE  | 
 MODIFY  | 
 MOUNT  | 
| 
 MOVE  | 
 MTS_DISPATCHERS  | 
 MULTISET  | 
| 
 NATIONAL  | 
 NCHAR  | 
 NCHAR_CS  | 
| 
 NCLOB  | 
 NEEDED  | 
 NESTED  | 
| 
 NETWORK  | 
 NEW  | 
 NEXT  | 
| 
 NOARCHIVELOG  | 
 NOAUDIT  | 
 NOCACHE  | 
| 
 NOCOMPRESS  | 
 NOCYCLE  | 
 NOFORCE  | 
| 
 NOLOGGING  | 
 NOMAXVALUE  | 
 NOMINVALUE  | 
| 
 NONE  | 
 NOORDER  | 
 NOOVERRIDE  | 
| 
 NOPARALLEL  | 
 NOPARALLEL  | 
 NOREVERSE  | 
| 
 NORMAL  | 
 NOSORT  | 
 NOT  | 
| 
 NOTHING  | 
 NOWAIT  | 
 NULL  | 
| 
 NUMBER  | 
 NUMERIC  | 
 NVARCHAR2  | 
| 
 OBJECT  | 
 OBJNO  | 
 OBJNO_REUSE  | 
| 
 OF  | 
 OFF  | 
 OFFLINE  | 
| 
 OID  | 
 OIDINDEX  | 
 OLD  | 
| 
 ON  | 
 ONLINE  | 
 ONLY  | 
| 
 OPCODE  | 
 OPEN  | 
 OPTIMAL  | 
| 
 OPTIMIZER_GOAL  | 
 OPTION  | 
 OR  | 
| 
 ORDER  | 
 ORGANIZATION  | 
 OSLABEL  | 
| 
 OVERFLOW  | 
 OWN  | 
 PACKAGE  | 
| 
 PARALLEL  | 
 PARTITION  | 
 PASSWORD  | 
| 
 PASSWORD_GRACE_TIME  | 
 PASSWORD_LIFE_TIME  | 
 PASSWORD_LOCK_TIME  | 
| 
 PASSWORD_REUSE_MAX  | 
 PASSWORD_REUSE_TIME  | 
 PASSWORD_VERIFY_FUNCTION  | 
| 
 PCTFREE  | 
 PCTINCREASE  | 
 PCTTHRESHOLD  | 
| 
 PCTUSED  | 
 PCTVERSION  | 
 PERCENT  | 
| 
 PERMANENT  | 
 PLAN  | 
 PLSQL_DEBUG  | 
| 
 POST_TRANSACTION  | 
 PRECISION  | 
 PRESERVE  | 
| 
 PRIMARY  | 
 PRIOR  | 
 PRIVATE  | 
| 
 PRIVATE_SGA  | 
 PRIVILEGE  | 
 PRIVILEGES  | 
| 
 PROCEDURE  | 
 PROFILE  | 
 PUBLIC  | 
| 
 PURGE  | 
 QUEUE  | 
 QUOTA  | 
| 
 RANGE  | 
 RAW  | 
 RBA  | 
| 
 READ  | 
 READUP  | 
 REAL  | 
| 
 REBUILD  | 
 RECOVER  | 
 RECOVERABLE  | 
| 
 RECOVERY  | 
 REF  | 
 REFERENCES  | 
| 
 REFERENCING  | 
 REFRESH  | 
 RENAME  | 
| 
 REPLACE  | 
 RESET  | 
 RESETLOGS  | 
| 
 RESIZE  | 
 RESOURCE  | 
 RESTRICTED  | 
| 
 RETURN  | 
 RETURNING  | 
 REUSE  | 
| 
 REVERSE  | 
 REVOKE  | 
 ROLE  | 
| 
 ROLES  | 
 ROLLBACK  | 
 ROW  | 
| 
 ROWID  | 
 ROWNUM  | 
 ROWS  | 
| 
 RULE  | 
 SAMPLE  | 
 SAVEPOINT  | 
| 
 SB4  | 
 SCAN_INSTANCES  | 
 SCHEMA  | 
| 
 SCN  | 
 SCOPE  | 
 SD_ALL  | 
| 
 SD_INHIBIT  | 
 SD_SHOW  | 
 SEGMENT  | 
| 
 SEG_BLOCK  | 
 SEG_FILE  | 
 SELECT  | 
| 
 SEQUENCE  | 
 SERIALIZABLE  | 
 SESSION  | 
| 
 SESSION_CACHED_CURSORS  | 
 SESSIONS_PER_USER  | 
 SET  | 
| 
 SHARE  | 
 SHARED  | 
 SHARED_POOL  | 
| 
 SHRINK  | 
 SIZE  | 
 SKIP  | 
| 
 SKIP_UNUSABLE_INDEXES  | 
 SMALLINT  | 
 SNAPSHOT  | 
| 
 SOME  | 
 SORT  | 
 SPECIFICATION  | 
| 
 SPLIT  | 
 SQL_TRACE  | 
 STANDBY  | 
| 
 START  | 
 STATEMENT_ID  | 
 STATISTICS  | 
| 
 STOP  | 
 STORAGE  | 
 STORE  | 
| 
 STRUCTURE  | 
 SUCCESSFUL  | 
 SWITCH  | 
| 
 SYS_OP_ENFORCE_NOT_NULL$  | 
 SYS_OP_NTCIMG$  | 
 SYNONYM  | 
| 
 SYSDATE  | 
 SYSDBA  | 
 SYSOPER  | 
| 
 SYSTEM  | 
 TABLE  | 
 TABLES  | 
| 
 TABLESPACE  | 
 TABLESPACE_NO  | 
 TABNO  | 
| 
 TEMPORARY  | 
 THAN  | 
 THE  | 
| 
 THEN  | 
 THREAD  | 
 TIMESTAMP  | 
| 
 TIME  | 
 TO  | 
 TOPLEVEL  | 
| 
 TRACE  | 
 TRACING  | 
 TRANSACTION  | 
| 
 TRANSITIONAL  | 
 TRIGGER  | 
 TRIGGERS  | 
| 
 TRUE  | 
 TRUNCATE  | 
 TX  | 
| 
 TYPE  | 
 UB2  | 
 UBA  | 
| 
 UID  | 
 UNARCHIVED  | 
 UNDO  | 
| 
 UNION  | 
 UNIQUE  | 
 UNLIMITED  | 
| 
 UNLOCK  | 
 UNRECOVERABLE  | 
 UNTIL  | 
| 
 UNUSABLE  | 
 UNUSED  | 
 UPDATABLE  | 
| 
 UPDATE  | 
 USAGE  | 
 USE  | 
| 
 USER  | 
 USING  | 
 VALIDATE  | 
| 
 VALIDATION  | 
 VALUE  | 
 VALUES  | 
| 
 VARCHAR  | 
 VARCHAR2  | 
 VARYING  | 
| 
 VIEW  | 
 WHEN  | 
 WHENEVER  | 
| 
 WHERE  | 
 WITH  | 
 WITHOUT  | 
| 
 WORK  | 
 WRITE  | 
 WRITEDOWN  | 
| 
 WRITEUP  | 
 XID  | 
 YEAR  | 
| 
 ZONE  | 
||