Re: Import/Export Problem

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 07 Oct 2004 20:02:13 +0200
Message-ID: <u11bm0h5675hlu5pm8o5pi30ktc6lashs9@4ax.com>

On 7 Oct 2004 09:09:13 -0700, iamrakeshp_at_yahoo.com wrote:

>Checked the packages they all seem valid .sys.dbms_repcat_utl does
>exist.

This problem does occur when you perform an upgrade of the database, don't set _system_trig_enabled=false in init.ora. If you have this, you have probably duplicate procedures, one under SYS the other under a different user. This usually results in problems like you posted. Resolution: drop the non-sys copy of the procedure.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Oct 07 2004 - 13:02:13 CDT