{"id":2644,"date":"2012-07-10T13:35:17","date_gmt":"2012-07-10T17:35:17","guid":{"rendered":"https:\/\/pitss.org\/us\/2012\/07\/10\/create-tablespace\/"},"modified":"2017-07-28T14:39:46","modified_gmt":"2017-07-28T18:39:46","slug":"create-tablespace","status":"publish","type":"post","link":"https:\/\/pitss.org\/us\/2012\/07\/10\/create-tablespace\/","title":{"rendered":"Create Tablespace"},"content":{"rendered":"<p>Creates a 5MB Tablespace with autoextend. Substitute &#8220;INDX&#8221; with the name of the tablespace you desire. The path (as shown below) should be the path leading to your database&#8217;s tablespace data files.<\/p>\n<p>CREATE TABLESPACE INDX DATAFILE &#8216;\/oracle\/app\/oracle\/oradata\/orcl\/INDX01.dbf&#8217; SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING DEFAULT STORAGE ( MAXEXTENTS UNLIMITED ) PERMANENT;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creates a 5MB Tablespace with autoextend. Substitute &#8220;INDX&#8221; with the name of the tablespace you desire. The path (as shown below) should be the path leading to your database&#8217;s tablespace data files. CREATE TABLESPACE INDX DATAFILE &#8216;\/oracle\/app\/oracle\/oradata\/orcl\/INDX01.dbf&#8217; SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING DEFAULT STORAGE ( MAXEXTENTS UNLIMITED ) PERMANENT;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[95,4],"tags":[11,13,27],"class_list":["post-2644","post","type-post","status-publish","format-standard","hentry","category-database","category-install-config","tag-11g","tag-installation-setup","tag-oracle-database"],"_links":{"self":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/comments?post=2644"}],"version-history":[{"count":2,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2644\/revisions"}],"predecessor-version":[{"id":9233,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/posts\/2644\/revisions\/9233"}],"wp:attachment":[{"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/media?parent=2644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/categories?post=2644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pitss.org\/us\/wp-json\/wp\/v2\/tags?post=2644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}