Novice Oracle User needs Urgent Help

[ashridharan]

Hi All,
I have just started using Oracle 8i for a project of mine. I am used to Microsoft SQL Server 2000 and am finding it kinda tough to switch over. Can someone direct me to something as simple as creating a Database in Oracle please ???

Is there some tool like SQL Server's Enterprise Manager for Oracle ???

Ashish

 

[cwong5]

My fav development tool for Oracle is TOAD. You can try it on <a href=&quot;

http://www.toadsoft.com/&quot;

target=&quot;new_win&quot;>

http://www.toadsoft.com/</a>.

 

[lfoata]

You have many products available for Oracle DB administration. If you are looking for an Oracle solution, look at Oracle Enterprise Manager. A pain to install and make work but it does what you are looking for.

For third party, you can look at BMC patrol, it is a good product. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[jcote]

When you installed Oracle for NT, it must have installed a couple of program that you can start. You should see something under Oracle/Database Administration/Database configuration Assistant. That tool lets you create a database.
You could also use the &quot;old&quot; method, which consist solely of using the &quot;create database&quot; command. Of course, there is a lot of parameters you will have to supply to the command, and since your new to Oracle, you'll have to do some reading.
My first advice for you would be to register to Metalink, the online support from Oracle. From this site, you will have access to a lot of information. For instance, I did a quick search for you, and found Note:68720.1 that explain exactly what you need to do to create a database.
To register to metalink, go to the metalink.oracle.com page. You will also need you CID (customer information ...)

Good luck!