Home » RDBMS Server » Server Utilities » Impdp Procedure or function 10.2.0.4 Error ORA-00904 (Impdp, Oracle 10.2.0.4)
Impdp Procedure or function 10.2.0.4 Error ORA-00904 [message #523243] Fri, 16 September 2011 06:17 Go to next message
wattman44
Messages: 2
Registered: September 2011
Location: FRANCE
Junior Member
I have error ORA-00904: "USERNAME" : identificateur non valide. What is the problem ?

My command impdp :
impdp datapump/password@%ORACLE_SID% DIRECTORY=datapump schemas=gcom INCLUDE=PROCEDURE remap_tablespace=gpao_indx:indx remap_tablespace=gpao_data:data DUMPFILE=%ORA_DUMPFILE% LOGFILE=Imp_%annee%%mois%%jour%%hh%%min%%sec%_%ORACLE_SID%.log

The result :
;;;
Import: Release 10.2.0.4.0 - Production on Jeudi, 15 Septembre, 2011 17:47:16

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connecté à : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Table maître "DATAPUMP"."SYS_IMPORT_SCHEMA_29" chargée/déchargée avec succès
Démarrage de "DATAPUMP"."SYS_IMPORT_SCHEMA_29" : datapump/********@gpao DIRECTORY=datapump schemas=gcom INCLUDE=PROCEDURE remap_tablespace=gpao_indx:indx remap_tablespace=gpao_data:data remap_tablespace=gpao_temp:TEMP DUMPFILE=GPAO_DATAPUMP.DUMP LOGFILE=Imp_20110915174715_gpao.log TABLE_EXISTS_ACTION=replace
Traitement du type d'objet DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Traitement du type d'objet DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit
ORA-01001: curseur non valide
ORA-06512: à "SYS.KUPW$WORKER", ligne 5241
ORA-06512: à "SYS.KUPW$WORKER", ligne 12750
ORA-01001: curseur non valide
ORA-00904: "USERNAME" : identificateur non valide
Tâche "DATAPUMP"."SYS_IMPORT_SCHEMA_29" arrêtée en raison d'une erreur grave à 17:47:35

Tkprof result :
Re: Impdp Procedure or function 10.2.0.4 Error ORA-00904 [message #523266 is a reply to message #523243] Fri, 16 September 2011 08:16 Go to previous messageGo to next message
BlackSwan
Messages: 26615
Registered: January 2009
Location: SoCal
Senior Member
>I have error ORA-00904: "USERNAME" : identificateur non valide. What is the problem ?
do not use RESERVED words as object name; like "USERNAME"

00904, 00000, "%s: invalid identifier"
// *Cause:
// *Action:

which version of impdp was used to make this file?
post complete command line from impdp that made this dump file.
Re: Impdp Procedure or function 10.2.0.4 Error ORA-00904 [message #523309 is a reply to message #523266] Fri, 16 September 2011 11:58 Go to previous message
wattman44
Messages: 2
Registered: September 2011
Location: FRANCE
Junior Member
It's impdp of Oracle 10.2.0.1 with patch 10.2.0.4

I cannot find more informations for this error. I activate trace for database but i have no more details.

Command :

impdp datapump/********@gpao DIRECTORY=datapump schemas=gcom INCLUDE=PROCEDURE remap_tablespace=gpao_indx:indx remap_tablespace=gpao_data:data remap_tablespace=gpao_temp:TEMP DUMPFILE=GPAO_DATAPUMP.DUMP LOGFILE=Imp_20110915174715_gpao.log TABLE_EXISTS_ACTION=replace

Before I used the next command for create table, data, index, trigger with a successfully creation of table, data, index and trigger, but procedure and Function wasn't create sucessfully :
impdp datapump/********@gpao DIRECTORY=datapump schemas=gcom remap_tablespace=gpao_indx:indx remap_tablespace=gpao_data:data remap_tablespace=gpao_temp:TEMP DUMPFILE=GPAO_DATAPUMP.DUMP LOGFILE=Imp_20110915174715_gpao.log

The history of the base is :
Creation of the error procedure in 2004 with oldest version of Oracle (I think 9i) with CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16. Now the version database is 10.2.0.4 with parameters : CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16;

I tested to create procedure with sqlplus and user datapump and the procedure has create sucessfully.



[Updated on: Fri, 16 September 2011 12:09]

Report message to a moderator

Previous Topic: interactive-command mode Vs logging mode
Next Topic: Importing text files
Goto Forum:
  


Current Time: Wed Nov 13 16:32:33 CST 2019