Re: HELP:Import data from different instances

From: <tandym_at_hotmail.com>
Date: Tue, 22 Feb 2000 21:10:28 GMT
Message-ID: <88uu01$i7j$1@nnrp1.deja.com>

personally would export as your user and then import into the other instance as user - lot's less keystrokes in the long run.

sonya

In article <88utok$hsq$1_at_nnrp1.deja.com>, Gonzalo <GSegarra_at_iname.com> wrote:
> Hi,
> I have two instances with the same user and tables. I need to import
> data from one instance to the other.
> Which is the easiest way to do this?
> Can I do something like this:
> INSERT INTO A.TABLEA
> SELECT * FROM A.TABLEA_at_OTHERINSTANCE WHERE A.TABLEA.FIELD=1
>
> Thanks,
> Gonzalo.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 15:10:28 CST