Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Posts
    87

    Smile Unanswered: TABLE SPACE and TABLE?

    hi

    can anybody explain me the difference between TABLE SPACE and TABLE in detail??

    thanx in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: TABLE SPACE and TABLE?

    I suggest you read the Concepts guide:

    http://download-west.oracle.com/docs...a96524/toc.htm

    In a nutshell, a tablespace is an area where many tables and indexes may be stored: tablespace is to table as folder is to file (very roughly).

  3. #3
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    Hi the hirarchy is like this in an oracle database

    DATABASE
    |
    TableSpaces
    |
    -- Tables, Views,Other DB Objects
    |
    -- Rows, Codes etc.,

    Hope this helps you
    But its better to go through the documentation or some book
    regards

  4. #4
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    You must have space (tablespace) for your table (table) in the dining room right?
    Simple way to remember.
    Anyway, my mind is on Thanksgiving !!!

  5. #5
    Join Date
    Oct 2003
    Posts
    706

    Lightbulb

    It might also help to briefly consider why this concept of a division of space exists in the first place ... Let me paint a simplified picture.

    In a very large, production database, it might not make sense to put all of the tables in a database on a single disk drive. Doing so would cause fairly murderous amounts of movement of that hard-working read/write head as it scuttles back and forth across the disk surface, slowly wearing out its bearings while performing only read/write operation at a time. ZZZzzzzz....

    Instead, tables are spread out onto a "farm" of separate disk drives. Now, it becomes possible to efficiently do more than one disk I/O operation simultaneously, and the read/write mechanism on any given drive moves much less. The speed of the database is greatly increased, and the wear-and-tear on the drive farm is greatly reduced.

    On a simple, IDE-style disk subsystem, not much advantage might be perceived, because IDE can't do much in the way of simultaneous disk I/O. But subsystems like SCSI and fiber-optic channels can have dozens of operations going all at once. This is where tablespaces become very important.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  6. #6
    Join Date
    Nov 2003
    Posts
    87

    Talking

    thnX to all.

  7. #7
    Join Date
    Nov 2003
    Location
    Mumbai
    Posts
    12

    Thumbs up

    Hi raseena

    Segments collectively form a Tablespace. There are different types of segments as given below:
    Data Segment: Stores data information
    Index Segment: Stores index information
    Rollback Segments: Stores undo information.
    Temporary Segments: Uses this segment when ORDER BY or SORT or any other operation is being used by SQL statement.
    Tables form a part of Tablespace. Tables can be spanned across the drives.
    Hope this much helps...

    Regards

    sk

Posting Permissions

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