DBCA Deletes All Files Specified In Template If the Database Creation Has Failed
Last updated on DECEMBER 28, 2016
Applies to:Oracle Database Configuration Assistant - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-DEC-2016***
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:
- the error message : Incorrect variables format. Use <variable_name> format to define variables
- 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms