installation question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: installation question

  1. #1
    Join Date
    Jan 2002
    Posts
    28
    Hi there,

    I have a simple question. Do I have to run the files such as catalog.sql and catproc.sql as a sys user after the installation of Oracle9i? Thanks a lot.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Yes u can. But before had better create cold backup.

  3. #3
    Join Date
    Jan 2002
    Posts
    148
    Catalog scripts are run for a DB creation / fixing.

    Cat Scripts are automatically run when DB created using DBCA ( Database Configuration Assistant ).
    A Manual DB creation also involves running of Cat scripts manually.

    Jr.

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    catalog.sql create set of data dictionary views (like dba_tables ...).
    each view creation command in catalog.sql use syntax:
    CREATE or REPLACE VIEW ...

    then if u execute this script u don't change any rows in real tables of oracle
    dictionary, except tables than keep view definition (like sys.source$, sys.obj$ ..), but
    this rows oracle will change thru sql commands (CREATE VIEW) execution not directly using DELETE / INSERT commands.

    conclusion: u can execute this script in any time not only as part of installation process.


  5. #5
    Join Date
    Jan 2002
    Posts
    28
    Thanks a lot!

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