Database Administration (MOSC)

MOSC Banner

Oracle Table with degree 1

edited Dec 3, 2019 5:19AM in Database Administration (MOSC) 5 commentsAnswered

Hi,

I'm trying to alter the table with no parallel , however i'm seeing the table degree as 1, is there anything else i need to change so that degree changes to null.

SQL> alter table admin.XYZ noparallel;

Table altered.

SQL> select degree from dba_tables where table_name='XYZ';

DEGREE

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

         1

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center