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

I'm gathering Statistics using following...

estimate_percent => dbms_stats.auto_sample_size );

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.

Re: Gathering Satistics - External [message #213318 is a reply to message #213242] Wed, 10 January 2007 05:22 Go to previous message
Messages: 21148
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: Archive/nonarchive mode
Next Topic: Oracle Express Server error - XPINSMGR-10531
Goto Forum:

Current Time: Mon Aug 21 20:54:20 CDT 2017

Total time taken to generate the page: 0.08402 seconds