Exadata General (MOSC)

MOSC Banner

Wish list for Exadata and Oracle DB

edited Nov 6, 2012 4:41AM in Exadata General (MOSC) 2 commentsAnswered
I did the migration of big DB from Itanium to Exadata and choosed datapump import via dblink.

And found that datapump import via dblink not support single partitions import! The full tables only.

The disk-based datapump support partitions, but via dblink - not. Why not - I don't understand. Very strange from my view.

Is it possible to ask developers to allow import partitions via dblink ?
It is very important for migrations.

In my case the old system has very overloaded IO, so we cannot import full table at once. And about 80% of DB is in old partitions. We planned to copy old archived data (80% of DB) and during the downtime copy the small actual rest. But this datapump restriction don't allow us this strategy.

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