Sql

Search

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
*/

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql sum per week
Sql :: how to get data from 2 database
Sql :: ltrim entire column sql select query
Sql :: hex string sql becomes int64
Sql :: SQL ORDER BY With Multiple Columns
Sql :: denormalise SQL command
Sql :: mysql case sensitive
Sql :: postgresql regular expression special characters
Sql :: print $dbpass
Sql :: date functions
Sql :: sqlites studio red exclamation mark when poening databse
Sql :: mysql faster delete
Sql :: site:av.ru "files"
Sql :: mysql vs sql server performance benchmark
Sql :: learn sqlite dart
Sql :: id desde sql
Sql :: MQL4 mql4 run ea on all symbols by adding to just one chart
Sql :: sql get latest of 2 datetimes
Sql :: dependent on column
Sql :: compare two tables to find unmatched records
Sql :: sql 2year
Sql :: mysql on delete set null
Sql :: how to get alternate records from a table in sql
Sql :: selecting names ending with vowels in sql
Sql :: sql server standard
Sql :: mysql stand for
Sql :: run sql script file and changes db name in this file using c#
Csharp :: c# delete file if exists
Csharp :: net core get remote ip
Csharp :: check if string is email c#

Search

SQL

oracle exchange partition

ADD CONTENT