oracle dba_tables degree default,oracle中如何将表的并行度设定为DEFAULT?如下:

满意答案

ghgjy51

2014.04.09

采纳率：42%    等级：9

已帮助：1462人

SQL> create table testa1 (ti int) ;

Table created.

SQL> create table testa2 (t1 int) parallel;

Table created.

SQL> SELECT owner, table_name, degree FROM dba_tables WHERE table_name in ('testa1','testa2');

no rows selected

SQL> SELECT owner, table_name, degree FROM dba_tables WHERE table_name in ('TESTA1','TESTA2');

OWNER TABLE_NAME DEGREE

------------------------------ ------------------------------ --------------------

SYS TESTA2 DEFAULT

SYS TESTA1 1

SQL>

默认为1

SQL> alter table testa2 noparallel;

Table altered.

SQL> SELECT owner, table_name, degree FROM dba_tables WHERE table_name in ('TESTA1','TESTA2');

OWNER TABLE_NAME DEGREE

------------------------------ ------------------------------ --------------------

SYS TESTA2 1

SYS TESTA1 1

noparallel=1

00分享举报