Re: Import Fromuser/Touser has problems with Views

Josh Sale wrote:

> I'm importing a database and need to change the schema (e.g., fromuser=foo
> touser=bar).
>
> All of the tables import OK. However, the export file includes a view
> definitions like:
>
> create view stuff as select col from foo.tab
>
> and import doesn't change foo.tab to bar.tab in the view definition. This
> means the view can't be created because the referenced table doesn't exist.
>
> Does anybody know a way around this?
>
> Manually editing the view definition after the fact isn't very satisfactory
> because I need to reimport the schema periodically.
>
> TIA,
>
> josh

[Quoted] Get the DDL definition of the view and recreate it.

Or

[Quoted] Before the import starts create synonyms that will solve the problem.

Daniel Morgan Received on Wed Jun 26 2002 - 00:05:23 CEST