| Export error Error [message #62134] |
Tue, 29 June 2004 04:16  |
Rajesh Lad
Messages: 5
Registered: June 2004
|
Junior Member |
|
|
I am Working on a win2k Adv server Oracle 9.2.0.4 .
on the same server other two database is working fine.
While taking a export i am gatting this error
D:Server BAckuporacle>EXP nds/nds@PDONDS FILE=D:backupnds290604.DMP log=raj.
txt
Export: Release 9.2.0.4.0 - Production on Tue Jun 29 17:44:09 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
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user NDS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user NDS
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
Pl. Help i dont have any backup of data
Regards
Rajesh
|
|
|
|
| Re: Export error Error [message #62135 is a reply to message #62134] |
Tue, 29 June 2004 04:40  |
shoblock
Messages: 325
Registered: April 2004
|
Senior Member |
|
|
|
I just had this very same error last night. First, connect as sys and run catexp.sql (in rdbmsadmin) - it may have run successfully at upgrade/install time, but best to be sure. Then shutdown the database, and do a "startup migrate" - I think this must be done from sqlplus (connect ... as sysdba) since I couldn't find it on oem. Then (still in sqlplus connected as sys) run catpatch.sql (also rdbms/admin). Shutdown, startup (normal method). If you still have problems (probably not) grant EXP_FULL_DATABASE to the user doing the export.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
