Re: Flashback Query - Sanpshot Too Old Error

"Prem K Mehrotra" <premmehrotra_at_hotmail.com> wrote in message news:43441e77.0411220925.82508cd_at_posting.google.com... --snip--
> I still do not know whether Oracle uses pctversion or retention,
>
> 1. when I specify pcversion 15 in create table statement, oracle shows:
> pctversion 15 retention 604800
>
> 2. When I specify RENETION in create table statement, oracle shows
> pctversion 10 retention 604800
>
> 3. When I do not specify anything in create table related to clob, oracle
> shows
> pctversion 10 retention 604800
>
> I am looking into user_lobs
>
> I am also not getting flashback error any more.
>
> I am using segment space management auto by mistake (without realizing). I see
> some bugs related to this with lobs, so it is possincle clob got corrupted
> or so.
>
> Prem

I think the following is true based on my tests (i.e. setting retention/pctversion and looking at sys.lob$.flags column):

It should use retention IF that is set and IF you are using AUM and IF pctversion is not set.

It should use pctversion IF that is set or if you are not using AUM.

So in all of your cases above:

1. should use pctversion
2. should use retention
3. should use retention .. but I think it really does use pctversion of default 10.

One note I read (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=268476.1) does clear things a little bit. It also mentions that the compatible parameter should be set to at least 9.2 for the retention parameter
to work.

Open a Tar and see what oracle support has to say about this... I guess oracle could not have made it more confusing :)

Anurag Received on Mon Nov 22 2004 - 18:32:54 CST