Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: import without views
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
![]() |
![]() |