Discover Top Posts Tagged with #create tablespace

How to create tablespace in Oracle

In Oracle, a tablespace is a logical storage container that can hold one or more database objects, such as tables, indexes, and other schema objects. The following is an example of a Data Definition Language (DDL) create tablespace in Oracle. Statement to create tablespace in Oracle CREATE TABLESPACE test_ts DATAFILE '/u01/app/oracle/oradata/test_ts01.dbf' SIZE 100M AUTOEXTEND ON NEXT…