OraFAQ Forum: Networking and Gateways » replication between oracle 7 and 8 or 8 to 7

Home » RDBMS Server » Networking and Gateways » replication between oracle 7 and 8 or 8 to 7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

replication between oracle 7 and 8 or 8 to 7 [message #66743]

Tue, 03 December 2002 22:01

Ata ur Rehman
Messages: 1
Registered: December 2002

Junior Member

How to copy tables from oracle 8i database to oracle 7.0.Please write the exact procedure for doing that. My problem is listener is not responding from oracle 7.0 . How to start listener in oracle 7.0

Please Reply Urgent

Report message to a moderator

Re: replication between oracle 7 and 8 or 8 to 7 [message #66748 is a reply to message #66743]

Fri, 06 December 2002 09:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i have not tried 7 and 8i versions.
BUT for 8 ,8i and 9i versions, i use the same 8 listener for all databases(ie..the lowest version).
are u trying to copy tables using dblinks?
[code]create table tab2 as select * from someuser.tab1@mylink;

????
that would work.
simple way is to recreate the table structure in target, create a csv flat file of data from source,
load the file into target using sql*loader.
if your actually trying to setup an REPLICATION ENVIRONMENT, that is VERY DIFFERENT CASE.

Report message to a moderator

Previous Topic:	Re: Can't Install java 2 on Pentium 4 ?
Next Topic:	Jre.exe(javai.dll)error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 15:47:53 CST 2025