I do this command:
COPY FROM xx/xx@RPNEW TO xx/xx@RP3 REPLACE GENRE_TREE_NEW USING (SELECT * FROM GENRE_TREE)
I get these messages:
Taille tableau extrait/lié est 15. (taille du tableau est 15)
Sera validé après opération. (COPYCOMMIT = 0)
Taille maximum (LONG) est 80. (longueur est 80)
ERREUR :
ORA-01458: longueur non valide dans une chaîne de caractères variable
It's in French but error 01458 is 'invalid length inside variable character string'.
GENRE_TREE looks like:
GNR_CODE NOT NULL VARCHAR2(3)
GNR_DDE NOT NULL VARCHAR2(3)
GNR_INF NOT NULL VARCHAR2(80)
GNR_MID VARCHAR2(80)
GNR_SUP VARCHAR2(80)
GNR_INF_BM NOT NULL VARCHAR2(80)
GNR_MID_BM VARCHAR2(80)
GNR_SUP_BM VARCHAR2(80)
GNI_CODE VARCHAR2(3)
and contains only 265 rows and no indexes nor partitions...
This usually worked...
Does someone knows how to correct it?
Thanks
COPY FROM xx/xx@RPNEW TO xx/xx@RP3 REPLACE GENRE_TREE_NEW USING (SELECT * FROM GENRE_TREE)
I get these messages:
Taille tableau extrait/lié est 15. (taille du tableau est 15)
Sera validé après opération. (COPYCOMMIT = 0)
Taille maximum (LONG) est 80. (longueur est 80)
ERREUR :
ORA-01458: longueur non valide dans une chaîne de caractères variable
It's in French but error 01458 is 'invalid length inside variable character string'.
GENRE_TREE looks like:
GNR_CODE NOT NULL VARCHAR2(3)
GNR_DDE NOT NULL VARCHAR2(3)
GNR_INF NOT NULL VARCHAR2(80)
GNR_MID VARCHAR2(80)
GNR_SUP VARCHAR2(80)
GNR_INF_BM NOT NULL VARCHAR2(80)
GNR_MID_BM VARCHAR2(80)
GNR_SUP_BM VARCHAR2(80)
GNI_CODE VARCHAR2(3)
and contains only 265 rows and no indexes nor partitions...
This usually worked...
Does someone knows how to correct it?
Thanks