Database - RAC/Scalability (MOSC)

MOSC Banner

Export table from one Oracle database and import to another database

edited Jan 19, 2015 10:00AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Hi,

I have a doubt.

We can export table using expdp utility.

Let us consider that table has primary keys, check constraints, idexes.

This table is already exist in target database.

While importing that table to target database how to avoid any constraint violations etc. And also this source table has indexes, which takes more time to import table to target database.

Could anyone explain me how to solve this kind of scenario?

Thanks,

Chinna

Tagged:

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