creating storage extents for large tables 1

[cspeig]

Help.....
I'm trying to create table while enforcing
storage extents. Please take a look and tell me
what I'm doing wrong. This is my first at storage
manipulation. The example was taken form an SQL
handbook (SAMS to be specific). Note: I noticed that
the script had an unaccompanied "(" and "}".


SQL> create table ssa02
2 (status varchar2(2),
3 ssan varchar2(9),
4 name varchar2(22),
5 dod varchar2(8),
6 dob varchar2(8),
7 state varchar2(2),
8 zip1 varchar2(5),
9 zip2 varchar2(5))
10 storage
11 (initial extent 100M
12 next extent 20M
13 minextents 1
14 maxextents 121
15 pctincrease 0};
(initial extent 100M
*
ERROR at line 11:
ORA-02218: invalid INITIAL storage option value

****************************************************
*****found err mesage with copernic ****
ORA-02218 invalid INITIAL storage option value

Cause: The specified value must be an integer.

Action: Specify an appropriate integer value and try again

 

[karluk]

Try removing the word "extent", and just put the number:

storage
(initial 100M
next 20M
...

 

[JHoarty]

Try just creating your tables:

SQL> create table ssa02
2 (
3 status varchar2(2),
4 ssan varchar2(9),
5 name varchar2(22),
6 dod varchar2(8),
7 dob varchar2(8),
8 state varchar2(2),
9 zip1 varchar2(5),
10 zip2 varchar2(5)
11 );

And then use the alter table command to define extents:

ALTER TABLE SSA02 STORAGE (initial 100M next 20M maxextents 121);

That oughtta work. Let me know if it doesn't. John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[carp]

And it's probably just a typo, but the } on line 15 should be a ).
As Karluk already mentioned, the word extent is what's fouling up your syntax.