Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating database from scratch (CreateDB.sql etc...)

PDVBVApr 21 2023

my goal: obtain create-scripts to create database from scratch.

my attempt was: to have DBCA generate the scripts.

Problem: DBCA -silent seems to always copy from template (e.g. recover existing database)

Question1: Is there a silent (CLI-only) option in dbca that generates the -sh and -SQL files to create a database from scratch ?

Question2: is there a another way to obtain or generate a set of CreateDB*.sql scripts from the new version 23 ?

(I’ll use the db-name “FREE” to be sure)

Any help is appreciated.

Comments
Post Details
Added on Apr 21 2023
6 comments
544 views