Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Tablespace in Load Pending and Quiesce st

    Hi Folks

    Iam trying to load 5 tables into one tablespace and My Load job failed on multiple tables abd Tablespace is in Load Pending State.

    I tried following ways to bring it back to Normal State.

    1. Truncate the tables with /dev/null
    2.Run The Load Job With TERMINATE option


    None of these options works and i wonder if any of you folks faced the same situation

    Help would be greatly Appreciated.


    Thanks
    Prasad

  2. #2
    Join Date
    Jul 2001
    Posts
    32

    Re: Tablespace in Load Pending and Quiesce st

    Try to load with REPLACE option.

    Originally posted by koganti
    Hi Folks

    Iam trying to load 5 tables into one tablespace and My Load job failed on multiple tables abd Tablespace is in Load Pending State.

    I tried following ways to bring it back to Normal State.

    1. Truncate the tables with /dev/null
    2.Run The Load Job With TERMINATE option


    None of these options works and i wonder if any of you folks faced the same situation

    Help would be greatly Appreciated.


    Thanks
    Prasad

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Re: Tablespace in Load Pending and Quiesce st

    Got The Solution !!!!!

    I See So Many Load Processes Hanging. I killed all the pending Load processesand made sure no Process Hangging.

    I executed the command QUIESCE RESET with all the tables and Table Space Came out Of Quiesce Exclusive State.

    Then I executed LOAD from /dev/null on all the tables involved. Thats it !!! and i got the tablespace out of Load Pending State.

    I Hope My experience will help to some one who uses LOAD with no DBA Previleges.


    --Prasasd


    Originally posted by koganti
    Hi Folks

    Iam trying to load 5 tables into one tablespace and My Load job failed on multiple tables abd Tablespace is in Load Pending State.

    I tried following ways to bring it back to Normal State.

    1. Truncate the tables with /dev/null
    2.Run The Load Job With TERMINATE option


    None of these options works and i wonder if any of you folks faced the same situation

    Help would be greatly Appreciated.


    Thanks
    Prasad

Posting Permissions

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