Creates a 5MB Tablespace with autoextend. Substitute “INDX” with the name of the tablespace you desire. The path (as shown below) should be the path leading to your database’s tablespace data files.
CREATE TABLESPACE INDX DATAFILE ‘/oracle/app/oracle/oradata/orcl/INDX01.dbf’ SIZE 5M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING DEFAULT STORAGE ( MAXEXTENTS UNLIMITED ) PERMANENT;
