Re: Copy tables from oracle 7 to oracle 9

From: Candido Dessanti <termy_at_blunet.it>
Date: Wed, 11 Sep 2002 18:13:45 +0200
Message-ID: <3D7F6BB9.2040906@blunet.it>

you can do that with export/import utilities you get with oracle's server

in the unix machine

exp userid=(the user owns the tables you want to export)/password_at_database alias direct=y buffer=65535 file=(the name you want for output file)

then get the file with an ftp transfer from your windows machine in binary mode, create a user with the same username you used for export in your oracle's instance and import it with import on your machine

imp userid=(the same user you have used for the export)/password_at_local database alias buffer=65535 file=(the name of the file you are impoting)

if this wouldnt work i have other but more complicated solutions Received on Wed Sep 11 2002 - 11:13:45 CDT