Introduction to the storage script [message #132461] |
Fri, 12 August 2005 18:53 |
Tafer
Messages: 64 Registered: July 2005 Location: Here!
|
Member |
|
|
CREATE TABLE shopping_list (
bananas NUMBER(2),
meat NUMBER(32,2),
vegetables NUMBER(1),
eggs NUMBER(2),
milk NUMBER(2),
liquor LONG,
money NUMBER(1,1)
)
STORAGE (
INITIAL 10 k
MINEXTENTS 1
MAXEXTENTS 50
);
I'm pretty new in this storage scrip for tables, and I have no idea if I'm doing something wrong.
When I run the script everything seems to be perfect... but when I check the information of the created table, the INITIAL, MINEXTENTS and MAXEXTENTS are completely different of those I wrote before. It seems that the table was created with some predefined numbers.
Any ideas, help?
Please, forgive my "English"
|
|
|
|
|