about coe_create_user_coecbostats.sql

Apr 9, 2014 5:58AM · Apr 9, 2014 5:58AM

Hi Guys,

from -> Manage CBO Statistics During an Upgrade from 10g or 9i into 11g (Doc ID 465787.1)

Since there are scripts to backup my users, dictionary, system, fixed objects using just this 2 scripts ->

1. coe_create_user_coecbostats

2. coe_backup_cbo_stats

thus, testing this script provided by oracle to backup my statistic before the upgrade.

I have successfully run the 2 scripts with the backup table created and the 2nd script to backup all my statistics.

Question:

1. There is this table created -> COE$_STATTAB

2. i cannot seem to select count (*) from COE$_STATTAB or desc it.

Is it not might to be view like a table?

Database Install/Upgrade/Opatch (MOSC)