Database Administration (MOSC)

MOSC Banner

impdp takes too much time to import index and constraint

edited Jan 24, 2012 11:33PM in Database Administration (MOSC) 5 commentsAnswered
 hi All,i have a schema level dump backup which we have practice to take on daily basis. and this schema level backup we import into development database as per request by user.
but problem is schema size reaches to 800G and all almost all tables have index and constraints. and tables have lob(c or b) data type as well. but index and constraints are applied on a column with varchar datatype. now main problem is tables are imported in normal time that take 10 to 12 hrs but constraints and index take 15 to 18hrs to complete. i m requesting to all of you is there any way i can do this with any alternate which takes short/less time as compared to impdp. 

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