I can attach in SQL Server, but can I in Oracle?
Date: Fri, 08 Aug 2003 18:00:28 GMT
Message-ID: <0zRYa.9$7Q2.7_at_newssvr24.news.prodigy.com>
[Quoted] [Quoted] First, let me apologize for the probably "simple and basic" question, but I [Quoted] [Quoted] have searched both Google and Deja without success.
[Quoted] [Quoted] I have a commercial application that I am finishing in VS.NET that connects [Quoted] with both SQL Server and Oracle databases -- the client gets to choose one [Quoted] of the following to store the data in: Access, SQL Server 7 or 2000, or [Quoted] Oracle 8i or 9i. The development has gone well and I can read/write to any [Quoted] of the 5 options successfully during development.
[Quoted] 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 [Quoted] [Quoted] in SQL Server and then "uploading" them into Oracle using the MS DTS app. [Quoted] Then I switch the "pointer" in my application so that it reads the data from [Quoted] the Oracle DBs and it also works just fine.
[Quoted] However, now I'm getting ready to create the distribution CDs and I realized [Quoted] that I have a problem...<G>.
[Quoted] With the SQL Server databases, I can distribute the two required database [Quoted] files and then either run SP_ATTACH_DB in SQL 7 or interactively in SQL 2000 [Quoted] in order to "attach" the databases to the Server. Works great.
[Quoted] I have tried to understand how to do the same thing in Oracle. I suspect
[Quoted] that since I have the developer versions of the Oracle software that I don't
[Quoted] have all of the tools to do what I need to do. When I attempt to import or
[Quoted] export the tablespaces it says something about "the wizard can only be
[Quoted] launched when the application is connected to the Oracle Management Server
(OMS)."
[Quoted] As a result, I'm at a loss to understand what it is I need to do. I've gone
[Quoted] [Quoted] through as much online as I can find and I have several Oracle 8i and 9i
[Quoted] 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
[Quoted] 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
[Quoted] and then "attach" these files to the database instance so that the
application can then access the tables.
[Quoted] [Quoted] Please understand that I may not be using the correct terminology for the [Quoted] Oracle databases and tables -- I apologize.
Any assistance would be greatly appreciated.
Thanks.
Ron Fluegge Received on Fri Aug 08 2003 - 20:00:28 CEST