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

Have you enclosed the table names with "? Like this:

"mytable"

instead of

mytable

"Chris" <cs123._no_spam__at_telstra.com> wrote in message news:r6kBb.46121$aT.18291_at_news-server.bigpond.net.au...
>
> "GX" <mailme_gx_at_hotmail.com> wrote in message
> news:4a51f3f8.0312090301.59473681_at_posting.google.com...
> > When trying to do and export from command line e.g.
> > exp userid=system_at_globaldb log=log.txt owner=rbs
> > We get the following error(s):
> >
> > EXP-00008: ORACLE error 942 encountered
> > ORA-00942: table or view does not exist
> > EXP-00024: Export views not installed, please notify your DBA
> > EXP-00000: Export terminated unsuccessfully
> >
> > We are running Oracle 9i on win2k server...
> > tables names were created in lowercase and this can not be avoided
> > because there is too much code to change in the application :(.
> >
> > This is most frustrating because there is no other way to backup data
> > (apart from backup which requires OMS which we are having problems
> > with too)
> >
> > We have tried a simple test on another machine create a table "test1"
> > export and import data and it works file. Is there something wrong
> > with the installation?
> > Or is Oracle a nice expensive tool that sits in the corner looks good
> > on paper and does nothing at all!
> >
> > GX
>
> You don't say what version of 9i you're running, but at a guess you may
need
> to run catexp.sql if your catalog views are not installed.
>
> BTW, there are other backup strategies apart from export, you don't need a
> OMS to backup the DB.
>
>
>
>
Received on Tue Dec 09 2003 - 12:55:11 CST