Home » RDBMS Server » Server Administration » importing stats from 9i to 10g database (10.2.0.3)
importing stats from 9i to 10g database [message #376673] Thu, 18 December 2008 04:18 Go to next message
hrishy
Messages: 25
Registered: August 2005
Junior Member
Hi

Is it possible to export just the table and index stats from 9i and import it into 10g ?

regards
Hrishy
Re: importing stats from 9i to 10g database [message #376675 is a reply to message #376673] Thu, 18 December 2008 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try it? Or are you just waiting for us to do it?

Regards
Michel
Re: importing stats from 9i to 10g database [message #376706 is a reply to message #376675] Thu, 18 December 2008 05:51 Go to previous messageGo to next message
hrishy
Messages: 25
Registered: August 2005
Junior Member
Hi

Sorry it was my question because i dont have acesses to Oracle 9i or 10g at this moment a friend of mine was trying to troubleshoot a query that went bad after migration from 9i to 10g.

Now one of the other Developer mentions that in another box the DBA solved this by exporting the stats from 9i and importing it into 10g and locking the stats down in 10g.

I am wundering if its possible that way between versions ?

regards
Hrishy

Re: importing stats from 9i to 10g database [message #377200 is a reply to message #376706] Sun, 21 December 2008 10:57 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes it can be, but for that you need to go through oracle documentation.

Regards,
Taj
Previous Topic: Strange database crash (no info. in alert log)
Next Topic: ORA-01092 (merged)
Goto Forum:
  


Current Time: Fri Dec 09 12:02:37 CST 2016

Total time taken to generate the page: 0.08687 seconds