Re: Reverse engineer DB or User

Bobby Abraham wrote:
>
> I find myself repeatedly wanting SQL code which will examine
> table/view/index descriptions and produce the SQL code required to
> construct them. This would made sizing and recreating users and DBs
> much easier than working with export files as they can be edited
> directly.
>
> I know tools exist to do this but I want something quick, small and
> portable (ie SQL scripts).

  It is not difficult provided that the script executor has the DBA rights or SELECT ANY TABLE privilege to query the DBA_xxx views or dynamic performance tables. Alternatively, you can use Designer/2000 to carry out reengineering.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841