Homework & Coursework Questions

Thank you everyone for the advice and guidance you shared to me. it gives a lot of ideas to me on how build my script.

Actually, the script ran too long maybe because I didn't command commit after I delete data in table before I run the import script. After I command commit then I run the script and it very fast to complete. Linux

But I cannot confirm also if that was the caused that the script ran too long.

---------- Post updated at 06:01 PM ---------- Previous update was at 05:40 PM ----------

I have encounter another problem hopefully can advice me on the issue.

I successful export data from oracle but I put into TABLE.DEL file.

Code:

exp user/pwd@table file=TABLE.DEL log=xxxxxx.log tables=CP_TABLE rows=yes indexes=no

then I used TABLE.DEL to import into db2.
Not all data was successful import into db2, the other data was rejected.

Code:

db2 "import from '/home/user/TABLE.DEL' of del insert into CP_TABLE"

results below:

Code:

Number of rows read         = 41
Number of rows skipped      = 0
Number of rows inserted     = 16
Number of rows updated      = 0
Number of rows rejected     = 25
Number of rows committed    = 41

Is the issue was during the export? Because supposedly during export should be the file .dmp and I change into .DEL?

Please advice me..

Thanks

The file name you choose should not make any difference to your export or import commands. They are pretty much just a label to find the data. There is no inference on the 'bit after the dot' like with Windows or other GUI does, but there is nothing really to it. If you go to DOS under Windows, they just become files. Perhaps a .bat or .exe is still special, but that's about it.

Would they have been rejected because they had a duplicate constraint? It's difficult to know without seeing the data exported, the data in the target table and the constraints (unique indices, foreign keys etc.)

Can you elaborate?



Robin

Hi rbatte1,

Thanks for your reply.

Actually, the table that I'm tried to import the data is empty. you can check also the attached text file for the error messages I found during import. most of the error are because of truncated.

so you mean, there is no problem in my export data from oracle which was changed into *.del instead of using default *.dmp.

is my import script is correct? or there something wrong/ missing that why it was truncated?

Please advice. Thanks