Topic: Testing without a test database?
I'm working on a very large, very complex legacy database (Oracle, > 4GB of text data in 1000s of tables). For this situation, dropping tables and populating them from fixtures just isn't feasible: I can't load 500MB of data every time I want to test my app. I also can't muck with the dev database, since it is used by other developers for other projects, and only gets cloned from the production DB once every few months. Is there a way to short circuit the typical testing methods to have them open a transaction, load test-specific fixtures, run the tests and then close the transaction without dropping the tables first?