cachesqlget
Syntax
cachesqlget [ASYNCHRONOUS_WRITETHROUGH | CACHE_CONFIG |INCREMENTAL_AUTOREFRESH | ORACLE_DDL_TRACKING ][[<cache_group_owner>.]<cache_group_name>] <INSTALL|UNINSTALL> [<filename>]
Description
Generates an Oracle SQL*Plus compatible script for the installation or uninstallation of Oracle database objects associated with a readonly cache group, a user managed cache group with incremental autorefresh or an AWT cache group.
If INSTALL
is specified, the Oracle SQL statement to install
the Oracle database objects is generated.
If UNINSTALL
is specified, the Oracle SQL statement used to
remove the Oracle objects is generated. If a cache group is not specified with
UNINSTALL
, a SQL statement to remove all Oracle database objects in the
autorefresh user's account is generated.
If the optional filename
argument is included, the
generated SQL statement is saved to the specified external file. If the external file
exists, its contents are destroyed before writing to the file.
Examples
Command> cacheSqlGet SCOTT.MYCACHEGROUP INSTALL create.sql; Command> cacheSqlGet ASYNCHRONOUS_WRITETHROUGH INSTALL create.sql; Command> cacheSqlGet UNINSTALL;