Home » RDBMS Server » Server Administration » Gathering Satistics - External
Gathering Satistics - External [message #213242] Wed, 10 January 2007 00:04 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

I'm gathering Statistics using following...

Begin
DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>''APPUSER'',
degree=>16,
estimate_percent => dbms_stats.auto_sample_size );
End;

Scheme APPUSER has some external tables like EXT_BOI_CARDS_LEDGER_STAT and linked flat file is missing in the unix directory. while gathering statistics since the file is missig it stops gathering statistics. It generates error like following.
--------------------------------------------------------
Errors in file /prodofsa/admin/bdump/proddwdb_j000_10721.trc:
ORA-12012: error on auto execute of job 122
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file 0101GL0503B.csv in EXT_CRD_DIR not found
--------------------------------------------------------
Is there a way to skip gathering stats for external tables using GATHER_SCHEMA_STATS. If does not exists, incase of errors can I continue gathering other objects in the schema.

Regards,
Brian.
Re: Gathering Satistics - External [message #213318 is a reply to message #213242] Wed, 10 January 2007 05:22 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There might be a simpler way to do that, but - how about writing a PL/SQL script which would loop through tables in current schema. Loop should have its own BEGIN-EXCEPTION-END block which would enable you to skip "non-existent" tables.

Of course, it means that you'd have to move from GATHER_SCHEMA_STATS to GATHER_TABLE_STATS, if it is acceptable to you.
Previous Topic: synchronizing user password from another database
Next Topic: problem when setting new DBTIMEZONE
Goto Forum:
  


Current Time: Sat Dec 10 22:48:56 CST 2016

Total time taken to generate the page: 0.08294 seconds