DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: 'unable to create INITIAL extent'

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    When I try to create a table in my already existing tablespace, I get the error
    ORA-01658: ' unable to create INITIAL extent for segment in tablespace PROVISION'

    What does this mean. What are the steps I need to take for this?
    Please it is very urgent. Thanks for any help.

    Shiva.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You don't have enough space in the PROVISION tablespace to create your object. Either modify the INITIAL storage parameter, or add more space to the PROVISION tablespace.
    Jeff Hunter

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You don't have space left on the tablespace. Add datafile or resize existing datafile if its 734 version and above.
    Reddy,Sam

  4. #4
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    I have found the solution by increasing the datafile size.

    Thanks a lot.

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