Re: SQLDMO for Oracle

Jim Smith wrote:
>
> I agree. It is like a Luddite DBA picket line.

Never heard about that.

> 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.

Isn't that so? :)

> 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.

Agreed - as usual, it depends.

> 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.

Agreed. But that wasn't the question. The question was about chance. All I said, was that I reckon the chance equal, and for greater than with a competent (mark that: not licensed!) DBA. I've just seen too many environments where the responsible DBA was to clean up the mess, where there should clearly have been a project DBA.

And for those small environments, there should be one, just because of the underestimating you do.
You underestimate the cost of data, or rather, the price of data.

> 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
<g>

> expect is a simplified backup manager, some way of exporting data for
> support purposes and possibly a way of implementing application schema
> upgrades.
>

Monkey-proof, eh? I was told, by the time you have a monkey-proof tool, only monkeys will break it.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...