SQL Developer Create Table Partition
Since the syntax to create a table partitioning is really hard to keep in mind, we'd better use GUI tools to facilitate us to create.… Read More »SQL Developer Create Table Partition
Partitioned Table
Alter Table Move Partition to Another Tablespace
Move Partition to Another Tablespace A partitioned table is one type of table which data is divided into several segments, where "segment" is essentially different… Read More »Alter Table Move Partition to Another Tablespace
How to Resolve ORA-14511: cannot perform operation on a partitioned object
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 »How to Resolve ORA-14511: cannot perform operation on a partitioned object
Network Link May Not Work When Importing Partitioned Tables
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 »Network Link May Not Work When Importing Partitioned Tables