Generate DDL from a Schema

Hi,

   I am trying to generate DDL scripts for each table, view and other indexes under a schema. I tested using DBMS_METADATA package and its get_ddl procedure. However, I can only output the create table (view, indexes) statements for all the tables in a schema in one script, not in each separation script, such as create table table_1.script, create table table_2.script, etc.
I have hundreds of tables, views, indexes, types and other objects under one schema. I would appreciate your advice on the issue.

   Thanks in advance.

    Nick Li Received on Fri Sep 21 2007 - 00:45:40 CDT