Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Difference between database and tablespace

    Hi All,
    Kindy help in understanding following :
    1.What is difference between *DATABASE* , *TABLESPACE* and *ORACLE_SID* in oracle.

    2.I am having one oracle 9i instance running in my machine .I gave one SID to this instance .is it possible to have more then one SID for a instance.

    3.In order to create some tables first I am creating a USER after logging as sysdba .Then I am connecting as that USER and creating the tables.I want to understand that in this table creation process I have never defined any thing like databasename and when ever I am try to access those tables I need to connect as that user only.Then here what is the name of my *DATABASE* ?Is database name is same as USER name ??

    4.My requirement is like this:
    a)I want to login to oracle as sysdba
    b)Create a database(no tables at this time)
    c)Create some USERS for the *DATABASE*(created above) with different level of permission.
    d)Now connect to this DATABASE as one of the USERS who is having permission to create tables.
    e)Create all the table.

    can any one suggest how to achieve the steps mentioned in 4.I want to do all these with the help of sql scripts .I do not want to use Oracle GUI tool for database configuration.

    Thanks in advance to all .


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    visit where ALL of Oracle's documentation is available to anyone who will take the time to read it.
    1) I suggest you start by reading the CONCEPTS manual.
    When all else fails, RTFM!

Posting Permissions

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