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 : http://www.dbform.com
Join ACOUG: http://www.acoug.org



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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: