RelationalDBDesign RelationalDBDesign


Database Architecture   «Prev 

Tables, Tablespaces, and Datafiles

In the first example, Table A maps to Tablespace A, which maps to Datafile A.

  1. Table A: Table A's data is stored in Tablespace A.
  2. Table B: Table B's data is stored in Tablespace A.
  3. Table C: Table C's data is stored in Tablespace B.
  4. Tablespace A: Tablespaces may contain data from several objects, in this case Tables A and B.
  5. Tablespace B: Tablespace B contains only data from Table C.
  6. Datafile A: May contain data from Table A or Table B or both.
  7. Datafile B: May contain data from Table A or Table B or both.
  8. Datafile C: May contain data from Table A or Table B or both.
  9. Datafile D: Will only contain data from Table C.