Performance Analysis for Oracle (PAO) collector agent has already been installed. How to change the PAO schema tablespace thereafter?
Shutdown the collector agent on the monitored host
Go to: <install dir>\pa_agent\<port>\agents\StealthCollect\6.0\data
Open the readme.txt file.
Read the uninistallation section and follow to step only for the monitored instance part as follows:
a. Login to the monitored instance as the Performance Analysis user
b. Run the script quest_pa_drop_mon.sql
Now create the schema again by following the section under "To install the Performance Analysis objects on the monitored instance". At this point, you can change the tablespaces.