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: copying data from one computer to another, without export

Re: copying data from one computer to another, without export

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Fri, 31 Aug 2001 13:22:31 GMT
Message-ID: <rcMj7.1677$QG5.1378057@news1.news.adelphia.net>


Which DB do you mean? I am running a local Oracle instance on my PC notebook and I want to copy table contents from a remote computer running Oracle. I am issuing all commands from SQL/Plus running on my notebook.

"TurkBear" <noone_at_nowhere.com> wrote in message news:o1hsotkvh48fojsau6tup4saanikre4e5s_at_4ax.com...
>
> Are you using Sql/Plus on the same machine as the database is running?
> If not, then it is the tnsnames.ora file on the database machine that
needs to be corrected, not the one on your client, for
> the dblink to work..
>
> scottmattes_at_yahoo.com (Scott Mattes) wrote:
>
> >Is the global database name the same as the SID?
> >
> >As I just now said to Brian in a reply to his post, the tnsnames.ora
> >entry is already there, I can access the remote DB through SQL/PLUS
> >just fine.
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Fri Aug 31 2001 - 08:22:31 CDT

Original text of this message

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