Datafile autoextend error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Datafile autoextend error

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Question

    Hi!
    My users tablespace has one datafile users01.dbf which has autoextend on. I set it to on after the tablespace was created.
    Still it is giving error
    ORA-1653: unable to extend table EPRO3.ITCDATA by 16 in tablespace USERS
    To keep my work going I have manually created User02.dbf for now. But the PRoblem is interesting.
    Any Answers....




  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What is the NEXT and MAXSIZE for the autoextend clause. Make sure that your datafile hasn't reached the MAXSIZE the other possibility is there is not enough space in that disk to allocate your NEXT extent.

    Sanjay

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Yes, MAXSIZE was the problem. Thanks a lot Sanjay.

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