Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to copy statistics of one partition for another ??

Status
Not open for further replies.
cheguvera

cheguvera

Programmer
Oct 13, 2005
32
GB
Hi,

I have a partitioned table (Oracle 9.2).
We will be creating new partitions for increasing data and I would like to copy the statistics of the existing partition for the newly created partition.

Whats the best way to do this?

Regards
 
Sort by date Sort by votes

You could try using the DBMS_STATS package export/import procedures. [3eyes]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
384
jj10438
J
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
2K
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
959
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top