We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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 ...