Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2014
    Posts
    8

    Arrow Unanswered: Implementation of the table cluster in oracle

    Hi there;
    Here is the brief about the table clusters in oracle:
    http://docs.oracle.com/cd/E11882_01/...s.htm#CNCPT608

    I would like to implement the scenario described above. I have a departments table as such:

    DEPARTMENTS
    ---------------------------------------------------------------------------
    DEP_ID NUMBER (PK)
    DEP_NAME NVARCHAR2(80)
    DEP_ESTABLISH_DATE DATETIME
    DEP_BUDGET NUMBER(*,2)
    ---------------------------------------------------------------------------

    and I have a employee table as such:
    EMPLOYEE
    ---------------------------------------------------------------------------
    EMP_ID NUMBER (PK)
    EMP_NAME NVARCHAR2(80)
    EMP_SURNAME NVARCHAR2(80)
    EMP_BIRTHDATE DATETIME
    EMP_SALARY NUMBER(*,2)
    EMP_PHOTO BLOB
    ---------------------------------------------------------------------------

    In this circumstances, I would like to implement the table cluster over these two tables. How can I do it? Can I do it without using indexed clusters?

    Thanks in advance.

  2. #2
    Join Date
    Sep 2014
    Posts
    8
    erroneous entry
    Last edited by tsozgen; 10-15-14 at 15:04.

  3. #3
    Join Date
    Sep 2014
    Posts
    8
    erroneous entry
    Last edited by tsozgen; 10-15-14 at 15:04.

  4. #4
    Join Date
    Sep 2014
    Posts
    8

    title-1


Tags for this Thread

Posting Permissions

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