Results 1 to 3 of 3

Thread: Clustered Index

  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Question Unanswered: Clustered Index

    Hi, I have one problem. I have to create table in oracle 9i EE database with index like MS SQL Server clustered index. I can't create index-organized table because there is no primary key in my oracle table. Is there any solution for my problem???
    Thanks.

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

    Re: Clustered Index

    Originally posted by VSOLARSKI
    Hi, I have one problem. I have to create table in oracle 9i EE database with index like MS SQL Server clustered index. I can't create index-organized table because there is no primary key in my oracle table. Is there any solution for my problem???
    Thanks.
    I am not familiar with MS SQL Server and its clustered indexes. What is the requirement here? I'm sure Oracle can handle your requirement, though maybe not in the way you would expect.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    IOT tables must have primary key - that's the whole idea of building an index with the tables rows. No other way around it.

    For the secondary indexes, which are based on ROWID values, there is no such requirement. The solution would be to create a primary key on your table.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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