Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!not-for-mail Reply-To: "Ron Fluegge" From: "Ron Fluegge" Newsgroups: comp.databases.oracle.tools References: <0zRYa.9$7Q2.7@newssvr24.news.prodigy.com> Subject: Re: I can attach in SQL Server, but can I in Oracle? Lines: 122 Organization: Fluegge Consulting Group X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 65.67.113.150 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr12.news.prodigy.com 1060371741 ST000 65.67.113.150 (Fri, 08 Aug 2003 15:42:21 EDT) NNTP-Posting-Date: Fri, 08 Aug 2003 15:42:21 EDT X-UserInfo1: FKPGGWSDSBUYSUTYKBCB^]\@PJ_^PBQLGPQRJRQIMASJETAANVW[AKWZE\]^XQWIGNE_[EBL@^_\^JOCQ^RSNVLGTFTKHTXHHP[NB\_C@\SD@EP_[KCXX__AGDDEKGFNB\ZOKLRNCY_CGG[RHT_UN@C_BSY\G__IJIX_PLSA[CCFAULEY\FL\VLGANTQQ]FN Date: Fri, 08 Aug 2003 19:42:21 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82479 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. Despite Sybrand's response, I hope that there are others here who are willing to provide relevant information. Again, any assistance would be greatly appreciated. Ron "Sybrand Bakker" wrote in message news:lop7jv0nqknstg8t08gi70j2siccug7f17@4ax.com... > On Fri, 08 Aug 2003 18:00:28 GMT, "Ron Fluegge" > wrote: > > >First, let me apologize for the probably "simple and basic" question, but I > >have searched both Google and Deja without success. > > > >I have a commercial application that I am finishing in VS.NET that connects > >with both SQL Server and Oracle databases -- the client gets to choose one > >of the following to store the data in: Access, SQL Server 7 or 2000, or > >Oracle 8i or 9i. The development has gone well and I can read/write to any > >of the 5 options successfully during development. > > > >I have installed the developer versions of SQL Server 7 and 2000 and Oracle > >8i and 9i. > > > >The application runs just fine. I have been creating the "master" databases > >in SQL Server and then "uploading" them into Oracle using the MS DTS app. > >Then I switch the "pointer" in my application so that it reads the data from > >the Oracle DBs and it also works just fine. > > > >However, now I'm getting ready to create the distribution CDs and I realized > >that I have a problem.... > > > >With the SQL Server databases, I can distribute the two required database > >files and then either run SP_ATTACH_DB in SQL 7 or interactively in SQL 2000 > >in order to "attach" the databases to the Server. Works great. > > > >I have tried to understand how to do the same thing in Oracle. I suspect > >that since I have the developer versions of the Oracle software that I don't > >have all of the tools to do what I need to do. When I attempt to import or > >export the tablespaces it says something about "the wizard can only be > >launched when the application is connected to the Oracle Management Server > >(OMS)." > > > >As a result, I'm at a loss to understand what it is I need to do. I've gone > >through as much online as I can find and I have several Oracle 8i and 9i > >books, but this leaves me mystified. > > > >Essentially what I need to do is the following: > > > >(1) Create copies of the tablespace (database in SQL Server terminology) > >required for the application (not only the schema, but also one "table" > >contains about 5,000 records that need to be a part of the installation so > >it appears to be more than a SQL script to create the tables) > > > >(2) Copy the files created in (1) to the distribution CD > > > >(3) Clients then copy the files created in (1) to their own Oracle server > >and then "attach" these files to the database instance so that the > >application can then access the tables. > > > >Please understand that I may not be using the correct terminology for the > >Oracle databases and tables -- I apologize. > > > >Any assistance would be greatly appreciated. > > > >Thanks. > > > >Ron Fluegge > > > > > You need to do the following things > 0.a find the financial resources to learn Oracle > 0.b alternatively hire a consultant > 0.c redevelop the sqlserver app for Oracle. It is not going to work > without change ever > 0.d regret you decided Oracle is Sqlserver sold by a different vendor > 0.e add several months to the release date > 0.f forget all of the points outlined above: they are crap and show > you don't know anything about Oracle > > > Sybrand Bakker, Senior Oracle DBA > > To reply remove -verwijderdit from my e-mail address