| How To Get Previous Version Of Stats Gathered [message #321119] |
Mon, 19 May 2008 02:36  |
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
|
Senior Member |
|
|
Dear All,
What are the various methods via i can get
previous version of stats.
DBMS_STATS has the feature via which i can create a
temp table and export and import previous statistics.
Is their any other efficient method available.
Thanks & Regards,
Rajat Ratewal
|
|
|
|
|
|
| Re: How To Get Previous Version Of Stats Gathered [message #321178 is a reply to message #321129] |
Mon, 19 May 2008 06:12  |
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
|
Senior Member |
|
|
Dear Michel,
Can't we use Export import utility for this.i think
when we use Export utility statistics are also
exported.
Is their any method to specify that only Statistics
will be exported in Export utility command.
Actually i am trying 2-3 approaches via i can achieve
results.
Can, you please guide me on this.
Thanks & Regards,
Rajat Ratewal
|
|
|
|
| Re: How To Get Previous Version Of Stats Gathered [message #321187 is a reply to message #321178] |
Mon, 19 May 2008 06:35 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | Can't we use Export import utility for this.i think
when we use Export utility statistics are also
exported.
|
Yes but do you want to export the whole table or only the statistics?
For statistics use dbms_stats package.
| Quote: | Is their any method to specify that only Statistics
will be exported in Export utility command.
|
No.
| Quote: | Actually i am trying 2-3 approaches via i can achieve
results.
|
Named them
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
