ORA-00955: name is already used by an existing object about dbt-oracle HOT 6 OPEN

Yes that worked !

Thank you so much for your fast answers !

from dbt-oracle.

@JeremyDel

It would good to check database name if it is lowercase or uppercase. I am suspecting there is some mismatch in the metadata.

select SYS_CONTEXT('userenv', 'DB_NAME') from dual;

Also, have you defined any quoting configuration in dbt-project.yml file?

from dbt-oracle.

The database name is lowercase !
I did try all the quoting possibilities in my dbt-project.yml but it doesn't work
quoting:
database: true
identifier: false
schema: false

from dbt-oracle.

Also, is this on-prem or Autonomous database ?

from dbt-oracle.

This is onprem.

I could recreate the error on another simple oracle database on which I can use the system user and when adding the database parameter in profiles.yml I was getting the error. By removing the database it worked as it should.
I cannot remove the database parameter when using another user:

Runtime Error
Credentials in profile "consilium", target "dev" invalid: 'database' is a required property

from dbt-oracle.

Could you try after enabling quoting only for database ?

quoting:
  database: true

from dbt-oracle.