Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 0 Records Tables

Re: 0 Records Tables

From: David Zhu <dzhu_at_starnetinc.com>
Date: 1997/11/20
Message-ID: <34749637.4396@starnetinc.com>#1/1

qutub_at_hotmail.com wrote:
>
> Hi all,
>
> Can someboby tell me about the overheads of tables with 0 records in the
> database.
>
> Thanks.
>
> ABD
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to UsenetOracle table at least will use certain space, even with 0 records. The
amount of that space is decided by the 'initial' storage parameter you defined when you first create that table, or it will use the default value from the tablespace which the table created on. Use dba_tables, dba_tablespaces, dba_extents to find above information. Received on Thu Nov 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US