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.
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
Post a Comment