37 Reserved Words

This chapter lists the reserved words that should not be used to name objects in Warehouse Builder.

Reserved Words

Table 37-1 provides the list of reserved words. Do not use these words as physical object names within a Warehouse Builder Project. In addition to these reserved words, do not use words containing the prefix OWB$ as object names.

Note:

If you purchased the Oracle Warehouse Builder Name and Address component, there are reserved words in addition to Table 37-1. The words STDDEF, TABLEDEF, TABLEPAT, and USERDEF are reserved for performing parse table maintenance.

The Reserved Words are listed in a columnar table that reads down the columns from left to right to conserve space.

Table 37-1 List of Reserved Words

Reserved Words	Reserved Words (Cont.)	Reserved Words (Cont.)	Reserved Words (Cont.)
ACCESS	ADD	ALL	ALTER
AND	ANY	AS	ASC
AUDIT	BETWEEN	BY	CHAR
CHECK	CLUSTER	COLUMN	COMMENT
COMPRESS	CONNECT	CREATE	CURRENT
DATE	DECIMAL	DEFAULT	DELETE
DESC	DISTINCT	DROP	ELSE
EXCLUSIVE	EXISTS	FILE	FLOAT
FOR	FROM	GRANT	GROUP
HAVING	IDENTIFIED	IMMEDIATE	IN
INCREMENT	INDEX	INITIAL	INSERT
INTEGER	INTERSECT	INTO	IS
LEVEL	LIKE	LOCK	LONG
MATERIALIZED_VIEW	MAXEXTENTS	MINUS	MLSLABEL
MODE	MODIFY	NAME_ALREADY_COMMITTED	NAME_ALREADY_RESERVED_BY_YOU
NAME_RESERVED_BY_OTHER_SESSION	NOAUDIT	NOCOMPRESS	NOT
NOWAIT	NULL	NUMBER	OWB_NS_FATAL_ERROR
OWBNOOP	OF	OFFLINE	ON
ONLINE	OPTION	OR	ORDER
PCTFREE	PEER_RESERVATION	PRIOR	PRIVILEGES
PUBLIC	RAW	RENAME	RESOURCE
REVOKE	ROW	ROWID	ROWNUM
ROWS	SELECT	SESSION	SET
SHARE	SIZE	SMALLINT	START
STDDEF	SUCCESSFUL	SYNONYM	SYSDATE
TABLE	TABLEDEF	TABLEPAT	THEN
TO	TRIGGER	UID	UNION
UNIQUE	UPDATE	USER	USERDEF
VALIDATE	VALUES	VARCHAR	VARCHAR2
VIEW	WB_CUSTOM_TRANS	WB_PREDEFINED_TRANS	WHENEVER
WHERE	WITH	No Value	No Value