Re: ORA-904 in EXP80

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 Received on Tue Aug 17 1999 - 03:03:42 CDT