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

Thread: SYS & SYSTEM schema

  1. 04-27-2006, 12:14 AM #1
    malru
    malru is offline Member
    Join Date
    Feb 2006
    Posts
    162

    SYS & SYSTEM schema

    Hi,

    If I'm creating a database manually,after creating the database,which script i've to run to create SYS & SYSTEM schema.

    Thanks,
    Malru
    Reply With Quote Reply With Quote
  2. 04-27-2006, 12:32 AM #2
    fraze
    fraze is offline Senior Member
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Login as SYSDBA and run $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/admin/catproc.sql
    Reply With Quote Reply With Quote
  3. 04-27-2006, 07:42 AM #3
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376
    Quote Originally Posted by fraze
    Login as SYSDBA and run $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/admin/catproc.sql

    Sys and System gets created when u execute the Create database command. You can also provide the password for these users while creating database.

    Internally oracle calls a script called sql.bsq for the creation.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
    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