impdp stucked

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I waited for more than one hour.
The size of the table is 2.5 GB.
I have disabled all the constriants and It has bitmap, btree and unique indexes.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I am not sure how long it should take , usually it takes 5-10 minutes.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

It was at the same line from last one hr when I terminated the job. So I thinked that It got stucked.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "harry"."SYS_IMPORT_TABLE_04" successfully loaded/unloaded
Starting "harry"."SYS_IMPORT_TABLE_04": harry/******** directory=DATA_PUMP_DIR dumpfile=table.dmp logfile=table.log tables=stagingdata.ST_MHS_ENRLM content=data_only
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

when I was checking the status in the impdp help. I got status 100% completed but when I check data.
I could not find any thing this way I was thinking It got stucked.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.