version control for Oracle 10g Express

Question

I'm looking for version control for Oracle 10g.

can anyone suggest good ones (free and commercial ones) ?

Answer 1

We use Spectrum SCM to store .SQL files of each database object (no table defs or data). We have spent a ton of time on the what, where and how. Two hard lessons that we learned were:

1) Chose a tool to create and update the files(we use TOAD) and stick with it. (We used three different tools before we settled on TOAD )

2) Make the version control part of the development process (otherwise you will get out of sync)