Database Backup and Recovery (MOSC)

MOSC Banner

Data Pump and MAX_STRING_SIZE

I was testing the import of some tables, exported from a 12.2.0.1.0 Enterprise DB, to another one of the *same* Oracle release version.

This failed, at a preliminary stage; due to the dump file being of an incompatible version (5.1). I was wondering if this could be related to the fact that the exporting DB had been converted to MAX_STRING_SIZE=EXTENDED and the importing one remains at the default setting?

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