Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER SESSION SET CURRENT SCHEMA

258794Jan 19 2007 — edited Jan 19 2007

Good Morning,

I reviewed / researched what was on the database but I did not find what I needed. I have an 8.1.7 database. I am logged in as sys dba. I change to another user with the alter session set current schema command. I then do a select on user_tables and all that is returned is the tables in the sys schema. Is this a bug or is there a parameter that needs to be reset to allow this?

Thanks in advance in you help on this matter.

al

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2007

Added on Jan 19 2007

#general-database-discussions

10 comments

2,220 views