column_ref_clause
The following is the syntax for the column_ref_clause in the CREATE TABLE statement:
[WITH ROWID] [SCOPE IS [schema
.]scope_table_name
]
- WITH ROWID
Stores the ROWID with the REF in the table. This usually results in better performance, but uses more space.
- SCOPE IS
Restricts the scope of the ref_column or ref_attribute to scope_table_name.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.