Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    5

    Unanswered: Database User = Database?

    I can create database users but cannot find a way to create database. I found that I can create objects like tables and views for a database user. Is a database user means a database?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Visit Oracle Documentation page; first read Concepts book. Because, I have that strange feeling that you don't know what you are talking about (when we talk about Oracle).

    Regarding your question: what do you call "a database"? I *suspect* you would like to create a schema (schema = user + its objects: tables, views, procedures, triggers, snapshots, ...). Therefore, once you have created a user (using the CREATE USER statement) and granted required privileges, all you have to do is to log in and start creating tables, views etc.

    However, if you'd really like to create a database, check the CREATE DATABASE statement syntax and examples.

  3. #3
    Join Date
    Jul 2007
    Posts
    5
    Thanks for your info. I just started learning Oracle. From my SQL Server experience, the tables and views are belongs to database. User account is seperated from database.

    For the tables and views in oracle, they must belongs to a database user?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Yes.

    I've seen that users who have MS SQL Server background encounter problems, difficulties and kind of mess in their heads until they switch a knob in their brains from SQL Server to Oracle. Some things are the same, some are similar, but some are very different. You'll find that out by yourself as the time goes by. So, don't think that you know something just because SQL Server did it that way. Open the manual and read about it. Then you'll be certain.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •