2
I have Oracle 11g installed on my machine.
In Oracle I have configured a local connection.
In this local connection I have several tables.
I would like in this same local connection, create another "database" where I could create new tables.
My question is:
Is there any way to do that?
If it exists, how can I create the new banks?
0
Do not need another Instance in my opinion (it seems to me a BD just for study) just create another USER give the necessary GRANTS and create the tables and other objects.
Creation of user (Oracle) http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm
Grants (Oracle) http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9013.htm
If you want to know more about instances http://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT005
Links are not recommended here, but I believe these will not "break" so soon.
Browser other questions tagged database oracle
You are not signed in. Login or sign up in order to post.
Welcome to [en.so]. Your question is not very clear. Take a look at [help] in particular at the [Ask] link. You can [Dit] your question to make it clearer.
– Caputo
Thanks @Caputo. I re-asked my question, I hope it is more understandable.
– johhny
@Johhny - What user(Owner) have you created your tables on? Do not need another Instance in my opinion (m seems a BD just for study) to create another USER to give the GRANTS and create the tables and other objects.
– Motta
@Motta, thanks for your help. I managed to locate myself.
– johhny
@Motta Consider adding a reply with the tips you gave in the comment, so the user can mark it as right and it is more visible to those who visit the site later.
– utluiz