compressing table and rebuild unusable indexes

Hello,

alter table table_name move compress parallel; -- is what I know

But how can I update the indexes of this table in the same statement?
I read something like

... update indexes

... rebuild unusable local indexes

But I did not find the right syntax.

Can you help me?

Quote:

---

Originally Posted by ckiltz

Hello,

alter table table_name move compress parallel; -- is what I know

But how can I update the indexes of this table in the same statement?
I read something like

... update indexes

... rebuild unusable local indexes

But I did not find the right syntax.

Can you help me?

---

You can't. Add index rebuild statements to your script.

Hallo, thank you for your reply!