My Oracle Support Banner

DBCA Deletes All Files Specified In Template If the Database Creation Has Failed (Doc ID 1506166.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database Configuration Assistant - Version to [Release 11.2]
Information in this document applies to any platform.


When creating the database creation scripts using the DBCA in silent mode from a template, if the path for a single datafile does not physically exist, the following error will be logged :



If the DBCA template is referencing a certain datafile and this datafile does not currently exist in the ORACLE_HOME where DBCA is running from, then the following actions will occur:

  1. the error message : Incorrect variables format. Use <variable_name> format to define variables

  2. DBCA will delete all datafiles specified in the template

This can occur if you first create a template from an existing database, then the physical structure of the database is changed by dropping a datafile or tablespace, and then you try to create the database creation scripts from this template.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.