Database Utilities (MOSC)

MOSC Banner

export schema with version =10 missing a table

edited Jan 24, 2017 3:50PM in Database Utilities (MOSC) 4 commentsAnswered ✓

Running expdp version 12.1.0.2 against a version 12.1.0.2 database in production.  Trying to export a schema with version=10.2.0.4 parameter skips just one table in the schema and doesn't produce an error.  If I run an expdp for just that table, with no version parameter or version=11.2, it works.  Exporting just the table with version=10.2.0.4 produces these errors:    

ORA_39166: Object schema1.table1 was not found or could not be exported or imported.  ORA-31655: no data or metadata objects selected for job.

I have compared this table with the one in our test environment using TOAD and no differences where shown. Exporting the schema in our test environment with version=10.2.4,  works without errors or missing tables.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center