Swap and drop in Oracle Database
I want to alter the data type for one column in a big table w/ billions of rows and using range partition. I don't want to lock the table, so I suppose I can only create a new table w/ the new data type for that column and copy the data over and drop the old table. Is this a correct assumption? Also if I want to copy a range partitioned table, what would be the most efficient way to do this? Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@sdstuber Can you give me more information? Is this package an external package I need to install? How can I actually use this package? Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks sdstuber. I just want to change the data type for one column from varchar2(2000) to nvarchar2(2000).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will test this out tomorrow and let you know if I encounter any issue. I will leave this ticket open for now. Thanks sdstuber.
ASKER
Thanks.
ASKER