Oracle tables and views can be documented in Predict with file objects of type OT and OV respectively. These file objects can be used to generate DDMs or CREATE TABLE/VIEW statements.

This document covers the following topics:

• Naming Conventions

• Oracle Table, File Type OT

• Oracle View, File Type OV

---

Naming Conventions

The following naming conventions apply for Oracle objects (Files of type OT and OV)

Upper / lower case

IDs must be entered in upper case. If the Predict parameter General Defaults > Miscellaneous > Upper/lower case / Object ID is set to L and you try and enter a file ID containing lower case letters, an error message is given.

See also section Defaults in the Predict Administration documentation.

Length

• Table/View names for Oracle objects can have up to 30 characters.

• A fully qualified ID (Creator + Hyphen + Table/View name) must not exceed 32 characters.

Permitted characters

• IDs containing special characters must be enclosed in double quotes, for example:

  "USR1"-"FIL£ABC"

• See overview of permitted characters in Naming Conventions.

Oracle Table, File Type OT

Parameters
TEMPORARY	Y	Global temporary table.
	N	Not temporary.
ORGANIZATION	Specify how the table is organized.
	H	Heap.
	I	Indexed.
	C	Clustered.
Cluster name	If a cluster name is entered here, the clause CLUSTER name is generated in the CREATE TABLE statement. The table is to be included in the specified cluster.
Number of partitions	The number of partitions of the table.
CACHE	Y	Yes.
	N	No.
ROWDEPENDENCIES	Y	Yes.
	N	No.
Archive/History table usage as	Name of the history or archive table linked to the Oracle table. If this option is selected, the following values can be set for "usage as":
	A	Archive table.
	H	History table.
	blank	Not specified. This is the default.
COMMIT	D	Delete.
	P	Preserve.
	blank	Not specified. This is the default.
INDEXING	Specify whether or not this table is indexed.
	Y	Yes. Table is indexed.
	N	No. Table is not indexed. This is the default.
RESULT_CACHE	Specify whether query results are stored in the result cache.
	D	Default.
	F	Force.
	blank	Not specified. This is the default.
ROW MOVEMENT	Y	Yes.
	N	No.
ROW_ARCHIVAL	Y	Yes.
	N	No.
Segment attributes
PCTFREE	If an integer from 1 - 99 is specified here, the clause PCTFREE n is generated in the CREATE TABLE statement. PCTFREE reserves a set amount of room in every block allocated to a table for future updates to that table's data.
PCTUSED	If an integer from 1 - 99 is specified here, the clause PCTUSED n is generated in the CREATE TABLE statement. PCTUSED specifies the minimum level of space usage that Oracle will maintain for each block of the table.
INITRANS	If a value from 1 - 255 is entered here, the clause INITRANS n is generated in the CREATE TABLE statement. INITRANS is the initial number of transaction entries that are allocated within each block.
Tablespace	If a tablespace name is entered here, the clause TABLESPACE name is generated in the CREATE TABLE statement. This name represents the tablespace in which the table will be created.
LOGGING	Specify whether or not to use the LOGGING clause in a CREATE TABLE or ALTER TABLE statement.
	Y	Yes.
	N	No.
	F	File system like.
	blank	Not specified. This is the default.
Segment storage
If specified, the values below are used in the STORAGE clause generated with the CREATE TABLE statement. All of the values below must be specified as integers.
INITIAL	The size of the first extent allocated when the object is created - the original amount of space allocated to the object. A value for Unit has to be applied in addition:
	K	Kilobyte.
	M	Megabyte.
	G	Gigabyte.
	T	Terabyte.
	P	Petabyte.
	E	Exabyte.
NEXT	The size of every subsequent extent to be allocated. A value for Unit has to be applied in addition. Possible values for Unit are described under INITIAL.
MAXSIZE	The MAXSIZE clause lets you specify the maximum size of the storage element.
OPTIMAL	Specifies an optimal size in bytes for a rollback segment.
MINEXTENTS	The total number of extents to be allocated when the segment is created.
MAXEXTENTS	The total number of extents, including the first, which can ever be allocated.
PCTINCREASE	The percent by which each NEXT extent will grow over the last extent allocated.
FREELISTS	The number of process free lists used to administer the free data blocks.
FREELISTS GROUPS	Magnitude of the set of free lists.
BUFFERPOOL	Determines the configuration of the buffer cache.
	D	Default
	K	Keep
	R	Recycle
	blank	not specified
FLASH_CACHE	Defines the configuration of a second tier of buffer cache on flash disks.
	D	Default
	K	Keep
	N	None
	blank	not specified
Heap organization
Table compression	Y	Yes.
	B	Basic.
	A	Advanced.
	QL	Query low.
	QH	Query high.
	Q1	Query low locking.
	Q2	Query high locking.
	AL	Archive low.
	AH	Archive high.
	A1	Archive low locking.
	A2	Archive high locking.
	NL	No row level locking.
	N	No.
	blank	Not specified. This is the default.
Index organization
MAPPING TABLE	Y	Yes.
	N	No.
PCTTHRESHOLD	Maximum size of the portion of the row that is stored in the index block, as a percentage of block size. Must be in the range of 1 to 50.
COMPRESS	Activate index compression for index-organized tables.
	Y	Yes.
	N	No.
	blank	Not specified. This is the default.
Compress length	Specify the compression length.
Index overflow
Refer to the descriptions given in Segment attributes above.
Index overflow storage
Refer to the descriptions given in Segment storage above.

Refer to your Oracle documentation for more information on these Oracle-specific parameters.

Oracle View, File Type OV

Parameters
Check constraint name	Name of check option used if parameter With check option is set. See SQL Attributes.