Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB design
Baski wrote:
> Hi,
>
> How to design a generalized database that is used to store datas from
> any other database. The thing is that the tables and datas of the
> source database is not known while designing this target database. The
> design should be a generalized one to store data from any database. Can
> dummy tables be used? Should there be a provion to create the actual
> tables from the source db?? Or is there any better way??
>
> Thanks in advance...
> Baski.
>
You might like to check how Oracle does it, like where it stores information of tables, columns, types etc. and where it stores the values. But, then you have "Oracle" implemented with Oracle, so what's the catch?
-- Arto Viitanen, CSC Ltd. Espoo, FinlandReceived on Tue Feb 28 2006 - 00:57:44 CST