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

Thread: USN?

  1. 04-18-2002, 03:58 AM #1
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    What's a usn in the views v$rollname,v$rollstat.?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  2. 04-18-2002, 04:03 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Tarry
    What's a usn in the views v$rollname,v$rollstat.?
    Rollback segment number.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 04-18-2002, 04:10 AM #3
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you join v$rollstat and dba_rollback_segs with usn and segment_id
    Reply With Quote Reply With Quote
  4. 04-18-2002, 04:19 AM #4
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Ok!
    thanx julian/pando!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Reply With Quote Reply With Quote
  5. 04-18-2002, 05:02 AM #5
    Sonia
    Sonia is offline Senior Member
    Join Date
    Feb 2002
    Posts
    267
    also know as

    undo segment number

    sonia
    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