Hello again,

I was able to spot the problem, apparently two copies of the table exist in the same schema, I have no clue how. I ran the query select * from sys.tables, and it showed me two copies per table. I had to do the following to fix this:

1) Log in using mclient
2) Drop table
3) quit
4) restart database
5) log in again
6) drop table again (first drop was for the first table)
7) double check using select * from sys.tables

It worked for me, but i still don't know how were two copies of the same table with the same name created under the same schema.


On Mon, Aug 11, 2014 at 12:01 PM, Ali Salem <sarafandee@gmail.com> wrote:
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.