Pages

▼
Showing posts with label Oracle Workspace. Show all posts
Showing posts with label Oracle Workspace. Show all posts
Aug 3, 2014

Interanl execution during Disable versioning a table

›
Step 1: SELECT 1  FROM DUAL WHERE EXISTS (SELECT 1 FROM  scott.experiment_lt   WHERE VERSION IN (SELECT VERSION FROM wmsys.wm$version_hie...
May 10, 2012

Workspace Error : ORA-20229

›
EXEC DBMS_WM.ENABLEVERSIONING('FACEBOOKBOUNDARY'); ORA-20229: statement 'delete from mdsys.sdo_geom_metadata_table' fail...
Nov 14, 2011

Oracle WorkspaceManager ErrorC0des

›
  exec dbms_wm.enableversioning('TABLEA'); ORA-20129: table 'TABLEA' does not exist ORA-06512: at "WMSYS.LT"...
Nov 1, 2011

ORA-20061 ,ORA-00604 and ORA-2017

›
ORA-00604: error occurred at recursive SQL level 1 ORA-20061: versioned objects have to be version disabled before being dropped ORA-065...
May 19, 2011

ORA-20171: Workspace Error during BEGIN DDL

›
SQL > exec dbms_wm.beginddl('TABLE_NAME'); ORA-20171: WM error: 'CREATE TABLE' and 'CREATE SEQUENCE' privileges...
May 4, 2011

ORA-20104: cannot version disable this table

›
ORA-20104: cannot version disable this table ORA-06512: at "SYS.LT", line 9152 ORA-06512: at line 3 the following error will o...
Nov 19, 2010

Drop foreign key from a Versioned Table

›
To drop a foreign key constraint from a version enable table . EXECUTE DBMS_WM.BeginDDL('PARENT_TABLE'); EXECUTE DBMS_WM.BeginDDL...
Oct 19, 2010

DBMS_WM.CompressWorkspace

›
DBMS_WM.Compress Workspace  If   you version enabled the tables with  DBMS_WM.EnableVersioning ('TABLE_NAME', 'VIEW_WO_OVERWR...
Sep 30, 2010

ADD FOREIGN KEY TO VERSIONED TABLE

›
   ORACLE WORKSPACE MANAGER  TOPIC     If there is  a version enabled table 'BILL' and      /*  CREATE TABLE BILL (N_BILLID NUMB...
Feb 2, 2010

Oracle Workspace Manager

›
Difference between Long Transaction (Oracle WorkSpace) and Short Transaction (Normal ) Long Transactions ----------------------- Comp...
Apr 7, 2009

Oracle Wokspace 4

›
dbms_wm.gotodate begin dbms_wm.gotoworkspace('B_focus_1'); end; insert into test values (6,'Wayanad','YS',...
Mar 26, 2009

Oracle Wokspace 3

›
To Refresh workspace begin dbms_wm.gotoworkspace('B_focus_9'); dbms_wm.refreshworkspace('B_focus_9'); end; But if th...

Oracle Workspace 2

›
The merge operation does not currently work with versioned tables. The optimizer translates the merge into insert/update statements on the ...
Mar 25, 2009

Oracle Workspace 1

›
Workspace Manager PL/SQL APIs The PL/SQL APIs in the DBMS_WM package can be executed * Workspace operations: create,refresh,merge,rollb...
Mar 19, 2009

Oracle Workspace

›
With Oracle's Workspace Manager it's possible to have several versions of data. That is, data can be changed, thus making a new vers...