how to verify current_schema? 2004-05-12 - By biti_rainy
hi,ryan.gaffuri
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
JServer Release 9.2.0.3.0 - Production
alibaba@(protected) >select sys_context( 'userenv ', 'current_schema ') from dual;
SYS_CONTEXT( 'USERENV ', 'CURRENT_SCHEMA ')
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
ALIBABA
alibaba@(protected) >alter session set current_schema = "SYSTEM ";
Session altered.
alibaba@(protected) >select sys_context( 'userenv ', 'current_schema ') from dual;
SYS_CONTEXT( 'USERENV ', 'CURRENT_SCHEMA ')
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
SYSTEM
alibaba@(protected) >
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@(protected)
>put 'unsubscribe ' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
