Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

COPY and ORA-01458

Status
Not open for further replies.

lecorr

Programmer
Apr 9, 2003
62
FR
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top