Look like you have some invalid views.
Run as sys to check for any invalid objects on the instances,
If you do have invalid objects, try to re-compile running
@$ORACLE_HOME/rdbms/admin/utlrp.sql to recompile all the invalid
objects.
If after you run the utlrp and still have invalid objects,
The best thing to do is put the instance on Migrate mode,
and re-run the catpatch.sql, check for any errors, re-run the catpatch
after correcting any errors.
Then shutdown and startup the instance, and re-run utlrp if necessary.
Hope this help,
David C
------------------------------------------------------------------------
----
David Chiu
-----Original Message-----
From: Amar P. Singh
[mailto:oracledba-ezmlmshield-x33788126.[Email address protected]
Sent: Wednesday, May 10, 2006 10:20 AM
To: LazyDBA Discussion
Subject: RE: Oracle Export Error
Did you upgraded your database server with a patchset recently?
With Regards,
Amar P Singh
-----Original Message-----
From: Pappas Dan
[mailto:oracledba-ezmlmshield-x16061399.[Email address protected]
Sent: Wednesday, May 10, 2006 7:47 PM
To: LazyDBA Discussion
Subject: RE: Oracle Export Error
Someone might have a better suggestion, but the following will work.
Once you have copied (inserted) the rows you want to keep into the new
table, then you can "truncate" the data in the original table. Next,
insert the records back into the original table from the new table.
Next, delete the new table.
Next, analyze the original table.
-----Original Message-----
From: Reddy S. Kadasani
[mailto:oracledba-ezmlmshield-x64327222.[Email address protected]
Sent: Wednesday, May 10, 2006 8:00 AM
To: LazyDBA Discussion
Subject: Oracle Export Error
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
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page