The difference between "USERNAME" and "SCHEMANAME" in v$session?
698271Apr 29 2009 — edited May 27 2009it is puzzling。
I always find that the SCHEMANAME= USERNAME whenever I query the v$session.
Oracle Doc:
Oracle® Database Concepts
10g Release 2 (10.2)
Part Number B14220-02
“A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema”
I think the schema must be the same as the username.
so, why use 2 different concepts?
Edited by: maqianyi on 2009-4-29 下午6:59