| Traditional vs. Container Database [message #690376] |
Tue, 22 July 2025 05:26  |
Eric Langager
Messages: 40
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
Greetings,
I recently installed the 21c XE Database on my new computer. The previous version on my old computer was 11g XE. Needless to say, I have missed a few upgrades. I found that I need to put a c## before the username. When I talked to the folks at Allround Automation (PL/SQL Developer) about this they said, "You may want to recreate your XE database as a traditional (non-CDB) database instead of a container database, to prevent the common user (c##name) issue." But is it worth it? Since everything works, should I just accept the nuisance of putting the c## before every username?
|
|
|
|
|
|
| Re: Traditional vs. Container Database [message #690381 is a reply to message #690377] |
Wed, 30 July 2025 04:44  |
Eric Langager
Messages: 40
Registered: April 2004
Location: Beijing, China
|
Member |
|
|
|
Thanks for that information. I created a pfile from spfile. My thought was to edit the new pfile, then hide the spfile and bounce the database to start with the pfile. The problem is that the common user value does not exist in the pfile. Should I just add it in?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
