Shulou(Shulou.com)06/01 Report--

When container database and plug-in database are used to store data in Oracle12c, with the increase of traffic, sub-database is adopted to store data, which is distributed to different storage devices, which can improve the overall performance.

The following is the creation of a pdb using a sql script:

Create the storage path corresponding to the pdb database

Make sure that the created directory is empty

Mkdir / u01/oradata/orcl/test

Create a tablespace

For the storage path of the corresponding database file, please see the corresponding parameter db_create_file_dest create tablespace ts_test datafile 'mkdir / u01 effective oradata size test01.dbf' size 100m autoextend on next 50m; create a pdb based on the seed pdb

Create pluggable database test admin user test identified by 123456 roles= (dba) default tablespace ts_test datafile 'mkdir / u01 size oradata autoextend on

File_name_convert ('/ u01qoradata / orclplash'/ u01laporadata'/ u01aporadata / orclapaphort / test')

Path_prefix=' / u01Compact oradata Universe orclUniverse Test'

Start pdb

The newly created pdb status is mount

Sqlplus / as sysdba

Show pdbs

Alter pluggable database test open

Connect the newly created pdb for verification

Sqlplus test/123456@127.0.0.1/test

Select * from dba_role_privs where grantee='TEST'

Alter system set db_create_file_dest='/u01/oradata/orcl/test' scope=both

Create tablespace ts_halee datafile 'halee01.dbf' size 100m autoextend on next 50m

.

All the subsequent operations are the same as the previous operations.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.