General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Dax Desai
Occasional Visitor

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

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
7 REPLIES
Ian Lochray
Respected Contributor

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

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

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

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

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

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
Honored Contributor

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

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.
Never give up, Keep Trying
Mikhail Ivanov
Honored Contributor

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

Hi.

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

Misha.
Massimo Bianchi
Honored Contributor

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

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
Honored Contributor

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

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.