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;