How to Safely Perform Data Type Conversion in an Oracle Table
Posted on 2011-03-17
We are using Oracle 11 Database and we have more than a dozen of "very large" tables. All the tables have a field (column) with Time Stamp (3) type. How can we convert these fields to DATE type in a safe way without recreating table?
Note: The truncation of the Time Stamp field (seconds fraction etc.) is not important. Year, Month, Date, Hour, Minutes are enough.