-
_system_trig_enabled = false?
Oracle 9.2.0.8
I am preparing to migrate a 9i database from DEC Alpha OSF/1, r1.1-8.1.0 to HP-UX B.11.23 U ia64.
Due to the fact they are different platforms, I will need to do the export/import dance.
My questions:
1) I would like to try a FULL import, do I need to set _system_trig_enabled = false?
2) Is it possible at all to do the full import or do I need to import each schema separately?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
1. I do not remember setting set _system_trig_enabled to false while doing full import.
2. It all depends of the size of the beast.
I noticed you are moving to HP-IA... are you going from Ora9i to Ora10g or are you staying on Ora9i?
I'm asking this because we bumped into an unplesant surprise when moving to HP-IA on Ora9i... Oracle requires twice as much memory per connection when running Ora9i on HP-IA, you better double-check. As per Oracle, issue got fixed on Ora10g.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Unfortunately I'm staying 9i for the time being, just moving to another server and also changing the block size.
Also, I had no say in the selection of the server. It's my third week on the job.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|