-2

We have ONE DB which has TWO schemas as follows:

enter image description here

Do the Names from both Customer tables refer to the same data file location?

If not, is it possible to set them into the same point so in case of changing one the other is changed as well?

philipxy
  • 14,867
  • 6
  • 39
  • 83
sws
  • 39
  • 1
  • 6
  • 2
    You can synchronize multiple databases with the same schema, but each schema has its own file storage. – Gilbert Le Blanc Aug 12 '22 at 12:28
  • Are you asking if the name column of one table is updated, can the other table with the same id be automatically updated too? – Bohemian Aug 12 '22 at 16:23
  • 1
    This is not clear. What the data means depends on the database designs. Are you trying to ask about how the databases are implemented? Again, this depends on information you did not give. Use enough words, sentences & references to parts of examples to clearly & fully say what you mean. [mre] [Why should I not upload images of code/data/errors when asking a question?](https://meta.stackoverflow.com/q/285551/3404097) [Why are images of text, code and mathematical expressions discouraged?](https://meta.stackexchange.com/q/320052/266284) DDL gives the content of an ERD. – philipxy Aug 12 '22 at 20:29

1 Answers1

0

In the case of Oracle, you can save both tables in the same datafile depending on your declaration in tablespaces.

If you don't need to duplicate the same data, you can use a synonym, assigning permissions between schemas.

Hosni Juarez
  • 1
  • 1