9i Question

[abongwa]

I tried to use a 9i exp to export a schema from a 9i database and use a 9i imp to import the dump file into a 817 database and got the following message:

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.


What are "Import views"? How to install?

[SANJAY_G]

You will have to create Version 8 Export file from 9i.

Sanjay

[abongwa]

That does not work either.

[SANJAY_G]

Is it a new database? Did you run catalog.sql and catproc.sql ?

[julian]

Originally posted by abongwa
That does not work either.

Do both: exp and imp with the 8i utility. Also, you probably have not run some scripts.

[mzahid]

8.1.7 import will not be able to read an export created by the Oracle9i export utility.

Make sure that you have created necessary views by running
CATEXP.sql script.

For more details please goto Oracle OTN site and download Utilities pdf Oracle 9i.

Cheers!!!!

[abongwa]

I tried to use different server to do the exp. Now, I got different error message:

$ exp sh/sh@asdf owner=sh file=sh.dmp

Export: Release 8.1.7.2.0 - Production on Thu Mar 7 10:46:03 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SH
. exporting object type definitions for user SH
About to export SH's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SH's tables via Conventional Path ...
. . exporting table CAL_MONTH_SALES_MV 35 rows exported
. . exporting table CHANNELS 5 rows exported
. . exporting table COSTS
. . exporting partition COSTS_Q1_1998 57879 rows exported
. . exporting partition COSTS_Q2_1998 58450 rows exported
. . exporting partition COSTS_Q3_1998 52570 rows exported
. . exporting partition COSTS_Q4_1998 65803 rows exported
. . exporting partition COSTS_Q1_1999 66940 rows exported
. . exporting partition COSTS_Q2_1999 67825 rows exported
. . exporting partition COSTS_Q3_1999 60968 rows exported
. . exporting partition COSTS_Q4_1999 75590 rows exported
. . exporting partition COSTS_Q1_2000 78468 rows exported
. . exporting partition COSTS_Q2_2000 78036 rows exported
. . exporting partition COSTS_Q3_2000 70424 rows exported
. . exporting partition COSTS_Q4_2000 54812 rows exported
. . exporting table COUNTRIES 19 rows exported
. . exporting table CUSTOMERS 50000 rows exported
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
. . exporting table FWEEK_PSCAT_SALES_MV 149325 rows exported
. . exporting table MVIEW$_EXCEPTIONS 0 rows exported
. . exporting table MV_CAPABILITIES_TABLE 0 rows exported
. . exporting table PLAN_TABLE 0 rows exported
. . exporting table PRODUCTS 10000 rows exported
. . exporting table PROMOTIONS 501 rows exported
. . exporting table REWRITE_TABLE 0 rows exported
. . exporting table SALES
. . exporting partition SALES_Q1_1998 71805 rows exported
. . exporting partition SALES_Q2_1998 72705 rows exported
. . exporting partition SALES_Q3_1998 63390 rows exported
. . exporting partition SALES_Q4_1998 83415 rows exported
. . exporting partition SALES_Q1_1999 86217 rows exported
. . exporting partition SALES_Q2_1999 87298 rows exported
. . exporting partition SALES_Q3_1999 76139 rows exported
. . exporting partition SALES_Q4_1999 100110 rows exported
. . exporting partition SALES_Q1_2000 104544 rows exported
. . exporting partition SALES_Q2_2000 104652 rows exported
. . exporting partition SALES_Q3_2000 91260 rows exported
. . exporting partition SALES_Q4_2000 74736 rows exported
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully