Custom Schemas Naming Convention in Oracle Applications

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


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

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

6 Responses to “Custom Schemas Naming Convention in Oracle Applications”

RSS Feed for OraclePitStop – Lets share some knowledge Comments RSS Feed

thanks for the info.

Thanks.
Suresh
http://applicationsdba.blogspot.com

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?

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?

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?

Thanks a lot for your continuous research and comments, Mike. Appreciate it.

cheers,
OraclePitStop.

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.


Where's The Comment Form?

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: