Re: import without views

Thanks for your replies. But conversely, is there any way to export a database without views and then when importing it i would have no problem with the views i am not interested in. The reason behind is that each time i import the export file i have endless errors concerning the views creation and i would like to avoid this. I thought i would be a way to avoid importing them but as you said this is not possible, so that's why i would like to ask if it is possible at least to export the all but views.

Tnaks and looking forward for your replies.

Tudor

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<k6s150li5dop0b7hr07gkphrv2igckhlu1_at_4ax.com>...
> On 11 Mar 2004 14:04:58 -0800, balan_tudor_at_yahoo.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
>
> not possible
Received on Sun Mar 14 2004 - 13:25:50 CST