CODEWITHSUNDEEP
oracle-databaseamazon-web-servicesamazon-rds
user2348487
user2348487

Reputation: 21

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

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.

Upvotes: 2

Views: 11610

Answers (2)

user2816719
user2816719

Reputation: 51

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.

Upvotes: 5

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

You're mixing terminology here. Are you talking about database instances, or about users/schemas?

Your database instance can have up to 30 users/schemas. http://aws.amazon.com/rds/faqs/#2

You can launch up to 20 database instances if you like. http://aws.amazon.com/rds/#details

Upvotes: 2

Related Questions