Home » SQL & PL/SQL » SQL & PL/SQL » how much space for records (oracle 9i)
how much space for records [message #338394] Mon, 04 August 2008 17:30 Go to next message
veljobs
Messages: 6
Registered: July 2008
Junior Member
Hi ,

When I create this table ,
CREATE TABLE
pay
(
lid NUMBER
,ley NUMBER(6,0) NOT NULL
,fy NUMBER(10,0) NOT NULL

)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
NOCOMPRESS
LOGGING
STORAGE (
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST
GROUPS 1
BUFFER_POOL
DEFAULT
)
TABLESPACE "INF"
MONITORING ;

what actually happens ?
Does it allocate any space for records ? Or it allocates this only for the Table definition?

Thanks
Jay
Re: how much space for records [message #338396 is a reply to message #338394] Mon, 04 August 2008 17:37 Go to previous message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

> INITIAL 65536
Unwilling or incapable to RTFM?
http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses9a.htm#997253


Previous Topic: CLOB to LONG
Next Topic: LEFT JOIN
Goto Forum:
  


Current Time: Wed Dec 07 18:38:55 CST 2016

Total time taken to generate the page: 0.21069 seconds