Re: help! import problem!

Hi,

    Based on the error messages it appears that the table DIGITAL in database A has been altered Using the ignore=y option in order to have tables and indexes go where you want them is a good thing -- providing that the individual tables in the export and import databases have the same structure. Fix up the table definition in database B and that error should go away.

    Off hand I can't think of the reason for the other error you are getting, since it implies that the export is generating an ANALYZE command for a table that doesn't already exist in database B and was not exported from database A. You should run an ANALYZE VALIDATE STRUCTURE against the TEMP_MSG table in database A. Don't be surprised if it comes back with an error message. (Since I know that export only puts out objects with valid structures I suspect that the table is invalid and not being exported but that the analyze statement is, for some reason, being generated.)

regards
Jerry Gitomer

cantoneseboy wrote in message <377B7E03.B60FE6D8_at_hotmail.com>...
>Hi
>
> I have a import problem , here is the error:
>
>. . importing table "DHOLIDAY"

69 rows
>imported
>. . importing table "DHOST_DATA" 1
rows
>imported
>. . importing table "DIGITAL"
>IMP-00020: long column too large for column buffer size (8)
>IMP-00028: partial import of previous table rolled back: 76846
rows
>rolled back
>IMP-00017: following statement failed with ORACLE error 942:
> "ANALYZE TABLE "TEMP_MSG" ESTIMATE STATISTICS "
>IMP-00003: ORACLE error 942 encountered
>ORA-00942: table or view does not exist
>. . importing table "TEMP_REFERENCE" 35578
rows
>imported
>. . importing table "TEMP_TASK_LOG" 9
rows
>imported
>
>Every day our system (A) will do a full export and we use this
export
>data file to import
>to system (B) once a week. I can use full import OR user mode
import
>to load
>the data back on last week But I don't know what's going on with
the
>export file
>these days.
>I can't load it by full import OR user mode OR just even import
the
>"DIGITAL"
>table only. I have asked oracle, and they said I should increase
the
>size of the
>import parameter "Buffer".
>
>Here is the command I use to do the import
>
> imp system full=y file=full_export.dat log=ful_import.log
commit=y
>ignore=y
> buffer=65535
>
>I had tried to increase the buffer to 6553500 or 65535000 but
nothing
>can help.
>It's strange that the import skip all the tables from "Digital "
to the
>table name
>start will "T". Why it don't import those tables even the table
digital
>is failed?
>
>Our oracle is 7.4.3.4 on AIX4.2
>
>
>Can someone help me?
>
>Wayne
>
>(The table digital seem does not contain raw data.)
>
Received on Sun Jul 04 1999 - 01:13:56 CDT