SQL Statement Hang? Why?
SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »SQL Statement Hang? Why?
Tablespace
How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it
ORA-01647 Tried to move a table to another tablespace, but it failed with ORA-01647. SQL> alter table employees move tablespace example; alter table employees move… Read More »How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it
How to Resolve ORA-00372: file cannot be modified at this time
ORA-00372 Tried to update a table, but it failed with ORA-00372 and ORA-01110. SQL> show user USER is "HR" SQL> update employees set first_name =… Read More »How to Resolve ORA-00372: file cannot be modified at this time
How to Resolve ORA-01536: space quota exceeded for tablespace
ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »How to Resolve ORA-01536: space quota exceeded for tablespace
How to Resolve ORA-00922: missing or invalid option
ORA-00922 ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects. Since it's a… Read More »How to Resolve ORA-00922: missing or invalid option
How to Resolve ORA-01258: unable to delete temporary file
ORA-01258 We successfully dropped a temporary tablespace with its all files, but we saw some errors like ORA-01258 in the alert log. SQL> drop tablespace… Read More »How to Resolve ORA-01258: unable to delete temporary file
How Oracle Rename Tablespace
Alter Tablespace Rename To rename a tablespace, we can issue command ALTER TABLESPACE RENAME TO like this. SQL> alter tablespace erp_tsb rename to erp_tbs; Tablespace… Read More »How Oracle Rename Tablespace
How to Resolve ORA-01950: no privileges on tablespace 'USERS'
ORA-01950 In this post, we introduce some error patterns of ORA-01950 as below: CREATE TABLE INSERT INTO ALTER TABLE CREATE TABLE Tried to create a… Read More »How to Resolve ORA-01950: no privileges on tablespace 'USERS'
How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
ORA-25139 Tried to create a temporary tablespace, but it failed with ORA-25139. SQL> create temporary tablespace temp1 datafile '/u01/app/oracle/oradata/ORCL/temp1_01.dbf' size 10m autoextend on next 10m… Read More »How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
How to Resolve ORA-01549: tablespace not empty, use INCLUDING CONTENTS option
ORA-01549 Tried to drop a tablespace in the simplest way, but it failed with ORA-01549. SQL> drop tablespace erptbs; drop tablespace erptbs * ERROR at… Read More »How to Resolve ORA-01549: tablespace not empty, use INCLUDING CONTENTS option