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

Thread: catalog and catproc

  1. 10-09-2002, 12:10 PM #1
    pascal01
    pascal01 is offline Member
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    Question

    Hi. I created a new instance with the Database Configuration Assistant tool. Do I still need to run catalog.sql and catproc.sql in svrmgrl?
    Reply With Quote Reply With Quote
  2. 10-09-2002, 12:17 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    try and create some objects, see what happens
    Reply With Quote Reply With Quote
  3. 10-09-2002, 12:18 PM #3
    prakashs43
    prakashs43 is offline Senior Member
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    you don't need to run that .

    if u generate this to shell script then u will see that catalog.sql and catproc.sql would be executed in it
    siva prakash
    DBA
    Reply With Quote Reply With Quote
  4. 10-09-2002, 12:21 PM #4
    pascal01
    pascal01 is offline Member
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222
    I'm not sure what you mean. I used the tool to create the db. Does catproc and catalog run in the tool during the creation of the db?
    Reply With Quote Reply With Quote
  5. 10-09-2002, 12:40 PM #5
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Yes it does.
    If you generate a DB creation script when prompted by the Wizard, rather than creating the DB straight away, you'd see it.

    Check the DB creation logfile which should show them being run.
    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