I am trying to craete a PDB as a non-sys user
CDB1>sho con_name
CON_NAME
------------------------------
CDB$ROOT
CDB1>select con_id, name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- -------------------------------------------------- ----------
2 PDB$SEED READ ONLY
4 PDB3_COPY READ ONLY
CDB1>create user c##sys identified by oracle;
User created.
CDB1>grant connect, resource to c##sys;
Grant succeeded.
CDB1>grant create pluggable database to c##sys;
CDB1>grant dba to c##sys;
CDB1>conn c##sys/oracle@cdb1
Connected.
CDB1>sho user
USER is "C##SYS"
CDB1>create pluggable database pdb1 from pdb3_copy;
create pluggable database pdb1 from pdb3_copy
*
ERROR at line 1:
ORA-01031: insufficient privileges
What all minimum privileges are required to create a PDB?
Regards