Database Architecture
«Prev
Tables, Tablespaces, and Datafiles
In the first example, Table A maps to Tablespace A, which maps to Datafile A.
- Table A: Table A's data is stored in Tablespace A.
- Table B: Table B's data is stored in Tablespace A.
- Table C: Table C's data is stored in Tablespace B.
- Tablespace A: Tablespaces may contain data from several objects, in this case Tables A and B.
- Tablespace B: Tablespace B contains only data from Table C.
- Datafile A: May contain data from Table A or Table B or both.
- Datafile B: May contain data from Table A or Table B or both.
- Datafile C: May contain data from Table A or Table B or both.
- Datafile D: Will only contain data from Table C.