Skip Headers
Oracle® Enterprise Manager Grid Control Installation and Basic Configuration
10g Release 2 (10.2) for Linux x86

Part Number B16228-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

H Oracle Reserved Words

This appendix provides a complete list of Oracle reserved words.

List of Oracle Reserved Words

In addition to the following reserved words, Oracle also uses system-generated names beginning with SYS_ for implicitly generated schema objects and sub-objects. Oracle discourages you from using this prefix in the names you explicitly provide to your schema objects and sub-objects to avoid possible conflicts in name resolution.

Table H-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

T_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