Migrating ORACLE from Dev to Prod
Date: 1996/07/12
Message-ID: <4s4pvo$kvm$1_at_mhafc.production.compuserve.com>#1/1
I am presently working at a client site where we are running
ORACLE Financials with ORACLE RDBMS 7.1.6, on an HP T520 running
HP-UX 10.10. We are approaching the time to move a significant
amount of development data (all of 1995 and 1996 data to date)
from a Development database instance to our Production database
instance on a separate database server.
The question I have is this:
How do you go about moving all of your Financials data, when the
size of an full export exceeds the maximum file size that your
operating system allows?
We have experimented with the concept of doing the 5 separate
exports, as follows:
1) Export of structure only.
2) Export of GL.GL_JE_LINES.
3) Export of GL.GL_BALANCES.
4) Export of all other tables in the GL schema.
5) And finally, an export of all other schemas other than GL
(including SYS and SYSTEM).
While these exports get us below our maximum file size of 2 GB,
we have a real concern about the order in which to run the
subsequent imports (other than importing structure first).
We are especially concerned with whether or not to import SYS and
SYSTEM objects. Any suggestions?
Thanks in advance for your suggestions.
Scott D. Lockhart (Clear Perception, Inc.)
Received on Fri Jul 12 1996 - 00:00:00 CEST