We use SmarTeam. It is not necessarily enterprise wide and can be purchased in modular form to some extent. Until recently I would not have recommended it. It was not intuitive to use by any stretch of the imagination. Also it was way out of synch with SolidWorks revisions - and still is to some extent. (We only just loaded SW 2003!). Of course this comment applies to any 3rd party code that you rely on for you operations. However things have improved greatly and the fact that SmarTeam is now part of Dassault Systems along with CATIA and SolidWork is really helping.
It is certainly a very capable product. If you need to know more specifics email me and I will give you the phone number of our guru.
I would say that you should definintely go to the Oracle version.
Generally (and SmarTeam is no exception) unless you are going with a very basic system, PDM/EDM systems are very costly and time consuming to implement. Many large companies are backing off and rethinking their strategy, as it can be a very painfull experience (no, it IS a very painfull experience). You do not realize what you are getting into until you try it. My advice is to determine exactly what you need to achieve and how much control you need - bearing in mind future growth. Only buy as much as you need - no more!!!!!! And I don't care WHAT anyone claims, THERE IS NO SUCH THING AS "OUT OF THE BOX" PDM OR EDM software. You should budget 5 to 10 times the time and resources than you think to implementation and twice what you think to sustaining.
Having said all that - SmarTeam really has been worth it and we could not do what we do today anywhere near as efficiently (and in some cases not at all) without it.