Hello, I need a help and little urgent to meet the deadline of window. Sorry for that.

I was importing a table streamfilelog. This table has a unique cosntraint and an index. I did not drop the index but disabled the constraint.

SQL> select index_name,status from user_indexes where index_name like 'STREMFILELOG_UK1';

INDEX_NAME STATUS
------------------------------ --------
STREMFILELOG_UK1 VALID

SQL> select constraint_name,status from user_constraints where constraint_name like STREMFILELOG_UK1 ;

CONSTRAINT_NAME STATUS
------------------------------ --------
STREMFILELOG_UK1 DISABLED


The import terminates with following warnings. All rows were successfully imported. But I would like to know why am I getting "resource busy warnings"?

BTW, given the high volume of data in this table, I am running import of this same table in 20 parallel threads.

"ALTER TABLE "STREMFILELOG" ADD CONSTRAINT "STREMFILELOG_UK1 " UNIQUE ("STREAM_"
"REF") USING INDEX PCTFREE 0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1048576"
"00 FREELISTS 5 FREELIST GROUPS 1) TABLESPACE "TS_BILL_D01" LOGGING ENABLE "
IMP-00003: ORACLE error 54 encountered
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Import terminated successfully with warnings.


IMP: one more observation is when I query the same index, it is in a different TABLESPACE than what is showing here in red above. Any idea?

A quick response from experts will be sincerely appreciated!!

Thanks and Regards