Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Question Unanswered: cannot extent tablespace users

    Hello everybody,

    be patient with me:

    Application(using Oracle) generated error that table ABC is not able extent tablespace users about 144.
    The limit was set to 2048 and there was obviously know free space as seen in DBA Studio. So I tried to set value to 4096(there was enough space on discs). But then nobody couldn't launch app even.
    Then status of users01.dbf was offline(need recovery); so recovery didn't help, app didn't run.
    Solution: drop tablespaces users, create again; import dmp file.
    Is there any choice how to avoid to problems like these? And is it known bug?
    Thank you, hooky

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I would check the alertlog ... Sounds like something else was going on ...

Posting Permissions

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