DB2 Export and Import Oracle

ETC Homework & Coursework Questions
1

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 '/cardpro/brac/v5/dev/dat/BBBBB.DEL' OF DEL select * FROM BBBBB"
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/CCCCC.DEL' OF DEL select * FROM CCCCC"
...
.. 

db2 terminate

is this enough to make the data perfect export into delimited file? there are some posted that i read, they included the table field names.

what is the different of this 2 (with table field names and without?

can anyone suggest for the import script into oracle?

Thank you very much.

2

Homework and coursework questions posted in this forum require a completely filled out template as described in the special homework rules.

Please provide a completely filled output homework template in your next post in this thread. You are not likely to receive any response to your questions until a completed template is provided.

3

Noted with thanks..

4

Continue here... http://www.unix.com/homework-and-coursework-questions/270533-db2-export-import-oracle.html\#post302989942