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
User and Schema
How to Resolve ORA-01502 Error Message
ORA-01502: index or partition of such index is in unusable state ORA-01502 means that the index that the optimizer want to use is in UNUSABLE… Read More »How to Resolve ORA-01502 Error Message
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
How Oracle Change Column Order and Position
One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »How Oracle Change Column Order and Position
How to Resolve ORA-14451: unsupported feature with temporary table
Temporary Tables Temporary tables are useful to developers who wants to stage some temporary data, but there're restrictions on them. Let's see an example. SQL>… Read More »How to Resolve ORA-14451: unsupported feature with temporary table
How to Resolve ORA-25176: storage specification not permitted for primary key
ORA-25176 When I tried to modify an attribute of an index like the following, I got ORA-25176: storage specification not permitted for primary key. SQL>… Read More »How to Resolve ORA-25176: storage specification not permitted for primary key
How to Modify VARCHAR2 to CLOB of a Column
Data Type Conversion There're several major data types built in Oracle. Character Numeric Datetime LONG RAW LOB (Large Object) In each major data types, minor… Read More »How to Modify VARCHAR2 to CLOB of a Column
How to Resolve ORA-01730: invalid number of column names specified
ORA-01730 ORA-01730 means that the number of listed columns between the target (the view) and the source (the base table) in the CREATE VIEW statement… Read More »How to Resolve ORA-01730: invalid number of column names specified
How to Create a Non-unique Primary Key in Oracle
The primary key in a table is just like the spine of a human being, which integrates all data in the table. In practice, we… Read More »How to Create a Non-unique Primary Key in Oracle