Enhancement Request: Use Parallel Degree

[Bernhard S]

Currently PSD doesn't seem to be aware of parallel degrees.
I create a table with parallel degree using command window:

create table table_parallel
( col1 number )
parallel 6;

In user_tables I can see that this table was created with parallel degree=6:

TABLE_NAME                     DEGREE
------------------------------ ----------
TABLE_PARALLEL                          6

However when I edit this table in PSD and change to "view sql" I only see:
-- Create table
create table TABLE_PARALLEL
(
col1 NUMBER
)
tablespace USER
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

DBMS_METADATA.GET_DDL however also includes the parallel degree:

SQL> col ddl format a80
SQL> set long 1000
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','TABLE_PARALLEL') ddl FROM dual;

DDL
--------------------------------------------------------------------------------

  CREATE TABLE "SCOTT"."TABLE_PARALLEL"
   (	"COL1" NUMBER
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USER"
  PARALLEL 6

Please make PSD aware of parallel degrees. Same applies to other DB objects with parallel degrees like clusters, indexes, materialized views, ...

 

[Marco Kalter]

I have added this to the list of enhancement requests.