-
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: 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
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
I remember when this place was cool.
-
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?
I remember when this place was cool.
-
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.
-
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?
Last edited by marist89; 08-12-2004 at 10:04 AM.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|