Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: schemas & tablespaces
Thanks. This info is really helpful. From the description below - then do all schemas on a particular db server access the same tablespaces (the one's described below)? For example, if I had two different applications that used the same server and seperate schemas for each application, would both schemas use the DATA tablespace for the table data and the INDEXES tablespaces for their indexes? If so, how do you distinguish between the two. By schema.object notation?
For pure performance, and money being no object, then each database should be housed on its own server. Each database will consists of at least 6 tablespaces -SYSTEM, ROLLBACKS, TEMP, DATA, INDEXES and "OTHER". Each basic tablespace thus described can be sub-divided: LARGE SLOW DATA; LARGE FAST DATA; SMALL SLOW DATA; SMALL FAST DATA and so on.
thanks a lot
-as
Sent via Deja.com
http://www.deja.com/
Received on Wed Jan 17 2001 - 11:16:39 CST
![]() |
![]() |