We run Oracle's standby server called Dataguard, which does real-time replication of live production data to a remote site. Our current setup does a physical standby, but we want to set up a local logical standby, meaning the DB instance is actually mounted for us to hit with queries w/out affecting the primary production instance.

The problem is that Oracle for some reason will not allow a logical standby instance of live data if the datatype LONG is used... it only likes numbers. So you ask why do they do this? I don't know... it's Oracle, they are strange. Anyway, what's the chance you can change the following column's data type to NUMBER instead of LONG? Is it technically feasible?

Table: PROPERTYDATA
Column: PROPERTYVALUE
Current Datatype: LONG RAW

Oooohhh even more fun... I think it has to do with the customfield stuff???