Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Common user creation while pluggable database is closed

Salman QureshiFeb 24 2015 — edited Mar 9 2015

Hi,

In Oracle 12.1.0.2 on Windows 7, I have a tablespace TEST in my CDB and my PDB is closed currently while i create a new common user C##TEST in my CDB with default tablespace TEST. According to documentation, PDB would synchronize with the CDB when I will open it and would try to create this common user. Now if I open my PDB, it would not be table to create C##TEST user in PDB because TEST tablespace does not exist in PDB and I should see some message somewhere (on SQLPLUS or alert log) about this problem, but I am not seeing anything anywhere. Is someone familiar with this kind of scenario and help to find out where this kind of dependency issue logged in Oracle so that we can resolve them.

Salman

-------------

<Moderator Edit - deleted link spam - pl see FAQ on where to include signature links>

This post has been answered by Salman Qureshi on Mar 3 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2015
Added on Feb 24 2015
7 comments
3,543 views