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 -> Re: EXP

Re: EXP

From: Nicolas Bronke <bronke_at_gmx.net>
Date: Thu, 1 Aug 2002 17:24:20 +0200
Message-ID: <aibjr5$1349fm$1@ID-121870.news.dfncis.de>

> "depending order" ? Check the manual for consistent = y and see if
> that is what you mean.
>

Yes and no. This was what I remembered but is actually not what I am looking for.

As a better explanation:
a)
view x depends on view y
now you exporting the schema and trying to import on another database. There you will get a failure. The result is an invalid view. This is a big problem, because I can recompile the view.

b)
As I found in some databases, there are views like

select NewColumn,TableName.* from TableName ....

With this I found out the problem, that the view is not imported in some cases. If I start the import twice, then mostly all objects are imported.

Especially b) I wanr to avoid. I cannot change the view-source, because it is not from mine.

I hope now I explained my problem a little bit better.

Regards
Nicolas Received on Thu Aug 01 2002 - 10:24:20 CDT

Original text of this message

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