| Impdp Procedure or function 10.2.0.4 Error ORA-00904 [message #523243] |
Fri, 16 September 2011 06:17  |
 |
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 #523309 is a reply to message #523266] |
Fri, 16 September 2011 11:58  |
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
