Re: SQLDMO for Oracle

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 04 Feb 2006 07:13:58 +0100
Message-ID: <sbh8u1dou0p0ls3o2rqb4j4ousr5i893jn@4ax.com>

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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Feb 04 2006 - 00:13:58 CST