>> It is in mine (10.2.0.2):
>>
>> SQL> desc dba_registered_archived_log
>> Name Null? Type
>> ----------------------------------------- --------
>> ----------------------------
>> CONSUMER_NAME NOT NULL VARCHAR2(30)
>> SOURCE_DATABASE VARCHAR2(128)
>> THREAD# NOT NULL NUMBER
>> SEQUENCE# NOT NULL NUMBER
>> FIRST_SCN NOT NULL NUMBER
>> NEXT_SCN NUMBER
>> FIRST_TIME DATE
>> NEXT_TIME DATE
>> NAME VARCHAR2(513)
>> MODIFIED_TIME DATE
>> DICTIONARY_BEGIN VARCHAR2(3)
>> DICTIONARY_END VARCHAR2(3)
>> PURGEABLE VARCHAR2(3)
>> RESETLOGS_CHANGE# NOT NULL NUMBER
>> RESET_TIMESTAMP NOT NULL NUMBER
>>
>> Which release of 10g are you running?
>>
>> David Fitzjarrell
>
> don't forget that exist 10gR1 and 10gR2. Obviously andrea's 10g is R1
> where that column does not exist
>
> Bye
> Cristian Cudizio
it's true. I've 10g R1 and the column there isn't.
Received on Wed May 02 2007 - 12:24:30 CDT
