Re: Export error!

Connect internal and run catexp.sql, this should solve your problems...

BTW, what version and platform are you on?? I've seen this on NT, Oracle 7.3.3 when I have not installed the default database but rather created my own...
the workaround: ran catexp.sql from an HP machine. Go figure??

Cheers,
Robert Prendin

"Yeung Man" <yngm_at_chowsangsang.com> wrote:

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

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Fri Jan 15 1999 - 08:50:59 CST