Roeland
Member³
Hi,
When copying an index from one table to the other the storage is pasted as string, but no storage is assigned.
1) View/Edit a table (let's say in the Dev environment)
2) Copy the index (select the line and press Ctrl-C)
3) View/Edit the target table (for example in the production environment)
4) Paste this in the indexes. You now see a index with storage. But if you look at the "View SQL" or press the storage button, you'll see that there is no storage assigned.
So if you press "Apply" this index will likely be created into another tablespace than you had in mind...
Version 7.1.5.1398
Regards,
Roeland
When copying an index from one table to the other the storage is pasted as string, but no storage is assigned.
1) View/Edit a table (let's say in the Dev environment)
2) Copy the index (select the line and press Ctrl-C)
3) View/Edit the target table (for example in the production environment)
4) Paste this in the indexes. You now see a index with storage. But if you look at the "View SQL" or press the storage button, you'll see that there is no storage assigned.
So if you press "Apply" this index will likely be created into another tablespace than you had in mind...
Version 7.1.5.1398
Regards,
Roeland