Archive for March, 2008

Custom Schemas Naming Convention in Oracle Applications

Posted on March 13, 2008. Filed under: Custom | Tags: Custom, schema, XX |

Have you ever wondered why custom schema names always start with ‘XX<some_name>’. Before getting into the detail lets see what happens if the custom schema name doesnt start with ‘XX’.

Impact: If you dont have a custom schema name starting with ‘XX’, be assured that this schema will be no longer available in your instance when you perform an UPGRADE. During upgrade Oracle apps will wipe out all unregistered schemas which doesnt start with ‘XX’.

Oracle had assured its customers that it will not touch any schemas that starts with ‘XX’. This is the reason why you find custom schema names with ‘XX’ prefixed.

cheers,
OraclePitStop