I am by no means a DBA so forgive me if this is a simple question. I
am attempting to run an export against my Oracle database. When doing
so I get the following:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR
character set
server uses WE8MSWIN1252 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported

About to export specified users ...
.. exporting pre-schema procedural objects and actions
.. exporting foreign function library names for user GDTMN_MNBUILD
.. exporting PUBLIC type synonyms
.. exporting private type synonyms
.. exporting object type definitions for user GDTMN_MNBUILD
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

Looking through the newsgroups I have found that catexp.sql needs to
be run in order to enable export. So, I ran this file as SYSDBA,
however my export is still not working. I then found some indication
that catalog.sql may need to be ran again? I just wanted to make sure
that this made sense and check that running catalog.sql would not "in
theory" affect my existing data in the database. Any advice is
greatly appreciated. Thanks!

On 21 Jul 2004 06:41:39 -0700, ahansen1@yahoo.com (Anders) wrote:

>I am by no means a DBA so forgive me if this is a simple question. I
>am attempting to run an export against my Oracle database. When doing
>so I get the following:
>
>Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 -
>Production
>With the Partitioning, OLAP and Oracle Data Mining options
>JServer Release 9.2.0.4.0 - Production
>Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR
>character set
>server uses WE8MSWIN1252 character set (possible charset conversion)
>Note: grants on tables/views/sequences/roles will not be exported
>
>About to export specified users ...
>. exporting pre-schema procedural objects and actions
>. exporting foreign function library names for user GDTMN_MNBUILD
>. exporting PUBLIC type synonyms
>. exporting private type synonyms
>. exporting object type definitions for user GDTMN_MNBUILD
>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
>
>Looking through the newsgroups I have found that catexp.sql needs to
>be run in order to enable export. So, I ran this file as SYSDBA,
>however my export is still not working. I then found some indication
>that catalog.sql may need to be ran again? I just wanted to make sure
>that this made sense and check that running catalog.sql would not "in
>theory" affect my existing data in the database. Any advice is
>greatly appreciated. Thanks!

'Still not working' calls for crystal balls. Are you getting the same
exact error messages. Likely your datadictionary is screwed up.
Running catalog.sql is non-intrusive, but right now you would better
select owner, object_name, object_type
from dba_objects
where status = 'INVALID'
something may be seriously wrong and/or you created the dictionary
when running as SYSTEM (or any other user not being SYS as SYSDBA)




--
Sybrand Bakker, Senior Oracle DBA

Thanks for your reply! Here is what I have tried now. You were
correct, I found that I had man "INVALID" obejcts when running your
query. So, I created a new SID to use for a simple test. In this new
database I created a new tablespace, TESTUSER and a new user TESTUSER.
I created a single table, TEST, in this database to attempt my
export. Then I attempted to export using the following:

-------------------------------------------------------------------------------
C:\Ora_Home\rdbms\admin>exp userid=system/tigger@TESTDB owner=TESTUSER
file=test.dmp grants=N compress=N consistent=Y recordlength=8192
Export: Release 9.2.0.4.0 - Production on Fri Jul 23 09:31:56 2004

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


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
character set
Note: grants on tables/views/sequences/roles will not be exported

About to export specified users ...
.. exporting pre-schema procedural objects and actions
.. exporting foreign function library names for user TESTUSER
.. exporting PUBLIC type synonyms
.. exporting private type synonyms
.. exporting object type definitions for user TESTUSER
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
-------------------------------------------------------------------------------

I then connected as sys/internal and ran the catexp.sql

-------------------------------------------------------------------------------
SQL> connect sys/internal@TESTDB as SYSDBA
Connected.
SQL> @catexp.sql
-------------------------------------------------------------------------------

I then tried exporting again using the same command shown above and
got the same 942 error shown above. I then verified that I still
didn't have invalid objects using:

-------------------------------------------------------------------------------
select count(*)
from dba_objects
where status = 'INVALID'
-------------------------------------------------------------------------------


Still no luck. Anyone have any ideas?

If running catexp.sql did not fix the problem, then I think that catalog.sql
won't either. I think that (and somebody correct me if I'm wrong) the
reason people sometimes run catalog.sql to fix this problem is that it in
turn calls catexp.sql. In principle, re-running catalog.sql shouldn't harm
your database - but you want to make sure you run the version that matches
your database!

Does the version of exp that you are using match the version of your
database?

--
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Anders" <ahansen1@yahoo.com> wrote in message
news:776f5b3c.0407210541.38c5bb49@posting.google.c om...
> I am by no means a DBA so forgive me if this is a simple question. I
> am attempting to run an export against my Oracle database. When doing
> so I get the following:
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 -
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.4.0 - Production
> Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR
> character set
> server uses WE8MSWIN1252 character set (possible charset conversion)
> Note: grants on tables/views/sequences/roles will not be exported
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user GDTMN_MNBUILD
> . exporting PUBLIC type synonyms
> . exporting private type synonyms
> . exporting object type definitions for user GDTMN_MNBUILD
> 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
>
> Looking through the newsgroups I have found that catexp.sql needs to
> be run in order to enable export. So, I ran this file as SYSDBA,
> however my export is still not working. I then found some indication
> that catalog.sql may need to be ran again? I just wanted to make sure
> that this made sense and check that running catalog.sql would not "in
> theory" affect my existing data in the database. Any advice is
> greatly appreciated. Thanks!