Re: I can attach in SQL Server, but can I in Oracle?

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F37BA12.82E6D800_at_exxesolutions.com...
>
>
> Ron Fluegge wrote:
>
> > Daniel,
> >
> > I have been to http://tahiti.oracle.com and am still at a loss about how
to
> > do the specific task.
> >
> >
> > <snipped>
>
> The Oracle software installation can not be done by your software. It must
be
> done as an independent step by a competent DBA working with a competent
> SysAdmin. From that point forward you can use a simple ASCII file script
to
> build the system tablespace, other tablespaces, create users, create
roles,
> create tables, populate them, etc. And it doesn't require documentation to
> figure out how to do this.
>
> Go to$ORACLE_HOME/admin/.../scripts on your server and the scripts for
database
> creation and tablespace builds are there: Just modify them. To create
tables,
> views, procedures, and populate them with data the scripts are at
> $ORACLE_HOME/rdbms/admin. Look specifically at sql.bsq, catalog.sql,
catproc.sql
> to see how.
>
> This isn't rocket science. It is elementary school and any Oracle shop
will know
> how it is done and expect to see it in this way.
>
> In fact many Oracle shops will refuse to let you install if you don't do
it this
> way because they will want to sign an NDA and review the scripts before
letting
> you run them on their server. I for one have never allowed a blind
installation
> on a server. If a vendor insists on doing that ... they lost the sale.

[Quoted] [Quoted] I gather Ron's intention is an automated way to install his application on [Quoted] an Oracle server. Why does one need the services of both a DBA and an administrator to do this? For example, if he is using ODBC/ADO, the Microsoft Oracle driver will allow him to execute native Oracle SQL commands, making it possible to script the entire creation of schema, populate tables, grant rights, create objects... whatever necessary, and completely without the services of a DBA or administrator. Received on Mon Aug 11 2003 - 18:55:13 CEST