Re: import without views

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 11 Mar 2004 22:39:58 GMT
Message-ID: <4050EABE.64AD4E33@remove_spam.peasland.com>

Tudor wrote:
>
> Hello
>
> I'am trying to import an export file from a oracle 8i database to
> another 8i database from a user xxx to user xxx. I want to import
> everything _without_ views. The syntax i use is imp
> system/manager_at_mydb file=export.dmp fromuser=xxx touser=xxx but this
> syntax tries to import everything from xxx to xxx including the views
> which i do not want.
>
> Can anyone help me please.
>
> Thanks.
>
> /tudor

There is no option to import everything but views. Your options to import are FULL (import everything in the dump file), FROMUSER (import everything a user owns in the dump file, and TABLES (import selected tablespace from the dump file). Can't you import everything with FROMUSER and then go in later and drop the views?

HTH,
Brian Received on Thu Mar 11 2004 - 16:39:58 CST