Custom Schemas Naming Convention in Oracle Applications
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
thanks for the info.
Thanks.
Suresh
http://applicationsdba.blogspot.com
suresh
March 14, 2008
Thanks for the information. I have a question – can we have multiple custom schemas? The reason why I’m asking this is, my client has implemented Oracle financials long time ago and they had created a custom schema. Now we are going for a fresh implementation of Purchasing modules. Are we supposed to use the same schema or use a new custom schema? Which option would be better?
Rakesh
March 31, 2008
I know many DBAs and developers that follow this standard, and believe this to be true. I am one of them. However – I connot find a single reference to this outside of the AOL Developers Guide where it “recommends” the XX naming convention for custom application short names. In other words – no reference to how to name the schema or database objects. Is anyone aware of other published references available?
Mike
October 22, 2008
To update:
I have found further references in the following Release 11i guides;
1) Upgrading Oracle Applications
2) System Administrator’s Guide – Security
3) System Administrator’s Guide – Configuration.
One could easily argue that by setting a standard for the Application short name, the majority of naming conventions for database objects etc. would flow naturally and logically from this beginning.
However, I am still searching for more concrete statements from Oracle, or widely accepted white papers on the subject.
Anyone?
Mike
October 23, 2008
Thanks a lot for your continuous research and comments, Mike. Appreciate it.
cheers,
OraclePitStop.
oraclepitstop
October 23, 2008
Hi Mike,
Heres something which i came across
Metalink Note: 471303.1 (The note deals with linking discoverer with R12, but it does have a comment regarding XX).
cheers,
Ram.
oraclepitstop
October 29, 2008