Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> re-direct to initial question with question

re-direct to initial question with question

From: nighthawk <nighthawk_at_mgfairfax.rr.com>
Date: Wed, 23 Feb 2000 04:21:12 GMT
Message-ID: <YeJs4.20371$gW5.98535@typhoon.southeast.rr.com>


back to Gonzalo's q, I'm curious if [regardless of efficiency], does his statement work?

reference -->
INSERT INTO A.TABLEA
SELECT * FROM A.TABLEA_at_OTHERINSTANCE WHERE A.TABLEA.FIELD=1 (specifically regarding to the '@OTHERINSTANCE' part)

<tandym_at_hotmail.com> wrote in message news:88uu01$i7j$1_at_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 - 22:21:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US