ORA-12911: permanent tablespace cannot be temporary tablespace

After upgrading to 12.2 databases, the temporary temp tablespace of some users is set to SYSTEM due to bug number 23715518. In this case, when you try to import any schema, you receive the error as follows. This problem was fixed in version 18.1.

Solution

In order to solve the problem, it is necessary to find the users whose LOCAL_TEMP_TABLESPACE is set to SYSTEM tablespace and change the temp tablespace of these users to default temp tablespace in the database.

The following query can be used to find users whose LOCAL_TEMP_TABLESPACE is set to SYSTEM tablespace.

Change the temp tablespace of users to default temp tablespace:

Or you can create the ALTER command required for all users with the following query.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *