Hi,

I've isolated that they're definately running different versions of the server engine, but I can't understand why the standby wouldn't have raised an issue - if it was being asked to maintain BITMAP indexes which are not enabled under SE, but are in-situ in the EE primary that the standby was supposedly built from...

I understand that the database is opened read-only everyday too, so clearly it doesn't have a problem opening with the bitmap indexes within it too.

I'm just curious what would happen if it was actually 'activated' and was thereafter requested to function and maintain these objects as a live primary.

Have to admit, I wouldn't want to be trying to use it as a DR standby right now!

Anyone know what the prospective migration path from an EE Database to SE database might be? I'm assuming that it might have to be export/import...

I can't believe that there would be much call for migration scripts to support this. SE to EE possibly... as it would be in Oracle's interest to get the revenue from the higher price-tag product, but not for a downgrade.

Any comments, thoughts, anyone?