Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to query the pfile location

451800Feb 20 2007 — edited Feb 20 2007

hi,

please let me know to get pfile location
like select name,value from v$parameter where name like '%pfile%';

when i give create pfile='d:/oracle/pfile%oracle_sid%.ora';

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2007

Added on Feb 20 2007

#general-database-discussions

9 comments

24,544 views