Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 0 Records Tables
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