extracting part of a database

From: Christian Wandrei <Christian.Berlin_at_gmx.de>
Date: Thu, 05 Nov 1998 14:51:36 +0100
Message-ID: <3641AD68.17F7025D@gmx.de>

Hi,

i've the following problem to solve:

i've two databases (ORACLE 7.3), one at my customer and one at my company.
the database at my customer is a very big one and i wish to have an consistent part
of it for testing and developing at my company.

the database has a central table called RING. All other tables depends on this table.
These dependencies are given by foreign keys. The depending tables themselve have likewise tables those depend on them ... and so on.

what i want to do is, to specify a condition for selecting some rows of the table RING
and then getting all data from the depending tables to get a consistent part of the
original database.

Perhabs one of you can give me a hint of making this in an easy way.

Thanx ... Christian Received on Thu Nov 05 1998 - 07:51:36 CST