Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Two databases but one instance

Re: Two databases but one instance

From: TurkBear <johng_at_mm.com>
Date: Wed, 29 Dec 1999 15:18:40 GMT
Message-ID: <386b2608.166274800@super.news-ituk.to>


Paul Bennett <bennett_at_cc.gatech.edu> wrote:

>SNIP------------------------------
>> then it should be straight forward. I asume the two databases are
>> identical (same version and have the same administration scripts
>> applied).
>
>I think when you import a schema from a export it puts the tables in the default
>tablespace of the new user you are importing into.
>
>-- Paul
>
>

Actually Import will use the tablespace specified in the Export if it exists; if not, then it will use the default for the importing user...

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Dec 29 1999 - 09:18:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US