that can be used.
-Original Message-
Sent: Friday, September 06, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L
Export can do this. Right?
But the output is not a script but a binary file only Import can understand.
ltiu
Connie Milliken wrote:
Does anyone have a script that will write
Thanks.
I wonder if you can treat an export file as a *.sql script and run it
off sqlplus with the @@script.sql command?
I shall give this a try.
ltiu
Fink, Dan wrote:
If you export with rows=n, you get a text file with all the ddl to recreate
the exportable objects. However, packages
Forgot to mention that this will only build the db create script.
Nothing more than that.
- Kirti
-Original Message-
Sent: Monday, September 09, 2002 10:07 AM
To: '[EMAIL PROTECTED]'
Here is one that I used to use some time ago (for Oracle 6 and 7).
This does not support all
#---
# crdb.ksh - creates sql script that contains statements necessary
# to recreate a database with the current physical
# configuration.
#
# parameters- SID (oracle database identifier)
#
# output- crdb_SID.sql
Hello,
Could anyone here suggest a software package that can create an ER
diagram by simply connecting to an Oracle database, reverse engineer it
to see the schema in an ER diagram - instead of in a file with ddl/dml
statements.
Thanks.
ltiu
--
Please see the official ORACLE-L FAQ:
Could anyone here suggest a software package that can create an ER
diagram by simply connecting to an Oracle database, reverse engineer
it to see the schema in an ER diagram - instead of in a file with
ddl/dml statements.
I haven't tested it, but Microsoft Visio 2000 claims to be able to
Itiu - ERWin Examiner (Computer Associates) is supposed to have that
capability. I have never used that capability.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, September 09, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Hello,
ErWin is an excellent tool..
Gabriel
--- ltiu [EMAIL PROTECTED] wrote:
Hello,
Could anyone here suggest a software package that
can create an ER
diagram by simply connecting to an Oracle database,
reverse engineer it
to see the schema in an ER diagram - instead of in a
file with
Most CASE tools have reverse engineering feature.
We are using PowerDesigner (from SYBASE).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 09, 2002 12:23 PM
Hello,
Could anyone
ERwin, Visia Architect, Oracle Designer all can do it. There may be
other packages that I do not know about. I have all three of them and
they work.
Shakir
--- ltiu [EMAIL PROTECTED] wrote:
Hello,
Could anyone here suggest a software package that can create an ER
diagram by simply
I have used Visio to do that .
It links the tables together if they have foreign/primary keys. If you have
no relations like that then it will at least list all the tables you pick.
-Original Message-
Sent: Monday, September 09, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Oracle Designer
Viso2000
I use Oracle Designer.
-Original Message-
Sent: Monday, September 09, 2002 12:24 PM
To: Multiple recipients of list ORACLE-L
Hello,
Could anyone here suggest a software package that can create an ER
diagram by simply connecting to an Oracle database,
Yeah, you can use Visio. I used it when I need to quickly generate
an ER diagram from a schema.
-Original Message-
Sent: Monday, September 09, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Could anyone here suggest a software package that can create an ER
diagram by simply
by: Subject: RE: Recreate database script
[EMAIL PROTECTED]
m
5 years ago, I worked through his UNIX flavor B/U scripts and found several
errors. Over a 2-3 week period, I had multiple phone conversations with
the Osborne editors with assurances, that the problems would be fixed
IMMEDIATELY in the download files. They effused many thanks for my time
Export can do this. Right?
But the output is not a script but a binary file only Import can understand.
ltiu
Connie Milliken wrote:
Does anyone have a script that will write another script to recreate a
particular database quickly with all the info specific to that particular
database?
Seems
Connie,
There are some scripts in Oracle Annotated Archives (by Kevin Loney and
Rachel Carmichael, Oracle Press) that will do what you want.
Dennis
Connie Milliken wrote:
Does anyone have a script that will write another script to recreate a
particular database quickly with all the info
If anyone has the dbbackup_begin script from the Velpuri book/website that
they are currently using and it is working properly, can you please send me a
copy? I would really appreciate seeing an example that is definitely working.
I realize that RMAN is available, but the person that I am
Been a while since I used them, but I had to go through the file and remove
some non-printable characters. You can do this pretty quickly with any
number of text utilities.
Do yourself a favor and use RMAN for backups. You can script any variety of
backups fairly easily once you work your
Did anyone else run into the error dbbackup_begin: syntax error at line 521
'end of file' unexpected after trying to use the Velpuri backup scripts for
Unix? Where was the problem at and how did you resolve it? I downloaded the
scripts from the Osborne website and this is the error that keeps
Thanks guys .
-Bp
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 11:33 AM
From the oracle Metalink..
/*
Doc ID: Note:1036972.6
DATABASE
Type: SCRIPT
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 15-OCT
Hi all:
Sorry for the (seemingly) easy question, but is it possible to execute
shellcode from inside a stored procedure?
Platform is Oracle 9.2.0.1 on Solaris 2.8
I understand that there are ways to do it using java or Pro*C, but I don't
know which resources to use, and I'm hoping that
From the oracle Metalink..
/*
Doc ID: Note:1036972.6
DATABASE
Type: SCRIPT
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 15-OCT-1997
Last Revision Date: 27-APR-2000
Language: USAENG
==
Title:
==
Compiling Invalid Objects
by: cc:
[EMAIL PROTECTED] Subject: RE: Unix Script Quest :
Urgent
Is there a way to
captureall files hit by a process/user in unix (Sun Solaris 9, ksh)?
I am seeing an OCI file not found on my production box. I can't resovle
it.
So, I want to run
the same process on my development box (where it works) and get a list of files
that it is hitting (I can
file. If you are sure that the files are being
created (vs. modified or accessed) by one specific userid
then:
find / -newer BEFORE -user id
will work also.
If you are going to run the thing regularly then take a
look at find2p, which will spit out a perl script to
match your find command
ldd filename should give you the dependencies.
--- [EMAIL PROTECTED] wrote:
Is there a way to capture all files hit by a
process/user in unix (Sun Solaris 9, ksh)? I am
seeing an OCI file not found on my production box.
I can't resovle it.
So, I want to run the same process on my
/ -newer BEFORE -user id
will work also.
If you are going to run the thing regularly then take a
look at find2p, which will spit out a perl script to
match your find command. The perly code will give you
finer control and better sanity checks (e.g., comparing
to a list in memory of what has already
:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Unix Script Quest : Urgent
ldd filename should give you the dependencies.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hannah,
I'm no Unix guru either but in this situation I use
'truss', e.g.
truss procname
HTH
Chris
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: 09 August 2002
16:08To: Multiple recipients of list ORACLE-LSubject:
Unix Script Quest : Urgent
changed since the
BEFORE file. If you are sure that the files are being
created (vs. modified or accessed) by one specific userid
then:
find / -newer BEFORE -user id
will work also.
If you are going to run the thing regularly then take a
look at find2p, which will spit out a perl script
section is loaded in my
application all the settings for controls are read from database(clob
field).
Now the problem is that I want to write the
script which will contain the data of my database and will populate the
database of our client so that report can be generated there also. Basically
Could anyone share their Unix script to age the listener log file? I know
that this has been posted to the group in the past, but I was unable to find
it in the archives at FatCity.
Thanks.
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET
Make a copy of the file appended by the Julian date then empty the log via
cat /dev/null listener.log. (You don't really need a cat.)
-Original Message-
Sent: Wednesday, July 24, 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
Could anyone share their Unix script to age
I posted this answer once before.
How about wrapping this is a script of your choice:
ARCHIVE_LISTENER_FILENAME=listener`date +%Y%m%d%H%M`.log
lsnrctl set log_file listener2.log
mv listener.log $ARCHIVE_LISTENER_FILENAME
mv listener2.log
Why is it necessary to null out the file? Does LSNR keep a open file handle
open to it?
-Original Message-
From: Orr, Steve [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener Log Aging Script
Make
PROTECTED]]
Sent: Wednesday, July 24, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener Log Aging Script
Make a copy of the file appended by the Julian date then empty the log
via
cat /dev/null listener.log. (You don't really need a cat.)
-Original Message
.
Erik Williams [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
24-07-2002 09:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:RE: Listener Log Aging Script
Why is it necessary to null out
? Does LSNR keep a open file handle
open to it?
-Original Message-
From: Orr, Steve [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Listener Log Aging Script
Make a copy of the file appended by the Julian
Thanks for the Oracle list members who responded very
promptly for my question. At the moment, I am very
satisfied with pause command.
I have one more question for the DOS Gurus.
Is there a way to change the fond size from the DOS
Script ?
Thanks,
Bob
--- James J. Morrow [EMAIL PROTECTED
All,
I have a DOS batch file. In between this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per the above
requirement?
Thanks,
Bob
All,
I have a DOS batch file. In between this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per the above
requirement?
Thanks,
Bob
Robert [EMAIL PROTECTED]
Date: 7/11/2002 12:37 PM
All,
I have a DOS batch file. In between this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per
this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per the above
requirement?
Thanks,
Bob
Bob Robert wrote:
All,
I have a DOS batch file. In between this script, I
would like to add user interactive question.
Ex: Do you want to Continue [Y/N]?
Once they hit Y, it will continue rest of the batch
file.
Could someone able to help me out as per the above
requirement
://www.Simtel.net
2. Another NT approach, posted by Bennett Benson, is explained at
this link: http://www.jsiinc.com/TIP0300/rh0323.htm
[this doesn't seem to be working as at 1-Mar-2002]
3. Write a Win Script Host script using the InputBox function
(requires Win 98, Win NT 4.0, IE
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
Hi All
Jared notified me that the attachment did not come through, so I am
attaching again. I am also enclosing it in the body of the email.
Credits go to Jared who wrote the shell of this some time back (98 was it
Jared ?). I just modified an excellent foundation.
tblindspace.sql
set
Title: script for comparing two schemas in two databases
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
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
-tools.co.uk
Maximising throughput performance
-Original Message-
Helmut
Sent: 29 May 2002 10:18
To: Multiple recipients of list ORACLE-L
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
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
: Wednesday, May 29, 2002 3:18 AM
To: Multiple recipients of list ORACLE-L
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
--
Please see the official
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
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Simon Anderson/SSplc)
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 7.3. I still
occasionally use it and can send my patched
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 7.3
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
Does anyone have an online backup script for Oracle 8.1.7 and AIX?
Or can anyone provide a definitive list of the actions required to be taken?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services
Does anyone have an online backup script for Oracle
8.1.7 and AIX?
Or can anyone provide a definitive list of the
actions required to be taken?
John
John,
Look for the script named hotbackup.sql at http://www.oriole.com/frameindexTK.html.
It's neither 8.1.7 or AIX specific, it uses 'cp
Just saw this todayhavent tried it yet.
Excerpt from MetaLink:
News
Notes
New Script: Pre-Install script which checks your Unix
environment to ensure successful installation of Oracle 9.x version of RDBMS
The Data Server Support team is pleased to release a new
On HP/UX at least, it doesn't work very well unless you've modified every
kernel parameter stated in the install docs, even if the default is
adequate. Only the modified values get put into /stand/system, which the
script greps.
Rich Jesse System/Database Administrator
recipients of list ORACLE-L
ArunC@1800FLO[EMAIL PROTECTED]
WERS.comcc:
Sent by: Subject: Script for deleting old archive
I need a routine which removes archive logs via RMAN tape backups if the
archive log destination exceeds half full. I already have the RMAN part
which we can kick off manually but I'm looking for something like a basic
cron job monitoring script which triggers this based on the half full
I need a routine which removes archive logs via RMAN tape backups if the
archive log destination exceeds half full. I already have the RMAN part
which we can kick off manually but I'm looking for something like a basic
cron job monitoring script which triggers this based on the half full
Does anybody has script to delete old archive logs on NT when the disk
reaches certain percentage.
Please let me know
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arun Chakrapani
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
v_LOCK_PID=${$}
echo ${v_LOCK_PID} ${JOB_LOCK}
echo Created job file lock
.
.the rest of your script goes here
.
rm ${JOB_LOCK}
PS: I'm looking for a new TV, think you could get me a deal at BestBuy with
your employee discount?
Brian P. MacLean
Oracle DBA, OCP8i
Doubtful you'll find output, some is written to the console and in some
cases to syslog. Instead, modify your startup script so it writes
output to a logfile. Here's mine:
#!/sbin/sh
#
# /etc/init.d/oradb - Start/Stop the Oracle Databases and SQL/NET
listeners
#
PATH=/usr/bin:/usr/sbin
Hello All,
I have a script, which cleans up the archive log destination by moving the
old archive logs to a retention area based on the thresholds
1. Percent of space utilization
2. greater than 2 days old.
The script was working fine , except for the reason , sometimes we see
multiple copies
My mistake , this new script is only working sometimes. Which is scheduled
every hour , but not working at all the hour changes .
-Original Message-
Sent: Monday, May 13, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L
Hello All,
I have a script, which cleans up the archive log
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
Where can I find the output of the Solaris run control scripts? I am trying
to debug a database startup problem and would like to view the output of the
echo commands in these scripts.
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET:
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 documented. I
ended up essentially rewriting the cod from
utldtree.sql and we gave up that
particular effort
Thank you Connor,
but I need a script that backups over 20 raw devices
datafiles to a TAPE without using a FS to store these
datafiles first.
TIA
___
Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente.
http
but I need a script that backups over 20 raw devices
datafiles to a TAPE without using a FS to store these
datafiles first.
To a single tape or multiple ones? If it's a single tape
then you are in for a real fun time trying to restore the
stuff...
This is skeletal but should give you
Greetings listers,
Ever worry about wrinkles, loss of hair, and bad
breath?
Well, the following script can't help you with THAT,
but it CAN show you a heirarchical list of objects
that depend upon the given object! Just pass in
1=owner and 2=object name, and viola! No more
changing objects
PROTECTED]
cc:
Subject:script to show heirarchical list of object dependencies for a
given object
Greetings listers,
Ever worry about wrinkles, loss of hair, and bad
breath?
Well, the following script can't help you with THAT,
but it CAN show you a heirarchical list
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
One more script from this list with slight changes. For 8i or up.
SELECT 'The database size is '|| round( (df.sum + rd.sum + tm.sum) / ( 1024
* 1024 * 1024 ) )
|| ' GB excluding INI, password and control files'
FROM
(SELECT SUM(bytes) sum FROM sys.dba_data_files) df,
(SELECT SUM(bytes
You can get the size of database using DBA studio. Which gives separately
the actual space consumed by the data and the size of table spaces.
Aleem
-Original Message-
Sent: Tuesday, May 07, 2002 3:39 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: DB Size script
Hello:
Hope the subject make sense. I'm new to LDAP, and
don't know how it works.
I need to use SQL Loader to load a text file into
Oracle817 Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does
Hello:
Hope the subject make sense. I'm new to LDAP, and
don't know how it works.
I need to use SQL Loader to load a text file into
Oracle817 Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does
Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does anyone has any examples? or know a helpful URL?
Thanks
From Steven
__
Do You Yahoo
, and
don't know how it works.
I need to use SQL Loader to load a text file into
Oracle817 Database from a unix box. The file/data
comes from LDAP server. My question is: how do I get
the file/object from LDAP site from my unix script?
Does anyone has any examples? or know a helpful URL
Interesting, Charlie! By the name of this script, I assume it's used to
change your Oracle password, but it's not searching against OiD, unless
you've manually added the Directory Manager cn. Are you using iPlanet?
Are your Oracle clients authenticating against this LDAP server? Or for
Oracle
Thanks for the code.
But can we do this in UNIX shell script or Java?
Thanks again
Steven
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I hope you can read UGLY Perl code.
HTH YMMV!
#!/usr/local/bin/perl
# File: chg-oracle-passwd.cgi
use Net::LDAP;
use Carp;
use DBI;
$ENV
Yes, you'd need the LDAP API libraries, check here
http://www.openldap.org/
Steven Joshua wrote:
Thanks for the code.
But can we do this in UNIX shell script or Java?
Thanks again
Steven
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I hope you can read UGLY Perl code.
HTH
33063
-Original Message-
From: Steven Joshua [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Does any one know how to call LDAP from UNIX script ?
Thanks for the code.
But can we do this in UNIX shell
://www.openldap.org/
Steven Joshua wrote:
Thanks for the code.
But can we do this in UNIX shell script or Java?
Thanks again
Steven
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I hope you can read UGLY Perl code.
HTH YMMV!
#!/usr/local/bin/perl
# File: chg-oracle
To: Multiple recipients of list ORACLE-L
Subject:Re: Does any one know how to call LDAP
from UNIX script ?
Thanks for the code.
But can we do this in UNIX shell script or Java?
Thanks again
Steven
--- Charlie Mengler [EMAIL PROTECTED] wrote:
I hope you can read UGLY
I have a script that I run to update statistics on my databases that is giving me
something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my
8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what
my screen looks like in SQLPlus;
SQL
again.
-Original Message-
Sent: Wednesday, May 01, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
I have a script that I run to update statistics on my databases that is
giving me something odd when run on a 7.3.4 database on NT 4.0
Farnsworth, Dave wrote:
I have a script that I run to update statistics on my databases that is giving me
something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my
8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is
what my screen looks
Thanks Stephane. That explains it. I'll go with the -- for my comments for version
consistancy.
Dave
-Original Message-
Sent: Wednesday, May 01, 2002 8:18 AM
To: Multiple recipients of list ORACLE-L
Farnsworth, Dave wrote:
I have a script that I run to update statistics on my
-L
Subject: Wierdness during script in SQLPlus
I have a script that I run to update statistics on my databases that is
giving me something odd when run on a 7.3.4 database on NT 4.0. The
script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the
script comes to an end
You are correct that it does not affect my script, it's just annoying. A ctrl-C does
break me out of the DOC prompt and puts me back into the SQL prompt. Learned
something new. :o)
Thanks,
Dave
-Original Message-
Sent: Wednesday, May 01, 2002 9:03 AM
To: Multiple recipients
Hi,
We have an ETL script that logs onto the db. The scripts usually runs without
error. During pre-production testing, we rec'd a logon denied error message. We
re-ran the scripts and all was fine.
I did not see anything in the alert log, only message for today was a redo
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
401 - 500 of 983 matches
Mail list logo