Hi, We run Spectra 1.5.3 on Win2003 with Oracle 9 databases for one of our customers. We used Access to Oracle (http://www.soft32.com/download_76142.html) to migrate the db's.
We have had this config up and running since early this year without problems. Cheers, Simon Slooten Prisma IT -----Original Message----- From: Miranda, Esther [mailto:[EMAIL PROTECTED] Sent: donderdag 3 november 2005 14:38 To: Spectra-Talk Subject: Problems porting Spectra Access db's to Oracle Hi, I'm trying to install Spectra 1.5.3 on a clean system (windows 2003 server). I want to use Oracle (9.2.0.5.0) instead of the provided access databases, and am trying to port the blank databases (allaire.zip) as described in the Spectra 1.5.3. releasenotes. I'm using the Oracle Migration Workbench to create the Oracle model, however I'm running into several errors : failed to map table : cfapplicationdb.cfapplicationdb.rs_lastcommit;oracle.mtg.migration.Migra tionSQLException: Failed to map table column:origin_qid:Failed to map table column:origin_qid The table rs_lastcommit contains the datatype 'Binary' which the Oracle Migration Tool does not seem to recognize (When checking the Data Type Mappings there's no entry for 'Binary', only 'LongBinary'). I've tried changing the access type to 'Long Binary' in the xml file, which get translated to BLOB in Oracle, but then I get other errors (ORA-02262: ORA-932 occurs while type-checking column default value expression). Changing the BLOB to LONG RAW does not help, as you can only have 1 LONG RAW type column per table (and cfaapplicationdb contains 2 binary columns) Anybody have any idea what I can try next, or have experience with running Spectra on Oracle ? Thanx in advance, Esther ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.17 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
