Can many Tablespaces share a single datafile between them?

Navigation
2

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
source

1 answer

1

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
source
Create a new table if the date is not the same Because in the console it indicates an arrangement of 3 objects, but when displaying its information, it only has 2 objects?