We get the following error when using parallel query across schemas and a logon trigger that alters the session to enable resumable. Any ideas why we would be getting this error? The user running the PQ has resumable granted, but the schema we're reading the data from does not....surely that shouldn't matter? ORA-12801: error signaled in parallel query server P025 ORA-02097: parameter cannot be modified because specified value is invalid ORA-01031: insufficient privileges ___________________________________________________________ To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com -- //www.freelists.org/webpage/oracle-l