0 Replies Latest reply: Sep 19, 2013 2:01 PM by Erhan_toronto RSS

    how can I get rid of nologin when I use Alter option?

    Erhan_toronto

      11gR2

       

      I am using below two queries to get rid of  NOLOGGING; but still getting this why?

       

       

      DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES', false)

      DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE', false;)

       

       

       

       

      ALTER TABLE "TBL" NOLOGGING;