General practice in creating child tables

GANAPATH · New User Joined: 06 Mar 2006 Posts: 35

Hi,

Can any one please answer the following question.

I have created a parent table P in one Database and i have created the child table C in another database with Delete rule and everything works fine. I created like this thinking people want to create child tables that have LOB columns in different DB that have more space.

Is this a general practice that people do create their children under different database or 99% of the times they create the parent and the child under the same database?.

Thanks,
Ganapth

raghunathns · Posted: Fri Oct 13, 2006 2:16 am

mostly parent and child stay on same data base.

parent and child is to address normalisation not for space constrain.

GANAPATH · New User Joined: 06 Mar 2006 Posts: 35

Thanks

Ganapath