Re: Migrating ORACLE from Dev to Prod

Scott D. Lockhart <102154.3320_at_CompuServe.COM> wrote:

>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.)
Since IMPORT will recreate most of the objects you want, I would NOT import SYS and SYSTEM schemas. God knows what you would do to the dictionary. I would suggest trying it out on Personal Oracle first! You will probably have to create all your tablespaces on Prod first, before importing.

Cheers

Pete Received on Sat Jul 13 1996 - 00:00:00 CEST