Re: SQLDMO for Oracle

In message <sbh8u1dou0p0ls3o2rqb4j4ousr5i893jn_at_4ax.com>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> writes
>On 3 Feb 2006 20:36:16 -0800, narayan.k.verma_at_gmail.com wrote:
>
>>I am developing a product where I do not want the users to directly
>>work with these tools. I want that handled via my application.
>>
>>My goals apart, it there such a tool or API?
>>
>>SQLDMO does not re-invent the wheel. It just provides an API over
>>which you can change the database structures, create backups etc.
>>Those tools do have a value.
>>
>>Thanks.
>
>Changing the database structure, creating backups, is a responsibility
>for a DBA. End-users shouldn't be allowed to do this, or to change the
>database structure on the fly. This is a recipe for disaster.
>Tools like SQLDMO don't have any place in the Oracle world.
>Oracle is a professional RDBMS, not a toy.
>

You need to get over this fear of difference that you have, Sybrand. Just because you don't understand it doesn't make it wrong, or even inferior.

Providing an application which can carry out backups and database maintenance without employing a DBA is a very useful. Not everyone wants or can afford to employ an expensive and arrogant DBA for every little application they buy.

-- 
Jim Smith
I'm afraid you've mistaken me for someone who gives a damn.