Can many Tablespaces share a single datafile between them?


I understand that a Tablespace can have many datafiles but my question is whether among the Tablespace they can share only one datafile. Thanks

asked by Yamila 06.10.2018 в 20:30

1 answer


No, a datafile can only belong to one tablespace exclusively. And a tablespace can have one or several datafiles, but not share them between tablespaces.

Here you can read a bit about the structure of oracle. link

answered by 08.10.2018 / 01:30