DBMS_METADATA.GET_DDL Table
Get Table DDL To retrieve the definition (Data Definition Language, DDL) of a table, we use the function DBMS_METADATA.GET_DDL to make it. Let's see an… Read More »DBMS_METADATA.GET_DDL Table
Table
LAST_DDL_TIME, How and Why
LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »LAST_DDL_TIME, How and Why
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
Alter Table Move to Another Tablespace
Move Table to Another Tablespace Basically, moving an Oracle table can defragment the data and make it compact so as to gain some benefit when… Read More »Alter Table Move to Another Tablespace
How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE
ORA-14808 Saw error ORA-14808 when we tried to move a Large Object (LOB) column to another tablespace online. SQL> alter table PM.PRINT_MEDIA move online lob(AD_PHOTO)… Read More »How to Resolve ORA-14808: table does not support ONLINE MOVE TABLE
Alter Table Move LOB to Another Tablespace
Move LOB Segment Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to… Read More »Alter Table Move LOB to Another Tablespace
How to Check Oracle Table Creation Date
We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »How to Check Oracle Table Creation Date
How to Resolve ORA-01439: column to be modified must be empty to change datatype
ORA-01439 ORA-01439 means that the data type of a column you want to change is not empty, you have to make it empty first, then… Read More »How to Resolve ORA-01439: column to be modified must be empty to change datatype
How to Resolve ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster
ORA-25188 There're some restrictions on using index-organized tables (IOT). This is one case of them. SQL> alter table ERPAPP.PAY_EXT_P drop constraint XM500P0; alter table ERPAPP.PAY_EXT_P… Read More »How to Resolve ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster