hello Fabio,
you wrote:
>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
The tool of choice to import data into SAP DB is
the SAP DB LOADER (formerly known as REPLICATION MANAGER).
It supports a variety of input formats, cf. the documentation.
>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"
if you really want to use the SQL Studio SQL Dialog to run
a batch of SQL statements,
you have to separate them with "//" comments :
INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('fabio', 'ffreddi', '01995383')
//
INSERT INTO UTENTIALL ( NOME, PW, TELEFONO) VALUES ('luca', 'ffreddi', '01995592')
//
commit
should work. The drawbacks of doing so are :
- several ten thousand (or so) inserts is more the text editor can easily handle.
- if an error occurs in the middle you have to answer a msgBox whether you want
to continue; it cannot be run unattendedly.
regards
Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
