Trying to work out the new CDB and PDB concepts moving from 11g to 12c.
Logging on to SQL*Plus as user SYSTEM, then created a PDB using:
CREATE PLUGGABLE DATABASE test
ADMIN USER test
IDENTIFIED BY password
ROLES = (DBA)
DEFAULT TABLESPACE users
TEMPFILE REUSE
FILE_NAME_CONVERT = ('C:\Oracle\oradata\orcl\pdbseed','C:\Oracle\oradata\orcl\test')
;
This produces an error:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
However, the command: sho pdbs
shows the new database TEST as open mode MOUNTED
The command: ALTER PLUGGABLE DATABASE test CLOSE;
results in: ORA-01031: insufficient privileges
The command: DROP PLUGGABLE DATABASE test INCLUDING DATAFILES ;
results in: ORA-01031: insufficient privileges
1. Why did the command result in an 'invalid file name' error? Does the database folder have to be created in advance?
2. Why can the PDB not be altered or deleted? What privilege is missing and how can it be applied?
Thanks.