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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).