RE: dbms_support on 8i

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 02 Dec 2003 14:59:26 -0800
Message-ID: <F001.005D8713.20031202145926@fatcity.com>

I have it in 8i:
oracle_at_dvlpq1 [/home/admin/oracle]sqlplus "/ as sysdba"

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 2 17:56:01 2003

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL> desc dbms_support
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE START_TRACE_IN_SESSION
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT

PROCEDURE STOP_TRACE
PROCEDURE STOP_TRACE_IN_SESSION

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN

-Mark

-----Original Message-----

[mailto:Reginald.W.Bailey_at_jpmorgan.com]
Sent: Tuesday, December 02, 2003 5:49 PM To: Multiple recipients of list ORACLE-L

Jared:

You can't find it in Oracle8i? Probably because Oracle8i does not have dbms_support. I believe it was introduced in Oracle 9i Release 1.

RWB

Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) reginald.w.bailey_at_jpmorgan.com
baileyre_at_us.ibm.com

                                                                                                                              
                    Jared.Still_at_ra                                                                                            
                    disys.com            To:     ORACLE-L_at_fatcity.com                                                         
                    Sent by:             cc:                                                                                  
                    ml-errors_at_fatc       Subject:     dbms_support on 8i                                                      
                    ity.com                                                                                                   
                                                                                                                              
                                                                                                                              
                    12/02/2003                                                                                                
                    04:19 PM                                                                                                  
                    Please respond                                                                                            
                    to ORACLE-L

Does anyone know which patch level of 8i includes the dbmssupp.sql and .plb files?

I have databases here that are at 8.1.7.4, but the files are not there.

9i has them, but none of the 8i databases.

Thanks,

Jared

PS. Metalink was no help for this. Neither was google.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Reginald.W.Bailey_at_jpmorgan.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

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.net
--

Author: Bobak, Mark
INET: Mark.Bobak_at_il.proquest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message