Partitioning would be an extra special case wouldn't it since you'd need a partitioning license as well. You could look at DBA_FEATURE_USAGE_STATISTICS if the app has been running a while. My take is that most (like over 70%) of applications will run just fine on SE. Mostly people don't write code that uses AQ etc etc. On 6/16/07, Michael Kline <mkline1@xxxxxxxxxxx> wrote:
Has anyone come up with a set of queries that will determine if an application will run in standard edition. One query may be to determine if there really ARE any partitions or something like that. I've got a client with some rather "plain" small database, and may well work in Standard Edition, but how can I be sure? Thanks. Michael Kline Midlothian, VA 23112 O: 804.744.1545 Fax: 804.763.0114
-- Niall Litchfield Oracle DBA http://www.orawin.info