Does anyone have the scripts (or URL) for identifying objects having
freelists contention?
Thanks.
Anand Prakash
mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17,
2002 2:29 PMTo: Multiple recipients of list
ORACLE-LSubject: Script for identifying objects having freelists
contention
Does anyone have the scripts (or URL) for identifying objects having
freelists contention?
Thanks.
Anand Prakash
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
Still room for improvement but enough changes to keep you busy for awhile.
Please note that I changed the script to use ksh shell (required by several
of the commands I added) and the exec command that will redirect all
script text output to a common file so that you don't have to redeclare
]
04/16/02 09:06 Subject: Re: Unix script(Document link:
Brian P MacLean)
AM
Hallo,
I have this unix script, please tell me how to change it so it also does the following:
(See attached file: laddabilbo.sh)
counts the time between start time and end time of the process(I mean time difference
between Jobb startat(Job started) and Job Klart(Job Finished).
IThis log
I have a fellow DBA that has to do some data cleansing. He is looking for
some software that can properly init cap a last name, like McDonald.
Obviously, Oracle has an initcap function...
SQL select initcap('GRABOWY') from dual;
INITCAP
---
Grabowy
Elapsed: 00:00:00.50
SQL select
Here's one way:
SQL DEF val = Donald
SQL
SQL SELECT
2CASE WHEN LOWER(SUBSTR('val', 1, 2)) = 'mc' THEN 'Mc' ||
INITCAP(SUBSTR('val', 3))
3 WHEN LOWER(SUBSTR('val', 1, 3)) = 'mac' THEN 'Mac' ||
INITCAP(SUBSTR('val', 4))
4 ELSE INITCAP('val' ) END
msg40478/bin0.bin
Description: application/pkcs7-mime
Hi
Can some one send me automatic shutdown and startup db script for WIN'2000?
Thx
-Seema
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official
[EMAIL PROTECTED] wrote:
Hi
Can some one send me automatic shutdown and startup db script for
WIN'2000?
Thx
-Seema
no.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You
M. To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ssolomon@ppg. cc:
com Subject: RE: hotbackup script
) then
check if the value is 40 then send an e-mail with the COMMAND name and the size.
Something like dbgora has a size of 42M
I was trying the following script. But I am not sure how to get the last character of
SIZE column from the above output and compare with 'M' and then compare
]
cc: [EMAIL PROTECTED]
03/28/02 11:05 Subject: Re: Help in unix script(Document
link: Brian P MacLean)
AM
Hi Ashoke,
I see that you are using NORAD (I am the resident NORAD sales critter ;P).
Can't help you much on the script help, but one thing I can say:
Have you looked at the IAS agent of NORAD (the system monitoring agent)?
This will be able to do all that you want..
Under the standard rules
]
ronic.com cc:
Sent by:Subject: Help in unix script
[EMAIL PROTECTED
Hi
Can some one send me hotback scripts for NT OR WIN'2000?
With regards
Seema
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
c:\winnt\system32\rtfm perhaps?
-Original Message-
Sent: Wednesday, March 27, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L
Hi
Can some one send me hotback scripts for NT OR WIN'2000?
With regards
Seema
_
Join
recipients of list ORACLE-L
[EMAIL PROTECTED]
ssolomon@ppg. cc:
com Subject: RE: hotbackup script for NT OR
WIN2000
.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 27, 2002 6:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: hotbackup script for NT OR WIN2000
Ya know, I enjoy a good RTFM as much
Hi,
What version of unix do you use ? I use this script on HP. If you want I
can send it to you.
Radim
-Original Message-
Ling Catherine (CSC)
Sent: Wednesday, March 13, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
Does anyone have the unix script to monitor disk
Hi Radim,
We are using Sun Solaris Version 2.6 right now. By this weekend, we'll be
upgrading our OS to Version 2.8. I am very interested in your script. Could
U send your scripts to me? Thank you so much.
Regds,
New Bee
-Original Message-
From: Radim
Something strange has happened.
This utility, supplied with iAS to test portals, tells me there may be
something wrong with my portal.
In fact, it can't find the server name for the portal.
Meanwhile we can access the portal no problem from a Web browser. I logged
a TAR with Oracle to ask
)
Subject: diag.cmd script
Leslie,
The supplied events are written in TCL.
For a description of the events and the associated TCL file names see Metalink notes
69563.1 and 69592.1.
The event you mention is:
TBSPFULL.TCL
Type : Database Event script.
Versions : OEM 1.6 onwards
Purpose : Signals the console
Hi Gurus,
Does anyone have the unix script to monitor disk space or a certain file ?
For example, if the disk space is more than 80%, send an email to the
administrator or if the log file is too huge, email the log file to the
administrator and truncate the file etc .
Please help. Thanks
space, the alert shows a tablespace that is 1.7% full,
but my script shows it's 70% full. That's way off!
OEM 9.0.1 on Win2000. Thank you!
Here is my script:
select f.tablespace_name tablespace,
sum(d.bytes/1000) bytes, sum((d.bytes/1000 -
f.free/1000)) Used, sum(f.free/1000) Free,
round((sum
This may be a little off topic so I apologize in advance. But I have seen
some good Unix scripting help come across lately so I thought I would go
ahead and send this.
I am trying to setup a Unix script that will logon to a remote server, get
the name and size of all the files in a remote
Hi,
Never tried it but feeling creative today
How about rsh to the remote machine to start a script that does the long
listing and ftp's back to your machine
Jack
Nancy McCormick [EMAIL PROTECTED]@fatcity.com on 01-03-2002 16:08:40
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL
I wrote some shell scripts that do something similar. Here is the sequence
of events: On host running the control process, run a script that resides on
remote server containing the logic to generate a file with the information
needed using rsh command. This remote script would also contain logic
I finally got the ls -l command with ftp working. It didn't like having the
remotedirectory specified so I just do a cd to the remote directory and then
ls -l with the local file name.
Here is a snippet from the script I am running right now
# set variables
SITE_DIR=$1; export SITE_DIR
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
- 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
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 column and generate the correct/valid values. Also, a DEFAULT value of
a column is also considered and generated accordingly. values
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
HI LIST,
I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS
5.7.
I want to schedule this script to shutdown the database at mid night and
make a backup then start it up at 5:00 AM.
Any URL or link or any document it will be very helpful.
Hamid Alavi
Office 818 737-0526
ORACLE-L
HI LIST,
I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS
5.7.
I want to schedule this script to shutdown the database at mid night and
make a backup then start it up at 5:00 AM.
Any URL or link or any document it will be very helpful.
Hamid Alavi
Office 818
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:UNIX SCRIPT
HI LIST,
I AM LOOKING FOR A SCRIPT TO MAKE A COLD BACKUP FOR ORACLE 8.1.6 ON SunOS
5.7.
I want to schedule this script to shutdown the database at mid night and
make a backup
Here's basically what you need to do:
1) Write a script which determines which files to backup (hit the DBA and
V$ tables)
2) Shutdown the database
3) Once you have those files, use them as a driver in a for|while loop (for
each file,
A) Check if it's raw or UFS
if [ raw
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
Hi all,
I get a perl script to telnet to several machines on network to check
something I want to check. When it trys to connect a machine which is down,
the script will stop running. How do I tell it to continue to check the
next machine and ignore the one down?. Below is my script.
Thanks
PROTECTED]
cc:
Subject:Script stops running.
Hi all,
I get a perl script to telnet to several machines on network to check
something I want to check. When it trys to connect a machine which is
down,
the script will stop running. How do I tell it to continue to check the
next
I am working through the book "OCP Intro to
Oracle9i; SQL Exam Guide" by Jason Couchman. On page 6 they say to run the
script utlsampl.sql to create objects. So, I have run it from the Command
Prompt, SQL*Plus and the SQLPlus Worksheet with the same problem. I have
checked Or
KENNETH JANUSZ wrote:
I am working through the book OCP Intro to Oracle9i; SQL Exam Guide
by Jason Couchman. On page 6 they say to run the script utlsampl.sql
to create objects. So, I have run it from the Command Prompt,
SQL*Plus and the SQLPlus Worksheet with the same problem. I have
Without seeing the script I would guess one of two things.
1) Trying to connect to a non-existant user.
2) It actually worked and script suppresses output to terminal.
I would open up the script and look to see what it is doing. Perhaps put
spool command if it does
not have one.
Rick
KENNETH JANUSZ wrote:
SQL @c:\oracle\ora90\rdbms\admin\utlsampl.sql;
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.1.1 -
Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production Any ideas as to what the
problem is?
problem is EXIT
T.
--
Please see
Why do
you think there is a problem? May be it finishes and disconnects
successfully.
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 06, 2002
10:33 AMTo: Multiple recipients of list ORACLE-LSubject:
Problem Running SQL Script
I
have you tried actually LOOKING at the sql script itself to see what is
happening? I mean, you are studying for the SQL exam, what better way
to study than to figure out what is going wrong in a SQL script?
--- KENNETH JANUSZ [EMAIL PROTECTED] wrote:
I am working through the book OCP Intro
: Problem Running SQL Script
I am working through the book "OCP Intro to
Oracle9i; SQL Exam Guide" by Jason Couchman. On page 6 they say to run
the script utlsampl.sql to create objects. So, I have run it from the
Command Prompt, SQL*Plus and the SQLPlus Worksheet with the same
That
script sets TERMOUT off and has an 'exit' at the end
Pl
check if it has created those sample objects in SCOTT schema..
-
Kirti
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 06, 2002
9:33 AMTo: Multiple recipients of list
: Problem Running SQL Script
I am working through the book OCP Intro to Oracle9i; SQL Exam Guide by
Jason Couchman. On page 6 they say to run the script utlsampl.sql to
create objects. So, I have run it from the Command Prompt, SQL*Plus and
the SQLPlus Worksheet with the same problem. I have
Ken,
Take a look at the top of the script:
SET TERMOUT OFF
SET ECHO OFF
Those 2 lines ensure that you won't see any output.
At the end of the script:
EXIT.
If you didn't see any error messages, it all worked as it should.
Jared
KENNETH JANUSZ [EMAIL PROTECTED]
Sent by: [EMAIL
My apologies -- dumb dumb here forgot to look at the script. It happened so
fast that I thought there was a problem with the script.
Again my apologies,
Dumb Dumb
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 11:23 AM
Hallo, is there anyone who can tell me if it ispossible run unix shell script from
PL/SQL
Anyone who has a good example too that I can use. Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
: 30 January 2002 08:41
To: Multiple recipients of list ORACLE-L
Hallo, is there anyone who can tell me if it ispossible run unix shell
script from PL/SQL
Anyone who has a good example too that I can use. Thanks in advance.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Do some research man!! This stuff isn't hard to find...sheesh!!
-Original Message-
Sent: 28 January 2002 14:31
To: Multiple recipients of list ORACLE-L
Hallo,
I have this unix script. I would like to include code which checks if the
oracle database is up and running so the procedure
Title: RE: Unix script
Basis of a script added into yours below. Note I am only checking to see if there is a PMON proces up - maybe best to make a sqlplus connection and read v$instance or something and exit if it fails.
Really very poor but will give you something to work on.
What I
Hallo,
I have this unix script. I would like to get a errorlog if the pl/sql procedure
konto.fillbotables.anrop doesnt start at all. Please tell me how to write the code
and where to include it in this shell script.
#!/bin/sh
. /usr/bin/orasetup.sh
. /d31/appl/konto/bat/movefiles.sh
sqlldr
a parameter in your procedure.
If the procedure finishes successfully change that parameter's value, and
pass it back to the parent script.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services
the one you are running this script from:ftp -i -n EOFopen $SERVER2user $USER2 $PWD2cd scriptsput filecloseEOFBoth of these can be included in the one shell script.Hope that helps.Kev.'In Windows no one can hear you scream'__Kevin ThomasTechnical AnalystDeregulation ServicesCalanais
Asunto: RE: Unix - script
I would suggest using wget, which is built exactly for this purpose.
-Original Message-
Sent: Wednesday, January 09, 2002 3:20 AM
To: Multiple recipients of list ORACLE-L
Roland,
Try this by setting up environment variables at the top of your script:
SERVER1
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
ia.com.ni cc:
Sent by: Subject: RE: Unix - script
ORACLE-L [EMAIL PROTECTED]
Kopia:
I would suggest using wget, which is built exactly for this purpose.
-Original Message-
Sent: Wednesday, January 09, 2002 3:20 AM
To: Multiple recipients of list ORACLE-L
Roland,
Try this by setting up environment variables at the top of your script
Use unix utility ftp to copy file between 2 mc's or use rcopy. For more details refer
to man pages.
--
On Tue, 08 Jan 2002 23:15:35
Roland.Skoldblom wrote:
Hallo,
I would like to have an example of a unix script, which does the following:
copy some files from directory /prod/sas/data
Roland,
Try this by setting up environment variables at the top of your script:
SERVER1= 10.10.10.10
USER1= 'xxx'
PWD1= 'xxx'
SERVER2= 10.10.10.20
USER1= 'yyy'
PWD2= ''
Then have this:
ftp -i -n EOF
open $SERVER1
user $USER1 $PWD1
cd scripts
get file
close
EOF
You can then have
Forgot to mention, the 'cd scripts' line in both examples is not required,
it's just been left in from the script I copied. oops!
K.
-Original Message-
Sent: 09 January 2002 08:20
To: Multiple recipients of list ORACLE-L
Roland,
Try this by setting up environment variables at the top
It could be faster to remote copy:
rcp -p /archive/orcl/arch_1_2290.arc
oracle@server2:/archive/orcl/arch_1_2290.arc
Mike
From: Thomas, Kevin [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Unix - script
Date: Wed, 09 Jan
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Unix - script
Date: Wed, 09 Jan 2002 00:35:23 -0800
Forgot to mention, the 'cd scripts' line in both examples is not required,
it's just been left in from the script I copied. oops!
K
PROTECTED]]
Sent: Wednesday, January 09, 2002 1:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Unix - script
Hallo,
I would like to have an example of a unix script, which does the
following:
copy some files from directory /prod/sas/data located at hardy.(which
Hallo,
I would like to have an example of a unix script, which does the following:
copy some files from directory /prod/sas/data located at hardy.(which is a computer)
to the other database hakon. Is it possible to do this. Please help me quick.
Thanks in advance
Roland S
--
Please see
Title: Export via pipe ksh script
Thanks everyone. Much appreciated.
-Original Message-From: Barb Baker
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 03, 2002 9:35
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Export via pipe ksh script
Here's one:
#!/bin/ksh
Title: Export via pipe ksh script
Could someone please send me a ksh script for doing imp/exp via a pipe.
We're running AIX 4.3.3.
Thanks!
Jeffery D Thomas
DBA
Thomson Information Services
Thomson multimedia Inc.
Email: [EMAIL PROTECTED]
DBA
Title: Export via pipe ksh script
From http://www.orafaq.com(in the sig for this
list):
begin
Can one export to multiple files?/ Can one beat the Unix 2 Gig
limit?
From Oracle8i, the export utility supports multiple output
files. This feature enables large exports to be divided into files
Is this what you are looking for?
#!/bin/ksh
mknod /tmp/exp_pipe p
compress /tmp/exp_pipe export.dmp.Z
exp file=/tmp/exp_pipe userid... log.
Rob Pegram
Oracle Certified DBA
--- Thomas Jeff [EMAIL PROTECTED] wrote:
Could someone please send me a ksh script for doing
imp/exp via a pipe
Title: Export via pipe ksh script
Here's one:
#!/bin/ksh # #
** # /etc/mknod
/u14/ORA_DUMP/arc_tadrcv.dmp p compress /u14/ORA_DUMP/arc_tadrcv.dmp
/u14/ORA_DUMP/arc_tadrcv.dmp.Z exp
parfile=$HOME/exp_arc_tadrcv.par file=/u14
I've always wanted an easy way to extract DDL info
from an import indexfile so I wrote a little perl
script that will extract create table ddl from an
indexfile. Seems to work and is a lot faster than
hand editing. Would appreciate any feedback/criticism
or ways to improve the script
For indexes, use this:
#!/usr/local/bin/perl -w
# Extract CREATE UNIQUE|BITMAP INDEX statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my ($infile, $outfile);
Finally, to get the ALTER statements from the
indexfile:
#!/usr/local/bin/perl -w
# Extract ALTER TABLE statements
# By: MKB Jan 02 2002
# Inputs: Location of log file and file output
# Outputs: Writes to file output
# Modification History:
#
use strict;
my
All,
I was creatinga script for PK and FK
generation and looks like I am stuck at this point ..
Problem:
If the table has a primary key with combinaiton of
colums , my script is not taking all , it's just taking the last position .
In one case it shows all the column, but in another
grace wrote:
hi gurus,
I found this unix script ... can any tell me what this means?
sqlplus - sys/msd filename.dat !
does anyone have a unix script to perform a database backups?
Best Regards,
Grace Lim
Suy Sing Comm'l Corp.
(632)-2474134
Your Unix script seems to take as input
!
-Original Message-
Sent: Thursday, November 29, 2001 1:10 AM
To: Multiple recipients of list ORACLE-L
grace wrote:
hi gurus,
I found this unix script ... can any tell me what this means?
sqlplus - sys/msd filename.dat !
does anyone have a unix script to perform a database backups
my, that's attractive! ;-)
-Original Message-
Sent: Thursday, November 29, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L
I believe the it is as follows:
Run SQL*Plus
| THIS SHOULD NOT BE HERE
| | database username
| | |
Hi grace
it basically means that log in to sql*plus and execute
whatever is below this line till you hit bang(!) ..
literally.
Deepak
--- grace [EMAIL PROTECTED] wrote:
hi gurus,
I found this unix script ... can any tell me what
this means?
sqlplus - sys/msd filename.dat !
does
In UNIX shell script: How does one invoke SQL*Plus, pass a shell variable
to run a stored procedure ?
i.e. if you have a UNIX variable $my_table (= dept)
how do you invoke sql*plus and pass $my_table to a procedure
which you'd otherwise manually run in sql*plus as
SQL exec check_table('dept
Robert,
Here is an example of logging into sql plus and running a stored procedure.
I pass 3 variables to my stored procedure. This is alot more to my shell
script than this but this will hopefully get you what you want. I pass $1,
$2, and $3 on the command line (separated by spaces) when I
(!) ..
literally.
Deepak
--- grace [EMAIL PROTECTED] wrote:
hi gurus,
I found this unix script ... can any tell me what
this means?
sqlplus - sys/msd filename.dat !
does anyone have a unix script to perform a database
backups?
Best Regards,
Grace Lim
Suy Sing Comm'l Corp.
(632
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: 27
November 2001 21:30To: Multiple recipients of list
ORACLE-LSubject: Script to Disable Constraint, Change Value, then
Enable Constrain
Listers,
Does
anyone have a script
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
allowed illegal data to be loaded later. Thus the need for a script.
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor
Blvd., Suite 110
Durham, NC 27703
Tel. (919)
941-4645
Fax (919)
474-0735
Email mailto:[EMAIL PROTECTED]
Web http
: 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
it falls out to the next set of pairs. When you run out of
pairs then the top level script will re-enable your constraints.
David Wagoner
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
You
have to create the constraints to support the deferred mode. Drop them and
recreate them DEFERRABLE.
Also you
can't do edit in SQLPLUS and put these three lines in one
window.
Either put
them in notepad and then cut and paste in sqlplus directly or create sql script
that look like
hi gurus,
I found this unix script ... can any tell me what this means?
sqlplus - sys/msd filename.dat !
does anyone have a unix script to perform a database backups?
Best Regards,
Grace Lim
Suy Sing Comm'l Corp.
(632)-2474134
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
501 - 600 of 983 matches
Mail list logo