Skip to Main Content
  • Questions
  • Rows and column size - how large can a table be

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gabriel.

Asked: February 02, 2018 - 8:32 pm UTC

Last updated: February 03, 2018 - 4:47 am UTC

Version: Oracle database

Viewed 1000+ times

You Asked

Hi Tom,
Can an oracle database accommodate 127 million rows with maximum of 17 columns where each character is 1 in both rows and columns

and Connor said...

Yes. Trivially so. In fact, I can do it on my laptop in about 5mins and query it in just a few seconds.

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





Is this answer out of date? If it is, please let us know via a Comment

More to Explore

SQL

The Oracle documentation contains a complete SQL reference.