Home » RDBMS Server » Server Administration » 10g and 8i Pfile
10g and 8i Pfile [message #207816] Thu, 07 December 2006 02:26 Go to next message
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)
Re: 10g and 8i Pfile [message #207823 is a reply to message #207816] Thu, 07 December 2006 02:52 Go to previous messageGo to next message
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
Re: 10g and 8i Pfile [message #207827 is a reply to message #207816] Thu, 07 December 2006 02:57 Go to previous messageGo to next message
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 ?
Re: 10g and 8i Pfile [message #207830 is a reply to message #207827] Thu, 07 December 2006 02:59 Go to previous messageGo to next message
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.

Re: 10g and 8i Pfile [message #207844 is a reply to message #207816] Thu, 07 December 2006 03:27 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
in future i will load some datas from 8i database.
Re: 10g and 8i Pfile [message #207889 is a reply to message #207844] Thu, 07 December 2006 04:32 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: 10g DB creation
Next Topic: 10g databases and patch sets
Goto Forum:
  


Current Time: Thu Dec 08 12:38:48 CST 2016

Total time taken to generate the page: 0.13060 seconds