Skip to main content

Create tablespace in Oracle

To create a tablespace in Oracle, use below query.
create tablespace <tableSpaceName> datafile '<datafileLocation>' size 50m autoextend on;

Without autoextend on option, the data file is not growing when the table/db growing big.

Comments

Popular posts from this blog