Database Administration (MOSC)

MOSC Banner

Change data type of a column

edited Nov 9, 2010 4:31AM in Database Administration (MOSC) 10 commentsAnswered
 I found out that one of our application code is doing a weird conversion from character to a date. This statement impacted the system a lot. I know that I can't just change the data type from varchar2(30) to a date by issuing  an alter statement. My question is that if I do an import/export of the table and re-create the table with the new date datatype. Will the data I exported with the old table with the old data type be able to inserted into the new table with the new datatype? How can I change the varchar2 to

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center