OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » 10g and 8i Pfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

10g and 8i Pfile [message #207816]

Thu, 07 December 2006 02:26

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Hi gurus,
can i use same 8i pfile for 10g database.any changes in parameters in both versions ?
i am creating a 10g database exactly same as 8i (it is not upgrade)

Report message to a moderator

Re: 10g and 8i Pfile [message #207823 is a reply to message #207816]

Thu, 07 December 2006 02:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi

NO,i don't think you can use oracle 8i pfile in oracle 10g. bcoz many parameter from oracle 8i is desupported or many new introduce with oracle 10g.

and what is meaning exaclty some.
you can also choose upgrade option.
if database is small then use export or import option for you database.

hope this helps
taj

Report message to a moderator

Re: 10g and 8i Pfile [message #207827 is a reply to message #207816]

Thu, 07 December 2006 02:57

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

8i is in one machine and i am creating same structure in another machien,without any data.

so do you think i can use sample init template file that comes with 10g, with same settings from 8i pfile that i have now ?

Report message to a moderator

Re: 10g and 8i Pfile [message #207830 is a reply to message #207827]

Thu, 07 December 2006 02:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

but why you need to create some database structure on oracle10g like oracle8i without data.

Report message to a moderator

Re: 10g and 8i Pfile [message #207844 is a reply to message #207816]

Thu, 07 December 2006 03:27

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

in future i will load some datas from 8i database.

Report message to a moderator

Re: 10g and 8i Pfile [message #207889 is a reply to message #207844]

Thu, 07 December 2006 04:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> 8i is in one machine and i am creating same structure in another machien,without any data
Then, what does the database features / parameter settings has to do with that?
Just create a new empty 10g database.
Export the ddl / extract ddl (no data) from the 8i.
import into 10g.
As user52 already said, many parameters are made obsolete and you will endup with unwanted issues.

Report message to a moderator

Previous Topic:	10g DB creation
Next Topic:	10g databases and patch sets

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:28:27 CDT 2024