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 -> User default directories using imp

User default directories using imp

From: Randy Harris <randy.harris_at_nospam.net>
Date: Fri, 25 Apr 2003 07:34:10 GMT
Message-ID: <Sx5qa.45$gN4.78901@newssvr28.news.prodigy.com>


I am trying to import a full dump file into 8i, using imp and full=y. It's working fairly well, the users are getting created with correct default tablespaces, however, the tables owned by at least one of them are ending up in SYSTEM rather than their correct default. Is there some way to force imp to put the data in the correct tablespace? Or, is there some way to get imp to import the users without any table structure? Would fromuser=system touser=system do that?

Thank you for your help

--
Randy Harris
Received on Fri Apr 25 2003 - 02:34:10 CDT

Original text of this message

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