Menu
In oracle XE, there's a pre-installed database, about employees and departments and whatever, But i want to create a new database, I know I can do it in the command line, but I checked the database homepage and I only found creating tables, in the GUI, or the browser, I need to create my own database, and make a user who can access only this database and not the employees database
620
Use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the PDB seed (PDB$SEED). Use can use up to 3 PDBs in a Oracle 21XE installation, one PDB xepdb1 is created by default.
Syntax of Create Database in Oracle There is no need to create the database in Oracle systems. In the Oracle database, we can directly create the database tables.
I think you mean "schema" and not "database". The installer program creates a database named XE, and inside that database is a schema named HR. To create additional schemas you could use any Oracle tool like SQLPlus or Database Control, and all you do is create a new user account (because user=schema). However, what Oracle probably prefers over SQLPlus is that you access the XE "Home Page" on your computer using the shortcut they put on your Win2K desktop, and then click on the Administration link
Read more here: http://www.dbforums.com/oracle/1605421-creating-new-db-express-edition.html
108
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
