Home » RDBMS Server » Server Utilities » Export than recreate table with new column and than importport
Export than recreate table with new column and than importport [message #69873] Fri, 15 March 2002 03:15 Go to next message
Peter
Messages: 62
Registered: August 2000
Member
How do I export an table, than drop/create with
an added column, and after that import the exported data to the changed table??

Report message to a moderator

Re: Export than recreate table with new column and than importport [message #69874 is a reply to message #69873] Fri, 15 March 2002 05:28 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
I am assuming you are not using "alter table add column" because you do not want the new column at the end. What you can do is create a new table with the new structure and do an "insert" command from the original. Then drop the old table and rename the new one to the original name.

You will not be able to import the data to the new table anyway the structure will not match and I believe it will error out on you.

Report message to a moderator

Previous Topic: Cron/SQL*Loader error
Next Topic: Import/Export with UTF8
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 15:03:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.