c3rberus
New Member
Hello,
Working on enabling multi-tenancy in our environment, we are running OE 11.3.3.
We have a few databases and for content ill add structure file here to support my question..
Database name: is db1
Within this database we have many tables/indexes/blobs that are spread across the different physical layout based on best practices for RPB, etc. All databases together is about 470 gigabytes.
Now when I enable the database for multi-tenancy, everything continues to stay the same as all tables within the multi-tenant database are not MT enabled and thus are "owned by the database".
This is exactly the same place I would like to be, except all tables/data owned by a "Regular" tenant.
However when I enable a table to be multi-tenant, it is assigned to the "Default" built-in tenant.. the default tenant becomes the owner of the table and its data.
So, now I add my new "Regular" tenant lets call it "Bob" and I want to allocate all the tables that have been multi-tenant enabled and assigned to Default.
What is the process for this? Everything I read points to having to move the data either via ABL or D&L... is there no way to do this kind in a similar way when the table is first enabled for MT and automatically owned by the Default tenant.
So my question is.. when I am about to enable my tables for multi-tenancy, is it possible to right away assign them to a tenant instead of the Default tenant? So that I can enable all the tables and segregate them within a tenant?
Working on enabling multi-tenancy in our environment, we are running OE 11.3.3.
We have a few databases and for content ill add structure file here to support my question..
Database name: is db1
Code:
b /usr4/bi_test/db1.b1
d "Schema Area":6,64;1 /usr4/testdbs/db1.d1
a /usr4/ai_test/db1.a1
a /usr4/ai_test/db1.a2
a /usr4/ai_test/db1.a3
a /usr4/ai_test/db1.a4
a /usr4/ai_test/db1.a5
d "index":99,1;64 /usr4/testdbs/db1_99.d1
d "d64":101,64;64 /usr4/testdbs/db1_101.d1
d "d32":121,32;64 /usr4/testdbs/db1_121.d1
d "d128":131,128;64 /usr4/testdbs/db1_131.d1
d "d256":141,256;64 /usr4/testdbs/db1_141.d1
Within this database we have many tables/indexes/blobs that are spread across the different physical layout based on best practices for RPB, etc. All databases together is about 470 gigabytes.
Now when I enable the database for multi-tenancy, everything continues to stay the same as all tables within the multi-tenant database are not MT enabled and thus are "owned by the database".
This is exactly the same place I would like to be, except all tables/data owned by a "Regular" tenant.
However when I enable a table to be multi-tenant, it is assigned to the "Default" built-in tenant.. the default tenant becomes the owner of the table and its data.
So, now I add my new "Regular" tenant lets call it "Bob" and I want to allocate all the tables that have been multi-tenant enabled and assigned to Default.
What is the process for this? Everything I read points to having to move the data either via ABL or D&L... is there no way to do this kind in a similar way when the table is first enabled for MT and automatically owned by the Default tenant.
So my question is.. when I am about to enable my tables for multi-tenancy, is it possible to right away assign them to a tenant instead of the Default tenant? So that I can enable all the tables and segregate them within a tenant?