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

Thread: Patch

  1. 06-26-2003, 04:10 PM #1
    msuresh
    msuresh is offline Member
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159

    Patch

    Is there any way to extract all the Patch no from database.
    Reply With Quote Reply With Quote
  2. 06-26-2003, 10:34 PM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    select * from v$version;
    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  3. 06-27-2003, 02:39 AM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    AFAIK under Windows v$version is only updated by the Universal Installer. If you apply patches by copying files (e.g. 8.7.1.4.10) the only way is to look at the date stamps of the files (e.g. oracle.exe).
    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