Database Utilities (MOSC)

MOSC Banner

datapump import - schema imp does not import one table.

edited Oct 8, 2009 12:33AM in Database Utilities (MOSC) 9 commentsAnswered
 I have an export file from Solaris 10/oracle 10gr2  When I import it in to unbreakable linux/10.2.0.4 I load all tables, except the first which gives a message . . imported "OLDDW"."RP_PAID_TRANSACTION"               22.89 GB       0 out of 74833183 rows

I do not get any error message (later some grants to another user fail because that user does not exist).

6 other tables are loaded successfully.  This table is 3 times the size of the next largest.

I have done this load repeatedly, with the same results.
Through EM and command line.

No errors in alert or trace, or log file.

Any ideas about why, or pointers to add tracing? Or places to look for clues?

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