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

Karsten,

[Quoted] Thanks for the response.

[Quoted] I'll give "transportable tablespaces" a further look. I found it in several [Quoted] books that I have, but I thought that there had to be an easier way ... from [Quoted] the "novice" perspective.

Again, thanks...

Ron

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.199daedeb9639a3f989833_at_news.la.sbcglobal.net...
> Hi Ron Fluegge, thanks for writing this:
> > First, let me apologize for the probably "simple and basic" question,
but I
> > have searched both Google and Deja without success.
> >

   :
   :
> >
> > 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
> >
>
> If I understand your requirement correctly (btw, thanks for being so
> thorough in your description ... sadly, a rare occurance in this NG), you
> need to read up on an Oracle feature known as "transportable tablespaces"
> (which you can find by searching for this phrase on Google).
>
> Since I don't know what the SQL Server stored procedure does, I don't know
> if this is the same thing. But basically, transportable tablespaces allow
> you to unhook a tablespace from one database and plug it into another.
> --
> [:%s/Karsten Farrell/Oracle DBA/g]
Received on Sat Aug 09 2003 - 00:26:51 CEST