is it possible to specify Tablespace on Entity Framework core OnModelCreating

[omora]

For tables and indexes?
Thanks

[alexkeh]

No, there isn't. What are you trying to accomplish by specifying a tablespace?

[omora]

When we apply the migration to create the database table and indexes it generates:
-- Create table
create table A01ARQ01.ARQ_EMAIL_ADJUNTO
(
"Id" RAW(16) not null,
"NombreFichero" NVARCHAR2(255),
"Binario" BLOB,
"EmailId" RAW(16) default '00000000000000000000000000000000' not null
)
tablespace ASSM_ARQAUD_DAT;
-- Create/Recreate indexes
create index INX_ARQ_EMAIL_ADJUNTO_01 on ARQ_EMAIL_ADJUNTO (EmailId)
tablespace ASSM_ARQAUD_DAT;
-- Create/Recreate primary, unique and foreign key constraints
alter table ARQ_EMAIL_ADJUNTO
add constraint INX_ARQ_EMAIL_ADJUNTO_PK primary key (ID)
using index
tablespace ASSM_ARQAUD_DAT;
alter table ARQ_EMAIL_ADJUNTO
add constraint FK_ARQ_EMAIL_ADJUNTO_ARQ_EMAIL_EmailId foreign key (EMAILID)
references ARQ_EMAIL (ID) on delete cascade;

It uses the default tablespace for the schema
Our DBA demand to create index tablespaces in a different one
create index INX_ARQ_EMAIL_ADJUNTO_01 on ARQ_EMAIL_ADJUNTO (EmailId)
tablespace ASSM_ARQAUD_IND;
and
alter table ARQ_EMAIL_ADJUNTO
add constraint INX_ARQ_EMAIL_ADJUNTO_PK primary key (ID)
using index
tablespace ASSM_ARQAUD_IND;

The work around is not to use migrations and create the tables and index with SQL , the traditional way.

it's a shame that because of this feature we can't use migrations

[alexkeh]

@omora Thanks for brining this to the Oracle EF Core team's attention. I filed an enhancement request (33219678) to have the dev team take a look.

We will prioritize ERs based on customer interest.