{"id":13961,"date":"2020-01-06T12:03:11","date_gmt":"2020-01-06T12:03:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=13961"},"modified":"2020-01-06T12:03:12","modified_gmt":"2020-01-06T12:03:12","slug":"ora-12911-permanent-tablespace-cannot-be-temporary-tablespace","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/","title":{"rendered":"ORA-12911: permanent tablespace cannot be temporary tablespace"},"content":{"rendered":"

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.<\/p>\n

ORA-39083: Object type USER:\"TEST\" failed to create with error:\nORA-12911: permanent tablespace cannot be temporary tablespace<\/pre>\n
Solution<\/h1>\n
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.<\/p>\n
The following query can be used to find users whose LOCAL_TEMP_TABLESPACE is set to SYSTEM tablespace.<\/p>\n
SQL> select username from dba_users where local_temp_tablespace='SYSTEM';<\/pre>\n
Change the temp tablespace of users to default temp tablespace:<\/strong><\/p>\n
SQL> alter user TEST LOCAL TEMPORARY TABLESPACE TEMP;<\/pre>\n
Or you can create the ALTER command required for all users with the following query.<\/p>\n
SQL> select 'alter user '||username||' LOCAL TEMPORARY TABLESPACE '||TEMPORARY_TABLESPACE||';' from dba_users where username not in ('XS$NULL') and local_temp_tablespace = 'SYSTEM';<\/pre>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
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. ORA-39083: Object type USER:”TEST” failed to create with error: ORA-12911: permanent …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":13962,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[6110,6111,6113,6114,6112,6108,6107,6109],"class_list":["post-13961","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-change-default-temp-tablespace","tag-change-local-temporary-tablespace","tag-change-local_temp_tablespace","tag-change-local_temp_tablespace-to-default-temp-tablespace","tag-local_temp_tablespace","tag-ora-12911","tag-ora-12911-permanent-tablespace-cannot-be-temporary-tablespace","tag-permanent-tablespace-cannot-be-temporary-tablespace"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":5815,"today_views":0},"yoast_head":"\nORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ORA-12911: permanent tablespace cannot be temporary tablespace\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ORA-12911: permanent tablespace cannot be temporary tablespace\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-06T12:03:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-06T12:03:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png\" \/>\n\t<meta property=\"og:image:width\" content=\"584\" \/>\n\t<meta property=\"og:image:height\" content=\"308\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"ORA-12911: permanent tablespace cannot be temporary tablespace\",\"datePublished\":\"2020-01-06T12:03:11+00:00\",\"dateModified\":\"2020-01-06T12:03:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\"},\"wordCount\":132,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png\",\"keywords\":[\"change default temp tablespace\",\"change LOCAL TEMPORARY TABLESPACE\",\"change LOCAL_TEMP_TABLESPACE\",\"change LOCAL_TEMP_TABLESPACE to default temp tablespace\",\"LOCAL_TEMP_TABLESPACE\",\"ORA-12911\",\"ORA-12911: permanent tablespace cannot be temporary tablespace\",\"permanent tablespace cannot be temporary tablespace\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\",\"name\":\"ORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png\",\"datePublished\":\"2020-01-06T12:03:11+00:00\",\"dateModified\":\"2020-01-06T12:03:12+00:00\",\"description\":\"ORA-12911: permanent tablespace cannot be temporary tablespace\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png\",\"width\":584,\"height\":308},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-12911: permanent tablespace cannot be temporary tablespace\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"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.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials","description":"ORA-12911: permanent tablespace cannot be temporary tablespace","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/","og_locale":"en_US","og_type":"article","og_title":"ORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials","og_description":"ORA-12911: permanent tablespace cannot be temporary tablespace","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-06T12:03:11+00:00","article_modified_time":"2020-01-06T12:03:12+00:00","og_image":[{"width":584,"height":308,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"ORA-12911: permanent tablespace cannot be temporary tablespace","datePublished":"2020-01-06T12:03:11+00:00","dateModified":"2020-01-06T12:03:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/"},"wordCount":132,"commentCount":1,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png","keywords":["change default temp tablespace","change LOCAL TEMPORARY TABLESPACE","change LOCAL_TEMP_TABLESPACE","change LOCAL_TEMP_TABLESPACE to default temp tablespace","LOCAL_TEMP_TABLESPACE","ORA-12911","ORA-12911: permanent tablespace cannot be temporary tablespace","permanent tablespace cannot be temporary tablespace"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/","name":"ORA-12911: permanent tablespace cannot be temporary tablespace - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png","datePublished":"2020-01-06T12:03:11+00:00","dateModified":"2020-01-06T12:03:12+00:00","description":"ORA-12911: permanent tablespace cannot be temporary tablespace","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-68.png","width":584,"height":308},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/06\/ora-12911-permanent-tablespace-cannot-be-temporary-tablespace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ORA-12911: permanent tablespace cannot be temporary tablespace"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"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.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13961"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13961\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13962"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}