Home » RDBMS Server » Server Administration » 10 g parameter
10 g parameter [message #292303] Tue, 08 January 2008 08:43 Go to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hello
i have an oracle 9i database on a windows server name "abc"
i want to upgrade this database to 10g R2 on another windows server

so

i created another database on the new server and named it "abc" then i imported all the data from the old 9i to the new 10g R2 database

my issue is that i dont want to check every parameter from the 9i database and use it in the 10g ?
what can i do to have the new 10 g database with the same parameters as the 9i ?

can i create a pfile from the 9i spfile
and edit this file for the 10g ?

any help is appreciated
thanks
Re: 10 g parameter [message #292311 is a reply to message #292303] Tue, 08 January 2008 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

can i create a pfile from the 9i spfile
and edit this file for the 10g ?

Yes.

Regards
Michel
Re: 10 g parameter [message #292315 is a reply to message #292303] Tue, 08 January 2008 09:16 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Yes, but keep in mind some v9 parameters are obsoleted in V10 & V10 supports parameters which did not exist in V9.
Previous Topic: any tips for ora-07445 error
Next Topic: Roles
Goto Forum:
  


Current Time: Mon Sep 16 05:46:41 CDT 2024