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 1 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 !
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 1 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 !