Sql

Search

oracle exchange subpartition

-- ORACLE subpartition swap
ALTER TABLE target_table
EXCHANGE SUBPARTITION target_subpartition
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 :: Oracle Procedure ex2
Sql :: ring MySQL commit updates to the database
Sql :: apex run 404
Sql :: restore backupfile discourse
Sql :: mariadb errno 121
Sql :: drop all tables db2
Sql :: SQL Syntax of RIGHT JOIN
Sql :: swiftui onappear only once
Sql :: tipos da linguagem SQL
Sql :: ORACLE multiset union distinct
Sql :: sql truncate table referencing itself
Sql :: use mysql 8 without password
Sql :: PDOException: SQLSTATE[HY093]: Invalid parameter numb
Sql :: sqldf change user
Sql :: sql data type of query
Sql :: compare subqueries oracle
Sql :: value of sold product using having and group by in sql
Sql :: sqlalchemy where in query
Sql :: mysql conf.d exampel
Sql :: postgresql < ALL very slow
Sql :: SQL IN Operator With Duplicate Values
Sql :: pgsql commit rollback example
Sql :: sql examples from your work
Sql :: get enginge db mysql
Sql :: why we have to set the password for my sql server
Sql :: Join base on multiple or conditions
Sql :: añadir clave foranea mysql
Sql :: How to do a cumulative count using Raw SQl / Laravel - Eloquent ORM
Sql :: #configuration database using PostgreSQL in ubuntu
Sql :: How to return only the Date from a SQL Server DateTime datatype

Search

SQL

oracle exchange subpartition

ADD CONTENT