DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$DATAFILE Columns

  1. 08-20-2002, 10:37 AM #1
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    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
    Reply With Quote Reply With Quote
  2. 08-20-2002, 10:39 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    http://otn.oracle.com/docs/products/...40.htm#1089670
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 08-20-2002, 10:45 AM #3
    Sameer's Avatar
    Sameer
    Sameer is offline Advisor
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width