Browsed by
Tag: GTT

Global temporary tables (GTT) and indexes

Global temporary tables (GTT) and indexes

In the category frequently asked and answered. The question: Can we create indexes on Global Temporary tables (GTT) on the standby Database? The answer is yes, but as always: it depends. I will just answer this with an example. Everything is done on the Read-only Active Data Guard standby database. So, when you create a temporary table That works as expected, but when you try to add a user index: That obviously fails with ORA-16000: database or pluggable database open…

Read More Read More

%d bloggers like this: