DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Transfer procedures

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    I want to transfer my procedures from one box to another. I know I can do this using the exp/imp option with rows = n, but my source is running 8.1.7 and my destination 8.1.6 and I have not been able to figure out the method of using 816 executables and export data from 817 as they are on different machines. I do not want to use a third-party tool. Does anyone have any ideas on how to go about doing this ?

    Thanks,
    Shiva.

  2. #2
    Join Date
    Feb 2000
    Posts
    175
    Hi,

    If you create an entry for the 8.1.7 database in the tnsnames.ora file on the 8.1.6 system you should be able to connect from the 8.1.6 system to the 8.1.7 database....

    sqlplus system/manager@817database where 817database is the tnsnames.ora entry for the 8.1.7 database.

    you can then try to export using the 8.1.6 export utlility....

    On the 8.1.6 system set the ORACLE_SID=8.1.7 database

    then enter

    exp system/manager@817database file=filename.dmp log=logfile.log rows=n

    Cheers
    Moff

    [Edited by moff on 11-16-2001 at 12:05 PM]

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    set long 2000
    set head off
    set page 0
    set lines 100

    spool text.sql

    select text from dba_source where onwer = 'user' ;

    spool off


    Just execute this on any of your DBs. Hope this helps.
    Vinit

  4. #4
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi,

    Vinit your solution does work and I have got my procedures generated.

    But , I also want to try out moff's suggestion. When trying to connect to the 817 database, I get a TNS Listener not found error, but the destination does have its listener up and running. I have even restarted oracle after changing the tnsnames.ora file. Could it be some access issue ??

    Thanks,
    Shiva.

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