DB2 Export and Import Oracle

 
Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions DB2 Export and Import Oracle
# 8  
Old 01-25-2017
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

Last edited by rbatte1; 01-25-2017 at 06:45 AM.. Reason: Added CODE tags for output and corrected spellings/case/etc.
# 9  
Old 01-25-2017
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
This User Gave Thanks to rbatte1 For This Post:
# 10  
Old 01-25-2017
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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Array - Export/Import in global environment variables.

Hello. During startup /etc/bash.bashrc.local generates some array ..... source /.../.../system_common_general_array_env_var ..... The file system_common_general_array_env_var contains : LEAP_VERSION='42.3' ARRAY_MAIN_REPO_LEAP=('zypper_local' 'openSUSE-Leap-'"$LEAP_VERSION"'-Non-Oss' ... (2 Replies)
Discussion started by: jcdole
2 Replies

2. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

3. Homework & Coursework Questions

DB2 Export and Import Oracle

Hi Guys, I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle. db2 connect to Tablename user id using psswrd db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA" db2 "EXPORT TO... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

4. Solaris

Zpool import/export error

A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Discussion started by: beantownmp
2 Replies

5. UNIX for Dummies Questions & Answers

Import and export PGP/GnuPG keys

Hi, I need to export an existing PGP key and import it into GnuPG on a different machine. This is how I did the export: pgp -kx myuser _myuser_public pgp -kx myuser _myuser_private secring.skr (this is from the pgp installation directory that contains secring.skr). This produced two... (0 Replies)
Discussion started by: imchi
0 Replies

6. Shell Programming and Scripting

export / import

I have a calling script which consists of calls to other scripts via the sh command. ie vi callscript.sh sh smallscript1.sh extra unix commands sh smallscript2.sh exit In smallscript1, I prompt for a filename, which I handle via :- read f1 export f1 I then need... (5 Replies)
Discussion started by: malts18
5 Replies

7. Shell Programming and Scripting

Error: SQL3100W while export in DB2

Problem has been resolved (7 Replies)
Discussion started by: ustechie
7 Replies

8. Shell Programming and Scripting

manipulate text for openldap import/export question.

Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
Discussion started by: i2ambler
0 Replies

9. Solaris

Export/import ZFS ACL's

I've been wondering about this one, is there any way to do the following with ZFS ACL's (i.e. "copy" the ACL over to another file)? getfacl /bla/dir1 | setfacl -f - /bla/dir2 I know about inheritence on dirs, it doesn't work in this scenario I'm working on. Just looking to copy the ACL's. ... (3 Replies)
Discussion started by: vimes
3 Replies

10. Filesystems, Disks and Memory

Local NFS import / re-export using automount?

Hi, Can I do the following: On SunOS 5.8 /etc/vfstab: remote-host:/Volumes/webdata - /export/home/webdata nfs - yes rw,vers=3,soft,intr,bg,timeo=600 In /etc/auto_direct: /home/science $HOST:/export/home/webdata/science /home/science-edu ... (2 Replies)
Discussion started by: bloyall
2 Replies
Login or Register to Ask a Question