Shell Programming and Scripting

Hi
All,

sqlplus << DO_THIS
sys/cleanitup as sysdba

CREATE TABLESPACE application DATAFILE '/u51/ORACLE/CMS/PICS_app01.dbf' SIZE 314572800 REUSE AUTOEXTEND ON NEXT 104857600 MAXSIZE
2000M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING;

DO_THIS

sqlplus << DO_THIS_NEXT
system/cleanitup

DO_THIS_NEXT
.... statements....
sqlplus << DO_FINAL
system/cleanitup

DO_FINAL
...statments..
sqlplus << DO_THIS
system/cleanitup

DO_THIS
sqlplus << DO_THIS_LAST
sys/cleanitup as sysdba
@$ORACLE_BASE/restore/scripts/tablespace_read_only.sql
exit;
DO_THIS_LAST

Now I want to know what does all the staement with bold black font means.

Thanks,
Vishal

Message was edited by:
vishal patel

sqlplus is a program that wants to read sql commands. You could put sql commands into a file and have sqlplus read that file via:
sqlplus < do_this.txt
but now you have a bunch a extra files to go with your shell script. By using a "here document" you can include a text data file directly in the script.

An example from the command line:

Code:

$
$ cat math.txt
1 + 1
$ bc < math.txt
2
$
$
$
$ bc <<anything
> 1 + 1
> anything
2
$

That "anything" is just some way to let the shell know when the input is finished. The "here document" extends to a line with just "anything" on it. This means that I cannot have a line in my "here doc" of just "anything". So I must pick a delimiting string that will not collide with my data.