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.