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

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Marc.

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

Answered by: Connor McDonald - Last updated: November 16, 2020 - 4:00 am UTC

Category: Database Administration - Version: EXP 12.2.0.1.0 DB 19.0.0.0

Viewed 100+ times

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 we 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

More to Explore

Utilities

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