| Gathering Satistics - External [message #213242] |
Wed, 10 January 2007 00:04  |
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  |
 |
Littlefoot
Messages: 21818
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
