import data from Oracle

[ing. fabio freddi]

To transfer data between different vertions of Oracle i normally use  Toad program.   Data are exported in sql format type   INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('fabio', 'ffreddi', '01995383'); INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('luca', 'ffreddi', '01995592'); commit;   To import data in Oracle database from sql file i use sqlplus program with command @path:\file.sql   With sql studio i can inport only one row each time.   If i execute   INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('fabio', 'ffreddi', '01995383') INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('luca', 'ffreddi', '01995592') commit   i recive this type of message "native error -5015 pos(85) missing keyword:update,reject,ignore"   Does exist a program that work with Sap DB as sqlplus with ORACLE  ???. If it exist is this a correct sintax ???   INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('fabio', 'ffreddi', '01995383'); INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('luca', 'ffreddi', '01995592'); commit;   tanks Fabio