Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am working on client system. There is a database on server contains many users. I have the access to database with a userid and password. my userid is "ncon" and Database name is 'HYDPPD'.

We are maintaining a Web-application with this database. Now we want to migrate database to another server.

my system is having toad version 9.5.0.31. and oracle client version installed.

I want to export complete "ncon" user data from database on client system. user data contains 470 tables, 450 procedures, 20 views, 15 triggers and some functions.

I tried:

D:\>exp ncon/nconac_2014 file=ncon.dmp owner=necon

Export: Release 8.1.7.0.0 - Production on Sat Mar 15 19:56:15 201

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully

D:\>

Please any one help me out. I have very less time to export data from database.

Thanks in advance.

share|improve this question

migrated from stackoverflow.com Mar 16 at 1:45

This question came from our site for professional and enthusiast programmers.

1  
This is not an exp issue. TNS errors are related to net configuration. are you able to connect to the database ? try the same command but with exp ncon/nconac_2014@HYDPPD (or what ever the entry name is for this databse - what you write after @ when you connect to sqlplus or toad) –  haki Mar 15 at 16:58
1  
This is a sqlnet problem. Post your tnsnames.ora listener and sqlnet.ora files –  steve Mar 17 at 7:00
    
Probably a good idea to edit out the password from your question –  Andrew Brennan Mar 18 at 14:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.