V$DATAFILE Columns
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$DATAFILE Columns

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Hi,

    Following two columns are from v$datafile.
    UNRECOVERABLE_CHANGE#,
    UNRECOVERABLE_TIME

    what these columns specify...

    One of my datafile has values

    UNRECOVERABLE_CHANGE# - 40280
    UNRECOVERABLE_TIME - 16.08.02 13:59:40

    and for rest of the datafiles it is NULL

    what it means?

    Thanks

    Sameer

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Thanks for the prompt reply..

    This column is always updated when an unrecoverable operation completes.

    but does this mean something has gone wrong with my datafile?

    Thanks

    Sameer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width