|
-
have a script with in it for example
#!/bin/ksh
sqlplus user/pass@instance <
analyze table xxx compute statistics;
analyze table yyy estimate statistics;
exit
EOF
The from the command line
nohup ./script.ksh &
You can then disonnect your session and it will run in the background
Hmm this forum messes up two of these < was supposed be two of them followed by EOF and then the commands
Last edited by marist89; 07-02-2004 at 10:25 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|