Export Error-ORA-12560

[bonny]

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: TNSrotocol 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

[sambavan]

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

[bonny]

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

[Mr.Hanky]

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

[fraze]

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:

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

[bonny]

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

[Mr.Hanky]

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

[bonny]

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

[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.

[marist89]

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?