Can I activate an Index online?
As far as I know I can only add tables online with inactive indeces. Is there any way of activating these indeces once the table is added?
I'm not finding any specific statements in the documentation that you cannot do it (but I'm not finding any way of doing it either).
I am not in the office. I will not be checking my mail and phone on a regular basis, but will reply to your mail as soon as I can.
If you need support from appSolutions, please send your mails to support@app-solutions.com.
If you need Roundtable support, please send mails to :
support-europe@roundtable-tsms.com.
Jeg er væk fra kontoret, og checker ikke mail og telefon regelmæssigt. Jeg vil dog svare på din mail så snart som muligt.
Hvis du har behov for support, kontakt venligst support@app-solutions.com, så vender vi tilbage så snart det er muligt.
Administrative henvendelser kan ske til : admin@app-solutions.com.
Med venlig hilsen / Regards
Thomas Hansen
appSolutions a/s
You can add an active index online to an existing table via the data dictionary. Or you can add an inactive index to an existing table and then activate it online with proutil idxactivate (with some restrictions).
But I don't believe you can add a new table and its indexes and then activate them online.