| Calling EXECUTE command from UNIX script [message #97365] |
Thu, 28 March 2002 01:49  |
Mick Wall
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
Here is my unix script
#!/bin/sh
sqlplus cfs/cfs << EOF
set echo on
spool log/p16_anal_schema.log
EXECUTE dbms_utility.analyze_schema('CFS','COMPUTE');
EOF
the problem is that the sqlplus sessions just sits there until i type quit... then the execute starts.
but if i replace the EXECUTE line with say DESC tablename then the unix script runs, does the command and then exits as i would expect.
anybody and ideas?
Cheers
Mick
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
