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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 11 Aug 2003 10:54:39 +0100
Message-ID: <3f3767e0$0$18492$ed9e5944_at_reading.news.pipex.net>


"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 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.

Hi Ron.

I have read through a number of the replies to you, and have the following comments which I *think* may be helpful and new to you.

  1. Karsten is correct that the transportable tablespace feature is the closest (though not exact) match to sp_attach/sp_detach in sqlserver.
  2. I'd suggest as others have that you go with exp/imp. The problems you seem to be having would appear to come from you using dba studio/oem console. exp is in fact a command line executable that is called by the GUI when you run the export wizard. You want to miss out the GUI entirely and use the utility directly. If you type exp -help at a command prompt you will get the usage notes but essentially you will wish to export just your schema.
  3. I think that your installation routine will end up looking something like run a sql script to create the user, any tablespaces you wish to create for them to use and grant appropriate permissions. run an imp script to import data from a dumpfile on your install media if the standing data isn't created via the import run various sqlldr scripts to import your initial data. do the rest of your application install.
-- 
Niall Litchfield
[Quoted] Oracle DBA
Audit Commission UK
Received on Mon Aug 11 2003 - 11:54:39 CEST

Original text of this message