how to avoid table chain?

I am trying to simulate a 700 column table, each column is varchar2(1). I created the data in a flat file and loaded into Oracle, looks like all the rows are chained and one block only hold 1 row. The block size is 16k, and average row length is 1409 from the "estimate statistics", I can't figure out why Oracle has to chain (I used the "pctfree 0"). The following is the partial "dba_tables" (I used "analyze table estimate statistics"):

OWNER TABLE_NAME B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE ---------- --------------- - ---------- ---------- ------------ ---------- OPS$DSHI SIMULATE N 3297 3,300 3099 14867 CHAIN_CNT AVG_ROW_LEN DEGREE INSTANCES CACHE TBL_LOCK ---------- ----------- ---------- ---------- ----- -------- 3297 1409 1 1 N ENABLED Thanks for you help.

David Received on Thu Jun 25 1998 - 17:58:02 CDT