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

Merlin_ArockiasMerlin_Arockias
in General Discussion
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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...