Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Table creation Problem....

RE: Table creation Problem....

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Tue, 8 Aug 2000 06:54:11 -0700
Message-Id: <10583.114073@fatcity.com>


Do the following to see largest contiguous space available. Rick

SELECT MAX(bytes),MAX(blocks)
FROM dba_free_space
WHERE tablespace_name='tablespace_name';   

> -----Original Message-----
> From: Deepender_Gupta_at_escorts.co.in [SMTP:Deepender_Gupta_at_escorts.co.in]
> Sent: Tuesday, August 08, 2000 10:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Table creation Problem....
>
>
> Dear Experts,
>
> Today I faced a new problem on
> Operating system : NT
> Oracle 7.3 ( Tablespaces with raw partitioned files)
>
> I went to one of my clients the problem they reported were that they were
> not able to create a big table neither by using copy command nor by imp73.
> The error message was
>
> 01658 - "unable to create INITIAL extent for segment in tablespace %s".
> and
> 00600- internal error with 4097 argument.
>
> I went there and give the command " alter tablespace data coalesce" but
> problem could not resolve then I add a new datafile (Freeing the space by
> dropping one unused tablespace)
> as I felt that the database is fragmented and this may be a temporary
> solution.
>
> When I gave the copy or import command again then the error message was
> "0600 - internal error with 4097 argument" only. I am not even able to
> create the table from
> the exported file. the table is having 50 columns and 2.5 lacs of records.
> but i am able to create small tables with the large initial and next
> extent
> size (same as of my large table).
>
> I am not able to solve the problem kindly give your views....
>
> Thanks and regards
> Deepender
>
> --
> Author:
> INET: Deepender_Gupta_at_escorts.co.in
>
> 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).
Received on Tue Aug 08 2000 - 08:54:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US