I have 2 to 3 columns in one table that really should be in another table. Is there a way to move columns and data over to another table. I was thinking something like creating the a new table with all the columns I want and then doing an insert based on a select. This will be eventually changed on a production database so I need to keep the names of the tables the same. Thanks for any suggestions.
02-01-2001, 12:35 PM
You cannot move a column from one table to another table.
02-01-2001, 02:00 PM
Any suggested work around?
02-01-2001, 02:11 PM
You can create a table with select including all the columns u need. Then drop the original table. Rename the new table u have created to the old table.
02-01-2001, 02:14 PM
OK - thats what I thought just wanted to confirm. Thanks.
02-01-2001, 03:17 PM
Once you copy the data from the original table, you may just want to drop the columns (oracle 8i onwards).