IT Questions and Answers :)

Sunday, August 25, 2019

What do you use the CREATE TABLESPACE command for in SQL?

What do you use the CREATE TABLESPACE command for in SQL?

  • To create a database trigger
  • To add/rename data files, to change storage
  • To create a space for a table
  • Storing scheme objects, rollback segments, files 

EXPLANATION

Creating Basic Tablespaces: Examples
This statement creates a tablespace named tbs_01 with one data file:
CREATE TABLESPACE tbs_01 DATAFILE 'tbs_f2.dbf' SIZE 40M ONLINE;
It sound like you are new to Oracle databases. Oracle provides a wealth of documentation at http://docs.oracle.com/en/database. Specifically, I recommend reading their excellent introduction to the database called the Concepts Guide.

 

Share:

0 comments:

Post a Comment

Popular Posts