Home » RDBMS Server » Server Administration » Introduction to the storage script
Introduction to the storage script [message #132461] Fri, 12 August 2005 18:53 Go to next message
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"


Re: Introduction to the storage script [message #132476 is a reply to message #132461] Sat, 13 August 2005 02:10 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
The final values also depends on your blocksize, number of freelists, type of tablespace, etc. See the "storage_clause" section in the SQL Reference guide for details.

Best regards.

Frank
Re: Introduction to the storage script [message #132883 is a reply to message #132476] Tue, 16 August 2005 09:57 Go to previous message
Tafer
Messages: 64
Registered: July 2005
Location: Here!
Member
Frank, thanks.


Previous Topic: Error Install ORACLE 9i on AIX 5.3 (oracle http server)
Next Topic: how to findout what are Oracle Instance is avaliable on different Unix boxes
Goto Forum:
  


Current Time: Sun Jan 26 10:40:18 CST 2025