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

Thread: Create spfile from pfile?

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    Create spfile from pfile?

    when we create spfile from pfile what are contents of spfile. is it replica of pfile in binary format or only some info from pfile are stored in spfile
    J Gangadhar

  2. #2
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    SP File is the binary format, but it can only written by Oracle ( alter system set parameter=some_value scope both/spfile; ) or
    create spfile from pfile.

    You can not edit directly in the spfile.ora file (as just we are doing on pfile.)
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  3. #3
    Join Date
    Jul 2003
    Posts
    134
    Originally posted by Dilippatel
    SP File is the binary format, but it can only written by Oracle ( alter system set parameter=some_value scope both/spfile; ) or
    create spfile from pfile.

    You can not edit directly in the spfile.ora file (as just we are doing on pfile.)
    Did you read the Question?

  4. #4
    Join Date
    Jul 2003
    Posts
    134

    Re: Create spfile from pfile?

    Originally posted by ganga
    when we create spfile from pfile what are contents of spfile. is it replica of pfile in binary format or only some info from pfile are stored in spfile
    Yes, everything gets recorded in the SPFILE in binary format when you build a SPFILE from PFILE.

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    You can not edit directly in the spfile.ora file (as just we are doing on pfile.)
    wanna bet?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by OracleDoc
    wanna bet?
    Well you can edit it, no doubt... but its not recommended, might get corrupted...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

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


Click Here to Expand Forum to Full Width