# Show WARNING when executing dropAll as SYSTEM on oracle

**URL:** https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054
**Category:** General Discussion
**Created:** [November 18, 2019, 7:08pm UTC](https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054 "2019-11-18T19:08:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)
#### Post date: [November 18, 2019, 7:08pm UTC](https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054/1 "2019-11-18T19:08:00Z")

</div>

If it wouldn’t bee too much trouble, can you write this up as a ticket in Jira? That will help us get the issue addressed.

[https://liquibase.jira.com/projects/CORE/issues](https://liquibase.jira.com/projects/CORE/issues)

Steve Donie  
Principal Software Engineer  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

### Author: ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)
#### Post date: [November 18, 2019, 7:08pm UTC](https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054/2 "2019-11-18T19:08:00Z")

</div>

Thanks!

Steve Donie  
Principal Software Engineer  
Liquibase Community Engagement  
Datical, Inc. [http://www.datical.com/](http://www.datical.com/)

---

<div class="post-metadata">

### Author: ![ZbynekVavros](https://avatars.discourse-cdn.com/v4/letter/z/9dc877/32.png) [@ZbynekVavros](https://forum.liquibase.org/u/ZbynekVavros)
#### Post date: [November 18, 2019, 7:08pm UTC](https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054/3 "2019-11-18T19:08:00Z")

</div>

Hi,

I’m not sure whether I’m not doing something wrong (only simple dev here) but trying to execute dropAll on connection with oracle SYSTEM results with nothing being dropped.

I did some digging and found out the there is a DIFF being calculated and on connection with oracle SYSTEM this always results in empty list (unexpectedObjects = 0).

This works just find on usual connections. Now I know using SYSTEM is extremely nasty but hey I work with what I get from admins…

If its easily possible it would be nice to print a WARNING, I have spent whole morning of debugging Liquibase internals to find out.

Thanks and keep the good job, Liquibase is awesome!

Zbynek

---

<div class="post-metadata">

### Author: ![un1405093691615r12id](https://avatars.discourse-cdn.com/v4/letter/u/e274bd/32.png) [@un1405093691615r12id](https://forum.liquibase.org/u/un1405093691615r12id)
#### Post date: [November 18, 2019, 7:08pm UTC](https://forum.liquibase.org/t/show-warning-when-executing-dropall-as-system-on-oracle/4054/4 "2019-11-18T19:08:00Z")

</div>

Here you go [https://liquibase.jira.com/browse/CORE-3510.](https://liquibase.jira.com/browse/CORE-3510.)

Zbynek