Converting nvarchar2 to varchar2 in a table without creating new table
We have one version of DB in nvarchar2 for all the table. We want all our table to be converted to varchar2.
Option 1:
I don't want to do export and import
Option 2:
Also dont want to create temproray table.
Since we have huge data, we dont want the above option. Is it possible to alter the table internally to convert these columns without affecting the data?