How to fix the Oracle error ORA-12950: SYSTEM tablespace specified as default permanent tablespace?

In this post, you’ll learn more about the Oracle ErrorORA-12950: SYSTEM tablespace specified as default permanent tablespace with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

Reason for the Error ORA-12950: SYSTEM tablespace specified as default permanent tablespace

SYSTEM tablespace was specified as the default permanent during database creation.

How to fix the Error ORA-12950: SYSTEM tablespace specified as default permanent tablespace ?

You can fix this error in Oracle by following the below steps

If default permanent tablespace is not specified,then SYSTEM will implicitly become the default permanent tablespace. Specify an alternate tablespace or omit the default tablespace clause and reissue the CREATE DATABASE statement