Oracle Performance and Engineering

 
Import: Release 10.1.0.3.0 - Production ON Mon Sep 25 18:04:39 2006

Copyright (c) 1982, 2004, Oracle.  ALL rights reserved.

PASSWORD:

Connected TO: Oracle DATABASE 10g Release 10.1.0.3.0 - 64bit Production

Export FILE created BY EXPORT:V10.01.00 via conventional path
import done IN US7ASCII CHARACTER SET AND AL16UTF16 NCHAR CHARACTER SET
import server uses UTF8 CHARACTER SET (possible charset conversion)
. importing ITGAPP's objects into ITGAPP
. . importing TABLE         "DSH_GENERATED_IMAGES"
IMP-00058: ORACLE error 942 encountered
ORA-00942: TABLE OR VIEW does NOT exist          0 ROWS imported
Import terminated successfully WITH warnings.
 

This typically happens when CLOB was created in a tablespace that's the new schema cannot "see" or access.

To get rid of -
(1) Either use IMPDP / EXPDP (it rocks! faster, better, easier!)
(2) Precreate the CLOB-ed tables exactly as it were in the exporting schema as follows and then import the table individually -

(a) RUN the following command -

imp FILE= indexfile= TABLES=

(b) RUN the tablecreate.SQL script FROM (a) in the importing SCHEMA. You may need TO CREATE a small TABLESPACE OR two (temporarily, you can get the name FROM the SQL script)

(c) Now import the TABLES -

imp /@ FILE= buffer=1000000 TABLES= ignore=Y LOG=  show=y COMMIT=N

COMMIT=N is better for large tables with LOB data.

posted by Nilendu  # 3:41 PM