Monday , May 20 2024

How To Add Datafile To Tablespace On Oracle


As the Oracle database grows, the existing data files in the tablespace will fill up.

In such a case, you will need to add a new data file to the tablespace so that the database can continue to grow.

With the command below you can add a new data file to the xyz tablespace.

With this script, you will add a data file in the “+DATA” Diskgroup on ASM that will grow to 1024 MB when needed with a starting size of 100 MB.


You can read the article named “How To Create Tablespace On Oracle” about how to create Oracle Tablespace.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *