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

Home -> Community -> Mailing Lists -> Oracle-L -> ora error 0600

ora error 0600

From: <Deepender_Gupta_at_escorts.co.in>
Date: Tue, 1 Aug 2000 15:49:28 +0530
Message-Id: <10576.113467@fatcity.com>


Dear all,

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

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" 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 Received on Tue Aug 01 2000 - 05:19:28 CDT

Original text of this message

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