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

Ron Fluegge wrote:

> As a follow-up let me again re-iterate, the application is fully functional
> and DOES ALREADY WORK with Oracle 8i and 9i on my development machines using
> the developer versions of them. I have both Oracle 8i running quite well on
> one development machine and Oracle 9i running on another (along with SQL
> Server 2000 on the same machine) -- developer versions.
>
> I readily admit that I am a developer -- not a DBA. That's the reason for
> posting the request for information here. And I have quite successfully
> written a single datalayer that accesses all 5 DBMS from a single source
> file using the managed data providers in VS.NET 2003.
>
> I have successfully created all of the Microsoft databases such that they
> can be very "easily" installed on client machines.
>
> The only thing that is lacking is the method outlined in my original posting
> to get the Oracle 8i and 9i on to the distribution CD and installed on the
> clients' machines -- hopefully without having to resort to very long SQL
> scripts -- because of the 5,000+ data records that have to be included in
> one of the tables.
>
> <snipped>

[Quoted] [Quoted] If by database you mean the Oracle software ... read Oracle's license. If you [Quoted] [Quoted] are trying to use a Microsoft term "database" to mean the equivalent Oracle term [Quoted] "schema" this is done by putting the DDL used to create the objects into one or [Quoted] more scripts and execute them from SQL*Plus as part of the install. Refer to [Quoted] c:\oracle\ora92\rdbms\admin\sql.bsq for an example of how this is done.

[Quoted] And ... in the future ...when posting in an Oracle group .... use Oracle terms [Quoted] ... not Microsoft terms. You will get more valuable answers.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
[Quoted] damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)