-
some people recommend adding applicatioon name prefix to all the table names. what are the advantages apart from from being able to identify which application does a table belong to ?
satish
-
I do not see any advantage.
-
I would discourage that practice. I don't think categorizing data as "for an application" is very accurate. It is more likely for a business process, and in many cases transcends processes and even businesses. If you really just like having those object names prepended with the application name, then just create synonyms. For example:
Owner name: Pat
Table name: fred
App name: flintstones
Create public synonym flinstones_fred for pat.fred;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|