Skip to Main Content
  • Questions
  • Error ORA-00942 while exporting database 19c (unix) with exp 12x (windows).

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Marc.

Asked: November 12, 2020 - 5:02 pm UTC

Last updated: September 07, 2021 - 7:10 am UTC

Version: EXP 12.2.0.1.0 DB 19.0.0.0

Viewed 10K+ times! This question is

You Asked

I have an ORA-00942 while exporting 19c database with exp 12c client installed on Windows server 2016
- CATEXP.SQL already executed.
- parameter file
File = ..\Export\Export1.dmp
Log = ..\Log\Export1.log
Full = N
Grants = Y
Indexes = Y
Rows = Y
Constraints = Y
Compress = Y
Consistent = Y
Statistics = none

exp UserId="SAMADMIN/*****@SAMT" ...

Export: Release 12.2.0.1.0 - Production on Thu Nov 12 17:56:07 2020

Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SAMADMIN
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SAMADMIN
About to export SAMADMIN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SAMADMIN's tables via Conventional Path ...
. . exporting table ACC 166 rows exported
. . exporting table ACC_TAB 13 rows exported
...
. . exporting table Z_IN_MODE 1 rows exported
. . exporting table Z_OUT_CRA 0 rows exported
. . exporting table Z_OUT_CRAD 0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
exp exited with error code 1

Thanks.

Regards.
Marc

and Connor said...

That is to be expected.

A *newer* exp or datapump can export an *older* database, but not vice-versa

You'll need to download a 19c client

https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Patrick Lelie, September 06, 2021 - 12:43 pm UTC

I got the same problem and thanks to this I learned that I needed to use a 19c client. Great.
But after that I needed to import that dumpfile into an 11.2.0.4. As I assumed to be able to import with an higher version of imp (you know backwards compability) into a lower version db, I used the same client to do the import (19c) and I got this : "IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
"
very confused now
Connor McDonald
September 07, 2021 - 7:10 am UTC

Export your 19c data with the 19c client.
Import your 11g data with the 11g client.

You *may* have some luck also using VERSION= to request that datapump handle the versioning, but I prefer sticking with the version that is associated with the data.

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.