Re: multiple dbid values in dba_hist_sqltext

Try: exec dbms_swrf_internal.unregister_database(db_id);

Kamus <kamusis@xxxxxxxxx>

Visit my blog for more :

On Wed, Apr 20, 2011 at 2:42 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote:
> dbms_xplan.display_awr is giving me an ora-1422.  I believe this is due to
> records in sys.dba_hist_sqltext with multiple dbid's.  I presume the "extra"
> dbids are from cloning of the database.  How can I clean up this table?
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

Other related posts: