"cel" <papouasied_at_yahoo.com> wrote in message
news:3d303c0c$0$273$626a54ce_at_news.free.fr...
> So that means if you want to import
> any dmp file into a newly created database, you need to know the
> tablespaces used in the exported database.
> Right ?
Not necessarily. You can create whatever tablespaces you want and then
create the users (with a non system default tablespace). Then you ccan
import using FULL=Y and IGNORE=N. The advantage being that you don't need to
know all the tablespace names, the disadvantage being that you have no
control over where the objects go (they'll all end up in the default
tablespace) if tablespace names differ.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Jul 13 2002 - 09:59:05 CDT
