Member Avatar for dogma

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.

Thanks

  • 3 Contributors
  • 5 Replies
  • 230 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by debasisdas

Recommended Answers

All 5 Replies

Member Avatar for debasisdas

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
Member Avatar for inzomniac

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

Member Avatar for debasisdas

Have you tried as suggested in previous posts.

Member Avatar for inzomniac

What previous posts?

Member Avatar for debasisdas

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.