Re: 10g Recycle Bin

Michael42 wrote:
> Dan,
>
> If I interpret this right, will this allow row level FlashBack or PIT
> FlashBack on each row?
>
> Thanks for confirming,
>
> Michael
>
>
> DA Morgan wrote:

>> Michael42 wrote:
>>> Guys,
>>>
>>> Thanks for the responses - what a great feature!
>>>
>>> Extending this a bit, is you have "Enable Row Movement" set to Yes, are
>>> there any downsides to this?  The reason is to be able to use the
>>> Flashback Table PIT option.
>>>
>>> I guess the obvious question is why would one not do this for all
>>> tables?
>>>
>>>
>>> Thanks again,
>>>
>>> Michael
>> Not one I can think of that would affect my decision to use it. But one
>> feature you have not mentioned that has a cost of 6 bytes per row and in
>> my opinion is worth the price of admission is: ROWDEPENDENCIES which
>> allow for the use of the new ORA_ROWSCN pseudocolumn.
>>
>> Demo in Morgan's Library at www.psoug.org under ORA_ROWSCN.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

Please do not top post. Scroll to the bottom to reply.

Yes.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org