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

13 votes299 views5 answers
Oracle list tables
SQL
3 votes308 views2 answers
Having in mysql
SQL
5 votes335 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
50 votes402 views6 answers
Install mysql on ubuntu
SQL
0 vote317 views1 answer
Mysql wsrep ls
SQL
-1 vote271 views1 answer
How to create script to connect to oracle database and run query
SQL
-1 vote356 views1 answer
Mysql faster insert
SQL
0 vote330 views1 answer
Oracle temporary table
SQL
3 votes332 views1 answer
Sql is not like
SQL
7 votes325 views6 answers
Reset identity column in sql server
SQL