INITIAL extent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: INITIAL extent

  1. #1
    Join Date
    May 2002
    Posts
    232
    Hiiii,any one can help me
    SQL> CREATE TABLE message_LIST AS SELECT * FROM MESSAGE_LIST@DBLINK11.DIGI.COM.MY;
    CREATE TABLE message_LIST AS SELECT * FROM MESSAGE_LIST@DBLINK11.DIGI.COM.MY
    *
    ERROR at line 1:
    ORA-01658: unable to create INITIAL extent for segment in tablespace
    kavitha

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    01658, 00000, "unable to create INITIAL extent for segment in tablespace %s"
    // *Cause: Failed to find sufficient contiguous space to allocate INITIAL
    // extent for segment being created.
    // *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
    // tablespace or retry with a smaller value for INITIAL
    Reddy,Sam

  3. #3
    Join Date
    May 2002
    Posts
    232
    Hiiii,thanks
    kavitha reddy
    kavitha

  4. #4
    Join Date
    May 2002
    Posts
    232
    Hiii any one can give exact syntax for altering datafile.
    thanks
    kavitha

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Apr 2002
    Posts
    291
    Here is the syntax,
    Alter tablespace YOUR_TS add datafile '/u01/oradata/ORCL/df01_01.dbf' size 2000M;

    Solution for your problem is to add a datafile , b'coz it couldn't allocate sufficient space needed to create your table.

    hope this may help you.

    thanks
    PNRDBA

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    I recommend you

    to spend 1or2 minutes why you are getting the error before jumping on to dbasuppport.com and post a thread.

    For example say you want syntax: instead of asking for syntax here if you could search on the web for the same it takes 1 min and if you post here and wait and then go thru the link suggested by members it might take 3-5 min ( assuming one of the members respond here instantly). Its not just that you get syntax while going thru the syntax you learn other parameters/clauses and advantages of those parms and how to use 'em effectively... same true with any of the issues/problems/errors you hit day-to-day.

    All I'm saying here is do your homework first, then try getting help from outside... 75% of the times you don't seek help from outside, unless you are very novice in that technology.

    http://tahiti.oracle.com/pls/tahiti/...?remark=tahiti
    Reddy,Sam

  8. #8
    Join Date
    Apr 2002
    Posts
    291
    SREDDY is 100% right. I alredy posted the solution for that, still not working?? see, if your OS is linux/Unix, just type at $ prompt : oerr ORA -
    eg:
    $oerr ORA 01658

    This gives you the action to be taken.
    seems, The momnet you are struck, just posting the error in the forum, seeking help from others. I suggest you to go for reading in OTN and some other sites like tahiti.com, google search, and then still won't work, then come here.ok.
    Hope this may help you,

    Thanks
    PNRDBA

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