Oracle6 to Oracle7 data migration
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