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 |