-
changing column lenght
Just checking!!!
I'm changing the column length of a field on 300 GIG partition table
from varchar2(12) to varchar2(20).
Does any body know if there could be any complication
due to the size of the data? Or how this might affect
the table or performance in any way?
-
AFAIK, it depends on PCTUSED and PCTFREE parameters.
Reddy,Sam
-
Not a problem, i think -- you're not going to be re-writing the whole 300Gb, as this will not change the stored data, just it's maximum length.
Bitmap indexes might need to be rebuilt on some versions.
-
Originally posted by sreddy
AFAIK, it depends on PCTUSED and PCTFREE parameters.
Does it matter if the existing records are not updated?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Hi,
There is should be no problem as long as ur increasing the column lenght.Please make sure that u, compile all the procedure.
regards
anandkl
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|