When I created a database use dbca, I found these users were created:
MDDATA, TSMSYS, DIP, DBSNMP, WMSYS, ORDSYS, EXFSYS, XDB, DMSYS, OLAPSYS, MDSYS, SYSMAN, CTXSYS, OUTLN
Now, I am trying to create an Oracle 10g database manually. I would like to find out what script(s) I should execute in order to create these users with appropriate roles assigned? Any help is appreciated!
well first work out what you need and then create the ones you want, look up that word in the docs and it will tell you how to create it
Check this Metalink, gives you details of all the schema and thier use and why you need them?
Do you really need them?
Best if you don't them not to create them
Click Here to Expand Forum to Full Width