Re: Oracle partitioning

If your business requirement is centered around performance, then partitioning is a viable, and potentialy inexpensive, solution IF you have a large data set and the data set is identical in structure across all hosted customers.

(Yes, partitioning is a separate cost option, but compare the 'DBA only gets involved' to that which needs to be developed and maintained.)

If your business requirement is more around security, or the database is not horribly large but it is still identical in structure across all hosted customers, then a better solution might be to learn about Virtual Private Database (which is included in EE, and possibly SE)

Either way, if the data set starts getting large and/or you are having perforamnce issues, look at Real Application Clusters, which also happen to work nicely with partitioned tables.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***