hello there, i am new to oracle. i am trying to load different database, which i have just created using database configuration assistant in oracle, called "mydb". i want to load it when scott user logs in. btw which database loads when scott logs in, is it orcl or something else.
how can i create new users and assign them new databases with specific commands.

Recommended Answers

You need to understand the basics correctly. scott is a schema within the database not the other way around.

Jump to Post

All 2 Replies

You need to understand the basics correctly. scott is a schema within the database not the other way around.

hey you want to load particular scott user data are what tel properly..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.