Alter Table Read Only Examples
ALTER TABLE READ ONLY If you just want NO data of the table can be modified permanently or temporarily, you may change the attribute of… Read More »Alter Table Read Only Examples
Data Manipulation Language (DML)
How to Resolve ORA-12081: update operation not allowed on table
ORA-12081 An user tried to update some data in a table (DML), but it failed with ORA-12081. SQL> update employees set first_name = 'Ed' where… Read More »How to Resolve ORA-12081: update operation not allowed on table
What is LAST_DDL_TIME?
LAST_DDL_TIME Generally speaking, LAST_DDL_TIME means the last date time of the object definition changed by Data Definition Language (DDL). But sometimes, it's been updated with… Read More »What is LAST_DDL_TIME?
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. Segment is different from schema… Read More »Alter Table Move Partition to Another Tablespace
Truncate vs Delete in Oracle
Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »Truncate vs Delete in Oracle
DB Link, How and Why
What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »DB Link, How and Why
How to Resolve ORA-00903: invalid table name
ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name
4 Types of SQL Languages in RDBMS
Types of SQL Statements SQL statements in relational database management system (RDBMS) could sometimes be too complicated to be analyzed for. As SQL developers, we… Read More »4 Types of SQL Languages in RDBMS