ORA-00054: resource busy and acquire with NOWAIT
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
