Oracle exchange 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

1 vote214 views1 answer
Sql run multiple updates in one query
SQL
1 vote216 views1 answer
Oracle datafile max size 32gb
SQL
19 votes226 views6 answers
Mysql if null
SQL
17 votes242 views3 answers
Postgresql list users
SQL
0 vote226 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote206 views1 answer
Renommer schema sql
SQL
0 vote210 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote215 views1 answer
Find most frequent value in SQL column
SQL
0 vote223 views1 answer
Dbms_output sql developer
SQL
2 votes226 views1 answer
Oracle convert run_duration to number
SQL