SQL for workspace enablement

As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or SQL Plus:

begin
owbsys.wb_workspace_management.set_workspace('workspacename', 'workspaceowner');
owbsys.start_enable_owb_roles;
end;

Replace the italics for workspacename and workspaceowner with the name of your workspace and the name of the owner (or user of) the workspace.

Now you can do what you need in direct access tools like SQL Plus...

Comments:

Post a Comment:
Comments are closed for this entry.
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today