Hy,
i have the following create Script for a table:
CREATE TABLE "KENPER"
(
"NR" NUMBER(5),
"BEZEICH" VARCHAR2(30)
)
TABLESPACE "SENANBI_E"
NOLOGGING
PARALLEL 2
;
If i create the table in my DB and view it with PLD i can't see the options "NOLOGGING" nor "PARALLEL".
It's the same problem if i use the Button "View SQL":
-- Create table
create table KENPER
(
NR NUMBER(5),
BEZEICH VARCHAR2(30)
)
tablespace SENANBI_E
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
This is the code what PLD shows to me.
If i select from the DBA_TABLES for the table above i see
the column LOGGING = NO and DEGREE = 2.
So i'm a little bit confused about the differences.
Could you please help?