-
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.
-
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]
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|