Results 1 to 6 of 6

Thread: No Mount

  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: No Mount

    can anyone tell me a query that will show all available views in a no mount startup, and a mount startup.


    Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Peeps on here want to help, but can't do your homework for you. Why not try it for yourself and see which ones are/aren't available?

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  3. #3
    Join Date
    Dec 2003
    Posts
    10
    its not for hw it is an ec assignment that we were allowed to use forums etc. and i would try to see which ones but can not figure out where to start righ now

    Rich

  4. #4
    Join Date
    Dec 2003
    Posts
    10
    during nomount i can not get any query to get anything
    during mount i think only v$_ view will work........

  5. #5
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I very much doubt there is anyone on here that can tell you off the top of their head what is or isn't available (and there are some very knowledgeable chaps on here).

    I would imagine that to answer you question they would simply try it.....

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  6. #6
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    I agree with u Mr/Ms billm..

    In no mount stage you can query the views that gives info abt the system paramteres, control files & probably Datafiles

    v$parameter, v$control_files , v$datafile
    just check....
    Regards

Posting Permissions

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