impdp takes too much time to import index and constraint
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.
0