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

Home -> Community -> Usenet -> c.d.o.misc -> Re: import data in an other table space

Re: import data in an other table space

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 30 Jul 2003 13:24:27 GMT
Message-ID: <3F27C70B.FF926B5F@remove_spam.peasland.com>


Precreate the tables in the tablespace that you want them to be allocated in. Then import with IGNORE=Y.

HTH,
Brian

Michel wrote:
>
> I'd like to import table in the console with the import tool. The
> problem is that the table are placed in the table space from where
> they where exported...
> Is ther a way to import them in an other table space?
>
> Thanks Michel

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

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 Jul 30 2003 - 08:24:27 CDT

Original text of this message

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