How do generate scripts to re-create a schema?
You can do this using the Generate Schema Script option under DBA menu in Toad 8.6 if you have the DBA module. This option is located under Database | Export in Toad 9.0, and again is only available if you have purchased the DBA module. With this you can create the scripts for the user and the privileges and all the objects, tablespace info, etc. for your schema.
If you do not have DBA module included in your license then you will not have this option available to you. In this case you would need create the scripts manually by accessing the script of individual user and objects, etc.
Screen shots of the Generate Schema Script feature and options are attached.
