ok, here it is :

I have to create 4 tables. Here is the space I need for each of my tables.

table_1 - 2M
table_2 - 1M
table_3 - 75M
table_4 - 1M

So, thats gives me a total of about 80M.

I have created a tablespace for all 4 of my tables.

Here is the syntax for creating my tablespace.

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;

Now if I am not mistaken, if I create my own tablespace I have to create my own rollback segment.

But, in order to create my own rollback segment I should create a tablespace for it.

So, here is my tablespace for my rollback segment.

CREATE TABLESPACE IDOT_RBS DATAFILE '/usr/local/oracle/8i/IDOT01_RBS.dbf' SIZE 100M REUSE DEFAULT STORAGE
(INITIAL 80M NEXT 5M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) PERMANENT;

My rollback segment tablespace is created exactly the same way as my first tablespace.

Now here is how I created my rollback segment.

CREATE ROLLBACK SEGMENT IDOT_RBS1 TABLESPACE IDOT_RBS STORAGE (INITIAL 80 NEXT 80M MAXEXTENTS UNLIMITED);

Then I have to put my rollback segment ONLINE ...

ALTER ROLLBACK SEGMENT IDOT_RBS1 ONLINE;


Ok, so now I start to create my tables.

Here is how I create my first table.

CREATE TABLE table_1 (
field_1
field_2 ...

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 (
field_1
field_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.

It says,

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 !