Hi,



I am trying to export my oracle database to a dump file using the
following export command. I created the database using an import from an
existing dump file. But exporting it out causes an error. Any help will
be appreciated.



Exp test/[Email Address Removed] file= C:\textdb.dmp full=y





Export: Release 9.2.0.6.0 - Production on Wed May 10 09:46:50 2006



Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.





Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set



About to export the entire database ...

. exporting tablespace definitions

. exporting profiles

. exporting user definitions

. exporting roles

. exporting resource costs

. exporting rollback segment definitions

. exporting database links

. exporting sequence numbers

. exporting directory aliases

. exporting context namespaces

. exporting foreign function library names

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions

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



Thanks

-RK




Oracle LazyDBA home page