Export error!

Hi,

    Our company want to export some of tables from our database. The control file is

        USERID=system/manager_at_orcl
        FILE=c:\runsales\expdat.dmp
        GRANTS=N
        INDEXES=N
        CONSTRAINTS=N
        TABLES= (SYS_IV.IV_WEEK_MODEL_SALES, SYS_IV.IV_POS_MODEL_ON_HAND,
SYS_IV.IV_POS_PRICE_ON_HAND, SYS_IV.IV_POS_USAGE_ON_HAND)
        BUFFER=4096
        RECORDLENGTH=1024
        RECORD=N
        STATISTICS=NONE
        DIRECT=N
        LOG=c:\runsales\expdat.log

    However, we got export error at the end of export. Here is the log file and error message:

        ³s±µ¨ì: Oracle7 Server Release 7.3.4.0.0 - Production
        With the distributed, replication and parallel query options
        PL/SQL Release 2.3.4.0.0 - Production
        ¶×¥X§¹¦¨ ZHT16BIG5 ¦r¤¸¶°
        ª`·N: ¹ïªí®æ¡þµøÆ[ªí¡þ§Ç¦C¡þ¨¤¦âªº±ÂÅv±N¤£·|³Q¶×¥X
        ª`·N: ªí®æªº¯Á¤Þ±N¤£·|³Q¶×¥X
        ª`·N: ªí®æªº­­¨î±ø¥ó±N¤£·|³Q¶×¥X

        §Y±N¶×¥X³]©wªºªí®æ ¸g¥Ñ¶Ç²Î¸ô®| ...


        . . ¥¿¦b¶×¥Xªí®æ            IV_WEEK_MODEL_SALES¶×¥X¤F         915 ¦C


        . . ¥¿¦b¶×¥Xªí®æ           IV_POS_MODEL_ON_HAND¶×¥X¤F        2521 ¦C


        . . ¥¿¦b¶×¥Xªí®æ           IV_POS_PRICE_ON_HAND¶×¥X¤F         484 ¦C


        . . ¥¿¦b¶×¥Xªí®æ           IV_POS_USAGE_ON_HAND¶×¥X¤F         184 ¦C


        EXP-00008: µo¥Í ORACLE ¿ù»~ 904
        ORA-00904: invalid column name
        EXP-00000: ¶×¥X§@·~¤£¶¶§Q²×¤î

    Anyone has idea about? TIA.

Best Regards,
Man
yngm_at_chowsangsang.com Received on Fri Jan 15 1999 - 02:05:07 CST