Answers for "oracle exchange subpartition"

SQL
0

oracle exchange subpartition

-- ORACLE subpartition swap
ALTER TABLE target_table
EXCHANGE SUBPARTITION target_subpartition
WITH TABLE source_table;
/*
. source_table and target_table have the same structure 
	(columns, data types, respect constraints).
. indexes have to be rebuilt
*/
Posted by: Guest on April-21-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language