Ed Chen Logic

How to Resolve ORA-01940: cannot drop a user that is currently connected

by Ed Chen
September 9, 2022July 27, 2022

ORA-01940 Tried to drop an user with all its contents cascadingly, but it failed with ORA-01940. SQL> drop user hr cascade; drop user hr cascade… Read More »

How to Resolve ORA-01950: no privileges on tablespace

by Ed Chen
September 7, 2022September 25, 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, 2022July 27, 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, 2022July 27, 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 »

Alter User Default Temporary Tablespace Examples

by Ed Chen
August 29, 2022September 12, 2022

Default Temporary Tablespace Normally, all users in the database use the same default temporary tablespace except that we specifically set another one for them. In… Read More »

Alter User Default Tablespace Examples

by Ed Chen
August 26, 2022September 12, 2022

Default Tablespace The default tablespace in the database for all users is USERS if you didn't specify the default one for the user. This can… Read More »

Alter Database Default Temporary Tablespace Examples

by Ed Chen
August 25, 2022September 12, 2022

To globally change the default temporary tablespace of a database, we take the following steps: Check Current Default Temporary Tablespace Make Sure the Target Tablespace… Read More »