AK, this is a very old script.
set pagesize 999
spool extent.lst
ttitle 'Database Objects that will have Trouble Throwing Extents'
column owner format a10;
column segment_name format a22;
column segment_type format a10;
column tablespace_name format a14;
column next_extent format
For something a little different, play with the attached free.sql script.
-Original Message-
where can i find a script to find segments which can't extend due to low of
space in tablespace .
-ak
free.sql
Description: Binary data
Here is a start for you. You can get the sleep command at any of these
places
http://www.weihenstephan.de/~syring/win32/UnxUtils.html
http://www.cruzio.com/~jeffl/mrtg/docs/sleep.exe
http://www.nextgeneration.dk/gnu/index.shtml
@ECHO OFF
set
Script would be good for this kind of thing, I think. Dig how similar this
windows scripting host script is to your pseudocode:
'
Dim FSO
Const WatchForFile = c:\pretend.txt
Const CopyFileTo = c:\copied.txt
Set FSO =
Hi Sami
Try something like this in korn shell, i have typed it in from memory so
please check the syntax...:-)
#!/bin/ksh
location=/tmp
filename=YOURFILENAME
done=false
while [[ $done = false ]]; do
if [[ ! -a $filename ]]; then
echo do something
cp
Here's what I use. Pretty basic (crappy) but may be a starting point for
you. You'll have to go through and change where you alert files are stored
and to whom to send the email. I schedule them to run about every 15
minutes. blat is a mail utility you can downloaded from the internet.
Check Tim Gorman's web site, http://www.evdbt.com/tools.htm. He has a script
(chk_oerr.sh) to monitor alert.log for new ORA- errors and e-mail.
You can see how it is done and come up with your own version for your own
requirements.
- Kirti
-Original Message-
Sent: Friday, March 21,
You can try a korn shell script called chkdberr.ksh at
http://www.appsdba.com/scripts/chkdberr.ksh, it's already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone have a simple script to scan an alert
log for errors and email a report if found?
Customer wants something to
Here a fast little script I wrote that can
be ran every minute
Emails only when it finds a new message
And pages if it finds a new message
between 6pm and 5am
FPATH=/prod/dba/scr
autoload f_xmail
logfile=/prod/dba/logs/`cat
/prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log
Andy:
This is a very cool script.
Thanks very much!!
Barb
--- Andy Rivenes [EMAIL PROTECTED] wrote:
You can try a korn shell script called chkdberr.ksh
at
http://www.appsdba.com/scripts/chkdberr.ksh, it's
already got the email
built in.
At 10:39 AM 3/21/2003 -0800, you wrote:
Anyone
Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options
In my previous message, I forgot to say:
You could always use the scorched earth approach and change everyone's
password. Then see who complains that they can't log in. :)
-Original Message-
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version
2.3.4.0.0.
I have a
I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6
Solaris.
You should be warned that on a couple of different occasions (I'm a slow
learner)
when I launched a SQL script which changed AUDITing on hundreds of objects,
Oracle went bonkers. It appearded as though the
I'm sure many of you have scripts to recreate an Oracle schema including
objects (i am interested in tables, indexes , comments, views,
sequences,
triggers, stored procs/functions etc..)
exp userid=system/manager file=schema.dmp rows=n owner=scott
vi schema.dmp
Instead of vi schema.dmp
Yes. And bvi for binary files.
-Original Message-
Sent: Thursday, December 26, 2002 2:04 AM
To: Multiple recipients of list ORACLE-L
exp userid=system/manager file=schema.dmp rows=n owner=scott
vi schema.dmp
really.
Jared
On Wednesday 25 December 2002 09:53, Andrey Bronfin wrote:
exp userid=system/manager file=schema.dmp rows=n owner=scott
vi schema.dmp
really.
Jared
On Wednesday 25 December 2002 09:53, Andrey Bronfin wrote:
Dear gurus !
I'm sure many of you have scripts to recreate an Oracle schema including
objects (i am interested in tables, indexes , comments,
If that's one of my scripts, RCS says it's from 1997.
Here's a newer one. It gets *everything* in the database, so
a little tweaking may be in order.
Jared
===
-- showspace_all.sql
-- use dbms_space to show exact amount
-- of space consumed by
searching in google for
script compare two schemas oracle
gives as the 6th result
http://www.arrowsent.com/oratip/tip15.htm
that may be sufficient in your case
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Attached..
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===
Hi!
Does anybody out there have a script that allows me
to compare two schemas
in two different databases (i.e. development and
production db)?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
There's something in the DBA tool kit at http://www.oriole.com. Forgot the exact name.
Regards,
Title: script for comparing two schemas in two databases
Hi Helmut,
There are some tools for it. For example, Oracle
Change Manager Pack for OEM.
This is a tough task for script, because too many
factors are involved.
HTH,
Alexandre
- Original Message -
From:
Daiminger,
Thanks for the script Mark!
Dave
-Original Message-
Sent: Wednesday, May 29, 2002 4:53 AM
To: Multiple recipients of list ORACLE-L
Attached..
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F:
OEM's Change Management pack does just that. It also allows you to
compare it with previous snapshots and implement them into production in
a scheduled, controlled manner.
Regards,
Michael Sale
Co-author: Oracle 9i on Windows 2000 Tips and Techniques
-Original Message-
Helmut
Sent:
Title: script for comparing two schemas in two databases
Years
ago, I found a script on Metalink that worked decently after a few bug
fixes. It was written by Ottar Sorland for use withOracle 7.3.
I still occasionally use it and cansend my patched (but still not perfect)
version if youneed
The Oracle Enterprise Manager 'Change Manager' does a good job of schema
comparisons, and has an easy point-and-click interface that shields you from
having to know what you're doing ;-)
The downside is that it can be a pain to get oem set up and working. I've never
tried it's more advanced
Kevin,
You should download the ver 7.3 of TOAD. It has a lot of improvements
that You might find handy.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 05/29/02 01:24PM
Years ago, I found a script on Metalink that worked decently after a
few bug fixes. It was written by Ottar Sorland for use with Oracle
I came to that conclusion as well. I especially like the fact that it even
creates a sync script after the compare.
I just used it on two of our DBs. Worked great.
-Original Message-
Sent: Wednesday, May 29, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Kevin,
You should
Arun,
Here are a couple of files (a .bat and .sql) that let me maintain a
constant number of Archived Redo Logs online.
The first batch file executes SQL*Plus to produce two other batch files to
delete the excess logs and move some others, maintaining, in this case
about 450 logs. It ran every
How is this essentially different than what you can get from utldtree.sql?
when Kevin Loney and I were writing the Annotated Archives a few years ago, I
tried to write a script that would show the dependencies, because part of the
reason for the book was to provide home-grown scripts that wre
Great minds think alike? Either that or we are the
borg and just don't know that we are part of the
collective yet.
--- [EMAIL PROTECTED] wrote:
How is this essentially different than what you can
get from utldtree.sql?
when Kevin Loney and I were writing the Annotated
Archives a few
create table depends as select * from
sys.dba_dependencies;
Depends? Like the adult diaper?
Doing a little CYA?
Jared
Jack Silvey [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/09/2002 04:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
Aw, DANG, I knew I was gonna get that one. Same story,
give someone a script named after an adult
incontenence device, get ready for the teasing!
Don't even ask for the viagra script.
--- [EMAIL PROTECTED] wrote:
create table depends as select * from
sys.dba_dependencies;
Depends? Like
Subject: RE: Script for identifying
objects having freelists contention
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
LE-L
Sent: Thursday, April 18, 2002 8:13
AM
Subject: RE: Script for identifying
objects having freelists contention
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,
20
I hope it works for
you.
set Trimspool onset Line 132set Pages
57set Newpage0set FeedBack offset Verify offset Term
offTTitle offBtime offcolumn Pct Format 990.99 Heading "%
Of |Free List Waits"column Instance New_Value
_Instance NoPrintcolumn Today New_Value _Date No
Printselect
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
I don't have one, but would love to have one. ( hint, hint )
Jared
On Tuesday 19 February 2002 03:28, John Dunn wrote:
Anyone got a script that will drop table constraints which have system
generated names and recreate them with names based upon the table name?
John
--
Please see the
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 1:28 PM
List,
i just finished writing a script to generate random data to populate
tables for load testing... the script takes into account the check
constraint
of a
Rahul,
This certainly is a good thing to have. Why not upload on a site for easy
access.
Aleem
-Original Message-
Sent: Monday, February 18, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Subject:script to populate tables, i just wrote one
List,
i just finished
Title: RE: script to kill session
if you want to do this interactively you might also want to
have a look at a small shareware win32 tool called osession at
http://www.materialdreams.com/oracle/products.html
D
-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent
Here is a shell script I use in UNIX, restrict_and_kill. I included the sql
command to build the sql with the kill commands, killuser_build. It
excludes users with restricted session access and puts the database into
restricted session mode. You can modify these scripts to suit your needs.
You really need to ask this on a Perl list or in one
of the ontopic usenet Perl forums.
Check www.perl.com.
Jared
Nguyen, David M [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/08/02 08:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL
How
could this be user proof? You are essentially disabling the constraint that WILL
enforce data integrity, then letting the user input whatever rubbish he wants
to, and are then going to try and enable the constraint
afterwards?
Not a
good approach.. How can you ensure that the user
If the old and new data are both intended to be valid
- why do you need to disable the constraint?
If its a referential integrity issue - maybe a
deferrable constraint (8.0+) is what you are after.
hth
connor
--- David Wagoner [EMAIL PROTECTED]
wrote: Listers,
Does anyone have a script
]]Sent: 28 November 2001
10:20To: Multiple recipients of list ORACLE-LSubject:
RE: Script to Disable Constraint, Change Value, then Enable
Constrain
How
could this be user proof? You are essentially disabling the constraint that
WILL enforce data integrity, then letting the user input
recipient(s), please
immediately notify the sender at (919) 941-4645 and delete this e-mail message
from your computer. Thank you.
-Original
Message-
From: Mark Leith
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001
5:20 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE
: RE: Script to Disable
Constraint, Change Value, then Enable Const
I can see the
confusion here. The point is not
to let someone enter data
that would
violate the referential integrity.
Let me explain with an
example:
1.
User wants to
update a primary key record
:
Sent by: rootSubject: RE: Script to Disable
Constraint,
Change Value, then Enable Const
11/28/2001
As far as I remember, there is such a script at http://www.oriole.com,
in the X-rated section - as the name implies, not full-heartedly
recommended.
--
Regards,
Stephane Faroult
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax:+44 (0) 7050-696-449
Performance Tools Free Scripts
I have
had the same type of requirement and decided to use deferrable constraints.
Works
great!
Rick
-Original Message-From: Igor Neyman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28, 2001
11:56 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: Script
Message-
From: Cale, Rick T (Richard)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001
12:29 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const
I have had the same type
of requirement and decided to use deferrable
David,
You
need a semi-colon after line2 i.e., update table1 ...;
Rick
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 28,
2001 1:16 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Script to Disable Constraint, Change
: Wednesday, November 28, 2001
2:35 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const
David,
You need a semi-colon
after line2 i.e., update table1 ...;
Rick
-Original Message-
From: David Wagoner
[mailto:[EMAIL
1:15 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Script to Disable Constraint, Change Value,
then Enable Const
Rick,
thanks for your input. When I
test the deferred constraint in SQL*Plus I get an error. What am I doing wrong? I did not find much information
Try this query to show objects whose next extent is larger than the largest
free extent in the respective tablespace.
set linesize 120
col owner format a10
col segment_name format a20
col type format a7
col tablespace format a15
select a.tablespace_name tablespace,
segment_type
,
New Bee
-Original Message-
From: Molina, Gerardo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Script for next_extent
Hi,
I have this Space Bound object script that will list every table that can
not allocate it's next extent. It will not list tables in tablespace that
is set to autoextent.
This is not entirely correct as you may have set an upper limit to the auto
extent (if you feel like adding it in please
try this query:
SELECT s.username, s.serial#, s.sid, u.tablespace, u.contents, u.extents,
u.blocks
FROM v$session s, v$sort_usage u
WHERE s.saddr=u.session_addr;
Lucy
On Mon, 10 Sep 2001, Jenkins, Michael wrote:
Does anybody have a script that will tell you which session_ids are using
Michael -
I've had similar problems (although the pain isn't high enough for me to get
in there and fix them yet). To do this I've set up a cron job to check
every 15 minutes. The script I run is:
set lines 100 pages 87
column username format a10
column tablespace format a6 heading 'TBSP'
Have you looked at v$sort_usage? (8i only)
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
Since 8.X joining v$sort_usage and v$session. In 7.X
Metalink had an script that I enclose.
When the query is running, you can issue a query over
v$session_wait. Looking for the event 'db file
sequential read' where p1 includes all the files of
the temp tablespace.
Regards.
--- Jenkins,
Thanks to everyone for all the help.
-Original Message-
Sent: Monday, September 10, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
try this query:
SELECT s.username, s.serial#, s.sid, u.tablespace, u.contents, u.extents,
u.blocks
FROM v$session s, v$sort_usage u
WHERE
Take a look at my site, www.vampired.net, you will find a script to do both,
it can be modified pretty easily to remove the storage clauses.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher
I've got a couple of PL/SQL scripts that grab the
table and index DDL and dump out to a file. They'll
do it for a particular schema. I'm also in middle of
converting them over to perl so I'll send that to you
as well. Let me know if you have questions.
hth
mkb
--- Sam Bootsma [EMAIL
I am using rman on UNIX so I am not sure how it works for NT.
The rman log will have this information. You can spool it to disk.
HTH,
Ruth
--- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 16, 2001 11:20 AM
Hi
Does anyone have any
Title: RE: Script to find space bound objects
This is my two pence
select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from
(select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a,
(select tablespace_name,max(bytes/(1024*1024)) sf
Title: RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
Bunyamin,
Download Toad (www.toadsoft.com). It does it for you. THe only thing it doesn't handle (from what I remember) is partitioning.
HTH
Lisa Koivu
Data Bored Administrator
Ft. Lauderdale, FL,
-Original
I just finished this the other day. It works for individual tables
only, but you could pretty easily modify it to work for all of the tables within
a schema. Hope it helps.
-::YEX::-
)))
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL PROTECTED]]Sent: Monday, 02
Title: RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
Thank youLisa.
Bunyamin
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 02, 2001 10:40
PM
Subject: RE: SCRIPT NEEDED TO MAKE THE
CREATE TABLE
: Multiple recipients of list ORACLE-LSubject:
RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A
SCHEMA.
I just finished this the other day. It works for individual
tables only, but you could pretty easily modify it to work for all of the
tables within a schema. Hope it helps
PROTECTED]]Sent: Monday, 02 July, 2001
14:51 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A
SCHEMA.
I just finished this the other day. It works for individual
tables only, but you could pretty easily modify it to work
The other really cool free tool is tora (Tool for ORAcle). It's free and
it works even on
Windoze platforms. Tora can be found through slashdot (go to slashdot.org
and
type tora in the search freshmeat field. I tested the app on RH 6.2,
Slackware and
Windoze platforms and it works on all of
Jack,
Here's one that we use..
--
CREATE OR REPLACE VIEW SPACE_BOUND_OBJECTS
( TS#,
NAME,
BLOCKSIZE,
MAXFREEBLOCKS,
TOTFREEBLOCKS,
FREEEXTENTS ) AS
select a.ts#,a.name,a.blocksize,
nvl(max(b.blocks),0),
nvl(sum(b.blocks),0),
Jack,
I think following script will do what you want...
Regards
Rafiq
col substr(seg.owner,1,10) heading OWNER
col substr(seg.segment_name,1,30) heading SEGMENT NAME
col substr(seg.segment_type,1,10) heading TYPE
col substr(seg.tablespace_name,1,20) heading TS NAME
prompt
Hi Greg,
I came to NT world from VMS and was used to DCL. I find the following book
a useful reference:
Windows NT Shell Scripting 1-57870-047-7
HTH,
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
Organon
Hi,
Within your *.sql script you can jump to the OS and give OS commands.
e.g: host sqlldr. (start with host).
I have used it with import and it works.
Jack
http://www.ultratech-llc.com/KB/Scripts/?File=Scripting.BAT
(also see bottom of this message for more URLs)
http://www.ultratech-llc.com/KB/?File=!Contents.TXT
--forwarded message follows--
[Date sent: Wed, 30 May 2001 10:32:11 -0400
To: Recipients of WINNT-L digests [EMAIL
My suggestion would be to install cygwin
(http://sources.redhat.com/cygwin/).
-Original Message-
From: GLoughmiller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 8:25 AM
To: ORACLE-L
Cc: GLoughmiller
Subject: Script examples for NT. (yuk!)
Quick question..
ALL
You can download CyGWin from Redhat for free that will give you a very nice
cloned shell of linux environment, full compatable with Bash/Sh scripting.
Wish i could find a ksh shell for it, but it has ALOT of the tools normally
available with Unix. ps, kill, grep, tail, head, piping, shell
see the host command in pl/sql
[EMAIL PROTECTED] 05/29/01 11:15AM
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want to create a new table TABLE1
-
Andrea,
Is this UNIX or NT.
In UNIX ( I don't know NT that well), the most simple method would be to use
a shell script.
The following is about as basic as it comes but would need to be embellished
with environment settings and error checking etc..
eg.
Start of Script
If it is NT you can create a batch file similar to Unix example given below
which will do the same. The only difference here is you'll have to save
your sqlplus scripts in a text or *.sql format and call them from the batch
file. After that you can call sqlloader.
-Original Message-
:Re: Script and control file
see the host command in pl/sql
[EMAIL PROTECTED] 05/29/01 11:15AM
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want
As Jared pointed out (shame on me), there is no host command in PL/SQL, the only place
where the host command is supported in in sqlplus and forms.
Jared Still [EMAIL PROTECTED] 05/29/01 02:10PM
On Tuesday 29 May 2001 09:07, William Beilstein wrote:
see the host command in pl/sql
Bill, I
On Thursday 24 May 2001 17:20, Helmut Daiminger wrote:
Does anybody out there have a script to compare to database schemas and
list the differences?
I'm forwarding a post I made on this topic a few days ago.
Jared
-- Forwarded Message --
Date: Sun, 13 May 2001 21:44:53
there is also the case of trying to enable a unique constraint on the
underlying table using the exeption option and creating an exception
table(utlexcpt.sql). The unique constraint will of caurse fail but inside
the exeption table the duplicate rowids will be written . Using this input
you can
Eric,
Yes they did...I am not resending this message. Either the List software is
screwing up, or my Company's email servers suck.
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Wednesday, May 16, 2001 9:45 PM
To: Multiple recipients of list ORACLE-L
didn't 27 1/2
ORACLE-L [EMAIL PROTECTED]
Subject: Re: Script that will remove redundant rows from table
Date: Wed, 16 May 2001 17:45:22 -0800
didn't 27 1/2 people post the answer to this yesterday???
On 16 May 2001, at 17:10, Haskins, Ed wrote:
A few months ago I remember seeing a script that enabled
How about we split the difference?
| 1* select (25.25+27.5)/2 from dual
|SQL /
|
|(25.25+27.5)/2
|--
|26.375
|
(no this is not the mean)
On 16 May 2001, at 19:36, Rachel Carmichael wrote:
now now, don't exaggerate it was only 25 1/4 people
...
didn't 27 1/2
recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
||
||
|| How about we split the difference?
||
|| | 1* select (25.25+27.5)/2 from dual
|| |SQL /
|| |
|| |(25.25+27.5)/2
|| |--
|| |26.375
|| |
||
|| (no this is not the mean
, 2001 1:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
||
||
|| How about we split the difference?
||
|| | 1* select (25.25+27.5)/2 from dual
|| |SQL /
|| |
|| |(25.25+27.5)/2
|| |--
|| |26.375
Deal! :)
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Script that will remove redundant rows from table
Date: Thu, 17 May 2001 09:31:33 -0800
How about we split the difference?
| 1* select (25.25
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:
Who was the half person?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
GROAN
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Script that will remove redundant rows from table
Date: Thu, 17 May 2001 10:50:39 -0800
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May 2001
didn't 27 1/2 people post the answer to this yesterday???
On 16 May 2001, at 17:10, Haskins, Ed wrote:
A few months ago I remember seeing a script that enabled the removal of
redundant rows in a table.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D.
now now, don't exaggerate it was only 25 1/4 people
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Script that will remove redundant rows from table
Date: Wed, 16 May 2001 17:45:22 -0800
didn't
I use this one that Araplan posted a while back:
delete from table_name a where rowid (select min(rowid)
from table_name b
where a.column_name=b.column_name)
/
From: Haskins, Ed [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
Sorry for the multiple posts...I first sent this message yesterday and it
never posted...I tried a couple times today. Looks like there was some sort
of backup between my mail server and the Lists'.
I've also received a solution!!
Thanks,
Ed Haskins
Oracle DBA
Verizon Wireless
-Original
Use the database trigger after startup event of the database.
--
On Sat, 28 Apr 2001 07:35:34
Bunyamin K.Karadeniz wrote:
I want to run a script after the startup of database automatically.
How can I do this on NT??
Bunyamin K.Karadeniz
Database Group /
1 - 100 of 126 matches
Mail list logo