Its a shame you want to change a string value because you can change other types using dbms_session.set_bool_param_in_session and dbms_session.set_int_param_in_session Not much help I know, but may be worth knowing in the future. Cheers, Ian |---------+-----------------------------> | | Jan-Hendrik.Boll@d| | | ataport.de | | | Sent by: | | | oracle-l-bounce@fr| | | eelists.org | | | | | | | | | 17/07/2009 12:16 | | | Please respond to | | | Jan-Hendrik.Boll | | | | |---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: oracle-l@xxxxxxxxxxxxx | | cc: | | Subject: Change other users session | >--------------------------------------------------------------------------------------------------------------| Hi folks, is there any way to change the parameters of an other users session? I want to change the parameter curser_sharing without interrupting the other sessions jobs. (Some kind of third-party import-tool ) Any input is appreciated. regards, Jan-Hendrik This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.(See attached file: atthdlm0.dat) For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk ********************************************************************************* Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications ********************************************************************************* Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics ********************************************************************************* The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.