Your Opinion please
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Your Opinion please

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    We have a user that has a quota. This user owns two tables in the database. Every night we have some files come in that get loaded into each table by SQL Loader. The other day the first load blew up but the second worked fine. The error message in the SQL Loader file said that the user's quota was hit.

    This is what I think happened. The user was right at the end of their quota. The first table it tried to load needed a new extent because it was out of room. When it went to grab the next extent it blew up. The next SQL Load started which loaded the 2nd table. That table had plenty of room so it loaded witout a problem.

    Does this sound reasonable? When we made the user's quota unlimited everything worked fine.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Did you check the alert.log?

    Remeber there is no basement in the Alamo!
    MH

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by lesstjm
    Does this sound reasonable?
    Yes, your assumptions are totaly correct.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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


Click Here to Expand Forum to Full Width