Tablespace

How to Resolve ORA-01647: tablespace is read-only, cannot allocate space in it

by Ed Chen
February 3, 2023January 5, 2023

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-00372: file cannot be modified at this time

by Ed Chen
February 2, 2023February 4, 2023

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-01536: space quota exceeded for tablespace

by Ed Chen
November 10, 2022June 6, 2023

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-00922: missing or invalid option

by Ed Chen
November 9, 2022March 24, 2023

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-01258: unable to delete temporary file

by Ed Chen
November 8, 2022March 20, 2023

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 Oracle Rename Tablespace

by Ed Chen
October 17, 2022November 17, 2022

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 to Resolve ORA-01950: no privileges on tablespace 'USERS'

by Ed Chen
September 7, 2022June 6, 2023

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-25139: invalid option for CREATE TEMPORARY TABLESPACE

by Ed Chen
September 5, 2022February 12, 2023

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-01549: tablespace not empty, use INCLUDING CONTENTS option

by Ed Chen
September 2, 2022October 20, 2022

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-12906: cannot drop default temporary tablespace

by Ed Chen
September 1, 2022July 27, 2022

ORA-12906 Tried to drop a temporary tablespace, but it failed with ORA-12906. SQL> drop tablespace temp1 including contents and datafiles; drop tablespace temp1 including contents… Read More »

JavaScript is not enabled. Please enable it and reload the page.