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

Ron:
[Quoted]   Not being an 'expert'. I suggest you elimiate transportable tablespaces unless you can somehow guarantee that the target O8i database has the same block size as your instance. With O9i, and care, the DBA can add the block [Quoted] buffers needed for your block size on the fly, but not with O8i.   Using 'Exp/Imp' also has some drawbacks. 9i can import 8i exports. 8i 'can' have problems importing 9i exports.   The 'as yet' unmentioned option is 'SQL*Loader'. Documents for this are in the same 'Utilities' manual as Imp/Exp.   In all cases, the target 'schema owner' must exist, have correct permissions etc.
HTH
tED
"Ron Fluegge" <rmflugge_at_swbell.net> wrote in message news:0zRYa.9$7Q2.7_at_newssvr24.news.prodigy.com...
> 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...<G>.
>
> 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
>
>
Received on Sat Aug 09 2003 - 10:45:42 CEST