Hi Simon, The tool works like a charm, thanx for the tip ;-)
Esther > -----Original Message----- > From: Simon Slooten [mailto:[EMAIL PROTECTED] > Sent: donderdag 3 november 2005 15:30 > To: Spectra-Talk > Subject: RE: Problems porting Spectra Access db's to Oracle > > 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.migra > tion.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:5685 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=11502.10531.17 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
