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

0 vote171 views3 answers
Between keyword sql
SQL
0 vote190 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote194 views2 answers
Soql last year
SQL
0 vote192 views1 answer
Connect laravel to mysql on mac
SQL
2 votes114 views1 answer
Sql view column data type
SQL
1 vote165 views1 answer
Get table which have specific columns in mysql
SQL
10 votes165 views4 answers
How to alter table name in mysql
SQL
0 vote157 views2 answers
Android sqlite tutorial for beginners
SQL
2 votes182 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote180 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL