Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Newbie Oracle Question


    Im in the process of converting our postgres database to Oracle.
    Does Oracle support inherited tables

    for example (postgresql)
    CREATE TABLE "conact"."name" (
    "primary" SERIAL,
    "firstname" TEXT,
    "middlename" TEXT,
    "surname" TEXT,
    CONSTRAINT "name_pkey" PRIMARY KEY("primary")
    ) WITH OIDS;

    CREATE TABLE "conact"."staff" (
    "conactnumber" Integer
    ) INHERITS ("contacts"."name") WITH OIDS;

    can find anthing in Oracle's help so im guessing its not supported

  2. #2
    Join Date
    Jan 2003
    Vienna, Austria
    I don't know much about postgres, but the OID is described as "internal unique object id", so it sounds similar to the pseudocolumn 'ROWID'. you can always select the column ROWID together with all the other columns. But be cautous using this special Column, do NEVER use it to reference to this column, or you'll crash your data integrity after the first export/import.
    But your construct at all seems similar to a CLUSTER, maybe [1] (free registration required) might be a starting-point to read about the concept of clusters.


Posting Permissions

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