On Tue, 9 Mar 1999, Ralf Staib wrote:
> Hi Ari,
>
> we want to import a Oracle7-Full-Datatbase Dump into an Oracle 8-Database with
> The Error-Message was IMP-00023:
>
> IMP-00023     import views not installed, please notify your DBA
>
> Cause:        The necessary Import views were not installed.
> Action:       Ask your database administrator to install the required Import 
>               views
>
> Which VIew?s are these?? How  can I get them created??
> You have a great site.
>
>
> We would appreciate it, if you could help us.
> With kindly regards
>
> Ralf + Wolf
Hi,

What you need to do is run "catexp.sql" as SYS or INTERNAL. The file is
located in $ORACLE_HOME/rdbms/admin.

This script creates data dictionary views for the Export and Import
utilities. There are a couple of dozen views created. If you are curious
to learn more about them, read the documented catexp.sql file itself.
$$
This script should have been run when your database was created.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 275+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page > Back to Ari Kaplan's Home Page