Question about databses [message #684721] |
Wed, 04 August 2021 08:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/8cfe99f5227f06e9834d2e21cdd914b6?s=64&d=mm&r=g) |
itmasterw
Messages: 13 Registered: July 2014 Location: NY
|
Junior Member |
|
|
Hi,
I am new to Oracle but did take a course in college. Anyway have been working in SQL Server and in there we would have to first create a Database, and then tables for it.
However, in looking around I do not see this for PLSQL in oracle. Do they have databases or is it something else?
Thank you
|
|
|
Re: Question about databses [message #684722 is a reply to message #684721] |
Wed, 04 August 2021 10:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You first have to install Oracle software.
Then create a database (which is not the same thing than a database in SQL Server) and an instance on it.
Then connect to the instance using SYSTEM account and create a user which is also a schema granting it the appropriate privileges.
Then connect to this new user/schema and create the tables.
The first 2 steps can be done using Oracle installer from the files you downloaded.
Read the Oracle® Database 2 Day DBA book.
[Updated on: Wed, 04 August 2021 10:27] Report message to a moderator
|
|
|
|
|
|