# Default Oracle schema

**URL:** <https://forum.liquibase.org/t/default-oracle-schema/8243>\
**Category:** General Discussion\
**Created:** [May 17, 2023, 4:09pm UTC](https://forum.liquibase.org/t/default-oracle-schema/8243 "2023-05-17T16:09:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jerryrgcm](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jerryrgcm](https://forum.liquibase.org/u/jerryrgcm)\
**Post date:** [May 17, 2023, 4:09pm UTC](https://forum.liquibase.org/t/default-oracle-schema/8243/1 "2023-05-17T16:09:58Z")

</div>

I’m using Liquibase 4.3.3. I’m having trouble using the defaultSchemaName parameter in the application.yml file:

liquibase:  
user: ${DATABASE\_USERNAME}  
password: ${DATABASE\_PASSWORD}  
change-log: classpath:db-changelog/dbchangelog-master.yml  
enabled: false  
parameters:  
defaultSchemaName: BOO\_USER

In general, is there a way to specify a default schema, so all sql files with statements like:  
foo.sql: CREATE TABLE FOO1…  
foo2.sql: CREATE TABLE FOO2…  
all go in the same schema without having to specify it?

Thanks,  
Jerry

---

<div class="post-metadata">

**Author:** ![PJatLiquibase](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@PJatLiquibase](https://forum.liquibase.org/u/PJatLiquibase)\
**Post date:** [May 17, 2023, 6:30pm UTC](https://forum.liquibase.org/t/default-oracle-schema/8243/2 "2023-05-17T18:30:58Z")

</div>

Hi @jerryrgcm,

This should work for a normal liquibase.properties file. Like it’s described in the documentation here: [Create and Configure a liquibase.properties File](https://docs.liquibase.com/concepts/connections/creating-config-properties.html)

However, since you are calling the file application.yml, I’m wondering if you are running this from Spring or Spring Boot perhaps? In which case it would be `spring.liquibase.default-schema` like you can see here: [Using Liquibase with Spring Boot](https://docs.liquibase.com/tools-integrations/springboot/springboot.html)

Good question! And any more detail would be helpful.

`-PJ`

---

<div class="post-metadata">

**Author:** ![jerryrgcm](https://avatars.discourse-cdn.com/v4/letter/j/c68b51/32.png) [@jerryrgcm](https://forum.liquibase.org/u/jerryrgcm)\
**Post date:** [May 17, 2023, 7:31pm UTC](https://forum.liquibase.org/t/default-oracle-schema/8243/3 "2023-05-17T19:31:01Z")

</div>

PJ,  
Thanks for responding! Yes, I should have mentioned that I am running this from Spring and my target is RDS Oracle in AWS. Also, the spring deployment is run through Bamboo. My application.yml file looks like this:

spring:  
main:  
web-application-type: none  
application:  
name: Application  
datasource:  
url: ${DATABASE\_URL}  
username: ${DATABASE\_USERNAME}  
password: ${DATABASE\_PASSWORD}  
liquibase:  
user: ${DATABASE\_USERNAME}  
password: ${DATABASE\_PASSWORD}  
default-schema: BOO\_USER

When I add the “default-schema” line, the deployment succeeds but doesn’t do anything – my test table is not in all\_objects in the Oracle target at all. When I take it out, the table is created in the schema of the account connecting to the Oracle instance.

Is it possible that the Bamboo deployment overrides the default schema parameter?

Thanks again,  
Jerry

---

<div class="post-metadata">

**Author:** ![PJatLiquibase](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@PJatLiquibase](https://forum.liquibase.org/u/PJatLiquibase)\
**Post date:** [May 18, 2023, 6:26pm UTC](https://forum.liquibase.org/t/default-oracle-schema/8243/4 "2023-05-18T18:26:42Z")

</div>

Hi @jerryrgcm,

I don’t think that Bamboo would be overriding the parameter.

Can you see anything in the logs around the Liquibase portion that could give us more information?

`-PJ`