| Problem about create table [message #35981] |
Sun, 28 October 2001 17:55  |
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  |
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 |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
