Oracle6 to Oracle7 data migration
From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/07/03
Message-ID: <DB5py7.CA1_at_mecati.mecasoft.ch>#1/1
Date: 1995/07/03
Message-ID: <DB5py7.CA1_at_mecati.mecasoft.ch>#1/1
Hello folks!
We have an HP 3xx server with Oracle Version 6 installed.
On this server we have an Oracle database with tables owned by a user.
We also have an HP 7xx server with Oracle7 installed. On this server we have an Oracle database (with different name) with tables (with different names) owner by a user (with different name). This tables at this moment contains no data, and are identical as the tables in the Oracle6 database, but with different names. For every table is a public synonym available defining the old table name for the new table. This new tables are better designed (constrainst names, foreign keys definition, storage, etc etc).
Thank you for any suggestion!
Stefano
______________________| Stefano Unternaehrer |__________________________ \ Mecasoft SA | Oracle DBA | fax: +41 93 335 507 / \ 6600 Muralto | and PL/SQL, Pro*C | voice: +41 93 337 444 / \ | C, XWindow & Motif | / / | Software Developer | email: \ / Switzerland Europe |____________________________| dba,unter_at_mecasoft.ch \ /________________________) (____________________________\Received on Mon Jul 03 1995 - 00:00:00 CEST