Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import Fromuser/Touser has problems with Views
manually edit the view as you have done and then when you refresh do not
drop the view but instead import with ignore=y so that the existing view
definition remains.
-- Niall Litchfield Oracle DBA Audit Commission UK "Josh Sale" <jsale_at_tril.com> wrote in message news:afa940$ss$1_at_slb4.atl.mindspring.net...Received on Tue Jun 25 2002 - 14:58:56 CDT
> 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
>