Results 1 to 2 of 2

Thread: Freshman

  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Freshman

    Happy new year!!!

    My Environment-Oracle 8.1.7,WIN 2000,one default instance named ORCL,it is also a database name.
    I have few easy questions.
    First,what is a difference between parameter file and server parameter file?
    And,how to closed open database?
    I know I can do SHUTDOWN,and after that STARTUP MOUNT,but is it posible to write something like
    ALTER DATABASE CLOSE?
    Thanks for advice,Zvonimir

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    SPFile is a binary representation of the init.ora parameter file.

    And I thought there was an ALTER DATABASE CLOSE command, but couldn't find any reference to it. Changing database states is explained at http://download-west.oracle.com/docs...start.htm#6252

Posting Permissions

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