Correct terminology for my role 1

[evergreean]

I would like to know if I using the correct terminology for my job as a Web Front end developer talking to an Oracle DBA about what I need for my back end because my DBA has asked me what I want from the Oracle Database.

I will tell him I need Oracle client software (which is Enterprise Manager?) and that I am a web developer and my only request to the DBA will be for him to create schemas throughout the year so I can use each schema as a back end to each one of my front end web applications.

I will be creating the objects (tables and queries) in the back end and advising what size for each schema.

I am not going to be a DBA and not interested in any DBA roles. I just want to be able to create tables and queries for each one of my schemas.

Please advise if my terminology is correct?

 

[SantaMufasa]

Evergreen,

Everything that you said, I understood, and it seems reasonable to me.

The only puzzlement that I have is about "Enterprise Manager"...that seems like a bit too beefy a tool for what you described as your need/charter. There are, perhaps, tools that come with Oracle that have the appropriate "horsepower" for your needs, which you describe as, "I just want to be able to create tables and queries for each one of my schemas."

Frankly, for documentation, reference, and maintenance purposes, I, personally, script all of my object CREATEs and run them in SQL*Plus (a freebie, stock item with just about any/every Oracle installation). But there are GUI tools (such as Oracle Designer/Developer tools, et cetera) that are probably better suited than "Enterprise Manager" (IMHO).

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[evergreean]

Thanks that is exactly the info I needed.