what is tablespace in oracle


what is tablespace in oracle

It is logical name of physical data file.

When we install oracle it creates few table spaces these are as follows

System table space is default table space in oracle.

  1. System
  2. index
  3. io
  4. usr
  5. undo

Use of Table Space

When we want to save our table data in our seprate file then we have create table space and then we have attach that table space to table name.

How to Create Table Space

>create tablespace tablespace_name datafile 'Data file path' int_size;

How to Attach Table Space With Table

>create table table_name tablespace tablespace_name;

Query

create table stud(sroll number, sname varchar2(20))tablespace my_tablespace;






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229