Oracle swap partition

-- ORACLE partition swap
ALTER TABLE target_table EXCHANGE PARTITION target_partition
WITH TABLE source_table;
/*
. source_table and target_table have the same structure 
	(columns, data types, respect constraints).
. indexes have to be rebuilt
*/

Similar codes

2 votes259 views3 answers
Postgres json to string
SQL
0 vote223 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote241 views1 answer
Sql statement show all emails with dome
SQL
0 vote213 views1 answer
Postgres add prefix to primary key
SQL
0 vote241 views1 answer
Kill mysqld_safe process mariadb
SQL
6 votes213 views1 answer
Oracle rank() over (partition)
SQL
1 vote233 views1 answer
How to delete a record from sqlite in android
SQL
0 vote250 views1 answer
Remove mysql from centos 7
SQL
0 vote235 views1 answer
Top frequency in sql server
SQL
2 votes236 views1 answer
Scaffold npgsql net core
SQL