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 Received on Tue Aug 08 2000 - 05:47:09 CDT