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: IMPORT - how many passes?

Re: IMPORT - how many passes?

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 5 Nov 2003 16:11:50 GMT
Message-ID: <3FA92146.98330BF8@remove_spam.peasland.com>

> Brian: I think the problem is rather that the OP has a locally-managed
> system tablespace, and in that case you *can't* create new DMTs, unless they
> are read only... which of course puts paid to the idea of doing an import
> into them. But whatever: the end result is the same -pre-create the
> tablespaces and then do the import.

Good catch. I didn't consider that SYSTEM may be LMT as well, which precludes DMTs.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Nov 05 2003 - 10:11:50 CST

Original text of this message

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