Re: Oracle database creation:no dba authority

In article <weiss.769269316_at_epx.cis.umn.edu>, weiss_at_epx.cis.umn.edu () writes:

I'm having trouble creating a database in Oracle; I'm told that I have
insufficient dba permissions by SQLdba and SQLplus . What can I do to train
in Oracle under these circumstances?

*---------------
A common problem I've seen with folks new to Oracle but perhaps familiar with other RDBMS systems is that in a typical Oracle environment, there are one or several "instances", or databases, and each user has his or her own schema with objects underneath. There is one big database that holds the data for all users / schemas, with administrative controls governing how much space can be used by any given user in a given tablespace, etc.

The only person that needs the ability to "create database" is your Oracle database administrator (DBA). Once this has been done, he or she can create Oracle usernames with appropriate validations that will allow developers, programmers, and others to have access to the database as is judged appropriate for the site's mission.

"create database" ought to be renamed to something more like
"DON'T!". In database creation, most important system / database
information is initialized; only the DBA need ever deal with this. I recall reinstalling and rebuilding an Oracle6 PC database about 5 times as programmers (familiar with other RDBMS, such as Informix/SE) found this infamous command, and somehow decided they needed to do this.

It should not be a big problem for you to ask your local ORACLE DBA for an Oracle username.

R. (Scott) Hunter
Database Administrator
AT&T Tax Systems, Morristown, NJ Received on Wed Jun 08 1994 - 02:09:01 CEST