Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: I can attach in SQL Server, but can I in Oracle? Date: Fri, 08 Aug 2003 14:38:10 -0700 Organization: EXE Message-ID: <3F341842.109DE8B1@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <0zRYa.9$7Q2.7@newssvr24.news.prodigy.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 39 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82485 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. > > If by database you mean the Oracle software ... read Oracle's license. If you are trying to use a Microsoft term "database" to mean the equivalent Oracle term "schema" this is done by putting the DDL used to create the objects into one or more scripts and execute them from SQL*Plus as part of the install. Refer to c:\oracle\ora92\rdbms\admin\sql.bsq for an example of how this is done. And ... in the future ...when posting in an Oracle group .... use Oracle terms ... not Microsoft terms. You will get more valuable answers. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)