Partitioned Table

Alter Table Move Partition to Another Tablespace

by Ed Chen
December 10, 2021June 30, 2022

Move Partition to Another Tablespace A partitioned table is one type of table which data is divided into several segments. Segment is different from schema… Read More »

How to Resolve ORA-14511: cannot perform operation on a partitioned object

by Ed Chen
December 10, 2021November 4, 2021

ORA-14511 There could be several kinds of error patterns that throws ORA-14511, this is one case. Moving a Partitioned Table SQL> alter table sh.sales move… Read More »

Network Link May Not Work When Importing Partitioned Tables

by Ed Chen
December 21, 2016August 22, 2018

I found I can't import partitioned table via NETWORK_LINK.[oracle@test ~]$ impdp system/password tables=sh.sales content=data_only table_exists_action=truncate network_link=system_link_orclImport: Release 11.2.0.4.0 - Production on XCopyright (c) 1982, 2011,… Read More »