hi,ryan.gaffuri Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production JServer Release 9.2.0.3.0 - Production alibaba@OCN>select sys_context('userenv','current_schema') from dual; SYS_CONTEXT('USERENV','CURRENT_SCHEMA') ---------------------------------------------------------------------------------------------------- ALIBABA alibaba@OCN>alter session set current_schema = "SYSTEM"; Session altered. alibaba@OCN>select sys_context('userenv','current_schema') from dual; SYS_CONTEXT('USERENV','CURRENT_SCHEMA') ---------------------------------------------------------------------------------------------------- SYSTEM alibaba@OCN> Best regards yahoo id: feng_chunpei A new dba from china ---- from the mail----- >I am using > >alter session set current_schema = &1; > >and setting it dynamically for some very long running batch processes. I want >to be very, very careful to check that the current schema is right. I can't >find anything like 'show current_schema' > > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > >. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------