DDL Scripts for 10g

I have installed Oracle database. On running the oracledate_install0504.sql as mentioned in the PRPC5-4SP1_J2EE_Install_Guide_Tomcat.pdf doc while creating the triggers its giving the following error "cannot create triggers as the object is owned by sys." Any idea why this error is coming ?? Logged in with user sys and connected as SYSDBA

***Updated by moderator: Marissa to close post***
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

March 26, 2009 - 11:43am

The best practice would be to create a PRPC user to run the scripts and create the tables with - and not execute it as "sys". Most people initially create this user with "connect" and "resource" roles.