Name
CREATE SNAPSHOT
Synopsis
CREATE SNAPSHOT [schema
.]snapshot_name
[PCTFREEinteger
] [PCTUSEDinteger
] [INITRANSinteger
] [MAXTRANSinteger
] [LOGGING | NOLOGGING] [CACHE | NOCACHE] [CLUSTERcluster_name
(clustercolumnlist
) ] [TABLESPACEtablespace_name
] [STORAGE ( [INITIALinteger
[K | M] ] [NEXTinteger
[K | M] ] [MINEXTENTSinteger
[K | M] ] [MAXEXTENTS {integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ] [NOPARALLEL] [PARALLEL ( {DEGREE {integer
| DEFAULT} | INSTANCES {integer
| DEFAULT} } ) ] [USING INDEX [TABLESPACEtablespace_name
] [PCTFREEinteger
] [INITRANSinteger
] [MAXTRANSinteger
] [STORAGE ( [INITIALinteger
[K | M] ] [NEXTinteger
[K | M] ] [MINEXTENTSinteger
] [MAXEXTENTS {integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ] ] [REFRESH [FAST | COMPLETE | FORCE] [START WITHdate
] [NEXTdate
] [WITH PRIMARY KEY] [WITH ROWID] [USING DEFAULT [MASTER | LOCAL ] ROLLBACK SEGMENT] [USING [MASTER | LOCAL] ROLLBACK SEGMENTrollback_segment
] ] [FOR UPDATE ] AS snapshot_query
Creates a snapshot (snapshot_name), which is the result of a query run against one or more tables or views.
Keywords
- PCTFREE
Specifies the percentage of space to be reserved in each data block for future updates to rows contained in that block. Valid values are - 99, and the default value is 10.
- PCTUSED
Specifies the minimum percentage of space that will be maintained as used in each data block. The value may be in the range 1- 99, ...
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.