| 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
|
|
|
|
|
|
|
|
|
|
| Re: Oracle 12c Multi Tenancy -Data Separation [message #663184 is a reply to message #663177] |
Wed, 24 May 2017 12:32  |
|
magnify
Messages: 6
Registered: July 2012
Location: delhi
|
Junior Member |
|
|
rational behind this might be to sale it as 'SaaS' . As i said, some of the clients want more resources ( more Core,processing power etc) whereas others like to use lesser resources.
they will be charged seperately. other reason is the compliance as clients want their own DBs rather than sharing the data with other clients.
I would like to differ on point you made on the security. One grant here and there in multi schema architecture
and you will end up providing those grants to all schemas whereas with multi tenancy, you can avoid that. Please correct me if I am wrong here.
Being said that, I am not the decision maker and architects in the organization have already made the decision and I am assigned the task to separate out the data. Your help in suggesting some approaches might be beneficial for me.
Thanks
[Updated on: Wed, 24 May 2017 12:32] Report message to a moderator |
|
|
|
| Re: Oracle 12c Multi Tenancy -Data Separation [message #663187 is a reply to message #663184] |
Wed, 24 May 2017 12:50 |
 |
Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:rational behind this might be to sale it as 'SaaS' . As i said, some of the clients want more resources ( more Core,processing power etc) whereas others like to use lesser resources.
So what is the difference between multi-schema and multi-tenant?
Quote:other reason is the compliance as clients want their own DBs rather than sharing the data with other clients.
With multi-schema you do not share more the data than with multi-schema.
Quote:One grant here and there in multi schema architecture
and you will end up providing those grants to all schemas whereas with multi tenancy, you can avoid that.
I don't see what you mean.
You grant privileges to users depending on their needs on data, this is completely independent of the storage and instance architecture.
Quote:Being said that, I am not the decision maker and architects in the organization have already made the decision and I am assigned the task to separate out the data. Your help in suggesting some approaches might be beneficial for me.
Create a schema for each client, copy the data on each client tables then export/import.
This is how I'd do it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
