database design question [message #90574] |
Tue, 13 April 2004 18:28 |
sandeep
Messages: 110 Registered: October 2000
|
Senior Member |
|
|
where do the tables in oracle database reside? and in what form
in the harddisk and or any other place
|
|
|
Re: database design question [message #90576 is a reply to message #90574] |
Wed, 14 April 2004 09:13 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Each table is allocated to a tablespace (sometimes more than one for more complex table structures). Each tablespace is made up using one or more datafiles which are stored on a hard disk. So generally one of those datafiles on disk contains many different tables, indexes etc.
|
|
|