This discussion is archived
5 Replies Latest reply: Jul 23, 2013 8:36 AM by Richard Harrison . RSS

Specifying the container to connect to from command line utilities (sqlplus/expdp etc)

Richard Harrison . Expert
Currently Being Moderated


To kick off this forum I've been playing around with 12c multitenant/pluggable features and I've a general question about connections to the container database - it seems from everything i tried so far (and everything I've read) that there is no way to connect to a container database without going through a sqlnet connection. For example:



sqlplus username/password -- this can only connect to the container database? (once you are in you can alter session to switch to the plugable database but can;t do it directly in the connection)


to connect to a plugged in database you always have to go through sqlnet


sqlpus username/password@pluggable


there is no option to say something like:


export ORACLE_SID=container

export ORACLE_CONTAINER=pluggable

and then do sqlplus username/password ?


or some extra command line switch like


export ORACLE_SID=container

sqlplus -container=pluggable username/password


Is that understanding correct or have i missed something in the documentation?







  • Correct Answers - 10 points
  • Helpful Answers - 5 points