Excel import [message #595845] |
Sat, 14 September 2013 10:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d61e91eac3ae05eb7c70ed7e1f46d0ff?s=64&d=mm&r=g) |
oracle_doubt
Messages: 96 Registered: December 2012 Location: CHENNAI
|
Member |
|
|
I have an Excel file (which has data imported from Oracle 11G Database) one of the fields is a Date Filed which has values like 28-JAN-11 03.25.11.000000000 PM ( Date field is Oracle Time Stamp(6) in Database )
When I am trying to Import that Excel file to another Oracle 11 G database (for another database/application), I get an error because the data field is not being recognized by Oracle 11G --> Import is being done by ORACLE SQL Developer (Table (field) has TIMESTAMP(6) as the datatype)
|
|
|
|
|
|