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 15: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;
