Full export fails, but user-level exports work EXP-00024 error

[Dax Desai]

user exports work, but full export fails. Also when trying to reimport a full dmp it fails on this database. I have tried rerunning catalog.sql and catexp.sql, but still I get the same error. This is an 8.1.7.2 database.
-------------------
exp dax/dax

Export: Release 8.1.7.2.0 - Production on Fri May 9 09:32:48 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Enter array fetch buffer size: 4096 >

Export file: ./expdat.dmp >

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 1

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
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
oracle@wild DSTR02E /usr/local/oracle/8.1.7/rdbms/admin
$ t views not installed, please notify your DBA

[Ian Lochray]

When you ran catalog.sql had you done a connect internal first?

[Yogeeraj_1]

hi,

first step in troubleshooting this is to:

1. Connect as sys or internal user -
2. Run $ORACLE_HOME/rdbms/admin/catexp.sql script

please do and try the export again.

Hope this helps!

regards
Yogeeraj

[T G Manikandan]

I would first suggest you to export the data using a user who has EXP_FULL_DATABASE privilege.

Does dax user have that privilege.

Try exporting using system or sys user.

Else grant the rights to dax and then try exporting the database.

sql>grant exp_full_database to dax;

Revert

[Indira Aramandla]

Hi,

Make you sure you execute $ORACLE_HOME/rdbms/admin/catalog.sql as (logged in as internal). This will also run catexp.sql and create the required views.
Then try exporting and see.

[Mikhail Ivanov]

Hi.

Make sure your Client and Server Oracle versions are the same.

Misha.

[Massimo Bianchi]

Hi,
check also this note, if the installation of catexp,sql (as pointed by others) does not work:


fix:

Problem
=======

On a system running multiple database versions the attempt to export objects
from a version 8.1.7.3.0 database failed with the following errors:

C:\>exp system/passwd file=c:\x.dmp full=y log=c:\x.log
.
Export: Release 9.0.1.2.1 - Production on Thu May 2 14:33:53 2002
.
(c) Copyright 2001 Oracle Corporation. All rights reserved.
.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
.
- Setting event tracing on 8.1.7.x database
.
SQL> alter system set events='942 trace name errorstack';
.
- Repeating export
.
- Viewing trace content:
.
*** SESSION ID:(19.23017) 2002-05-02 14:33:53.719
*** 2002-05-02 14:33:53.719
ksedmp: internal or fatal error
ORA-00942: table or view does not exist
Current SQL statement for this session:
.
SELECT VALUE FROM SYS.EXU9GSAS
.
- Verifying on different database versions:
.
Version 9.0.1
~~~~~~~~~~~~~
SQL> select * from v$version;
.
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.2.1 - Production
PL/SQL Release 9.0.1.2.1 - Production
CORE 9.0.1.2.0 Production
TNS for 32-bit Windows: Version 9.0.1.2.0 - Production
NLSRTL Version 9.0.1.2.0 - Production
.
SQL> SELECT VALUE FROM SYS.EXU9GSAS;
.
VALUE
-------------------------------------------------------------------
524288
.
.
8.1.7.3
~~~~~~~
SQL> select * from v$version;
.
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
PL/SQL Release 8.1.7.3.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.3.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
.
SQL> SELECT VALUE FROM SYS.EXU9GSAS;
SELECT VALUE FROM SYS.EXU9GSAS
. *
ERROR at line 1:
ORA-00942: table or view does not exist
.
==> That's our problem!!

Cause:
======
This problem was caused by using a version 9.0.1 export utility to export
data from a version 8.1.7.x database. You can run into this problem if not
validating the PATH environment variable before starting the export.


To avoid this problem
=====================
1. Control your currently used PATH environment variable.
2. Control the export banner to verify export version and database version.


Example
=======

C:\>exp system/passwd file=c:\x.dmp full=y log=c:\x.log
.
Export: Release 9.0.1.2.1 - Production on Thu May 2 14:33:53 2002
=========================
Export utility version

(c) Copyright 2001 Oracle Corporation. All rights reserved.
.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
==============================================
Database version

With the Partitioning option
JServer Release 8.1.7.3.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

[twang]

Please check the versions of export utility and oracle server. You cannot use a higher version of the export utility with an earlier version of the Oracle server. It seems that your target database is of an earlier release.