Database Utilities (MOSC)

MOSC Banner

Exp 11.2 failing to export all tables

edited Jun 27, 2011 4:48AM in Database Utilities (MOSC) 3 commentsAnswered ✓
Hi,

a strange thing happened to me, I made an export with exp11.2 against a server 11.2 and out of 154 tables, only 63 have been exported. I have never seen that over about 20 years of using this utility.

On closer inspection I found that the tables which were not exported are all empty, but some of the empty tables were exported . I tried to use Oracle 10g export, but the result was the same.

The export command was simple: exp user/pwd@alias file=name.dmp log=name.log.

The tables are really missing in the dmp file, actually I found the problem when trying to import the file and creating foreign keys failed.

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