Home » SQL & PL/SQL » SQL & PL/SQL » Problem about create table
Problem about create table [message #35981] Sun, 28 October 2001 17:55 Go to next message
Henry
Messages: 14
Registered: November 2000
Junior Member
Pls Help!
After I execute SQL program to create table,the error list below:
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
What does it mean???
Best Regards,
Henry


----------------------------------------------------------------------
Re: Problem about create table [message #35989 is a reply to message #35981] Mon, 29 October 2001 07:07 Go to previous messageGo to next message
Phenoracle
Messages: 35
Registered: March 2001
Member
Hi,
At a first glance I would say that when your table whilst creating itself is trying to grab a large inital extent from the tablespace (remeber when a object is created it has to grab a storage area called an inital extent), but the available extents in the tablespace are to small.
Do you specify the storage parameters for the table.
...If not then the table will use the defaults set by the tablespace, they may be to large. Specify a smaller initail extent if possible.

One other solution maybe for your DBA to coalese the tablespace this may create a extent large enough for your table, or it just be a case that more space needs to be added to the tablespace.

Hope this was of help

Rae





----------------------------------------------------------------------
Re: Problem about create table [message #37098 is a reply to message #35981] Thu, 17 January 2002 09:38 Go to previous message
D Timms
Messages: 1
Registered: January 2002
Junior Member
You need to alter your datafile by turning autoextend on because it has run out of space.

Issue a command similar to tihs:

ALTER DATABASE DATAFILE ‘D:IMASTERTBSP.DBF’ AUTOEXTEND ON NEXT 10M MAXSIZE 500M;
Previous Topic: ERROR WHILE MANIPULATING A PL/SQL TABLE.
Next Topic: Re: Changing the Port of The Oracle Server
Goto Forum:
  


Current Time: Tue Jul 07 05:09:52 CDT 2020