Thursday, April 17, 2008

Create pfile from memory...

During the post 11g upgrade steps, I discovered a new feature in 11g.
In the 11g database, you can now create a pfile/spfile from memory !

I was used to create a pfile from the current spfile in 10g, and offcourse create a spfile from the adjusted pfile...but now it's also possible to creaet a pfile from memory. The syntax is almost the same..

[oracle@ebs2 log]$ sqlplus '/ as sysdba'
SQL*Plus: Release - Production on Wed Apr 16 17:06:02 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:

Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create pfile='/ebs/proddb/11.1.0/dbs/init_prod.ora' from memory;

File created.

1 comment:

Tents Suppliers Nigeria said...

Al Fares International Tents and Marquees are rented for the purpose of accommodating indoor and outdoor events, such as Exhibition, Tradeshows, Wedding celebrations, Concerts, Music Festivals, Carnivals, Defense Exhibitions, Sporting Events, etc. We are also engaged in other services such as Field Hospitals, Drive Through or Screening Tents, Cooling Solutions, Commercial, and Industrial Mobile Halls. خيام مجالس | majlis tent for sale dubai