{"id":10784,"date":"2019-07-29T05:57:12","date_gmt":"2019-07-29T05:57:12","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10784"},"modified":"2019-07-29T06:04:03","modified_gmt":"2019-07-29T06:04:03","slug":"oracle-sql-create-tablespace","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-create-tablespace\/","title":{"rendered":"Oracle SQL – Create Tablespace"},"content":{"rendered":"

Hi everyone, Today i will show you how to create tablespace on Oracle Database. I installed Oracle database with GRID , so i created ASM disk that means data files are in the ASM disk. This is important, you will get the point soon. <\/span><\/span><\/p>\n

We need to know the name of the ASM disk group in tablespace you want to add. You can list ASM groups with the following query
\n<\/span><\/span><\/p>\n

SELECT name, total_mb \/ 1024 AS total_gb, TRUNC (cold_used_mb \/ 1024) AS used_gb, ROUND (free_mb \/ 1024) AS free_gb FROM v$asm_diskgroup;<\/pre>\n
\"\"<\/p>\n
We learned about our ASM disk group<\/span><\/span>, It looks like one, but there could be more than one. In this case, we must decide which group we want to add<\/span><\/span><\/p>\n
 <\/p>\n
CREATE TABLESPACE TS_EXAMPLE DATAFILE \r\n  '+ASM' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED\r\nLOGGING\r\nONLINE\r\nEXTENT MANAGEMENT LOCAL AUTOALLOCATE\r\nBLOCKSIZE 8K\r\nSEGMENT SPACE MANAGEMENT AUTO\r\nFLASHBACK ON;\r\n<\/pre>\n
When creating tablespace we can give multiple parameters at once<\/span><\/span>. This depends on your expectations from the tablespace.
\n<\/span><\/span><\/p>\n
For example AUTOEXTEND ON NETX 100M, determines that tablespace size will increase by 100M based on occupancy. <\/span><\/span><\/p>\n
Look at this ,<\/p>\n
\"\"<\/p>\n
This is an image from oracle’s own site. You can get more information https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14200\/statements_7003.htm<\/a>
\n<\/span><\/span><\/p>\n
 <\/p>\n
You can check the tablespace you created with the following query<\/span><\/span> ,<\/p>\n
 <\/p>\n
SELECT  FILE_NAME, BLOCKS, TABLESPACE_NAME\r\n   FROM DBA_DATA_FILES;\r\n\r\n<\/pre>\n
\"\"<\/p>\n
Everything looks successful, see you in the next article<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Hi everyone, Today i will show you how to create tablespace on Oracle Database. I installed Oracle database with GRID , so i created ASM disk that means data files are in the ASM disk. This is important, you will get the point soon. We need to know the name of the ASM disk group …<\/p>\n","protected":false},"author":67,"featured_media":9920,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[4936,4929,5597,4875,5600,5609,4883,4873,4869,4910,5616,5617,5614,5603,5607,5608,5605,5604,1340,5613,5611,4870,4895,5602,5610,4905,5599,5601,4935,4926,4915,4921,4919,4920,4918,4917,3192,4872,4916,4928,4876,4912,4881,4880,4890,4867,3062,4879,4891,4923,4924,4922,4925,4909,4911,4877,4896,4908,4882,4884,4897,4901,4900,4898,4902,4903,4899,4871,3015,3018,4868,4904,4906,4893,4930,4934,4914,4933,4885,4887,4913,3000,4931,4889,4927,4907,4888,5612,5619,5618,5620,5621,4886,4892,4874,4878,4894,4932,5598,5606,5615],"class_list":["post-10784","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-case-insensetive","tag-create-view","tag-database-audit","tag-database-nedir","tag-database-schema","tag-grant","tag-insert-nedir","tag-kolay-sql","tag-mysql-sql","tag-or","tag-oracle-add-datafile","tag-oracle-add-tablespace","tag-oracle-create-tablespace","tag-oracle-dba-title","tag-oracle-grant","tag-oracle-revoke","tag-oracle-role","tag-oracle-role-creating","tag-oracle-sql","tag-oracle-tablespace","tag-oracleprivileges-usage","tag-php-sql","tag-plsql","tag-publiv-parameter","tag-revoke","tag-right-outer-join","tag-schema","tag-schema-privileges","tag-selecting-multiple-colum","tag-sql-all-drop","tag-sql-all-statements","tag-sql-alter","tag-sql-alter-colum","tag-sql-alter-database","tag-sql-alter-statement","tag-sql-alter-table","tag-sql-and","tag-sql-baslangic-dersleri","tag-sql-creat-table","tag-sql-create-view","tag-sql-database","tag-sql-date-functions","tag-sql-dcl","tag-sql-ddl","tag-sql-delete","tag-sql-dersleri","tag-sql-distinct","tag-sql-dml","tag-sql-dml-nedir","tag-sql-drop-colum","tag-sql-drop-database","tag-sql-drop-statement","tag-sql-drop-table","tag-sql-filtering-data","tag-sql-functions","tag-sql-ifadeleri","tag-sql-ile-ne-yapilir","tag-sql-in-statement","tag-sql-insert","tag-sql-insert-nasil-yapilir","tag-sql-is-ilanlari","tag-sql-join-yapisi","tag-sql-kaynaklari","tag-sql-kullanmak","tag-sql-lef-join","tag-sql-left-outer-join","tag-sql-makaleleri","tag-sql-nasil-ogrenilir","tag-sql-nedir","tag-sql-ogrenme","tag-sql-ogrenmek","tag-sql-right-join","tag-sql-right-outer-join","tag-sql-select-islemi","tag-sql-set-auto-increment","tag-sql-sorting-results","tag-sql-subqueries","tag-sql-syntaxt-rule","tag-sql-tablo-olusturma","tag-sql-tablo-yapisi","tag-sql-to_char-function","tag-sql-tutorial","tag-sql-union-statement","tag-sql-update-islemi","tag-sql-view","tag-sql-where-statement","tag-sql-yapisi","tag-tablespace","tag-tablespace-auditing","tag-tablespace-management","tag-tablespace-script","tag-tablespace-size-script","tag-tablo-nedr","tag-tablodan-veri-cekmek","tag-temel-seviye-sql","tag-temel-seviyede-sql","tag-tsql","tag-union-table","tag-user-privileges","tag-what-is-role-in-sql","tag-what-is-tablespace"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/06\/sql-express.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=10784"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10784\/revisions"}],"predecessor-version":[{"id":10788,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10784\/revisions\/10788"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/9920"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=10784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}