Question about databses [message #684721] |
Wed, 04 August 2021 08:38 |
|
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 |
|
Michel Cadot
Messages: 68694 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
|
|
|
|
|
|