Re: dbmsutil.sql errors

t_m_vogt_at_hotmail.com (Mel) wrote in message news:<4f2e877a.0303171544.234e102d_at_posting.google.com>...
> I ran the dbmsutil.sql using sql*plus and got the following errors:
> drop type dbms_xplan_type_table
> *
> ERROR at line 1:
> ORA-04043: object DBMS_XPLAN_TYPE_TABLE does not exist
>
>
> drop type dbms_xplan_type
> *
> ERROR at line 1:
> ORA-04043: object DBMS_XPLAN_TYPE does not exist
>
> Is there another sql file I should run? What am I missing?
>
> Thanks!
I think it's probably nothing to worry about (though without seeing the full script I can't be certain). The script is probably dropping any existing types with those names before it creates them. If they already existed, they will ne dropped; if they didn't exist you get the error and the script continues and creates anyway. Received on Tue Mar 18 2003 - 14:12:56 CET