Differences between Create-Script and View in PLD

TenGor

Member³
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?
 
There is indeed no DDL support for these options. This is on the list of enhancement requests though.
 
Back
Top