Re: SQL COPY between Oracle9i databases from 8i client.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 04 Aug 2003 23:26:30 +0200
Message-ID: <mpjtiv40k0ouhu5g0o94simoco6e67te4d@4ax.com>

On 4 Aug 2003 12:10:47 -0700, nilanjan_sarkar_at_hotmail.com (nilanjan) wrote:

>Any comments on this observation :
>
>I found that when using SQLplus COPY command to migrate data between
>two 9i instances, when I run the command from an 8i instance (8i
>client) , I am always running into this error:
>ORA-00904: : invalid identifier
>
>[ the syntax is ok since the same worked when the client was a 9i
>client ]

The error message after the error number doesn't make sense. Please try to be as concrete and accurate as possible and post a full transcript instead of hiding things, when you are soliciting comments

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Aug 04 2003 - 16:26:30 CDT