This content has been marked as final. Show 2 replies
there are some standard scripts and also some script which depents on that what you are selecting. What you can do is to start the dbca and go through the last screen. In this Screen it ask you also to save the scipts. Save it and read it, this should answer you question.
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)