Hi and thanks for taking a minute. I am brand new to Oracle databases. I know next to nothing. I am trying to make the jump from MS SQL Server and recently downloaded OracleXE. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production .
My version in SQL Plus lists as 21.3.0.0.0 and I have downloaded version Version 24.3.1.347 of Oracle Sql Developer.
In SQL Plus I have managed to create a user with sysdba privileges and in SQL Developer I managed to create a connection whereby I can run a query like “SELECT name, open_mode FROM v$pdbs;” and I can see results . The results seem to say I only have 2 mounted databases currently.
I have big ideas like standing up a new database for an application I would like to build .NET. So its my understanding (correct me if I am wrong) that this would most likely be a pluggable database? Correct? (A database that lives within a container database? ) I would also like to create a specific user that has full rights to create tables, schemas, etc to this new database. Right now whenever I try to run the commands I have read about to do this, almost next to nothing works.
So for example when I runthe following command in SQL Plus I get this:
SQL> CREATE PLUGGABLE DATABASE my_new_pdb;
CREATE PLUGGABLE DATABASE my_new_pdb
*
ERROR at line 1:
ORA-00922: missing or invalid option
In SQL Developer I get this :
CREATE PLUGGABLE DATABASE my_new_pdb
Cause: An invalid option was specified in defining a column or
storage clause. The valid option in specifying a column was NOT
NULL to specify that the column cannot contain any NULL
values. Only constraints may follow the datatype. Specifying a
maximum length on a DATE or LONG datatype also causes this
error.
*Action: Correct the syntax. Remove the erroneous option or
length specification from the column or storage specification.
Also In tried creating a user in SQL Plus. When I run the following command to create a new user I get this…
SQL> create user jazzcatone identified by jazzcatone default tablespace users quota unlimited on users;
ERROR at line 1:
ORA-01109: database not open
I guess don't know what database I should be trying to connect to ? Is there a database called users ? Any advice or direction would be greatly appreciated.
Jason