Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export error!
try to insert the following parameter into the control file:
USERID=SYS_IV
and kill the schemaname from the TABLE-Parameter
TABLES=(IV_WEEK_MODEL_SALES, ...)
instead of
TABLES=(SYS_IV.IV_WEEK_MODEL_SALES, ...) hope this helps
greeting
rjs
Yeung Man schrieb:
> 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
--
b e r l i n . d e - d e r o n l i n e d i e n s t d e r s t a d t
Rüdiger J. Schulz
Technik
tel: +49 (30) 2554-1497
fax: +49 (30) 2554-3725
email: r.schulz_at_berlin.de
homepage: http://www.berlin.de
Received on Fri Jan 15 1999 - 04:06:00 CST