Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What's special about this create table statement?

What's special about this create table statement?

From: dean <deanbrown3d_at_yahoo.com>
Date: 4 Jan 2006 14:53:46 -0800
Message-ID: <1136415226.032284.61280@o13g2000cwo.googlegroups.com>


CREATE TABLE "UPD"."SELECTED_NODES" ("SEQ_I" NUMBER NOT NULL,     "NODE_I" NUMBER NOT NULL, "LABEL_S" VARCHAR2(1 byte),     CONSTRAINT "PK_SELECTED_NODES" PRIMARY KEY("NODE_I")     USING INDEX
    STORAGE ( INITIAL 0K NEXT 0K MINEXTENTS 0 MAXEXTENTS 0     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1) PCTFREE 10     INITRANS 2 MAXTRANS 255) PCTFREE 10 PCTUSED 40 INITRANS 1     MAXTRANS 255
    STORAGE ( INITIAL 0K NEXT 0K MINEXTENTS 0 MAXEXTENTS 0     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)     NOLOGGING I'm trying to determine what it is about this table that lets me insert records into it in one session, commit them, and still not see them in another identical (SQL+) session.

It was set up so that different users can insert and delete independently and for it to look like their data is the only data in the table, I just don't see how it works.

Thanks,

Dean Received on Wed Jan 04 2006 - 16:53:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US