out who is responsible for what.
From: Grabowy, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: RE: The use of schemas
Date: Wed, 13 Feb 2002 11:44:17 -0800
There is the three schema method for security
Hi all,
Our consultant has presented a schema design which I have never seen
(not that I have seen all the designs in the world) but I also failed
to see the advantage.
Basically our application consists of 35 tables and all is under one
schema named after the application. Granted, the
[EMAIL PROTECTED] wrote:
Has anyone seen such a approach? And what's the benefit of doing so?
yes, and none i can see.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta
Check your consultant's credentials. From what you've indicated, there is absolutely
no reason to do this. Tell him he will get to do all the management of synonyms,
permissions, and schema exports. I suppose he also wants separate tablespaces for
each of these schemas as well?
Jim Hawkins
hmmm, consultant, complicate it, bring consultant back, get paid more . it seems
a bit much 8 schema's for 35 tables. i would only separate the schema's if the
objects were used by other applications. if its a self contained application, kiss :)
gene
[EMAIL PROTECTED] 02/13/02 02:09PM
I agree with you. This makes no sense to me. 35 tables split into 8
schemas gives you about 4-5 tables per schema?
Did you ask him/her for the methodology as to why he/she feels this is
important?
Oracle applications uses multiple schema's for it's components, but then,
you are talking
There is the three schema method for security and integrity purposes, not
quite sure why you would break it up the consultant's way.
Is there a problem with asking the consultant about the split? What are the
advantages? Is there some business requirement? S(he) may know of some
requirement
mail.com To: [EMAIL PROTECTED]
Sent by: cc:
root@fatcity.Subject: The use of schemas
: The use of schemas
Date: Wed, 13 Feb 2002 11:30:53 -0800
Hum, did he used to work with financials? Its kind of hard to tell without
knowing more about how the database is used but I cannot think of an
advantage
off the top of my head. What reasons did he give?
-Original Message-
Sent
Multiple schemas can be handy if there's a reason to isolate
functional areas. One reason might be so that when you fire up a tool
that does ERD's you can tell it to do just the BILLING schema. Or if
you wanted to export just a section to load into a test database to do
development. You could
] (Jim Hawkins)
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: The use of schemas
Date: Wed, 13 Feb 2002 11:30:51 -0800
Check your consultant's credentials. From what you've indicated, there is
absolutely no reason to do this. Tell him he
Thanks Tom,
I will demand an explaination for this design when I get on a call
with him tomorrow.
Rich
From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: The use of schemas
Date: Wed, 13 Feb 2002 11
They have to make their money somehow! Our consultants have us put
everything into one schema. If the various components are so different,
maybe they need their own databases. Suggest that! You might as well
protect your job as theirs.
Ruth
- Original Message -
To: Multiple recipients
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: The use of schemas
Date: Wed, 13 Feb 2002 11:30:51 -0800
Check your consultant's credentials. From what you've indicated, there is
absolutely no reason to do this. Tell him he will get to do all the
management
]
Subject: RE: The use of schemas
Date: Wed, 13 Feb 2002 11:44:17 -0800
There is the three schema method for security and integrity purposes, not
quite sure why you would break it up the consultant's way.
Is there a problem with asking the consultant about the split? What are
the
advantages
oracle dba wrote:
Jim,
How do you know? Yes, he wants separate tablespaces for every schema.
I wonder if he knows he can still put tables into separate tablespaces
without using separate schemas. :)
And maybe for fun. I am going to recommend back that we use a schema
per table!
ROFLMFAO !!!
:D JoJo
-Original Message-
Sent: Wednesday, February 13, 2002 7:58 PM
To: Multiple recipients of list ORACLE-L
On Consultant Topic
Interesting one
===
It's all about an intelligent consultant...
Once upon a time there was a shepherd looking
17 matches
Mail list logo