Default Tablespace

How to Resolve ORA-01950: no privileges on tablespace 'USERS'

by Ed Chen
September 7, 2022February 20, 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 »

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 Tablespace Examples

by Ed Chen
August 24, 2022September 12, 2022

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

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