changing column lenght
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: changing column lenght

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Question 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?

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    AFAIK, it depends on PCTUSED and PCTFREE parameters.
    Reddy,Sam

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
  •  


Click Here to Expand Forum to Full Width