I have limited oracle experience

I want to dump a copy of one db and import it into a local oracle server which I'm using for dev.

My problem is that I can't sort out the connect information (user@host:port/SID) type stuff.

I've tried just connecting to the remote db using sqlplus: I get the following
I'm getting a ORA-12504 TNS:listener was not given...

The format I'm using is above, and I think it's wrong.

Can anyone point me in the right direction.


in sql *plus type HOST

in the command prompt type

exp username/password@databasename

then just follow the instructions as prompted

commented: Nice and quick explanation +7

You could even start by just typing EXP (or IMP) in the command prompt.

Have you tried as suggested in previous posts.

What previous posts?

Have you tried as suggested in post #2.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.