does anyone know how to create a second database in the same machine using Oracle?
I have 1 database already. But I have not clue on how to create a second one using the same RDS instance.
any help or advice is welcome 🙂
I looks like I have to create a second user and that will create the schema. Now looking how to do this.
Best Answer
the user you created during rds setup (Master user/pass) is more or less like a sysdba user with which you can create other schema users.
something like this
sqlplus /@TEST
SQL> create user identified by default tablespace ;
User created.
SQL> grant connect to ;
Grant succeeded.