DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: migration

  1. 04-06-2001, 04:18 PM #1
    ganjisb
    ganjisb is offline Junior Member
    Join Date
    Nov 2000
    Posts
    35
    hello.. i found in a book that when you migrate database from oracle 7 to oracle 8 using export/import method , it has give one environment variable to be set .

    oraenv_ask = No
    # . oraenv

    what is the necessity of this parameter ?
    and also it is said to run catalog.sql script again . why ?
    can any body help me !!
    thanks in advance.
    Reply With Quote Reply With Quote
  2. 04-06-2001, 04:24 PM #2
    gpsingh
    gpsingh is offline Senior Member
    Join Date
    Feb 2001
    Posts
    389
    This is a shell script to set the Envireonment for Oracle,
    Generally it contains ORACLE_SId,ORACLE_HOME etc.
    If u say no , it would not confirm the oraenvironment and just set it.
    Reply With Quote Reply With Quote
  3. 04-06-2001, 04:56 PM #3
    rcaballe
    rcaballe is offline Member
    Join Date
    Oct 2000
    Posts
    235
    The catalog.sql and catproc.sql are very important they synchronize the metadata of the database (data dictionary) whith the kernel installed (oracle executable).
    Even between 8.1.5 and 8.1.6 or any 8.1.x number you must run them again.
    Ramon Caballero, DBA, rcaballe@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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