how to know what table is created by dbms_stats.create_stat_

All posts relating to Oracle database administration.

Moderator: Tim...

how to know what table is created by dbms_stats.create_stat_

Postby kytemaniac » Mon Dec 03, 2012 4:13 am

Hi,

I'm looking at the article id 837570.1

step 32

Step 32

Upgrade Statistics Tables Created by the DBMS_STATS Package.

If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following procedure:



in the first place how do I know which tables are create by DBMS_STATS.CREATE_STAT_TABLE.

have check 10gr2 http://docs.oracle.com/cd/B19306_01/app ... sthref6598

11gr2 http://docs.oracle.com/cd/E11882_01/app ... ARPLS68508

and search for CREATE_STAT_TABLE in metalink, but search was in vain.

did not mentioned about tables created by the above by DBMS_STATS.CREATE_STAT_TABLE

thanks a lot!
kytemaniac
Senior Member
 
Posts: 234
Joined: Tue May 19, 2009 12:59 am

Re: how to know what table is created by dbms_stats.create_s

Postby Tim... » Mon Dec 03, 2012 7:52 am

Hi.

They will be tables you created using DBMS_STATS.CREATE_STAT_TABLE for the specific purpose of holding stats. If you don't know the names of these tables it means either:

- You don't have an.
- You don't use them regularly, so forgetting to upgrade them is not a problem.

To try and identify some, I would create a new stats table. Check the columns in that table, then search for other tables with similar named columns.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17933
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests