Loading Spread Sheet Data into Oracle 10G XE - Continuing to Load
(Page 4 of 4 )
If you were to start afresh and come to the stage where you can make changes to the data you will see this screen. Here for the two columns with the data type date, you can pull down on the drop-down and change them to type Date.
If you now continue to load you will end up with 9 failures and 0 successes as shown in the next picture. The reason for this is that the date format mm/dd/yy is not acceptable to Oracle 10G XE.
Now if you click on the hyperlink in the Failed column in the next table pertaining to this load, TestNW2, you will see the following screen displayed. This shows why the failure occurred (Ora 01843: not a valid month).
Now if you make the following changes while loading you will see that the loading was a success for this loading, TestNW4.
You may click on the table name TestNW4 and verify that the data type for the two columns with the date data type came out okay.
Summary
Loading an MS Excel file into Oracle 10G XE was a very simple exercise. It required no more than cutting and pasting the data. The interface is simple, intuitive and the loading process is well staged. It would have been helpful if some interactive help were available for data formatting. The reporting of loading success and failure is immediately available without opening another file, making the process very simple and effortless. Oracle 10G XE is really a one-stop solution for data management and application development that would appeal to many.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 24 
