Next create a batch file called "C:\backup.bat" containing the following command. As an example, place the following RMAN commands in a file called "C:\cmdfile.txt". The method is very similar when using Recovery Manager (RMAN). (Start > Programs > Accessories > System Tools > Scheduled Tasks) or the AT scheduler. Sqlplus /nolog resulting batch file can be run manually, by double-clicking on it, or scheduled using the Scheduled Tasks Wizard Next, create a batch file called "C:\get_emp.bat" containing the following command. For example, save the following script in a file called "C:\emp.sql". To run a SQL script using SQL*Plus, place the SQL along with any SQL*Plus commands in a file and save it on your operating system. UNIX and Linux (Returning values from SQL). ![]() ![]() This article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN. ![]() Home » Articles » Misc » Here Oracle Shell Scripting
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |