Tablespace

How to Resolve ORA-01536: space quota exceeded for tablespace

by Ed Chen
November 10, 2022October 17, 2022

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, 2022October 17, 2022

ORA-00922 Tried to grant some quota on tablespace to an user, but it failed with ORA-00922. SQL> alter user hr quota 100g on tablespace users;… Read More »

How to Resolve ORA-01258: unable to delete temporary file

by Ed Chen
November 8, 2022October 17, 2022

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

by Ed Chen
September 7, 2022November 2, 2022

ORA-01950 Tried to create a new table or insert some data into the table, but it failed with ORA-01950. CREATE TABLE SQL> create table t0… Read More »

How to Resolve ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

by Ed Chen
September 5, 2022July 27, 2022

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 »

How to Resolve ORA-12919: Can not drop the default permanent tablespace

by Ed Chen
August 31, 2022October 8, 2022

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

Drop Tablespace Examples

by Ed Chen
August 30, 2022July 27, 2022

We take the following steps to drop a tablespace. 1. Make Sure Non-Default The tablespace that we want to drop must not be the default… Read More »