![]() This facilitates a fast "move" of data between the data segments (opposed to doing something like "lect" or "create table.as select") as the operation is DDL (the partition exchange operation is a data dictionary update without moving the actual data) and not DML (large undo/redo overhead). Common Table Expressions)Įxchange/convert a partition to a non-partitioned table and vice versa.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |