Difference between revisions of "12c database syntaxes"
Jump to navigation
Jump to search
(Created page with "1. At first, create pluggable database. create pluggable database my_plug01 admin user my_admin identified by my_admin; alter pluggable database my_plug01 open; 2. Next, create ...") |
|||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | + | * Create a pluggable database. | |
− | alter session set container= | + | <pre> |
+ | create pluggable database pdb12c admin user john identified by doe; | ||
+ | alter pluggable database pdb12c open; | ||
+ | </pre> | ||
+ | |||
+ | * Create a user in the pluggable database. | ||
+ | <pre> | ||
+ | alter session set container=pdb12c; | ||
create user test identified by test; | create user test identified by test; | ||
− | + | </pre> | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
[[Category: Oracle Database]] | [[Category: Oracle Database]] | ||
[[Category: Oracle 12c]] | [[Category: Oracle 12c]] |
Revision as of 16:23, 5 August 2013
- 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;