Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> pl/sql rollback segs

pl/sql rollback segs

From: Lane Hignight <lhignight_at_otaywater.gov>
Date: Tue, 26 May 1998 09:40:59 -0700
Message-ID: <356AF09B.1205@otaywater.gov>


Anyone have an example of pl/sql code which gets the status of a rollback segment, then brings it online if it's not already online? I've tried the code below, but I get errors when referencing sys.dba_rollback_segs..

Thanks - Lane



PROCEDURE GETMETROZIP IS
  /* this procedure should check rollback status and alter rollback segment if necessary,

   for now, this code is in client.. */

   lv_Status varchar2(10);
   dbinternal Integer;
BEGIN
  dbinternal := DBMS_SQL.OPEN_CURSOR;
  SELECT STATUS INTO lv_Status FROM SYS.DBA_ROLLBACK_SEGS   WHERE SEGMENT_NAME='RBCONV0';
  IF lv_Status = 'OFFLINE'
    THEN
      DBMS_SQL.PARSE(dbinternal, 'ALTER ROLLBACK SEGMENT RBCONV0 ONLINE', dbms_sql.v7);

    END IF;
  SET TRANSACTION USE ROLLBACK SEGMENT RBCONV0;   UPDATE COREPARCELCONSTRUCT A SET A.SITUS_ZIP = (SELECT B.SITEZIP FROM METROSCAN B WHERE B.PARCEL=A.COUNTYASSESSORPARCEL_ID);   DBMS_SQL.PARSE(dbinternal, 'ALTER ROLLBACK SEGMENT RBCONV0 OFFLINE', dbms_sql.v7);
  DBMS_SQL.CLOSE_CURSOR(dbinternal);
END; -- Procedure



Error
(1):PLS-00201: identifier 'SYS.DBA_ROLLBACK_SEGS' must be declared Received on Tue May 26 1998 - 11:40:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US