Last post Jan 15, 2009 01:18 PM by Kumar Reddi
Jan 13, 2009 08:07 AMemail@example.com|LINK
How to create new database on oracle 9i for windows and assigning privileges( i mean username & password)?..
i was worked on sql server.am new to this oracle 9i..
Thanks in advance
Jan 14, 2009 02:49 AM|Kumar Reddi|LINK
Jan 15, 2009 06:38 AMfirstname.lastname@example.org|LINK
Thanks reddi.The thread u gn for creating new user in orcale 9i.
actually i wanna creating a NEW DATABASE ON ORACLE 9I.how to do?..
Jan 15, 2009 11:31 AM|Kumar Reddi|LINK
In oracle a user is a schema, which is loosely called as database too.
Lets say you need to create a TestDB in oracle database, you would be creating a user named "TestDB"
Jan 15, 2009 12:29 PMemail@example.com|LINK
Thanks again reddy for ur response.As u said "in oracle user is a schema..if u want to create a new user in oracle the first step is below
Start Console in stand-alone mode, double-click the Databases folder, double-click the database you want to work on, and log in as the DBA user (if necessary).
now my qn is if i have db then only i can create new user ri8?..
i wanna how to create db first of all?..if i did that only i can create a new user...
am i clear?..
Jan 15, 2009 01:18 PM|Kumar Reddi|LINK
What you are asking is called Instance.. Creating an Oracle instance is little more complicated.. If you have a DBA, I will suggest you to take his help.. If not, here is an article that talks about creating an instance in oracle