Hi,
After porting my schema from ORACLE to SAPDB(wasn't as simple as I thought. if
anybody knows what causes a -9111 Move error while deleting a row from a table pls.
mail me) ,I am now looking to port my data from ORACLE to SAPDB.
My current data porting mechanism involves
1 export each ORACLE table to a separate file using toad. (a free oracle client)
This generates a file with an insert statement for each row.
2 Parse the insert statements in each file to replace ; with //
3 Use repmcli to run the file(s) and add data to SAPDB
This mechanism works ok except :
a. Takes a long time(20+ mins) to parse the files and replace ; with // as some files
contain upto 0.3 million records. Also takes a still longer time(40+ mins) 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.
Can someone who has migrated data between ORACLE and SAPDB suggest a better
method?(Preferably using free tools)
Is there a way to insert large number of records into tables without using a huge
number of insert statements in SAPDB?
Regards,
Ajit
P.S: More info about the -9111 error:
I insert a row into a table and I get the -9111 error on deleting the row immediately
afterwards.
The -9111 move error seems to be caused by my schema. (which works fine in oracle).
It seems to be caused by some hangup with referential integrity between multiple
tables and unique columns.
I made a few more columns unique and used a composite PK to solve the problem. However
I am still trying to isolate the problem and generate a simple test schema and bug
report. I will mail that when I'm done.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
