Skip to main content
Solved

Name of the IFS instance

  • June 2, 2022
  • 2 replies
  • 186 views
T
Hero (Partner)
Forum|alt.badge.img+13
  • TheoB
  • Hero (Partner)
  • 161 replies

Hello, I would like to find the name of the IFS instance in a table/view :


Is this possible?
Thank you! 

Best answer by sutekh137

I think this works:

SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual

 

Good luck,

Joe Kaufman

    2 replies

    S
    Hero
    Forum|alt.badge.img+12
    • sutekh137
    • Hero
    • 217 replies
    • Answer
    • June 2, 2022

    I think this works:

    SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual

     

    Good luck,

    Joe Kaufman

    Just because something is part of a plan doesn't make it right.
    R
    Hero (Partner)
    Forum|alt.badge.img+13
    • Ruchira
    • Hero (Partner)
    • 135 replies
    • June 3, 2022

    Hi,

    That instance name in the image is coming from the name of the MWS instance; if you have both MWS and database instances from the same name you can get it from sys_context 

    Cheers | Ruchira


    Terms & ConditionsCookie settingsAccessibility statement