Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Red face Unanswered: tablespace load pending

    newbie here..

    One of our tablespaces has been in load pending status for a while and no one can tell who was responsible for the load that caused the problem. I am now trying to find out which table in the tablespace caused the load pending status, where can I find that information?!

    Once I get the table info, do I still need to know the exact offending load command to cancel the load and put tablespace back in normal?!


    TIA.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: tablespace load pending

    In this situation I'll just go one table at a time in the LOAD QUERY command ...

    I don't think that you require the same LOAD Statement, but you'll need to know which user did it ...

    Cheers

    Sathyaram

    Originally posted by KenWhite
    newbie here..

    One of our tablespaces has been in load pending status for a while and no one can tell who was responsible for the load that caused the problem. I am now trying to find out which table in the tablespace caused the load pending status, where can I find that information?!

    Once I get the table info, do I still need to know the exact offending load command to cancel the load and put tablespace back in normal?!


    TIA.

Posting Permissions

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