storage (initial 10M next 1M pctincrease 0) tablespace IDOT;
My initial storage is more than enough for my data. I have no problems creating this table.
Here is my second table.
CREATE TABLE table_2 (
storage (initial 3M next 1M pctincrease 0) tablespace IDOT;
Once again my storage is more than enough for my data ... BUT, I am getting an ERROR message.
ORA-01658: unable to create INITIAL extent for segment in tablespace IDOT
Could anyone tell me why I am getting this message? If anyone has any idea please reply, I have been working on this problem for over a week and still I can't figure it out.
Pleeeeeeeeeeeease .... anyone HELP !
12-17-2001, 05:21 PM
"ORA-01658: unable to create INITIAL extent for segment in tablespace IDOT"
If you got this error message, that means that you do not have enough contiguous space for the initial extent for the segment.
Try this, enlarge the datafile in IDOT tablespace.
Try this: Can you create a talbe using small initial extent?
12-18-2001, 01:16 AM
There is no problem with ur rollback segment creation..
CREATE TABLESPACE IDOT DATAFILE '/usr/local/oracle/8i/IDOT01.dbf'
SIZE 100M REUSE DEFAULT STORAGE (INITIAL 80M NEXT 5M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) PERMANENT;
change ur maxextents dont give unlimited give some size ,because once u give ut maxextents unlimited then oracle will inturn takes care of ur extents size so we might not know when it is getting filled up . Considering the performacne issue dont give unlimited extent size.Once the maximun specified extent size is reahce u can alter the size of the extent.
if ur initla exent is 5K and next is 5k...ur first exent size will be 5 once the first exent gets filled the next extents size will be 10 and the next one will we 15 .. this will exetnet till ur extends accoring to ur max exetnd size so if u give max extents unlimited u dont have the control over it!!
so remove the max extents unlimited from all the tablepace and try to give some size !!!
TRy this way ....if u have any queries revert back
12-18-2001, 09:00 AM
The way you have the tablespace sized you will allocate 80M for all four tables. First look at automatic allocation if you are running 8i/9i if not then look at the following
Also if you specify the right default storage on your tablespace then you don't need to specify storage parameters whenever you create a table in that tablespace. You do have a typo on your rollback creation you specified an inital extent of 80 which is 80 bytes. I think that you will find that Locally managed tablespaces are faster, easier to setup and require less maintenance. Also you may want to use the DBA Studio in 8i/or the Enterprise Manager Console in 9i. This would make it easier and keep you from wasting a week.
12-18-2001, 10:32 AM
OK, THANK YOU ALL FOR THE HELP !!
I have found a simple solution to my problem which seems to work beautifully.
However, I'm not sure if this solution is the most efficient one for my problem. If anyone has any warnings about doing this please let me know.
I simply turned ON the AUTOEXTEND option for my tablespace.
CREATE TABLESPACE IDOT DATAFILE '/usr/local/oracle/8i/IDOT.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
And also for the rollback segment tablespace.
CREATE TABLESPACE IDOT_RBS DATAFILE '/usr/local/oracle/8i/IDOT_RBS.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;