1.

Can I Do Insert ... Select * Into A Partitioned Table?

Answer»

When you use the INSERT ... SELECT * syntax to copy data into a PARTITIONED table, the columns corresponding to the partition KEY columns must appear last in the columns returned by the SELECT *. You can create the table with the partition key columns defined last. Or, you can use the CREATE VIEW STATEMENT to create a view that reorders the columns: PUT the partition key columns last, then do the INSERT ... SELECT * from the view.

When you use the INSERT ... SELECT * syntax to copy data into a partitioned table, the columns corresponding to the partition key columns must appear last in the columns returned by the SELECT *. You can create the table with the partition key columns defined last. Or, you can use the CREATE VIEW statement to create a view that reorders the columns: put the partition key columns last, then do the INSERT ... SELECT * from the view.


Discussion

No Comment Found

Related InterviewSolutions