How can I retrieve defined database with all tables

[qbzh]

Hi,
I am now to this forum and I am doing a project. I want to retrieve all table definations and constraints for a database in Oracle system. So that I can insert new data into all table and satisify the constraints.

Is there simple way to get all those information into a templary file?

Please help!!

Regards,

John

[TimHall]

You can get this information using the following views:

USER_TABLES
USER_TAB_COLUMNS
USER_INDEXES
USER_INDEX_COLUMNS
USER_CONSTRAINTS

Or modify this script to get what you want:

http://www.oracle-base.com/DBA/DBASc...eate_Table.sql