+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    214

    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?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    try and create some objects, see what happens

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    460
    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

  4. #4
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    214
    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?

  5. #5
    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.

Bookmarks

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