I want to change the ZFS filesystem under some read-only tablespaces to compressed - how can I make
I have some history databases that have about 2.2 Terabytes of mostly read-only tablespaces. I want to set the ZFS filesystems to compression, but it won't compress until the files have writes - which they never will. Can I just offline-move-rename-online the data files from one filesystem to the other to get them compressed, or is it better to export and import the data?