Home » RDBMS Server » Networking and Gateways » replication between oracle 7 and 8 or 8 to 7
replication between oracle 7 and 8 or 8 to 7 [message #66743] Tue, 03 December 2002 22:01 Go to next message
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
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.

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


Current Time: Thu Feb 29 09:23:23 CST 2024