René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Table properties [Oracle SQL] | ||
[ column-properties ] [ table-partitioning-clauses ] [ cache | nocache ] [ parallel-clause ] [ rowdependencies | norowdependencies ] [ enable-disable-clause-1 [, enable-disable-clause-2 ....] ] [ row-movement-clause ] [ as subquery ]
The table properties appear as part within the
create table [heap] statement.
rowdependencies vs norowdependencies
The default is norowdependencies which keeps the
SCN of the last modification at block level. When a table is created with rowdependencies, the SCN of each row's last modification is stored along with the row (which also uses six additional bytes per row).
See also ora_rowscn.
|