To Create New DB in Oracle

**senthil** · **senthil** on Wed 5 Nov - 15:55

To Create a New DB in Oracle :
1.Start -> Programs -> Oracle Enterprise Manager Console
2.Select "Launch Standalone" & Click OK. Then select HSINDORA under Databases.
3.Then enter User id & Password: HRM5_CON, then select "Connect as : Normal" & click OK.
4.Select "Storage" -> Tablespace -> Right click & Select "Create", then give database name eg."HRMora" & give the Size & Click "Create" . Message displays like "Tablespace Creates Successfully".
5.Then Select Security -> User ( Right Click & Select Create).
6.Enter the "User name, Password & Confirm Password then select Tablespace (Already Created "HRMora") & select "Temporary" as Temp.
7.Then Select Role.In that enable the Admin option for Connect & select & move down "DBA" in the list & enable the Admin Option.
8.Then Select System. In that select & add "Alter tablespace & Unlimited tablespace. Then Enable the Admin Option.
9.Click Create "User Created Successfully" message displayed.