| catalog.sql on 8i [message #145019] |
Mon, 31 October 2005 05:41  |
galaxy
Messages: 62
Registered: October 2005
|
Member |
|
|
Hello,
I tried to execute the script catalog.sql to prepare the database for an full export. Database is Oracle 8.1.7
The script starts, and do grants etc but it doesn't run until it is finished.
At one point, it stops (for example when it creates a synonym)
and it doesn't do anything more. Also when I wait 1 hour, nothing happends.
When i press Enter or a Mouse button, then sqlplus writes: "not responding"
But a few days ago I had started the script, without any error.
(I have to run it again, because I have a new Image on my pc)
What could be the problem?
Is it possible that sqlplus makes the error? Cann i run a script from anywhere else the from sqlplus?
Thanks for help
|
|
|
|
| Re: catalog.sql on 8i [message #145033 is a reply to message #145019] |
Mon, 31 October 2005 08:34  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to do some investigations yourself to find the problem. Start with the following:
1. Check for errors in your ALERT.LOG file;
2. Add "SET ECHO ON" to the top of catalog.sql and spool the output.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
