Welcome to All Things Warehouse Builder
-
Metadata
September 3, 2008
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...
Be the first to comment
Comments ( 0 )