CTED] (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
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.oraf
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: Aponte, Tony
INET: [EMAIL
Title: RE: Veritas and disks
This note may describe the behavior you are observing.
www.sun.com/blueprints/0400/ram-vxfs.pdf
HTH
Tony Aponte
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 25, 2003 3:34 PM
To: Multiple recipient
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:40
PMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: SharePlex
info
Your bandwidth requirements will be the rate of
changes to the actual data. The traffic co
Title: Message
Your
bandwidth requirements will be the rate of changes to the actual data. The
traffic consists of the actual data and control information needed to reassemble
the transaction on the target. The source database's other redo payload
(i.e., index operations, rollback segment
Title: RE: Tracing a user session with multiple database connections
It may need some changes for the Alter Session syntax but the trigger should help you isolate the activity by these session.
HTH
Tony Aponte
CREATE OR REPLACE TRIGGER sys.trap_conversion_connect_trig
AFTER LOGON ON co
Title: RE: Veritas Quick I/O for Oracle
Dennis,
The benefits of QIO are realized not only by Oracle but also by the storage administrators. Oracle improvements come from kernelized async I/O, elimination of UNIX double-buffering and single-writer file header locking in the O/S. Storage ad
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: Aponte, Tony
INET: [EMA
Title: RE: a DIFFERENT sql question
SELECT DISTINCT
t1.category CAT
,t2.type TYP
,SUM(DISTINCT t1.amount1) OVER(PARTITION BY t1.category) Sum1
,SUM(t2.amount2) OVER(PARTITION BY t1.category, t2.type) Sum2
FROM
t1
,t2
WHERE
t1.mykey1 = t2.mykey1
/
CAT TYP SUM1
---
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
Title: RE: Rolling up Sums
create table genledg (budget number(4),week number(2)) tablespace tools
insert into genledg values (100,1)
insert into genledg values (100,2)
insert into genledg values (100,3)
insert into genledg values (100,4)
commit
Select sum(budget) over (order
Title: RE: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Soft
Would you happen to know how the software layer that combined LUNs to make it look like a large file system was enabled? We're experiencing similar issues with one of our Clarion arrays.
TIA
Tony Aponte
-Origina
uru') 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
Title: RE: urgent help: replication, shareplex
I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML o
Title: RE: using obfuscation
I was wondering if this was of any help.
Tony Aponte
-Original Message-
From: Aponte, Tony
Sent: Tuesday, September 17, 2002 7:04 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: using obfuscation
I&
Title: RE: Spool Oracle Tables into Excel Format
There were some posts recently suggesting the spooling of the columns using a comma as a separator. But check out this article in XML Journal (http://www.syntelinc.com/syntel/english/0072/SYNT_XMLjrnl.pdf). It shows how to build preformat
Title: RE: using obfuscation
I've been developing a solution for a similar requirement. Although I reached a dead-end with this thread I think it solves your problem.
I'm picking it up from the point where the data in encrypted_data of sensitive_table needs encryption. I did that with an an
Title: RE: Table Locks
Call me crazy if you wish. But I would take a process or system state dump and navigate the locking session's object hierarchy. Yes, I know, ugly as Sin and potentially life-shortening.
HTH
Tony Aponte
-Original Message-
From: Alan Davey [mailto:[EMAIL PR
Title: RE: Constraints problem
I
remember a Y2K testing parameter for setting the database date. It still
might work. Search for FIXED_DATE to see what NLS date format to
use.
HTH
Tony
Aponte
-Original Message-From: Karthikeyan S
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, S
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate "servers"? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child.
What
kind of SAN?
Tony
Aponte
-Original Message-From: Gulamabbas Sikiladha
[mailto:[EMAIL PROTECTED]]Sent:
Monday, August 26, 2002 3:08 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: DB Refreshes
Thanks for the response Dennis, I got a very good idea from your
Title: RE: Analyzing a Trigger for Performance
Hi Hannah,
Have you looked into the DBMS_PROFILER and DBMS_TRACE packages? They can be used to trace PL/SQL execution and performance.
Tony Aponte
Home Shopping Network, Inc.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[E
Here's
an answer I posted to a similar question a few weeks ago.
HTH
Tony
Aponte
I hope this is not to late for you. Anyway, this questions
comes up often. Below is the solution to pivot rows for up to 12 values of
field1. Just adjust to fit your range of values.
HTH Tony Aponte
, 2002
2:24 PMTo: Aponte, Tony; [EMAIL PROTECTED]Subject:
RE: db locking quandry
Can
you point me to the note on MetaLink that had this TCP
setting?
thx
bill
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 20, 2002 2:15
Title: RE: db locking quandry
We had a similar situation that ended up being a network setting issue. The server was showing blocking locks. It turned out to be that the client application was getting a network error. After the error it re-established the database connection and re-submitt
Title: RE: Delete performance
I would use your method to CTAS but combine it with partitioning in order to overcome the unavailability issue. The new table would be a single-partition (MAXVALUE) object that would enable the use of EXCHANGE feature. I posted a nugget a while back describing
I pivoted the result set on the
WO column. This example works for up to 12 distinct values for the CP
column. I don't know if you need to pivot it again to get back to the
original result set but at least it gives you the sort order you
described.
HTH
Tony Aponte
Home Shopping Network,
Title: RE: Select Query - Help required
I posted an answer on a similar question about 2 weeks ago. The underlying concept is how to pivot a result set. I've attached the thread below.
HTH
Tony Aponte
Home Shopping Network
-Original Message-
From: Aponte, Tony
Title: RE: SQL Query
I hope this is not to late for you. Anyway, this questions comes up often. Below is the solution to pivot rows for up to 12 values of field1. Just adjust to fit your range of values.
HTH
Tony Aponte
Home Shopping Network, Inc.
create table tab1 (field1 number,fiel
Title: RE: Where is Oracle 9.2 init.ora?
On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open
Performance Engineering Melbourne, 3000,
VIC, Australia Only
Robinson Crusoe had all his work done by Friday
-Original Message-----From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, 24 June 2002 7:58
AMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: V
Title: RE: SESSION_CACHED_CURSORS and shared_pool sizing.
I don't recall where I read this but I remember a few things about it. As you noted, the use of SESSION_CAHED_CURSORS has an impact on the UGA. If you are using MTS then that becomes part of the SGA in the shared pool (or large pool
Title: RE: Virtual drive on Solaris
Here is the command sample:
mount -f tmpfs -o size=800m swap /ramdisk
We use it to run a small database totally in memory. We decided that staying within the Oracle product suite was better for us vs. using a real memory-only rdbms. The mounting
I
would love to join a list were we can post all of the colossal dumb-isms emitted
by Oracle Support.
Tony
Aponte
-Original Message-From: Brian McGraw
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June
20, 2002 11:29 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: wha
Title: RE: DBMS_SYSTEM.KSDWRT question
We've been using KSDWRT in logon and table triggers (as well as in maintenance jobs for our 24x7 databases that didn't have a UTL_FILE_DIR entry) and have yet to encounter a problem. I trussed a background process that used the procedure and it wrote to
Title: RE: RE: Advance Oracle Trigger Writing Advice
Hi Hannah,
I think you could use a simpler feature to brute-force a trace of your trigger's execution path. The SYS.DBMS_SYSTEM.KSDWRT procedure provides output facilities for the alert.log and session trace files. SYS.DBMS_SYSTEM.KSDWR
Title: RE: Replication question
Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored.
Yet another is during
t will read the redo and produce
SQL. I'm surprised they haven't suggested it already...
:-)
----- Original Message -
From:
Aponte, Tony
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 8:47
AM
Subject: RE
One
more link with a complete package. http://www.quest-pipelines.com/Pipelines/PLSQL/archives.htm#code35
Tony
-Original Message-From: Aponte, Tony
Sent: Thursday, June 13, 2002 12:29 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: oracle error
logging
rk for the application. i.e. orders taken for our Order Entry app.,
packages shipped for Fulfillment, IVR calls, outbound calls placed,
etc.)
HTH
Tony
-Original Message-From: Vergara, Michael (TEM)
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 13, 2002 12:26
PMTo: Aponte, To
PL/SQL
Tips & Techniques from Oracle Press has a few sections that may
interest you. There's one on encapsulating exception blocks, with code to
set up an infrastructure for exception routines. Another good on is a
complete package to encapsulate UTL_FILE exception handling.
HTH
Tony
Ap
Title: RE: Management Reports
Is your management looking for real-time charts or are they looking for higher-level scorecard-like info (i.e.. number of transactions yesterday, last 7 days, yada yada yada?)
Tony Aponte
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL
Title: RE: oratcl
I use TCL/TK Tools by Mark Harrison. It has a chapter on Oratcl. There's also good information in the OEM's Intelligent Agent Users Guide.
HTH
Tony Aponte
-Original Message-
From: Arslan Bahar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:29 AM
Title: RE: Any Good , Complete Docs , Source , Links on OUTLN ?
Chapter 11 in Tom Kyte's Oracle one-on-one Export (start here if you can and save yourself time)
Metalink Note 92202.1 How To Specify Hidden Hints in SQL
Oracle Corporation paper by David McElhoes, Stabilizing Query Performance
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think Yechiel is referring to a statistical claim by Quest that only 30% of the redo stream is usable in re-assembling the SQL statement. The rest is like you suspect, index maintenance, rbs segment
Title: RE: Diagnose Slow System
I apologize if I missed the final post. Did you discovered the cause of the problem?
Tony Aponte
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Su
Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago
The
logs are usually located in /opt/openv/netbackup/logs. The instructions on
how to activate logging for each of the Netbackup components is in
/opt/openv/netbackup/logs/README.debug. The process you are looking to
debug is bpres
Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago
Netbackup has a repository that keeps track of what files are on which tapes, dates, sizes, volumes, serial number, etc. Depending on how you are restoring the files, Netbackup gets a request to get a file name (as it is know on tape
Title: RE: Wrong Results Bug in Oracle 8.1.7.1
We had a similar issue, although it always resulted in an ORA-600. It was with descending indexes as defined in the Peopletools repository. We had to set _IGNORE_DESC_IN_INDEX=TRUE (and _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply with the
sage, then we are in agreement.
regards,
Waleed
-Original Message-From: Aponte, Tony
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 10:16
AMTo: [EMAIL PROTECTED]Cc:
[EMAIL PROTECTED]Subject: RE: Complex Integrity
Checking
Sorry for the delaye
Title: RE: Complex Integrity Checking
Sorry for the delayed reply (I type with 2 fingers.) The section starts on page 685.
<<< rip >
Database Changes
Now, this is were things get interesting - database changes. Here, things can get a little murky. Database changes made, but not ye
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
I think they are alluding to UNIX file system contention. If the redo logs are in regular file systems (not raw, Veritas Quick I/O, etc.) then UNIX (at least in my Solaris environment) needs to lock th
only
the committed one. So no way to enforce business logic during the context of
the transaction.
This is why I asked before
how frequently commit happens.
Regards,
Waleed
-Original Message-From: Aponte, Tony
[mailto:[EMAIL
Title: RE: Complex Integrity Checking
With the introduction of Autonomous Transactions this is no longer entirely true. If you call an autonomous transaction procedure, it is executed in a separate transaction context. This gives you the ability to probe the mutating table without inducing
PROTECTED]]
- this really doesn't suit my needs, create 2 tables instead of one
========
Attn: DENNIS WILLIAMS [[EMAIL PROTECTED]], Aponte, Tony
[[EMAIL PROTECTED]]
- I did make a function:
FUNCTION check_for_overlap
Title: RE: Complex Integrity Checking
I would look into combining a before-insert row-level trigger with an autonomous transaction procedure. The procedure would execute the validating query using parameters passed by the trigger. If your new row values would cause an overlap then return a
Here's
a quick-n-dirty SQL that pivots the result set into one row. It has
its limits (you must know the number of rows that would be returned so that you
can adjust the grouping columns value01 through value12.
SELECT
g1
,MAX(DECODE(line_no,01,value,NULL)) value01
,MAX(DECODE(line_n
Title: RE:
There is a solution in Tom Kyte's Expert One on One book. It implements as SQL Loader in PL/SQL with UTL_FILE.
Tony Aponte
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 11:38 AM
To: Multiple recipients of list OR
Steve Adams' site is a good
start. http://www.ixora.com.au/
Tony Aponte
-Original Message-From: Anand Prakash
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17,
2002 5:29 PMTo: Multiple recipients of list
ORACLE-LSubject: Script for identifying objects having freelists
al ORACLE-L FAQ: http://www.orafaq.com
--
Author: Aponte, Tony
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To
I
think you are running into the stampeding herd phenomenon. I'm
suspicous of the low value for the spin count. It seems timid.
Could you truss one of the shadow processes with the timing option and post the
output? Just enough to identify the repeating pattern. Also, please
run the tr
Title: RE: How to test BCV and backups
Are you going to use RMAN or only OS utilities?
Tony Aponte
-Original Message-
From: Seppo Kaasalainen [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Subject: How to test BCV and
Title: RE: EMC's DBTuner
We've been using Precise/SQL since its early days. We also are using DBTuner for our servers that have Symmetrix devices attached. As far as we know it attaches to the SGA for read-only but you can probably verify that with pmap. But we've never had any problems wit
We
have several 2-way VCS clusters with 16 and 10 CPU's per server. We found
that the failover time was proportionate with the number of file systems that
need to be mounted by the take-over node. We consolidated the file systems
containing the datafiles down to 1 and each database takes 2
ion that I had posted
previously:
"Aponte,
Tony"
<[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Could it be that the standby is
auto-registering itself with the listener for the production database?
We've had a couple of incidents where a development DBA copied the init.ora file
from a production database configured for MTS. But the listener
parameters were not changed and all new co
Title: RE: How to make deletes faster.
How are you selecting the rows to be deleted? Is it in one cursor driving a loop with incremental commits or is it done via batch cycles of 10,000-row delete ... from ...where commit; delete ... from ...where commit; .?
Tony Aponte
-Or
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database
I have an idea for a poor man's version of what you are looking for. Turn on listener logging to a level high enough where you can see the text of the net traffic. With some creativity or a copy of Sed & Awk you'll be
Title: RE: Help !! Password Encryption/decryption ??
How about right-padding the string to a multiple of 8 bytes. I think 8-MOD(LENGTH(string),8) will give you the number of characters to use in RPAD(string,...). E.I.. to pad with blanks:
SELECT RPAD('123456789',LENGTH('123456789') + 8
Title: RE: Where does a DBA go from here?
I haven't read the Tuning 101 but it sounds like it lets you know where you are waiting. The Internals book will give you in-depth knowledge of why by diving deeper into some of the algorithms used to implement those waits. Break out the aspirin 'ca
' AS "12345678901234567890" FROM DUAL
Tony Aponte
-Original Message-
From: Aponte, Tony
Sent: Friday, February 08, 2002 11:32 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Help !! Password Encryption/decryption ??
How about ri
Title: RE: HOW TO KNOW INDEX NOT IN USE?
Nope. Same behavior for me.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: HOW TO KNOW INDEX NOT IN USE?
Can anyone
Title: RE: HOW TO KNOW INDEX NOT IN USE?
Another option you have if your Oracle version is high enough is to use Stored Outlines. Enable automatic generation of stored outlines for a full processing cycle as defined by the application (full month, Qtr, etc.) Then extract all of the indexes
Title: RE: How can i receive name of the running procedure
Take a look at DBMS_UTILITY.FORMAT_CALL_STACK. You can parse out the caller from the return value. Here's a short example of an anonymous block:
DECLARE
stack_info VARCHAR2(4096);
BEGIN
stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK
Title: RE: Hm
What you are observing is the concurrency mechanism as implemented in the Oracle rdbms. I couldn't explain it better in an email so I suggest you get a hold of Expert One-on-one Oracle by Thomas Kyte, chapter 3 on Locking and Concurrency. Another thought I have is that it
Title: RE: Hm
I just had another idea. Maybe you can use UPDATE SET =+1 RETURNING INTO instead of the SELECT FOR UPDATE. This will add 1 to the current value and return the result to the caller.
Tony Aponte
-Original Message-
From: Aponte, Tony
Sent: Friday, January 25
Title: RE: SPACE FREE HOW?
Nick,
I have
a question regarding LiveReorg's method that prevents modifications to the
original table when it's time to switch to the newly reorged one. AS the
mechanism to prevent DML, LiveReorg creates a temporary trigger
on Insert, Update and Delete. It simp
Title: RE: Freeable memory
Hi Mike,
I did a test on one of our 7.3 databases. It seems that some (but not all) freeable chunks get coalesced by flushing the shared pool. I tested it on a database with no other users logged in and took before/after pictures of the chunk breakdown.
SQL> se
ary 16,
2002 5:54 PMTo: Aponte, Tony;
[EMAIL PROTECTED]Subject: RE: How to calculate user load on the
system
Database Load ... is the main target at this time
...
Thanks Tony,
Raj
__
Rajendra
Jamadagni
MIS,
Title: RE: How to calculate user load on the system
Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)?
Tony
-Or
Title: Socket directory under solaris
Try
/ver/tmp/.oracle
Tony
Aponte
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 14, 2002 9:00
AMTo: Multiple recipients of list ORACLE-LSubject:
Socket directory under solaris
Un
Title: RE: VLDB backup policy
What type of application is it (OLTP, DSS, mixed, etc.)? Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)?
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL PROTECTED
Title: Install of two client versions on same box
This
is very easy if you follow OFA standards for software installation. The
different versions are installed as sub-directories of the $ORACLE_BASE
directories (i.e... /oracle/app/oracle/product/8160,
/oracle/app/oracle/product/8172). You
Title: RE: Lookup table design thoughts needed
I would start by considering how the application is deployed. For code that is easily deployed (E.I.. executables are located on a few application servers or a shared drive) I would consider compiling the rule data along with the logic. It gene
From: Aponte, Tony
Sent: Tuesday, December 11, 2001 12:21 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: sql query
add NULLS FIRST after the ORDER BY CAR_MAKE:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
Title: RE: sql query
add NULLS FIRST after the ORDER BY CAR_MAKE:
select
to_number(null) as id,
to_char(null) as car_make
from
dual
union
select
id,
car_make
from
carmake
order by
car_make NULLS LAST;
Tony Aponte
-Original Message-
From: Steven Hoving
Title: Help in deciphering the values for flag in systemstate dump
I'm troubleshooting a discrepancy between v$session_wait and Precise/SQL 3.1. Oracle reports that sessions waiting on "SQL*Net message from client" but the tool shows some of them in MTS wait. Since Precise/SQL parses the SG
Title: RE: Retek ERP & ORacle
Yes. Still on 7.3.4.
-Original Message-
From: MRaval [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Retek ERP & ORacle
Anyone in this forum working with Retek ERP. Thanks.
Title: RE: CROSS TAB QUERY
I gave it a whack and came up with the following solution (I needed the distraction). For demo purposes each statement build upon the previous ones. But first a little reality. There are some problem boundaries that can be declared. The first one is that there a
Title: RE: Email through trigger
UTL_SMTP.
-Original Message-
From: Aldi Barco [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Email through trigger
Hi Listers,
What is the oracle procedure / package to
Title: RE: CROSS TAB QUERY
What Oracle version? Also, is the requirement for pure SQL or can there be some PL/SQL?
Tony Aponte
-Original Message-
From: Moses Ngati Moya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 3:15 AM
To: Multiple recipients of list ORACLE
DBA
group.
Tony
Aponte
-Original Message-From:
YTTRI Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 21,
2001 10:59 AMTo: Aponte, Tony;
'[EMAIL PROTECTED]'Subject: RE: Oracle and
MQ
Tony
-
Do
you have error handling built in to your VB program,
Title: RE: Oracle and MQ
I believe Oracle sells an MQ-to-AQ bridge that just moves messages between queuing systems. We use VB to pull messages out of MQ and issue SQL to get it into the database.
HTH
Tony Aponte
-Original Message-
From: YTTRI Lisa [mailto:[EMAIL PROTECTED]]
Se
Title: RE: exp a big tablespace
Here's a tip I mined many moons ago from I don't know where. It's a script to split the compressed file into smaller chunks using the standard UNIX split utility.
HTH
Tony Aponte
January 16, 1998
Exporting a Database That's More Than 2GB When Comp
Title: RE: Internal Benchmarking
I've had some luck with the tools described in Scaling Oracle8i by Morle. It has and awk script to parse out 10046 event trace sql and bind variable information and produce a tcl script suitable for dbaman. Dbaman is an extended tcl shell sotra-likea oratcl.
Title: RE: Oracle Text (ConText/InterMedia) and realtime updates
I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX.
Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your r
Title: RE: Sockets and Pl/SQL
Tom Kyte's book Expert One On One Oracle has a very informative chapter on using UTL_TCP. Well worth the $ for this chapter alone. We had a developer waste the company's time trying to create the same functionality using external procedures.
HTH
Tony Aponte
E would do but I wouldn't go that route.
-Original Message-
From: H elp_me [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 3:38 PM
To: Aponte, Tony; [EMAIL PROTECTED]
Subject: RE: Works interactively but not in procedure
Hello Tony,
I tried with 'authid curr
Title: RE: Works interactively but not in procedure
This is a privilege issue. The stored proc runs with the security of the connected user except for those inherited via roles. Try adding the pragma for current user as follows to see if this is what you want:
CREATE OR REPLACE
procedure
1 - 100 of 130 matches
Mail list logo