Skip to main content

Copy a table from one schema to another in the same database without using INSERT statement with SEL

  • January 16, 2014
  • 0 replies
  • 6 views

Merlin_Arockias
I have a table in one schema that is 160 GB and I would like to copy it to another schema. Is there a way other than INSERT statement with SELECT query?? The INSERT statement with SELECT query takes so long to copy. I have not found any other commands that can be used for this purpose. I believe EXPORT TO VERTICA works for the remote database. Please share with me if any of you have ideas