Sanity check 
Author Message
 Sanity check

Have been doing extensive design and PL/SQL API development for a J2EE
front end.  One set of tables are used globally, others are specific
to each sub-system.  In all nearly 200 tables.

I've got the global ones in one schema, the others each on its schema.
A "wrapper" schema then concentrates all the API procedures and
packages that access the required schemas as needed, with appropriate
security established.

A Java "guru" the other day asked in a very "suspicious" way if that
was a " *normal* ORACLE design process", to have "multiple schemas in
a database, one for each subsystem".

Please tell me I'm not dreaming: the guy is a nong, right?

Sometimes I doubt if I'm living in the same world...

Ah, yes!: 8.1.7, M$ NT4
TIA

Cheers
Nuno Souto



Sun, 06 Jun 2004 18:20:31 GMT
 Sanity check

Quote:

> Have been doing extensive design and PL/SQL API development for a J2EE
> front end.  One set of tables are used globally, others are specific
> to each sub-system.  In all nearly 200 tables.

> I've got the global ones in one schema, the others each on its schema.
> A "wrapper" schema then concentrates all the API procedures and
> packages that access the required schemas as needed, with appropriate
> security established.

> A Java "guru" the other day asked in a very "suspicious" way if that
> was a " *normal* ORACLE design process", to have "multiple schemas in
> a database, one for each subsystem".

> Please tell me I'm not dreaming: the guy is a nong, right?

> Sometimes I doubt if I'm living in the same world...

> Ah, yes!: 8.1.7, M$ NT4
> TIA

> Cheers
> Nuno Souto


I don't know if he is wrong.  I have always modeled different functions
of applications into different schemas.  It is analogous to writing Java
classes vs. one BIG program.
--
Ron Reidy
Oracle DBA


Sun, 06 Jun 2004 19:50:26 GMT
 Sanity check
Ron Reidy doodled thusly:

Quote:
>I don't know if he is wrong.  I have always modeled different functions
>of applications into different schemas.  It is analogous to writing Java
>classes vs. one BIG program.

thank you!  that's MOL what I did here too.  for a moment I thought I
was dreaming and doing something fundamentally wrong.

Cheers
Nuno Souto



Sun, 06 Jun 2004 19:56:27 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. output parameter acts like input; sanity check please

2. sp_executesql - sanity check

3. Sanity check: SQL Server 7 retrieval times?

4. Quick sanity check - Triggers with BCP

5. SQL Server build sanity check...

6. paradigm sanity check needed [long]

7. failed sanity check, table answers was not found

8. pg_dump fails sanity check

9. pg_dump - failed sanity check, type

10. max_fsm_pages Sanity Check

11. max_fsm_pages Sanity Check

12. Looking for sanity check on postmaster configuration


 
Powered by phpBB® Forum Software