8i Concept PCTFREE & PCTUSED are 0

From: Sinard Xing <sinardyxing_at_bcs-ach.com.sg>
Date: Mon, 18 Feb 2002 01:08:27 -0800
Message-ID: <F001.00412192.20020218010827@fatcity.com>

Hi all,

Oracle 8i (81600)

I create user Panadol and give unlimited quota on TBS.

as Panadol I create 1 table like this:

SQL> CREATE TABLE mytable(

  2     col1 char(3),
  3     col2 char(4),
  4     col4 varchar2(4)

  5 )
  6 PCTFREE 0
  7 PCTUSED 0
  8 STORAGE (
  9 INITIAL 20K
 10 NEXT 20K
 11 PCTINCREASE 0
 12 MAXEXTENTS 10
 13 )
 14 ;

Table created.

SQL> insert into mytable values('abc', 'abcd', 'a');

1 row created.

SQL> commit;

I don't understand That table PCTUSED is 0 ????? where Oracle keep those data ?

Look at this:

SQL> select * from mytable;

COL COL2 COL4
--- ---- ----
abc abcd a

Sinardy

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinard Xing
  INET: sinardyxing_at_bcs-ach.com.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 18 2002 - 03:08:27 CST