Oracle6 to Oracle7 data migration

From: Paul Teague <teague_paul>
Date: 1995/07/05
Message-ID: <3tes6p$71t_at_booz.bah.com>#1/1


unter_at_mecati.mecasoft.ch (Stefano UNTERNAEHRER) wrote: <snip>
>Now the problem... :-)
>I have to transfer the data from the V6 database to the new one.
>Is a simple export in V6 + import in V7 possible? Note that the
>database name is changed, as well as the tables' owner name.
>Others solutions???
>

The problem on import is that the PUBLIC synonym is not effective on the EXPORT/IMPORT toolset. Effectively on an import you are the user in question and table creation would fail because an object of the same name exists and is NOT at table.
If you rename the tables from their new names back to their old names then yes you can do a simple Oracle v6 EXPORT and Oracle7 IMPORT. The import will automatically convert the datatypes so they are functinally the same in the new database. What you will have to do to make sure that the data tables end up with the correct owner to redo the import specifying import arguments FULL=N FROMUSER=<old username> TOUSER=<new Username>

IMPORTANT : The table structures (definitions of columns) must match EXACTLY! Lots of luck

-- 
Paul Teague    Systems Engineer/Unix Admin/Oracle DBA
E-mail: teague_paul_at_.bah.com
#include <Standard disclaimer>  "All opinions voiced are my own, etc..."
Received on Wed Jul 05 1995 - 00:00:00 CEST

Original text of this message