Database Structure

Hey!

Does anyone know a good documentation or tutorial on "how to design a good database structure" in oracle, i.e. for what reason do i create a new database? What should be in one tablespace? How many schemes should there be for what purpose?

For example I want to know if there is a major loss of performance if I want to access data from two databases. If this is a serious performance
problem I would make one database out of two etc.

regards
Paul Gaggl

-- 

                                                                   

 sterreichisches Institut f r Wirtschaftsforschung     WIFO

Name:	Paul Gaggl		Postadresse: 	Postfach  91
Tel.:   +43-1-7982601-229			A-1103  Wien      

Fax:    +43-1-7989386		Standort: 	Arsenal Objekt 20
Mail:	gaggl_at_wifo.ac.at			A-1030  Wien 


http://www.wifo.ac.at/