Re: How do you guys maintain DDL versions?

Mischa Sandberg wrote: > > Once that DDL is in text form, any version control system gives you > what you need. Sybase is particularly nice in this regard: all the > text of non-table objects (procedures, views, rules, defaults, > triggers) is readily available, and is guaranteed to be current. Not a problem in Oracle; all the above is stored in system tables, and almost all of it's in straight text or numeric columns. > The best repository for definitions is not in a repository --- it's > should be the database itself. Anyone remember Dick Pick's philosophy > in this regard? That's what makes Pick/Revelation developers so loyal; > you can walk in on *any* running system, and the system itself is its > own dictionary, easily queried and manipulated *like data*. There's an even better source than Pick, arguably: one of Codd's RDBMS rules is that the data dictionary should be manipulable with the same language that you use to manipulate data - and _only_ that language. Again, not an issue with Oracle. -- Phil Edwards phil@news400.com Editor, NEWS/400.UK Oracle User In Previous Life