Re: SCHEMA/OBJECT MODELING, MAPPING

For point b - partial solution, you can find out the dependencies between different schema's by working out a query on DBA_DEPENDENCIES.

Thanks!
amar

Paula Stankus wrote:
> I am working on a project where we have to separate a database and schema into two. The biggest issue from a database-side is underlying objects called, accessed from packages, procedures and views in other schemas that will not be copied (at least we don't think so yet). However, to make decisions about using database links, snapshots, etc. to make these processes work - I was just wondering:
>
> a-what is the best modeling technique to map a .Net class to a package say to other packages in other schemas
>
> b-find out what packages, views, objects in schema B and schema C are being accessed in schema A - how (CRUD), how frequently.
>
> This is an 8i database on Solaris.
>
> Thanks in advance,
> Paula
>
>
> ---------------------------------
> Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase.

--
http://www.freelists.org/webpage/oracle-l