Generating Schema Scripts

Ever needed to reverse-engineer a schema? In the old days when there were just tables, indexes, and views, DBAs simply had a script to reproduce their Data Description Language (DDL) from the online data dictionary. Of course, nowadays there are so many convoluted object types and interdependencies among them that you can’t use simple, home-grown scripts any more. So some DBAs will attempt to use data modeling tools like Quest Software’s QDesigner or CA’s ERwin, but these tools often don’t support the more physical aspects of DDL, such as tablespaces and partitions. So what’s the poor DBA to do? TOAD comes to the rescue with the perfect solution with the Generate Schema Script screen. Plus this screen can be run from ...

Get TOAD® Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.