Re: ORA-904 in EXP80

Chris

Sorry about the MIME stuff, I'm just sending from Netscape and it does whatever it does behind the scenes. If you know how to clear it, let me know!

I had a look in the bug database, and found a problem with the catexp script in 7.3.3.3 which produced this 904 error. I can't remember what version you're on, but have a look at the view exu7tgr (owned by SYS). If it doesn't match the create statement below, recreate it as SYS, rerun the export and see what happens.

CREATE OR REPLACE view exu7tgr

                   (ownerid, owner, baseobject,baseobjowner,  definition,
                    whenclause, actionsize, action, enabled, name, basename) AS
        SELECT o.owner#, u.name, t.baseobject, u2.name, t.definition,
               t.whenclause, t.actionsize, t.action, t.enabled, o.name, o2.name
        FROM sys.obj$ o, sys.trigger$ t, sys.user$ u, sys.obj$ o2, sys.user$ u2
        WHERE o.obj# = t.obj# AND u.user# = o.owner# AND
              o2.obj# = t.baseobject AND
              o2.owner# = u2.user#

HTH. Pete

Christoph Kukulies wrote:

> Pete Sharman <psharman_at_us.oracle.com> wrote:
> : This is a multi-part message in MIME format.
> : --------------5B20158B56BAA7B1F1312B6B
> : Content-Type: text/plain; charset=us-ascii
> : Content-Transfer-Encoding: 7bit
>
> : Chris
>
> : Comments inline
>
> : Pete
>
> : Christoph Kukulies wrote:
>
> :> Pete Sharman <psharman_at_us.oracle.com> wrote:
> :> : This is a multi-part message in MIME format.
> :> : --------------7C830B8C76FC2E7613ED8EB1
> :> : Content-Type: text/plain; charset=us-ascii
> :> : Content-Transfer-Encoding: 7bit
> :>
> :> : Chris
> :>
> :> : You can get this error if you create a view that selects a column on the base table that
> :> : does not exist. One reason is that you are running a later version of catalog.sql or
> :> : catproc.sql that has a create view statement in it that references a column on a
> :> : dictionary table that only exists in the later release. I would look at the columns
> :> : chosen in the create view statements and see if they match the underlying data
> :>
> :> You mean 'my' (View8.ora) create view statements?
> :>
> :> : dictionary.
> :>
> :> Excuse my ignorance.
> :>
> :> What is catalog.sql (resp. catproc.sql)?
>
> : These two scripts build a lot of data dictionary views and PL/SQL packages. They are scripts that must be run for the database to be of any use.
>
> To complete the picture: I synced the clients and the server (both
> having 8.0.5 now) and the error only occurs when I'm trying
> to run EXP80 on the client and do a full export - the error occurs
> already with no user tables created.
>
> Running the same command (EXP80) on the server doesn't yield the error.
>
> This must be an Oracle problem. But you will tell me it is fixed
> in 8.1.x (or whatever the latest release is) :-)
>
> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de

--
Regards

Pete

Received on Tue Aug 17 1999 - 11:08:38 CDT