Re: dba_tables.backed_up

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Fri, 06 Jan 2006 09:45:48 +0100
Message-Id: <pan.2006.01.06.08.45.47.291000@gmail.com>

On Thu, 05 Jan 2006 09:57:16 -0800, DA Morgan wrote:

> Jerome Vitalis wrote:

>> Hi,
>>
>> What is the real description for this column? The documentation is not
>> clear about this one.
>>
>> Even after a physical backup and no subsequent updates,
>> backed_up='N' for all tables according to my tests. The same after a
>> logical backup.
>>
>> This behavior seems to be the same whatever the Oracle version.
>>
>> Cheers,
>> Jerome

> 
> $ORACLE_HOME/rdbms/admin/catalog.sql
> 
> Search for "comment on column DBA_TABLES.BACKED_UP"

Thanks for your answer.
However the script comment is consistent with the documentation.

What I observe is that backed_up='N' even immediately after a backup (and no DDL or DML operations has occurred on the table after the backup.) Received on Fri Jan 06 2006 - 02:45:48 CST