oracle view

[Bob Dalek]

ok - so its not the view holding thigs up

can you query the user_views table?

Is that advisable? Given that the DBA is against seeing the SQL? I say don't, as it's an obvious try at circumvention. He will probably be watching out for this - if he's any good.

[Spacecadet]

Is that advisable? Given that the DBA is against seeing the SQL? I say don't, as it's an obvious try at circumvention. He will probably be watching out for this - if he's any good.

All he said was that the DBA won't supply the SQL, not that he can't

[Bob Dalek]

All he said was that the DBA won't supply the SQL, not that he can't

Yes. That'd sound very convincing if the w@nky DBA decides to play the "Security" card with the boss. 10 points.

[EternalOptimist]

ok - so its not the view holding thigs up

can you query the user_views table?

are you saying that there is a system table that will hold the views sql string ?
(if so, i am getting a stiffy)

[Spacecadet]

are you saying that there is a system table that will hold the views sql string ?
(if so, i am getting a stiffy)

yes

[EternalOptimist]

yes

and will it be in any sort of schema ? like dbo.


select * from dbo.user_views

[Bob Dalek]

are you saying that there is a system table that will hold the views sql string ?
(if so, i am getting a stiffy)

Any object's DDL:

SET SERVEROUT ON SIZE 1000000 LONG 1000000 PAGES 9999 LINES 200
execute dbms_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SE SSION_TRANSFORM,'SQLTERMINATOR',true);

SELECT DBMS_METADATA.GET_DDL('<object_type>','<object_nam e>','<owner>')
FROM DUAL;

The DBA may well dob you in.

[Spacecadet]

Any object's DDL:

SET SERVEROUT ON SIZE 1000000 LONG 1000000 PAGES 9999 LINES 200
execute dbms_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SE SSION_TRANSFORM,'SQLTERMINATOR',true);

SELECT DBMS_METADATA.GET_DDL('<object_type>','<object_nam e>','<owner>')
FROM DUAL;

The DBA may well dob you in.

Add the following to the statement:
/* if you spent your time helping rather than spying on me then I wouldn't have to do this */

include any choice swearwords as you see fit

[Bob Dalek]

Call the DBA "Burleson" - if he's got any current savvy, he'll be well pissed off.

[expat]

Is that advisable? Given that the DBA is against seeing the SQL? I say don't, as it's an obvious try at circumvention. He will probably be watching out for this - if he's any good.

I agree with that. Ask him (by email) to help. When he doesn't, go to the next contact point. Ask for the resources you need. Raise the slow response of the view (or its unsuitability for this requirement) as an issue.

You're still talking about the view as an issue at this stage, not the boneheadedness of the DBA. BTW if the DBA really is boneheaded, it will have been noticed already.