problems with Oracle: FK, triggers

Hi All!

Is anyone working with Oracle on Rails? What about testing? I will be very happy if you can help me:

  1. When I run rake test:unit it removes all my sequences in test enviroment. And I get an error like "OCIError: ORA-02289: sequence does

not exist" But when I run rake db:test:clone_structure I can see all sequences again. Where is a problem?

Set schema dump format to :sql in config/environment.rb.

  1. How I can take proper account of triggers? Now I just can’t run some test because this action suppose to drop a data (and I have a trigger on DELETE event).

Others are in the same boat here; not sure how they handle it.

jeremy