Base solution for your next web application
Open Closed

Oracle Multi Tenant DB #8239


User avatar
0
muleso created

I want to use oracle DB,

How can i configure to use a PDB per tenant.

Regards,


4 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    hi @muleso

    When we create a new tenant, we should select/create a database to store new tenant's data. We can select 'Use host database' to store tenant data in host database (can be used for single database approach) or we can specify a connection string to create/use a dedicated database for new tenant. ASP.NET Zero supports hybrid approach. That means you can use host database for some tenants and create dedicated databases for some other tenants. Even you can group some tenants in a separated database.

    https://docs.aspnetzero.com/en/aspnet-core-angular/latest/Features-Angular-Tenant-Management

  • User Avatar
    0
    muleso created

    Hello,

    I know how multi tenancy works and have already implemented with MS SQL and Postgres.

    But now i want to test on oracle.

    In MS SQL it creates a new DB automatically is you specify a connection for a DB that doesn't exist.

    In oracle a DB=PDB, does it create a new PDB ?

  • User Avatar
    0
    maliming created
    Support Team

    In oracle a DB=PDB, does it create a new PDB ?

    It depends on the oracle ef provider you use. I haven't tried it in oracle, you can try it.

  • User Avatar
    0
    ismcagdas created
    Support Team

    This issue is closed because it has not had recent activity for a long time.