While upgrading one of my 10.2.0.4 64-bit database
to 11.2.0.2 using DBUA it failed with retrieve db information and pop up the message
"The Upgrade Assistant failes in
bringing up the database XXX. Oracle Home /oracle/OraHome11203 obtained from
file /etc/oratab was used to connect to the databa...
Saturday, 7 June 2014
How to copy schema stats from one schema to another schema
Here we will see how to copy schema statistics from one schema
to another. Basically there are two methods for doing this:
using
DBMS_STATS or
using
Data Pump
This is especially useful when doing large
data transfers between either schemas or databases and statistics are needed
fast. Remember that data density, row chaining or index cluster factor changed
due to the data import and index rebuilds.
Method 1: Using DBMS_STATS
Extract the statistics
First we need to login as schema owner which
from which we want to extract...