Re: PB with export

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Sat, 15 Dec 2001 10:39:55 +0100
Message-ID: <lf6m1uoc64fff03406bs7gpfnvpcvdoen8@4ax.com>

On Sat, 15 Dec 2001 10:22:10 +0100, "Thierry" <thierry.constant2_at_wanadoo.fr> wrote:

>Hi,
>
>I try to export a user from a remote database:
>
>exp system/manager_at_SID file=export.dmp owner=john
>
>I get the error:
>ORA-00904 invalid column name
>for all the columns of all the tables of the user john
>
>The local machine is: HP-UX 11.0,Oracle 8.1.7
>The remote machine is: W2000, Oracle 8.1.6
>
>What is wrong ????
>
>Thanks
>
>
>
>

Higher version export running against lower version database. You'll need to make an export using the lower version export, the other way around doesn't work, as the export views change with every release. The ora-904 error does not pertain to your columns, it pertains to the export views.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Dec 15 2001 - 03:39:55 CST