Re: Oracle and Version Control

Redrobot5050 wrote:
> Hello all,
>
> Say I have a worst case scenario in my development environment where
> our production
> server and our version control are out of sync. We know that the
> production server code
> is complete and accurate, and what needs to be in version control.
> Does anyone
> have any suggestions for automating the export of the source code,
> triggers, tables, functions, and packages
> that consist of the applicaiton I'm trying to sync up into version
> control?
>
> --Thanks in advance,
> CW

I would highly recommend, even though it is slow and somewhat painful, using DBMS_METADATA.GET_DDL.

You will find a working demo in Morgan's Library at www.psoug.org.

Use it to reverse engineer everything ... even the tablespaces.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org