Oops . . . I want to change from number to varchar2. There are no
indexes or constraints dependent on the column.

Brad

********************************************

-----Original Message-----
From: Losito Bradley - Salt Lake City UT
[mailto:oracledba-ezmlmshield-x6657100.[Email address protected]
Sent: Thursday, April 24, 2008 9:25 AM
To: LazyDBA Discussion
Subject: Change column data type from varchar2 to number

What's the best way to change the column data type from varchar2 to
number? I am contemplating two options:

1) ALTER TABLE . . .

2) Create a new column, populate the new column from the old column,
and then drop the old column.

Any suggestions would be appreciated!

Brad



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page