_system_trig_enabled = false?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: _system_trig_enabled = false?

  1. #1
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Cool _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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,470

    Talking

    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
  •  



Click Here to Expand Forum to Full Width