Table is not unique, corrupt catalog?

Hello all,

Last night I imported 500M records into my fact table, it took around 19 hours, but it worked fine. I created my indexes afterwards with no issues as well. However, when I tried to access the rest of the tables in my database, I received the following error:

table table_name is not unique, corrupt catalog?

Any idea why this happened and how to fix it?

Thank you.