Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    8

    Exclamation Unanswered: SQL Loader "resource busy"

    Hi,

    Hopefully someone can help me with this. I'm trying to load a small table from a text file with SQL Loader. Sometimes it works, but other times I get the following message. The only fix seems to be to bounce the instance. Any ideas?

    Thanks
    Charlie

    SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table PARTNERS.BUILDINGS_RE
    ORA-00054: resource busy and acquire with NOWAIT specified

  2. #2
    Join Date
    Jan 2003
    Location
    й
    Posts
    18

    Re: SQL Loader "resource busy"

    Originally posted by cpyne
    Hi,

    Hopefully someone can help me with this. I'm trying to load a small table from a text file with SQL Loader. Sometimes it works, but other times I get the following message. The only fix seems to be to bounce the instance. Any ideas?

    Thanks
    Charlie

    SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table PARTNERS.BUILDINGS_RE
    ORA-00054: resource busy and acquire with NOWAIT specified

    It is possible you have exceeded the MAXTRANS setting for the TABLE you are trying to update. You can query the MAXTRANS setting from DBA_TABLES. For example:
    SELECT TABLE_NAME, MAX_TRANS FROM DBA_TABLES WHERE TABLE_NAME='EMP';
    Increase the current MAXTRANS setting by running an ALTER TABLE statement. For example:
    ALTER TABLE "SCOTT"."EMP" MAXTRANS 255;

  3. #3
    Join Date
    Jun 2009
    Posts
    2

    Question sql*Loader-926

    Quote Originally Posted by yikaikai
    It is possible you have exceeded the MAXTRANS setting for the TABLE you are trying to update. You can query the MAXTRANS setting from DBA_TABLES. For example:
    SELECT TABLE_NAME, MAX_TRANS FROM DBA_TABLES WHERE TABLE_NAME='EMP';
    Increase the current MAXTRANS setting by running an ALTER TABLE statement. For example:
    ALTER TABLE "SCOTT"."EMP" MAXTRANS 255;
    It's already set to 255, what do you suggest?

  4. #4
    Join Date
    Jun 2009
    Posts
    2
    It's already set to 255, what do you suggest?

  5. #5
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by cpyne
    ORA-00054: resource busy and acquire with NOWAIT specified
    SQL*Loader is trying to truncate the table, but another process is selecting, inserting or deleting from that table, and thus it cannot be truncated.

    Make sure that no other session is changing data in that table or remove the "truncate" option from the control file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •