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
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