Hi, I have to copy the table structures from one database to another. I am using below statement
CREATE TABLE ABC.party as XYZ.party WITH NO DATA ;
But the problem is all tables in database XYZ are partitioned but while copying the tables to ABC i do not want them to be partitioned. Above clause takes table defination as available in XYZ and creates. Anybody help me how to do this?
Hi, I am not sure if you can actually do this automatically. You will need to generate the SHOW TABLE results for your XYZ.Table, manually (or automatically using script) edit the Table structure to remove the Partitioning and them run the same on the ABC database.