Jump to content
ifmx

ORA-04063

Recommended Posts

Oracle 12.1.0.2.0. Unexpectedly Data Pump Export starts to report about identical errors on 5 tables:

ORA-31693: Table data object "EDS_DEV"."EMAILS":"ACTIVE" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-02373: Error parsing insert statement for table "EDS_DEV"."EMAILS".

ORA-04063: table "EDS_DEV.EMAILS" has errors

Need your assistance to understand what does this errors mean and also how to avoid it?

Share this post


Link to post
Share on other sites

Hi, and welcome to the forum!

This is a tough issue because there is no detailed error message.

Here are a few suggestions:

1 - Try using the “version” clause in the exp do command.  version=12.1.2.0

http://www.dba-oracle.com/t_export_import_different_releases_of_oracle.htm

2 - check to see if the tables are different from the others, such as the tables having LOB columns:

Hope this helps!

Share this post


Link to post
Share on other sites

1. My version doesn't support 12.1.2.0:

Export: Release 12.1.0.2.0 - Production on Wed Feb 21 14:12:04 2018

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

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-39023: Version 12.1.2.0 is not supported.

 

2. There are 3 schemas (eds_dev, eds_tst and eds_prd) in the db with identical tables (please take a look to attached file. Unfortunately 1 of them gives error mentioned (ORA-04063). Another two work fine...

schema.sql

Share this post


Link to post
Share on other sites

Differ only default tablespace where tables are located. All 3 schemas have it's own - eds_dev, eds_tst and eds_prd accordingly. So, looks like problem exists inside eds_dev tablespace. Please correct me if I am wrong. Is there any tool for checking/repairing physical consistency of tablespace files (like oncheck in Informix)?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×