With dbca you can fasten the procedure of creating databases in your company. You can also run this in silent mode and create exactly the database you want, with your redo/undo size, with your parameters settings. You create the template once, and use it many times. Fast and easy 😀
I have one database which I created with SQL*PLUS called LSC01.
1) Create template lsc-template
–> Manage Templates
–> Create a database template
–> from an existing database (structure as well as data)
–> convert the file locations to use OFA structure
This takes some place on disk and will speed up database creation. Technically speaking, it is doing a compressed backup with RMAN that will be restore, and restore is way faster than create database
2) Create database LSC99 in silent mode or progressOnly mode.
dbca -silent -createDatabase -templateName lsc-template.dbc -gdbName LSC99.lcsys.ch
It took me only two minutes to create my database on my notebook !
Try it ! Of course I expect comments on this post