Oracle® Database Recovery Manager Reference 10g Release 1 (10.1) Part Number B10770-02 |
|
|
View PDF |
sql::=
To execute a SQL statement or a PL/SQL stored procedure from within Recovery Manager.
SQL
keyword must be enclosed in double quotes. For example, use the following syntax:
SQL "CREATE TABLESPACE temp1 DATAFILE ''?/oradata/trgt/temp1.dbf'' SIZE 10M TEMPORARY";
If you attempt to use single quotes for the string following the SQL keyword or use only one set of single quotes for the filename, then the command fails.
SELECT
statements.
See Also:
For valid SQL syntax, see the Oracle Database SQL Reference |
This example backs up a tablespace and then archives all unarchived online logs:
BACKUP TABLESPACE users; SQL "ALTER SYSTEM ARCHIVE LOG CURRENT";
This example specifies a filename by using duplicate single quotes within the context of a double-quoted string:
SQL "ALTER TABLESPACE tbs_1 ADD DATAFILE ''/oracle/dbs/tbs_7.f'' NEXT 10K MAXSIZE 100k;"
This example issues a PL/SQL stored procedure called scott.update_log
:
RUN { SQL ' BEGIN scott.update_log; END; '; }