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