Monday, February 27, 2017

Create plugable Database

Below is the command to create a plugable database. Another way is to create through dbca.

CREATE PLUGGABLE DATABASE orclpdb ADMIN USER pdbadm IDENTIFIED BY password
  STORAGE (MAXSIZE 2G)
  DEFAULT TABLESPACE testpdb
    DATAFILE '/disk1/oracle/dbs/orclpdb/sales01.dbf' SIZE 250M AUTOEXTEND ON
  PATH_PREFIX = '/disk1/oracle/dbs/orclpdb/'
  FILE_NAME_CONVERT = ('/disk1/oracle/dbs/pdbseed/', '/disk1/oracle/dbs/orclpdb/');

How to drop Plugable database

Below is the command to drop a plugable database

DROP PLUGGABLE DATABASE ORCLPDB INCLUDING DATAFILES;

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...