RE: Very Urgent ,Help me

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Wed, 8 Nov 2000 18:26:37 -0800
Message-Id: <10674.121526@fatcity.com>

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_at_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_at_gecapital.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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
> >// 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_at_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_at_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_at_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_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Very Urgent ,Help me</TITLE>
</HEAD>
<BODY>

or resize the = datafile to a bigger size.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satar</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Madhavan Amruthur = [SMTP:mad012000_at_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>

<BR><FONT SIZE=3D2 FACE=3D"Arial">....</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">....</FONT>
</P>

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

<P><FONT SIZE=3D2 FACE=3D"Arial">create table/index</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">....</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hope this helps.</FONT>

Regards,

<P><FONT SIZE=3D2 FACE=3D"Arial">Madhavan</FONT>
</P>
<BR>

>From: "Dash, Saroj  = (CAP,CEF)" <Saroj.Dash_at_gecapital.com> >Reply-To: = ORACLE-L_at_fatcity.com
 >To: Multiple recipients of list = ORACLE-L <ORACLE-L_at_fatcity.com> >Subject: Very Urgent ,Help = me
 >Date: Wed, 08 Nov 2000 17:40:53 = -0800

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Hi,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;I got a problem of error ora =

1658.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Please tell me what are the best =
ways to solve this problem.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Tell me the step.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;THe problem is like this.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;, &quot;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

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;--</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A> >-- >Author: Dash, Saroj  = (CAP,CEF)
 >   INET: = Saroj.Dash_at_gecapital.com
 > >Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 >San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">&gt;-----------------------------------------------------=

---------------
 >To REMOVE yourself from this = mailing list, send an E-Mail message >to: ListGuru_at_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).

<FONT SIZE=3D2 =

FACE=3D"Arial">_________________________________________________________=
________________</FONT>

Get Your Private, Free E-mail from = MSN Hotmail at <A HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A>.

Share information about yourself, = create your own public profile at <A = HREF=3D"http://profiles.msn.com" =
TARGET=3D"_blank">http://profiles.msn.com</A>.

-- Please see the official ORACLE-L = FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Madhavan Amruthur</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

mad012000_at_hotmail.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_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 = Received on Wed Nov 08 2000 - 20:26:37 CST