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!