Export Error-ORA-12560

I have remote server and access through oracle client and dbartisan.I do have resource and connect privileges.When I am exporting tables from my schema this problem is encountered(ora-12560: TNS:protocol adapter error).I did look into TNSnames.ora file on my computer , which already contains the name of the database I am trying to export from.

Could not understand why ?? I would appreciate if someone could answer to this.where further I should look into.

Thanks

Hi,

On your export string that you used to execute the export, how did you define the connectivity to the database

i.e

exp user_name/password

or

exp username/password@remote_db

If it was the fist, then you either have to define the TWO_TASK=remotedb.domain in your environment or you have to resolute that of using the second option.

Before you proceed, try doing a tnsping, and ensure that you can reach that database.

tnsping remote_db.domain

Hope this would help you.

Thanx.
Sam

Thanks Sam,

I did tnsping dbname- it shows the connection which is correct.

I am exporting like-

C:\>exp userid=bonny/testb@testb file=c:\temp\
sttb.dmp log=c:\temp\sttb.log buffer=1000000 compress=N consistent=Y rows=Y tables= 'bonny.stats_tb'

Export: Release 9.2.0.1.0 - Production on Thu Aug 12 08:24:07 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
JServer Release 9.0.1.4.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

I did try using= exp userid=bonny@testb file=......
password was applied.But still has either tnsname error or table or view does not exist.

Any further suggestion.

Thanks

Bonny, try...

TABLES=(owner.table_name)

I don't think you want to use tick marks, assuming you are using a parfile.

Did you set the oracle sid from the command prompt?

C:\SET ORACLE_SID=SID

Are you sure the table exists?? Can you describe or select from it in SQL Plus?
Not sure about windows but UNIX doesnt like having brackets round the tables clause:

Code:

---

$ exp userid=/ tables=(oracle.t1);
ksh: syntax error: `(' unexpected

---

Hi guys,

Yes table exists and I am able to describe and select the table.I have connect and resource privs.I collected staistics from test database using dbms_stats.I want to export this table to use the staistics in another table.

I am using parfile from command prompt-

set oarcle_sid=test
exp parfile=expstats.par

parfile contains:

userid=bonny/bonny@test
file=c:\sttb.dmp
log=c:\sttb.log
buffer=1000000
compress=n
consistent=y
rows=y
tables=(bonny.stats_tb)

I tried with your suggestion but still having same problem.I am able to connect to remote server on command prompt-
connect bonny/bonny@test

Any further suggestion.

Thanks for all your help

Are you still getting the same error, can you post it?

Hi guys,

One more point which i want to tell you.When i connect to the database test (which i am able to bonny/bonny@test on command prompt)and run-

select * from user_tab_privs where table_name='STATS_TB';
no row select

Don't you think that I should have privleges on this table as I am the owner.although i am able to slect * from stats_tab;

Thanks

Hi,

I am posting the output-


C:\>set oracle_sid=test

C:\>exp parfile=c:\temp\expstats.par

Export: Release 9.2.0.1.0 - Production on Thu Aug 12 09:42:42 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
JServer Release 9.0.1.4.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully


Thanks for all your help.I really appreciate.

Quote:

---

Originally posted by bonny
Hi,

I am posting the output-


C:\>set oracle_sid=test

C:\>exp parfile=c:\temp\expstats.par

Export: Release 9.2.0.1.0 - Production on Thu Aug 12 09:42:42 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production
JServer Release 9.0.1.4.0 - Production
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully


Thanks for all your help.I really appreciate.

---

dude, you're using 9.2 version of export against a 9.0 database. Use the same version. Where does ORA-12560 come into play?

dude, you're using 9.2 version of export against a 9.0 database. Use the same version. Where does ORA-12560 come into play?


__________________
Jeff Hunter
[email protected]

ora-12560 was the problem in the begining.but when you guys helped and this came down to table or view does not exist.

I am checking for versions of the exp and database.

Thanks

Hi Guys,

That was the version problem and it has been resilved.Thanks
for all the help.

Bonny