5 Replies Latest reply on Jul 23, 2013 3:36 PM by Richard Harrison .

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

    Richard Harrison .


      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:


      export ORACLE_HOME, ORACLE_SID etc

      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?