Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtp\sql\delete_warehouse_object.sql
rem rem This script can be used to delete a Warehouse Object. rem rem USAGE rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege rem rem @<OWB-HOME>/owb/rtp/sql/delete_warehouse_object.sql <object-name> <location-name> <workspace> rem rem This script deletes the object with the given name from the given location. rem rem The given workspace is the one in which the object was deployed rem <workspace> should be declared as workspaceOwner.workspaceName rem if only workspaceName is given, workspaceOwner will be defaulted to user rem set serveroutput on; set echo off set verify off define OBJECT = &1. define STORE = &2. define WORKSPACE = &3. set role OWB_USER; call owbsys.wb_rt_script_util.set_workspace('&WORKSPACE.'); declare begin owbsys.wb_rt_script_util.delete_warehouse_object('&OBJECT.','&STORE.'); end; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de