Database Administration (MOSC)

MOSC Banner

all_tables - what does user SYSTEM see in PDB/CDB under 12c?

edited Jan 19, 2016 10:05AM in Database Administration (MOSC) 7 commentsAnswered

I'm a bit puzzled at the moment. I have a PDB and a PDB01  in a multitenant CDB instance. PDB contains a schema owned by CHRIS.

PDB01 contains a schema owned by CHRIS01 plus another schema owned by CHRIS.

When I log into PDB01 as USER CHRIS01 and do a SELECT OWNER, table_name from all_tables where table_name='ENV' ; I'm getting

OWNER     table_name

---------------------------------

CHRIS01    ENV

But logging into SQLPLus  as SYSTEM/password@PDB01 I'm getting:

OWNER     table_name

---------------------------------

CHRIS01    ENV

CHRIS        ENV

Why is this?

--

Christoph

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center