Database - RAC/Scalability (MOSC)

MOSC Banner

Alter table add clolumn hang

edited Jun 16, 2015 10:01AM in Database - RAC/Scalability (MOSC) 5 commentsAnswered

Hi

tape this command

ALTER TABLE user.tab1 ADD (OPTIONNAMEDEACTIVATE  VARCHAR2(128 BYTE));

select * from  v$session_wait where sid=157; returns : SQL*Net message from client

SQL> select comp_name,version,status from dba_registry;

COMP_NAME                           VERSION                        STATUS

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

Oracle Database Catalog Views       10.2.0.4.0                     VALID

Oracle Database Packages and Types  10.2.0.4.0                     VALID

JServer JAVA Virtual Machine        10.2.0.4.0                     VALID

Oracle XDK                          10.2.0.4.0                     VALID

Oracle Database Java Packages       10.2.0.4.0                     VALID

Oracle Expression Filter            10.2.0.4.0                     VALID

Oracle Enterprise Manager           10.2.0.4.0                     VALID

Oracle XML Database                 10.2.0.4.0                     VALID

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