Easy way to export and import schema statistics – in case the optimizer is behaving strangely and you want to re-import old statistics when the optimizer behaved properly.
SCHEMA NAME – SACHI
Create the table to store the statistics-
Export schema stats – will be stored in the temp_stat
If required import these statistics back to TEST schema.
Finally drop the table created to backup the schema stats
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > DBA's Forum, Routine Tasks and Activities >