https://drive.google.com/file/d/1JvCew42AGOFfS3V602WVWP1Nx11JQxql/view?usp=share_link
SYNTAX ERROR[4856][42601]
Question
partition by cannot be used in create table as ...?
+1
+2CREATE TABLE AS SELECT allows segmentation but not partition. You can add partition later with ALTER TABLE x PARTITION BY partition-clause REORGANIZE.
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.
77 4th Avenue
Waltham, MA 02451 USA
