Help Needed Regarding Oracle Migration
From: Azhar Bilgrami <azhar_at_weblinx.com.pk>
Date: 31 Dec 2003 00:53:49 -0800
Message-ID: <c0ed2dfb.0312310053.7f200738_at_posting.google.com>
Now here is what I want to do
Date: 31 Dec 2003 00:53:49 -0800
Message-ID: <c0ed2dfb.0312310053.7f200738_at_posting.google.com>
Dear
Hi:
Hope to see u in good health.
" I want to migrate a database which is currently running
Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3 (text base)as Front End"
Now here is what I want to do
" I want to migrate that database from Oracle for Unix to
Oracle for Linux With retaining all the Forms, in other words all I want
is to change the Operating System!, nothing else, no change in Oracle or
Certainly no change is Forms"
I read other discussion forums and gathered the following, i.e. the steps to migrate a Database from Unix to Linux.
- Export the database from source machine,i.e. Export all the Databse files using Oracle 7 Database Utility.
- Install Oracle 8i on Linux Machine and Import that Database into Oracle 8i using Oracle 8i Database Utility.
- Just Copy the Source Files of Oracle forms 3.3 from Unix Machine and Paste then onto my Linux Machine.
- Recompile those files.
- The system is ready!.
Now kindly correct me if iam wrong in these steps, also I have few questions in my mind.
- How to Export an database in Oracle 6 for Unix.
- How to Import an Database in Oracle 8i for Linux.
- How to recompile the Forms 3.3 Files.
- Do I have to follow the same directory structure as Unix, i.e. if the form files are located at /usr/oracle/home on UNIX then should I follow the same directory structure?
Thanks for your help in Advance.
Take care of ure self. Azhar BilgramiReceived on Wed Dec 31 2003 - 09:53:49 CET