Posts Tagged ‘database conversion’
Table Conversion from Oracle to DB2
Posted by: Chyne on: August 5, 2008
- In: DB2| Oracle
- Leave a Comment
Oracle
Connect the Oracle database through Toad (Download from: http://www.toadsoft.com/, Toad for Oracle)
Save the result (data retrieval) based from the SQL statement in Fixed Field Spacing (Untick column headers, Tick ‘Include NULL text’)
• Save the result with the filename: testing.txt
DB2
Create a database
• Create a table
• Create the fields with the same attributes as the table in Oracle
Right click the [...]
Search
- The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program
- The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
- Installation of Bugzilla in Ubuntu Environment
- Installation of Subversion 1.6.5 on Ubuntu 8.10
- java.io.FileNotFoundException with (Permission Denied)
- Cannot convert value '0000-00-00 00:00:00' from column XX to TIMESTAMP
- error while loading shared libraries: libstdc++-libc6.2-2.so.3 on JAD in Ubuntu
- How to Install Mantis in Ubuntu?
- Tomcat Startup Error: Error in dependencyCheck
- Too many open files
- system_forex_: I like this website very much. This is such a outstanding web. And it is not like other money oriented website, the message here is genuinely impo
- Faruk: its very very very fine solution perfect
- blackhawk: Nice tip -- thanks for sharing
RSS - Posts