Hi, dbas:
How to drop a index organized table? I have pks and indexes
on these iots.
Thanks.
Printable View
Hi, dbas:
How to drop a index organized table? I have pks and indexes
on these iots.
Thanks.
I'm not 100% sure, but I don't think there is any differenc in the syntax of DROP TABLE command for IOT as opposed to heap tables. PKs and indexes will be dropped automaticaly. But if you have FKs from other tables referencing your IOT you'll have to trop those foreign keys before dropping your IOT.
HTH,