|
|
|
|
|
|
| Author |
Message |
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
 Posted: Fri Feb 04, 2005 6:19 pm Post subject:
Re: Workspace Manager question
|
|
|
NowhereMan wrote:
| Quote: | You need to be in SQL*Plus as all of my demos assume that
as the tool in use. At the UW we don't let students use
any GUI tools so that they will be as proficient on a
*NIX machine as on Windoze.
Same result:
SQL> @c:\temp\ex.sql
dbms_wm.GetSessionInfo(current_workspace,current_context,current_context_typ
e);
*
ERROR at line 6:
ORA-06550: line 6, column 9:
PLS-00302: component 'GETSESSIONINFO' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
SQL
|
What permissions have been granted to the user? And were they
granted explicitly or through a role?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
 |
NowhereMan
*nix forums beginner
Joined: 02 Feb 2005
Posts: 4
|
| Posted: Fri Feb 04, 2005 11:46 am Post subject:
Re: Workspace Manager question
|
|
|
| Quote: | You need to be in SQL*Plus as all of my demos assume that
as the tool in use. At the UW we don't let students use
any GUI tools so that they will be as proficient on a
*NIX machine as on Windoze.
|
Same result:
SQL> @c:\temp\ex.sql
dbms_wm.GetSessionInfo(current_workspace,current_context,current_context_typ
e);
*
ERROR at line 6:
ORA-06550: line 6, column 9:
PLS-00302: component 'GETSESSIONINFO' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
SQL> |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Fri Feb 04, 2005 2:12 am Post subject:
Re: Workspace Manager question
|
|
|
NowhereMan wrote:
| Quote: | Thanks, that looks very interesting.
I'm trying to run portions of your demo in SQL*Plus Worksheet.
This runs as expected:
SELECT owner, workspace, parent_workspace
FROM user_workspaces;
As does this:
execute dbms_wm.RemoveWorkspace('TryOut2', TRUE);
When I try this snippet, however,
set serveroutput on
DECLARE
current_workspace VARCHAR2(30);
current_context VARCHAR2(30);
current_context_type VARCHAR2(30);
BEGIN
dbms_wm.GetSessionInfo(current_workspace,current_context,
current_context_type);
dbms_output.put_line('Session currently in workspace: '
|| current_workspace);
END;
I get the error
dbms_wm.GetSessionInfo(current_workspace,current_context,
current_context_type);
*
ERROR at line 6:
ORA-06550: line 6, column 9:
PLS-00302: component 'GETSESSIONINFO' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
Why is GetSessionInfo unrecognized?
Thanks for your help.
The best way I can think of is to read the concept docs
at http://tahiti.oracle.com and run the full demo at
http://www.psoug.org ... click on Morgan's Library ...
click on Workspace Manager.
|
You need to be in SQL*Plus as all of my demos assume that
as the tool in use. At the UW we don't let students use
any GUI tools so that they will be as proficient on a
*NIX machine as on Windoze.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
NowhereMan
*nix forums beginner
Joined: 02 Feb 2005
Posts: 4
|
| Posted: Thu Feb 03, 2005 11:57 am Post subject:
Re: Workspace Manager question
|
|
|
Thanks, that looks very interesting.
I'm trying to run portions of your demo in SQL*Plus Worksheet.
This runs as expected:
SELECT owner, workspace, parent_workspace
FROM user_workspaces;
As does this:
execute dbms_wm.RemoveWorkspace('TryOut2', TRUE);
When I try this snippet, however,
set serveroutput on
DECLARE
current_workspace VARCHAR2(30);
current_context VARCHAR2(30);
current_context_type VARCHAR2(30);
BEGIN
dbms_wm.GetSessionInfo(current_workspace,current_context,
current_context_type);
dbms_output.put_line('Session currently in workspace: '
|| current_workspace);
END;
I get the error
dbms_wm.GetSessionInfo(current_workspace,current_context,
current_context_type);
*
ERROR at line 6:
ORA-06550: line 6, column 9:
PLS-00302: component 'GETSESSIONINFO' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
Why is GetSessionInfo unrecognized?
Thanks for your help.
|
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Thu Feb 03, 2005 7:01 am Post subject:
Re: Workspace Manager question
|
|
|
GreyBeard wrote:
| Quote: | On Wed, 02 Feb 2005 19:45:05 -0800, DA Morgan wrote:
Get out of EM and you'll find there are a few materialized views and
other objects too. Creating a workspace creates a lot of objects.
Which, IIRC, you can see using the schema capabilities of EM.
I don't quite follow the reason for your 'get out of EM' comment. Care to
expand on it?
/FGB
|
I was just assuming since you refered only to the views you couldn't
see the other objects. As I don't use EM I couldn't quickly check it
out. No angst intended.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
| Posted: Thu Feb 03, 2005 4:13 am Post subject:
Re: Workspace Manager question
|
|
|
On Thu, 03 Feb 2005 05:11:30 +0000, GreyBeard wrote:
| Quote: | On Wed, 02 Feb 2005 19:45:05 -0800, DA Morgan wrote:
Get out of EM and you'll find there are a few materialized views and
other objects too. Creating a workspace creates a lot of objects.
Which, IIRC, you can see using the schema capabilities of EM.
I don't quite follow the reason for your 'get out of EM' comment. Care to
expand on it?
/FGB
|
BTW: My comment based on OEM9i. |
|
| Back to top |
|
|
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
| Posted: Thu Feb 03, 2005 4:11 am Post subject:
Re: Workspace Manager question
|
|
|
On Wed, 02 Feb 2005 19:45:05 -0800, DA Morgan wrote:
| Quote: |
Get out of EM and you'll find there are a few materialized views and
other objects too. Creating a workspace creates a lot of objects.
|
Which, IIRC, you can see using the schema capabilities of EM.
I don't quite follow the reason for your 'get out of EM' comment. Care to
expand on it?
/FGB |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Thu Feb 03, 2005 2:45 am Post subject:
Re: Workspace Manager question
|
|
|
GreyBeard wrote:
| Quote: | On Wed, 02 Feb 2005 18:50:17 -0500, NowhereMan wrote:
Hello,
I'm reading the "Oracle Workspace Manager Dev Guide", and came across this:
"A workspace logically groups collections of
new row versions from one or more version-enabled tables, and isolates these
versions until they are explicitly merged with production data or discarded,
thus
providing maximum concurrency."
Can someone help me understand how a workspace could have rows from more
than one table? How would the workspace get populated?
Thanks for any insight...
Create a schema with one table, fire up Oracle Enterprise Manager 9i,
create a workspace and enable the table in the workspace. Look at the
resulting schema.
You will find that the table gets replaced by a view that maps to the
table. With the addition of a few columns and supporting info, you can
now simulate a table that supports 'named versions' of rows. With a few
added packages you can now simulate commits, rollbacks, etc. for
transactions that persist across logoffs
lol/FGB
|
Get out of EM and you'll find there are a few materialized views and
other objects too. Creating a workspace creates a lot of objects.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
| Posted: Wed Feb 02, 2005 11:50 pm Post subject:
Re: Workspace Manager question
|
|
|
On Wed, 02 Feb 2005 18:50:17 -0500, NowhereMan wrote:
| Quote: | Hello,
I'm reading the "Oracle Workspace Manager Dev Guide", and came across this:
"A workspace logically groups collections of
new row versions from one or more version-enabled tables, and isolates these
versions until they are explicitly merged with production data or discarded,
thus
providing maximum concurrency."
Can someone help me understand how a workspace could have rows from more
than one table? How would the workspace get populated?
Thanks for any insight...
|
Create a schema with one table, fire up Oracle Enterprise Manager 9i,
create a workspace and enable the table in the workspace. Look at the
resulting schema.
You will find that the table gets replaced by a view that maps to the
table. With the addition of a few columns and supporting info, you can
now simulate a table that supports 'named versions' of rows. With a few
added packages you can now simulate commits, rollbacks, etc. for
transactions that persist across logoffs
lol/FGB |
|
| Back to top |
|
|
DA Morgan
*nix forums Guru
Joined: 06 Mar 2005
Posts: 1042
|
| Posted: Wed Feb 02, 2005 11:22 pm Post subject:
Re: Workspace Manager question
|
|
|
NowhereMan wrote:
| Quote: | Hello,
I'm reading the "Oracle Workspace Manager Dev Guide", and came across this:
"A workspace logically groups collections of
new row versions from one or more version-enabled tables, and isolates these
versions until they are explicitly merged with production data or discarded,
thus
providing maximum concurrency."
Can someone help me understand how a workspace could have rows from more
than one table? How would the workspace get populated?
Thanks for any insight...
|
The best way I can think of is to read the concept docs
at http://tahiti.oracle.com and run the full demo at
http://www.psoug.org ... click on Morgan's Library ...
click on Workspace Manager.
Seeing with your own eyes is a good way to understand the functionality.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond) |
|
| Back to top |
|
|
NowhereMan
*nix forums beginner
Joined: 02 Feb 2005
Posts: 4
|
| Posted: Wed Feb 02, 2005 10:50 pm Post subject:
Workspace Manager question
|
|
|
Hello,
I'm reading the "Oracle Workspace Manager Dev Guide", and came across this:
"A workspace logically groups collections of
new row versions from one or more version-enabled tables, and isolates these
versions until they are explicitly merged with production data or discarded,
thus
providing maximum concurrency."
Can someone help me understand how a workspace could have rows from more
than one table? How would the workspace get populated?
Thanks for any insight... |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 1:39 am | All times are GMT
|
|
Car Loan | Mortgages | Debt Help | Mortgages | MPAA
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
