-
How about the solution I mentioned ..It didn't work???
Raghu
-
Raghu:
Thanks! I will try that. This is what I did and worked so far…
Export the table.
Drop the table.
Recreate the table with new columns.
Import the data.
-
Yes you can do that .. But creating another table from the existing table ..Drop the original and rename the temp to orginal is sofast ..
I tried before I gave you this solution
Just insert dummy column, alias it name you want
create table test1 as select row1,' ' dummy,row2 from test;
Raghu
-
Raghu:
Thanks…Work great!
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
|