Oracle – How to create a second database schema in the same RDS instance on Amazon RDS

amazon-rdsamazon-web-servicesoracle

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 Solution

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.