9i Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: 9i Question

  1. #1
    Join Date
    Feb 2002
    Posts
    59
    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?

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You will have to create Version 8 Export file from 9i.

    Sanjay

  3. #3
    Join Date
    Feb 2002
    Posts
    59
    That does not work either.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Is it a new database? Did you run catalog.sql and catproc.sql ?

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

  6. #6
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87

    IMP-00023 Import views not installed

    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!!!!

    Mohammad Zahid
    Software Developer
    Database Management Applications.
    Vancouver, Canada
    E-mail: mzahid@shaw.ca

  7. #7
    Join Date
    Feb 2002
    Posts
    59
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width