OraFAQ Forum: Server Administration » importing stats from 9i to 10g database

Home » RDBMS Server » Server Administration » importing stats from 9i to 10g database (10.2.0.3)

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

importing stats from 9i to 10g database [message #376673]

Thu, 18 December 2008 04:18

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

Report message to a moderator

Re: importing stats from 9i to 10g database [message #376675 is a reply to message #376673]

Thu, 18 December 2008 04:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you try it? Or are you just waiting for us to do it?

Regards
Michel

Report message to a moderator

Re: importing stats from 9i to 10g database [message #376706 is a reply to message #376675]

Thu, 18 December 2008 05:51

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

Report message to a moderator

Re: importing stats from 9i to 10g database [message #377200 is a reply to message #376706]

Sun, 21 December 2008 10:57

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

Report message to a moderator

Previous Topic:	Strange database crash (no info. in alert log)
Next Topic:	ORA-01092 (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 20:56:31 CST 2024