Hi Fabio, Well I had the same import problem sometime back (ORACLE to SAPDB) This is the solution I used:
1 export each ORACLE table to a separate file using toad. This generates a file with an insert statement with ; for each row. 2 Parse the insert statements in each file to replace ; with newline+// (Don't even try to do this using a text editor for a large file. I tried a 200 MB file and it was still doing this 2 hours later on a P4 1.6. Bad text editor or maybe just windows? Ultimately I used the stream editor (Sed) under cygwin on windows to replace ; with newline //. 2 mins for the same file;-) 3 Use repmcli to run the file(s) and add data to SAPDB i.e repmcli -d dbname -u username,pwd -b filename This mechanism works ok except : a. Also takes a long time (40+ mins for 200 MB file) to run each file with repmcli. b. Since each table is being exported individually the order in which I import them into SAP DB becomes crucial due to referential integrity constraints. Alternately It's possible to export comma separated values from ORACLE,Remove any junk text in the file and use repman to import the data.I have'nt tried this but I believe its possible. Regards, Ajit _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
