icon Enroll in the OCI Weekend Batch – Don’t Miss the Free Session! ENROLL NOW
  • User AvatarKiran Dalvi
  • 21 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-30033: Undo Tablespace Cannot Be Specified As Default User Tablespace

Solution :

As the error suggests, we can’t set an undo tablespace as default tablespace for a user.
We can get the type of tablespace by using below query.
SQL> select tablespace_name,contents from dba_Tablespaces;

TABLESPACE_NAME CONTENTS
------------------------------ ---------
SYSAUX PERMANENT
SYSTEM PERMANENT
TEMP TEMPORARY
TEST PERMANENT
TEST_2 PERMANENT
TS_CRM_EXTCH PERMANENT
TS_GGATE PERMANENT
USERS PERMANENT
UNDOTBS1 UNDO ------ >>>>
So just use a tablespace with PERMANENT type,
SQL> alter user Testuser default tablespace TS_GGATE;
User altered.

Let's Talk

Find your desired career path with us!

Let's Talk

Find your desired career path with us!