|Lesson 7||Using stored scripts |
|Objective || Use the run command.|
Using Stored Scripts in Oracle
In the previous lesson, you learned about managing stored scripts within Recovery Manager. This lesson introduces you to the
run command, which is used to execute stored scripts.
In addition, the
run command allows you to execute operating system commands and SQL commands.
run command operates, two things happen. The commands are compiled into blocks or steps of PL/SQL code.
Then, these steps are then stored in memory and executed. The compiled version of your script is not stored for later use. Take a look at some samples of the
run command in the SlideShow below:
Oracle Run Command Examples
It should be noted that you could use the
run command to execute the same syntax that you might have in a stored script. Below is an example of using the
run command to back up the USER_DATA tablespace.
allocate channel 1 type disk;
incremental level = 0
In the next lesson, you will learn what data dictionary views are available to you to interrogate the recovery catalog.