RE: Table creation Problem....

Do you know which tablespace the table is trying to create in? Have you run import to a list file to see the table creation statement - this may give you clues

Phil West
Unix Sys Admin and Oracle Financials DBA +44 (0) 20 7623 5222 x5221

-----Original Message-----
From: Deepender_Gupta_at_escorts.co.in
[mailto:Deepender_Gupta_at_escorts.co.in]
Sent: 08 August 2000 15:09
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).




*******************************************************************************

The information in this Internet e-mail is confidential and may be legally privileged.  It is intended solely for the addressee.  Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. 
 When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.


*******************************************************************************