This content has been marked as final. Show 2 replies
You can see scripts generated by DBCA as below
On step 2 of DBCA, select the database template as 'Custom Database'.
On the last step DBCA will ask whether you want to create the database or just generate the scripts.
Choosing 'General Purpose' or any other template on step 2 will not give the option of creating just the scripts.
How to generate Sample Database Creation Scripts using 10G DBCA (Doc ID 272397.1)