This content has been marked as final. Show 4 replies
No, as with any other index, when you export an indexed table it only exports the index definition, which must be recreated on import.1 person found this helpful
The technical reason behind this is that the index contains references to the rowids of the indexed table, and these rowids would be meaningless after export/import.
Any other way different from export/import to obtain the same result without recreate the index?
yes, with Transportable Tablespace export / import.1 person found this helpful
Yes, but the transportable tablespaces feature is available only in Enterprise Edition.
Anyway, thanks for help