DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Export Error-ORA-12560

  1. #1
    Join Date
    Aug 2002
    Posts
    40

    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Aug 2002
    Posts
    40
    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

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    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.

  5. #5
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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

  6. #6
    Join Date
    Aug 2002
    Posts
    40
    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

  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    Are you still getting the same error, can you post it?
    I remember when this place was cool.

  8. #8
    Join Date
    Aug 2002
    Posts
    40
    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

  9. #9
    Join Date
    Aug 2002
    Posts
    40
    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.

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width