Oracle - table

• • Reply

  14 years ago

  by advsoap

  Magnus Flisberg

  Sweden, Sweden

  Joined 15 years ago

  Best programmer,

  I have a Oracle database with a table. This table have a column (char, size 16). I have many rows in this table and my question is if I with no problem can change size to 14. All data is maximum 14 so I don't see any problem. I don't want to loose data or make it all crappy! ;-)

  What do you think?

  Report abuse
• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Hi,

  You can create a temp table and make the changes to the temp table and see is the changes affect the data.

  Example:

  CREATE TABLE temp_table AS SELECT * FROM original_table:

  INSERT INTO temp_table SELECT * FROM original_table;

  ALTER TABLE original_table MODIFY (column_name CHAR(14));

  Report abuse
• • Reply

  14 years ago

  by advsoap

  Magnus Flisberg

  Sweden, Sweden

  Joined 15 years ago

  This will probably be the solution since I can't find any other information.

  Thanks for your reply!

   

  Regards,

  Magnus Flisberg

  Report abuse