•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,634 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,456 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 1131 | Replies: 5
 |
•
•
Join Date: Aug 2003
Location: Oz
Posts: 13
Reputation: 
Rep Power: 5
Solved Threads: 0
Newbie Poster
Oracle EXP and INP 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
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
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,175
Reputation:
Rep Power: 4
Solved Threads: 75
in sql *plus type HOST
in the command prompt type
exp username/password@databasename
then just follow the instructions as prompted
in the command prompt type
exp username/password@databasename
then just follow the instructions as prompted
Share your Knowledge.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,175
Reputation:
Rep Power: 4
Solved Threads: 75
Have you tried as suggested in previous posts.
Share your Knowledge.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
Other Threads in the Oracle Forum
- Previous Thread: ER diagram from TOAD
- Next Thread: Help needed! Oracle settings for integrated security
