Forum Stats

  • 3,770,408 Users
  • 2,253,104 Discussions


Limitations in number of tables in RPD

Hello Guys,

I would like to know how many tables can be imported in Physical layer in RPD. If there is any limitations on number of tables, please let me know. Thanks in advance.





  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,351 Gold Crown
    edited Jul 28, 2020 5:31AM

    Is this a question from a pure theoretical point of view?

    If a soft-limit exists, you would have to ask internally.

    Technically nothing would prevent a very large number of physical tables, even if most of the time the ID attribute (which isn't supposed to be used anymore as the UID is the official unique identifier but both still exists all the time) is a 5 digits number.

    So the limit could be 100'000, or maybe it's a signed 32bit int and the limit could be 2 billions and something.

    Practically, if you get any close to a possible limit, the issue is somewhere else : are you really doing things in the right way?

  • Christian Berg-0racle
    Christian Berg-0racle Everything Analytics And Data Member Posts: 9,463 Gold Crown
    edited Jul 28, 2020 9:08AM

    I pray that this is a theoretical question as my brain refuses after about 50k physical tables