rake db:test:clone_structure error with oracle_enhanced

attempting to use SQL in SQLPlus

SQL> create table CARD_INFO (
 card_name varchar2(50),
 max_port number(9,0),
 card_type varchar2(50),
 key number(9,0),
 CONSTRAINT SYS_C0017199 UNIQUE (KEY)
)  2    3    4    5    6    7  
  8  ;

Table created.

SQL> CREATE UNIQUE INDEX sys_c0017199 ON CARD_INFO (key);
CREATE UNIQUE INDEX sys_c0017199 ON CARD_INFO (key)
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> drop table card_info;

Table dropped.

development_structure.sql

create sequence CPT_CHANNELS_SEQ

-- @@@ --

create sequence CPT_PROTECTIONS_SEQ

-- @@@ --

create sequence CPT_SPANS_SEQ

-- @@@ --

create sequence CPT_SUBCHANNELS_SEQ

-- @@@ --

create sequence REQUISITIONS_SEQ

-- @@@ --

create sequence REQUISITION_DETAILS_SEQ

-- @@@ --

create sequence REQUISITION_STATUSES_SEQ

-- @@@ --

create sequence REQUISITION_TYPES_SEQ

-- @@@ --

create sequence REVISION_RECORDS_SEQ

-- @@@ --

create sequence RING_UTILIZATIONS_SEQ

-- @@@ --

create sequence RING_UTILIZATION_VERSIONS_SEQ

-- @@@ --
                                                                                                  

gistfile3.txt

[mnyon@nyon ~/Documents/workspace/client_rails  (svn::163:/trunk) ] rake test:plugins PLUGIN=activerecord_oracle_enhanced
(in /Users/mnyon/Documents/workspace/client_rails)
DEPRECATION WARNING: Rake tasks in vendor/plugins/google_visualization_on_rails/tasks and vendor/plugins/open_flash_chart/tasks are deprecated. Use lib/tasks instead. (called from /Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/rails-2.3.8/lib/tasks/rails.rb:10)
/Users/mnyon/.rvm/rubies/ruby-1.8.6-p399/bin/ruby -I"lib:test" "/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake/rake_test_loader.rb"  
[mnyon@nyon ~/Documents/workspace/client_rails  (svn::163:/trunk) ] 

rake db:test:clone_structure output

10:27 ~/Documents/workspace/client_rails $ rake db:test:clone_structure --trace
(in /Users/mnyon/Documents/workspace/client_rails)
DEPRECATION WARNING: Rake tasks in vendor/plugins/google_visualization_on_rails/tasks and vendor/plugins/open_flash_chart/tasks are deprecated. Use lib/tasks instead. (called from /Users/mnyon/\
.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/rails-2.3.8/lib/tasks/rails.rb:10)
** Invoke db:test:clone_structure (first_time)
** Invoke db:structure:dump (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:structure:dump
** Invoke db:test:purge (first_time)
** Invoke environment
** Execute db:test:purge
** Execute db:test:clone_structure
rake aborted!
OCIError: ORA-00900: invalid SQL statement: -- @@@ --
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-2.3.8/lib/active_record/connection_adapters/abstract_adapter.rb:221:in `log'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-oracle_enhanced-adapter-1.2.4/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1591:in `log'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-oracle_enhanced-adapter-1.2.4/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:583:in `execute'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-oracle_enhanced-adapter-1.2.4/lib/active_record/connection_adapters/oracle_enhanced.rake:37
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-oracle_enhanced-adapter-1.2.4/lib/active_record/connection_adapters/oracle_enhanced.rake:35:in `each'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@rails2.3/gems/activerecord-oracle_enhanced-adapter-1.2.4/lib/active_record/connection_adapters/oracle_enhanced.rake:35
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/Users/mnyon/.rvm/gems/ruby-1.8.6-p399@global/gems/rake-0.8.7/bin/rake:31
/usr/local/bin/rake:20:in `load'
/usr/local/bin/rake:20

unique constraint problem

-- @@@ --

create table CARD_INFO (
 card_name varchar2(50),
 max_port number(9,0),
 card_type varchar2(50),
 key number(9,0),
 CONSTRAINT SYS_C0017199 UNIQUE (KEY)
)

-- @@@ --

CREATE UNIQUE INDEX sys_c0017199 ON CARD_INFO (key)