Re: SQLDMO for Oracle

In message <OKOdnSh5Y6K7fXneRVn-oA_at_comcast.com>, Mark C. Stock <mcstockX_at_Xenquery.com> writes
>
>"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
>news:ds2hs3$ogm$1_at_news3.zwoll1.ov.home.nl...
>> Jim Smith wrote:
>>
>>> Tell me this. Which is more likely to cause problems?
>>>
>>> 1 Giving users access to Enterprise Manager
>>> 2 Giving users access to an application which lets them carry out
>>> limited dba activities under conditions and control determined by the
>>> programmer.
>>
>> Either.
>>
>> Usually, neither users nor programmers know about backups,
>> restores, block corruption, etc.
>>
>> You're not allowed to drive a car without a license, either.
>>
>> --
>> Regards,
>> Frank van Bortel
>>
>> Top-posting is one way to shut me up...
>
>this thread is getting just plain silly. users don't know about backups?
>programmers don't know about backups? c'mon!
>

I agree. It is like a Luddite DBA picket line.

There seems to be a view that there is no DBMS but oracle, all oracle systems are multi-terabyte RAC systems with teams of DBAs, and applications are things which are designed to break our databases.

In fact there are many, many systems out there where the database is small (100s of MB - 10s of GB) which don't (or shouldn't) need a specialist tech support team to look after it. Providing facilities to allow users[1] to manage backups and perhaps database upgrades through the application is a major step towards this. It may not be good for the DBA job market but reducing the cost of technology is good for business.

As to the anti-programmer bigotry, it is no more than that. There are cowboys on both sides and there are good professionals on both sides.

I don't know exactly what the OP had in mind, (and I suspect he got bored and has gone somewhere civilised) but I the kind of thing I would expect is a simplified backup manager, some way of exporting data for support purposes and possibly a way of implementing application schema upgrades.

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