DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: decrease column size

  1. #11
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Originally posted by elaine3839:
    However, the import failed because it tried to recreate the table while the table's definition is already there.How can I only import data but not schema when I use Oracle's Import utility?
    Try Import with table=tablename, rows=Y and ignore=y






  2. #12
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by elaine3839


    2. How can I only import data but not schema when I use Oracle's Import utility?

    Thanks!
    imp user/passwd@servicename IGNORE=Y

    http://www.oradoc.com/ora816/server....ch02.htm#25141

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #13
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    while doing the import if you have a precreated object in the database then set the parameter in the import IGNORE=Y
    which means that if the object is already in existance you need not to pop up the object existance message and terminate the import process.
    sonofsita
    http://www.ordba.net

  4. #14
    Join Date
    Mar 2013
    Posts
    1
    You can easily reduce the size of a column in oracle without affecting the data in the modifying column.

    SQL> alter table column

    example:

    SQL> alter table employee column emp_name varchar2(12);

    If your data size in the modfying column is greater than your reduced new size then it won't change rather it will display an error message "cannot decrease column length because some value is too big".
    Last edited by ArjunRaghu; 03-07-2013 at 02:29 PM.

  5. #15
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Not only is your advice not helpful, it is also 12 years too late. If you want to post, look for something that has been updated within this decade...
    Also as the original poster mentioned, the column set to 12 bytes, so sizing it to what it is won't change anything.

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