Results 1 to 2 of 2

Thread: easy question

  1. #1
    Join Date
    Nov 2003
    Location
    MAlaysia
    Posts
    1

    Red face Unanswered: easy question

    can one tell me( Need Help)

    what is Table space, Oracle schema and instance

    or give me some web site which is can make me clearer about this three defination

  2. #2
    Join Date
    Sep 2003
    Posts
    12
    TABLESPACE is a
    logical storage unit
    database is divided into many tablespaces
    system is by default
    tablespace is related with datafile that is physical storage unit
    schema
    where user will store its objects
    or schema is collection of user created objects
    instance
    when u issue startup command
    then oracle first start instance
    then mount the database
    then open database
    in instance, memory is allocated acc to init.ora to oracle objects
    like pmon,smon etc
    read all oracle architecture of oracle
    use
    tahiti.oracle.com

Posting Permissions

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