Re: exp error : ORA-00942: table or view does not exist on tables with lowercase names

Thank you Chriss

You were a great help.

I ran the catpatch.sql its seems to have got stuck in some sort of loop because it took forever to run and the output seemd to have a similar pattern. Eventaly after 2 hrs I gave up and aborted it.

Export works fine now

Regards
GX

"Chris" <cs123._no_spam__at_telstra.com> wrote in message news:<pWDBb.47435$aT.21467_at_news-server.bigpond.net.au>...
> "GX" <mailme_gx_at_hotmail.com> wrote in message
> news:4a51f3f8.0312100307.3ad7cc89_at_posting.google.com...
> > Thanx for the reply(s)
> >
> > The version of oracle is 9.2 with Patch p3095277_9204_WINNT installed.
> If you have upgraded the DB then you should have run catpatch.sql, which I
> suspect you haven't.
> If you created a DB after patching but used the preconfigured DB you'll be
> in the same situation.
>
> You'll have to shutdown the DB and startup migrate then run catpatch.sql.
Received on Thu Dec 11 2003 - 03:06:30 CST