Oracle 12c Multi Tenancy -Data Separation [message #663170] |
Wed, 24 May 2017 11:39 |
|
magnify
Messages: 6 Registered: July 2012 Location: delhi
|
Junior Member |
|
|
Hi All,
I need your advice on best approaches to separate data in multiple tenants . We have recently moved to Oracle 12c from Oracle 11g and serving multiple clients. So planning to host each client as different tenant. Right now all the clients data resides in one schema. there are hundreds of tables and data is spread across everywhere in tables. Just wanted to know if anyone of you have faced similar issue and how did you approach the problem. As of now I am trying to create delete scripts for each table and not sure if this is correct approach or not. Please let me know if I am not clear in explaining my question and would provide further details.
Your help is appreciated.
Thanks
|
|
|