Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
*/
Comment
PREVIOUS NEXT
Code Example
Sql :: drop unique 
Sql :: sql full outer join 
Sql :: Kill session in SQL Developer 
Sql :: how to save postgresql query 
Sql :: sqlite get columns for table 
Sql :: delete sql 
Sql :: alter table add multiple columns mysql 
Sql :: sql developer connect to sql server 
Sql :: trigger in mysql 
Sql :: tables in sql 
Sql :: data types mysql vs postgresql 
Sql :: how to print some string in mysql 
Sql :: creating database with - 
Sql :: install mssql on ubuntu 
Sql :: search from comma separated values in sql server 
Sql :: xampp mysql problem detected port 3306 in use by 
Sql :: sql is not null 
Sql :: .sql File Run in PSQL 
Sql :: quit mysql 
Sql :: mysql split explode 
Sql :: mysql update one table from another table multiple columns 
Sql :: sql to linq converter 
Sql :: SQL AS With More Than One Column 
Sql :: use mysql in java program 
Sql :: order child below the parent in mysqli 
Sql :: postgresql interview questions 
Sql :: sql trigger difference between for and after 
Sql :: select * from mysql.proc 
Sql :: ring MySQL create new table and insert records 
Sql :: connect colab with Microsoft sql server 
ADD CONTENT
Topic
Content
Source link
Name
9+4 =