Granting select on AQ buffer views.

Hi, I don't know if I'm going off on the wrong tack or if this is an issue.

I'm trialling rebuilding two tablespaces (one is data, the other indexes) that is not only quite fragmented, but also has a lot of data files. The tablespaces are application related, not system. I thought that the quickest way to achieve this, was to export the four schema owners out that use the tablespaces, drop the tablespace, create a new one using larger data files, then import.

So far, so good. I got all the data reimported, (I had used datapump and named the schemas to export/import) but found that there were a lot of invalid objects due to grants not being reinstated to objects owned by other schemas not removed and reimported by this process. So I reverted and tried again, but before the exported schemas were droppedd, this time I generated DDL of object privs to objects used by them that were not part of the datapump. I hope that makes sense. That meant I had script files I could run in to recreate missing