Barry,
Many thanks for your reply. I managed to sort out the problem a few weeks ago,
and was meaning to post a followon to this thread about the solution.
Essentially, I was told by my support people that when I created my
database, somehow, 'catalog.sql' was not run on the database. 'catalog.sql' should
have automatically been run at database creation time - I don't know why this didn't
happen.
Now I have run catalog.sql on my database/s and this seems to have fixed the problem.
To run 'catalog.sql' on the database, I have had to do a cold backup of the database
(just for precaution). Then rum the following command after login into thw database
in 'sqlplus'. (as sys user with sysdba).
The command to run is
@C:\oracle\ora92\rdbms\admin\catalog.sql
Thanks for the help again
Krish |