My company is a software developer - We make an ODBC compliant Visual
Basic application that currently handles several database platforms
including Oracle.
Unfortunately, we set up and tune our own servers for internal knowledge
of the basic process. For oracle, however, we had a DBA do the initial
install of Oracle 7 for Windows NT (because we couldn't get it working
ourselves) - After about 3 days, it seemed that the DBA finally managed to
figure it out himself with help from one of our employees (the DBA wasn't
extremely knowledgable - like he was in training or something)
They created one database successfully that we can log into, but since
then we have not been able to create another database, we have run into
all sorts of problems, mostly lack of permissions (even though we're
logging in as an Admin)
I assume it is required that we use SQL Plus to create this database, but
the documentation doesn't seem to help us much, and my normal CREATE
DATABASE knowledge doesn't seem to apply very accurately.
I have worked extensively with Microsoft SQLServer, Sybase SQLServer,
dBASE, IBM DB2/2, and Watcom 4.0, but Oracle is not like any of these.
What is the normal procedure for creating a database under Oracle - short
of hiring a DBA to do it for us?