Copy a table from one schema to another in the same database without using INSERT statement with SEL
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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.