Oracle 行和列大小-表可以有多大

SQL> create table t tablespace largets nologging
  2  as select
  3     rownum c1
  4    ,rownum c2
  5    ,rownum c3
  6    ,rownum c4
  7    ,rownum c5
  8    ,rownum c6
  9    ,rownum c7
 10    ,rownum c8
 11    ,rownum c9
 12    ,rownum c10
 13    ,rownum c11
 14    ,rownum c12
 15    ,rownum c13
 16    ,rownum c14
 17    ,rownum c15
 18    ,rownum c16
 19    ,rownum c17
 20  from
 21    ( select 1 from dual connect by level <= 127 ),
 22    ( select 1 from dual connect by level <= 1000000 );

Table created.

Elapsed: 00:05:16.98
SQL>
SQL>   select count(*) from t;

  COUNT(*)
----------
 127000000

1 row selected.

Elapsed: 00:00:06.85