Message-Id: <10674.121526@fatcity.com> From: Satar Naghshineh Date: Wed, 8 Nov 2000 18:26:37 -0800 Subject: RE: Very Urgent ,Help me This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C049F4.7C9AE400 Content-Type: text/plain or resize the datafile to a bigger size. Satar > -----Original Message----- > From: Madhavan Amruthur [SMTP:mad012000@hotmail.com] > Sent: Thursday, November 09, 2000 2:26 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Very Urgent ,Help me > > Hi Saroj, > The problem is that you are not able to create a segment (table, index, > etc) > in a tablespace because there is no space in the tablespace. > > One solution is to create the segment in a different tablespace where > there > is space > create table/index > tablespace > .... > .... > > Or add a datafile to the tablespace and then create the segment. > alter table add datafile ...... > > create table/index > .... > > Hope this helps. > Regards, > > Madhavan > > > >From: "Dash, Saroj (CAP,CEF)" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >Subject: Very Urgent ,Help me > >Date: Wed, 08 Nov 2000 17:40:53 -0800 > > > >Hi, > > > >I got a problem of error ora 1658. > > > >Please tell me what are the best ways to solve this problem. > > > >Tell me the step. > >THe problem is like this. > > > >, "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 > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Dash, Saroj (CAP,CEF) > > INET: Saroj.Dash@gecapital.com > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Madhavan Amruthur > INET: mad012000@hotmail.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C049F4.7C9AE400 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Very Urgent ,Help me

or resize the = datafile to a bigger size.

Satar

    -----Original Message-----
    From:   Madhavan Amruthur = [SMTP:mad012000@hotmail.com]
    Sent:   Thursday, November 09, 2000 2:26 AM
    To:     Multiple recipients of list ORACLE-L
    Subject:       = Re: Very Urgent ,Help me

    Hi Saroj,
    The problem is that you are not able = to create a segment (table, index, etc)
    in a tablespace because there is no = space in the tablespace.

    One solution is to create the segment = in a different tablespace where there
    is space
    create table/index = <name>
    tablespace = <another_tbs_name>
    ....
    ....

    Or add a datafile to the tablespace = and then create the segment.
    alter table <curr_tbs_name> add = datafile ......

    create table/index
    ....

    Hope this helps.
    Regards,

    Madhavan


    >From: "Dash, Saroj  = (CAP,CEF)" <Saroj.Dash@gecapital.com>
    >Reply-To: = ORACLE-L@fatcity.com
    >To: Multiple recipients of list = ORACLE-L <ORACLE-L@fatcity.com>
    >Subject: Very Urgent ,Help = me
    >Date: Wed, 08 Nov 2000 17:40:53 = -0800
    >
    >Hi,
    >
    >I got a problem of error ora = 1658.
    >
    >Please tell me what are the best = ways to solve this problem.
    >
    >Tell me the step.
    >THe problem is like this.
    >
    >, "unable to create INITIAL = extent for segment in tablespace %s"
    >// *Cause:  Failed to find = sufficient contiguous space to allocate INITIAL
    >//        &nb= sp; extent for segment being created.
    >// *Action: Use ALTER TABLESPACE = ADD DATAFILE to add additional space to
    >the
    >//        &nb= sp; tablespace or retry with a smaller value for INITIAL
    >--
    >Please see the official ORACLE-L = FAQ: http://www.orafaq.com
    >--
    >Author: Dash, Saroj  = (CAP,CEF)
    >   INET: = Saroj.Dash@gecapital.com
    >
    >Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
    >San Diego, = California        -- Public Internet = access / Mailing Lists
    >-----------------------------------------------------= ---------------
    >To REMOVE yourself from this = mailing list, send an E-Mail message
    >to: ListGuru@fatcity.com (note = EXACT spelling of 'ListGuru') and in
    >the message BODY, include a line = containing: UNSUB ORACLE-L
    >(or the name of mailing list you = want to be removed from).  You may
    >also send the HELP command for = other information (like subscribing).

    _________________________________________________________= ________________
    Get Your Private, Free E-mail from = MSN Hotmail at http://www.hotmail.com.

    Share information about yourself, = create your own public profile at
    http://profiles.msn.com.

    --
    Please see the official ORACLE-L = FAQ: http://www.orafaq.com
    --
    Author: Madhavan Amruthur
      INET: = mad012000@hotmail.com

    Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
    San Diego, = California        -- Public Internet = access / Mailing Lists
    ---------------------------------------------------------= -----------
    To REMOVE yourself from this mailing = list, send an E-Mail message
    to: ListGuru@fatcity.com (note EXACT = spelling of 'ListGuru') and in
    the message BODY, include a line = containing: UNSUB ORACLE-L
    (or the name of mailing list you want =