12c database syntaxes

From Ittichai Chammavanijakul's Wiki
Revision as of 16:23, 5 August 2013 by Ittichai (talk | contribs)
Jump to navigation Jump to search
  • Create a pluggable database.
create pluggable database pdb12c admin user john identified by doe;
alter pluggable database pdb12c open;
  • Create a user in the pluggable database.
alter session set container=pdb12c;
create user test identified by test;