| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL Editor
I am getting this error: ORA-01731
Saying that I can't do it because of circular view, I can't create a view from another view;
What's the workaround?
Denis Vasconcelos
DBA - Fábrica de Software
Portais Brasil Tecnologia S.A.
( 0 XX 81 3465 - 3211 Ramal 37
* Denis.Vasconcelos_at_pbt.com.br
Bill,
You said "One note about the Freeware version of TOAD - it has some internal
thing
that limits it to 5 concurrent connections to the same db, which is a
problem for us in a dev shop."
I got around this by replacing the v$session view with the following: Note the "REPLACE" statement in the select for the PROGRAM and MODULE columns:
CREATE OR REPLACE VIEW V$SESSION ( SADDR,
SID, SERIAL#, AUDSID, PADDR,
USER#, USERNAME, COMMAND, OWNERID,
TADDR, LOCKWAIT, STATUS, SERVER,
SCHEMA#, SCHEMANAME, OSUSER, PROCESS,
MACHINE, TERMINAL, PROGRAM, TYPE,
SQL_ADDRESS, SQL_HASH_VALUE, PREV_SQL_ADDR, PREV_HASH_VALUE,
MODULE, MODULE_HASH, ACTION, ACTION_HASH,
CLIENT_INFO, FIXED_TABLE_SEQUENCE, ROW_WAIT_OBJ#, ROW_WAIT_FILE#,
ROW_WAIT_BLOCK#, ROW_WAIT_ROW#, LOGON_TIME, LAST_CALL_ET,
PDML_ENABLED, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER,
RESOURCE_CONSUMER_GROUP, PDML_STATUS, PDDL_STATUS, PQ_STATUS
) AS SELECT
SADDR
, SID
, SERIAL#
,AUDSID
,PADDR
,USER#
,USERNAME
,COMMAND
,OWNERID
,TADDR
,LOCKWAIT
,STATUS
,SERVER
,SCHEMA#
,SCHEMANAME
,OSUSER
,PROCESS
,MACHINE
,TERMINAL
,REPLACE(UPPER(PROGRAM),'TOAD','FROG') PROGRAM
,TYPE
,SQL_ADDRESS
,SQL_HASH_VALUE
,PREV_SQL_ADDR
,PREV_HASH_VALUE
,REPLACE(UPPER(MODULE),'T·O·A·D·','F~R~O~G') MODULE
,MODULE_HASH
,ACTION
,ACTION_HASH
,CLIENT_INFO
,FIXED_TABLE_SEQUENCE
,ROW_WAIT_OBJ#
,ROW_WAIT_FILE#
,ROW_WAIT_BLOCK#
,ROW_WAIT_ROW#
,LOGON_TIME
,LAST_CALL_ET
,PDML_ENABLED
,FAILOVER_TYPE
,FAILOVER_METHOD
,FAILED_OVER
,RESOURCE_CONSUMER_GROUP
,PDML_STATUS
,PDDL_STATUS
,PQ_STATUS FROM sys.V_$SESSION
-bill
-----Original Message-----
Sent: Wednesday, August 28, 2002 8:18 AM
To: Multiple recipients of list ORACLE-L
PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL Editor
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
oharel_at_barak013.net.il
-----Original Message-----
[mailto:cosltemp-g.manoj_at_orbitech.co.in]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi All,
which is the best PL/SQL editor available as a trial version .
the editor should support Oracle sql,PL/SQL and may or may not
support debugging.
The tool should be support Win 9X OS and provide best
performance .
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda INET: j.miranda_at_sermatica.es Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: Bill.Magaliff_at_lendware.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: NDATFM_at_labor.state.ny.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denis Vasconcelos INET: denis.vasconcelos_at_pbt.com.br Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 28 2002 - 12:38:35 CDT
 |
 |