Catalog and Cataproc.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Catalog and Cataproc.sql

  1. #1
    Join Date
    May 2002
    Posts
    35

    Post Catalog and Cataproc.sql

    Hi friends

    I just wanted to know if there exists any order in which the catalog.sql and catproc.sql scripts to be run.

    What i mean to ask is that could cataproc.sql run first and catalog.sql

    SK

    Sharmila
    -----------
    OCP 8i

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I would stick to the order suggested by Oracle (catalog, catproc), why would you want to run them in a different order?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Aug 2001
    Posts
    36
    You can execute these scripts in any order.

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    CATALOG.SQL
    Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.

    CATPROC.SQL
    Runs all scripts required for or used with PL/SQL.

    http://download-west.oracle.com/docs...te.htm#1003614

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