TOAD has a 'Generate Schema script' function and if I recall correctly
you can specify the objects that you want the script to include. You can
download an evaluation copy at
http://www.quest.com/solutions/download.asp
On Tue, 2003-12-30 at 19:24, system manager wrote:
Dear all, I have
Dear all, I have a script to generate constraints for a single table
but I need a script to generate constraints for a schema owner . Can
anyone send me a copy?
Many thanks,
_
Free email with personality! Over 200 domains!
http
run the same script for every table for the schema owner and spool everything to the
same file ... there you have it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
the scripts for the entire database.
Ron
[EMAIL PROTECTED] 12/30/2003 2:24:25 PM
Dear all, I have a script to generate constraints for a single
table
but I need a script to generate constraints for a schema owner . Can
anyone send me a copy?
Many thanks
Thanks Ron, I got this recreate constraints script from our list but
lost it.It was really good script and it can re-generate all the
constraints under a schema owner.
--
Original Message
Date: Tue, 30 Dec 2003 12:14:26 -0800
dba_constraint
Thanks Rajendra, Good idea but I have 1200 tables :(I got a good
script from our list long time ago but lost it.That script can capiture
constraints for the schema owner.
--
Original Message
Date: Tue, 30 Dec 2003 11:39:26 -0800
run
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:recreate constraints script - URGENT
Dear all, I have a script to generate constraints for a single table
but I need a script to generate constraints for a schema owner
For 9i DBs, DBMS_METADATA will (re)create DDL for every (at least most)
object in the DB.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 11:09 PM
Thanks Ron, I got this recreate constraints script from our list but
lost it.It was really good script and it can re-generate all the
constraints under a schema owner
Yep, that's a good call, although there was some bug with paritioned tables
I think...
Also, metalink note 1016836.6 has a script for capturing constraints.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 11:49 PM
Hi list,
Need a little help with this, have seen in metalink both ways with and without the
equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I
removed it and the same error.
run
{
allocate channel c1 type disk
format '/u08/backups/rman/BD_
Title: RMAN Script
Hi list,
Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error.
run
{
allocate channel c1 type disk
format '/u08/backups
Hi Ramon,
I guess you are on 8i :
your setsize and fileperset specs should be
inside the backup command not outside i.e.
something like this :
backup
fileperset 2
setsize 2000
database
Hi list,
Need a little help with this, have seen in metalink both ways with and without the
equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I
removed and the same error.
run
{
allocate channel c1 type disk
format '/u08/backups/rman/BD_%d_%U
Take any tool that does compare schema, trace it, and put
a wrapper that will activate the script for all schemas in the
database.
If you have TOAD you can easily capture the sql via spool
sql to file (or screen).
For your side note: restore a backup to the test
system.
If you need only
--_=_NextPart_001_01C3AAA8.95C529E0
Content-Type: text/plain; charset=iso-8859-1
Well, I have to say the answer to both questions is probably DataBee . (
www.databee.com http://www.databee.com ) , although not via a script.
Just been using it quite a bit recently, so your question
Hi
Check out the free tool on http://www.impacttoys.com. It is called
T.O.Y.S. and compares the schema's or complete database between two
databases. You can specify down to the object levels what is compared
and also generate DDL to synchronise the two. Its windows GUI based and
seems quite
Here are the requirements for toys:
Microsoft® Windows® XP / 2000 / NT4 / Me* / 98*
Do you know af any tool that doesn't require obscene operating systems?
(Obscene OSes = the ones above, plus anything from the same vendor)
At least, it should work under Wine.
On 11/14/2003 12:09:27 PM, Pete
I am looking for a script to compare an entire database
instance against another. (From [EMAIL PROTECTED], etc).
I do not want something that has to be done by schema, as I
have 50+ schema's to compare.
ALSO - on a side note, is there an 'easy'
way of duplicating a PRODUCTION
script has more than one slashes(/)
inside it?
code
when I learn something, I go : was that all? and they go,
yes, yes, that was all... Well, let me show you what I mean..
What does it mean when a .sql script has more than one slashes(/)
inside it?
code
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mercadante, Thomas
Your script contains URL? May be, if you show us the code snippet,
we could tell you something that actually makes sense? Not that is normally
to be expected from the DBA crowd, but you are welcome to try.
Do you feel lucky?
On 11/07/2003 01:39:26 PM, Maryann Atkinson wrote:
Sorry if I bore you
Mladen Gogala scribbled on the wall in glitter crayon:
try. Do you feel lucky?
No.
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
[EMAIL PROTECTED]
In the
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Why does script have more than one slash(/) inside?
Sorry if I bore you all with my dumb questions, its just that
the simplest and silliest things appear complex, if we dont know them...
Often when I learn
Hi
Not sure what the original question was BUT the script offered splits
exports so you may be interested in a tool Kurt van Meerbeeck and
Kugendran Naidoo wrote called Ora*PePi availbale on sourceforge - the
description from there reads:
quote
Ora*PePi is a superset of the Oracle export/import
. or you can run the
following script (modified to suit your system, it was last tested on
Solaris/Oracle 7.3.4)
#!/bin/sh
#
cd $EXPORT_DIR
#
# set maximum file size for each chunk of the export file
#
MAXFILESIZE=2000m
export MAXFILESIZE
#
# create filenames for the parts of the backup... for now
-Original Message-
Sent: 16 May 2001 22:28
To: Multiple recipients of list ORACLE-L
there is a note out on Metalink on how to do this. You can also break
the
export into separate files in later versions of Oracle8i. or you can
run the
following script (modified to suit your system
Title: Setting environment variable in Perl script
I need some help with a perl script! I have a script that currently does batch compiles of forms and reports so I know it works. However, I need to have a version of it for compiling forms in French using the NLS_LANG
Can anyone point me to a definitive hot back up script for Oracle 9 on AIX,
please
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Yes Im on Windows xp the script names and dir structure should be the
same though...
Here is buildall.sql
buildall.sql
spool \build.log
SET TERMOUT OFF
SET ECHO OFF
connect internal
@@build_db.sql
@C:\oracle\ora81\RDBMS\admin\catalog.sql
@C:\oracle\ora81\RDBMS\admin
buildall.sql?
Guang
-Original Message-
Bob Metelsky
Sent: Thursday, October 09, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L
installation)?
Yes Im on Windows xp the script names and dir structure should be the
same though...
Here is buildall.sql
buildall.sql
Mark,
I didn't fully understand you're earlier post, but now it seems that
the sqlunldr.pl script in the PDBA toolkit may do what you want.
http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/
It will dump blobs to hex in a sqlldr compatible file, along with
the control and parameters script
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time. I
let the installation to create a sample db. Now I am trying to see where I
can find the db creation script, so I can study it and use it to create db
instance manually. I can only find a bounch of log files
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
calls several others
bob
-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st
check this script which
calls several others
bob
-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st time.
I
let the installation to create
into new_data from table for update;
dbms_lob.writeappend(new_data, offset,
hextoraw('the_hex_returned'));
end;
So, to summarise. It's possible to convert BLOB's to hex, place the
results into a basic sql script and have then reloaded into a table.
Unfortunately you can only work on 1K of data
Guang - If you run dbca, Oracle's Database Creation Assistant, there is an
option that will create a script for you instead of a database. I was never
able to get this to work, but others on this list reported success.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED
:
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
calls several others
bob
-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st
Note that the foofoofoo volume causes the disk info to show up on the
following line. A script I have that loops through each line coming back
from bdf is breaking because of this. Any simple way to bring the line back
up to the Filesystem line using awk, sed etc...?
bdf -l
Filesystem
I don't know if it will be available on your platform but have you tried
using fold to see of that affects your script. I didn't think line
wrapping was an issue with a script, so it seems to be a bug in bdf. have
you tried just df
Cheers
Hi Ethan,
Our SA gave me the following script...
Put it in your /usr/local/bin and include the dir in PATH...
- Kirti
#!/bin/ksh
# -- bdfg
COUNT=0
bdfit () {
if [ -z $SIZE ] ; then
LVOL2=$LVOL
((COUNT=1))
else
if [ $COUNT -eq 1 ] ; then
echo $LVOL2 $LVOL $SIZE $USED $FREE
Title: Question with lock script - phantom objects
Hi all,
I am using following script to see locks in the DB. Do you see any problems with it?
cut here =
connect / as sysdba
set linesize 200 feedback off heading on pagesize 100
column sid
The script as such works, but I do not like user scripts
accessing objects owned by SYS directly. I normally use
modified version of utlockt.sql in which dba_locks_temp
and lock_holders are global temporary tables in my schema
which do not get dropped re-created every time.
On Mon, 2003-10-06
]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 06 Oct 2003 07:29:30
--_=_NextPart_001_01C38C16.3B1E156B
Content-Type: text/plain;
charset=iso-8859-1
Hi all,
I am using following script to see locks in the DB.
Do you see any problems
Title: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
PROTECTED]
Date: 2003/10/06 Mon PM 12:24:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj
Hi List,
I have been asked to look into the possibility of populating a BLOB column
(Oracle 8i currently) using an SQL Script. All the examples I've ever seen
involve reading the blob from a file and inserting it directly to the table
though.
The reasoning behind this is the desire to deliver
Betreff: RE: UNIX : script help/input
Good! The more the merrier! Welcome to the club.
Oh most definitely.
As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.
I
Title: RE: UNIX : script help/input
XOR that gives me some painful memories in recent days ... xor is possible in pl/sql but needs a little work. I migrated a C encryption code to pl/sql and then use utl_tcp to sent it to our router which feeds the modem banks.
This is how I worked
Note:
This message is for the named person's use only. It may
contain confidential, proprietary or legally privileged
information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message in
error, please immediately delete it and all
Johan:
Please see the attachment file, which is my script for everyday web
server log file and uses nslookup to process the results. Hope that it
is helpful.
Don
Johan Muller wrote:
Anybody with a quick and dirty (elegant would be nice too), to munge
output from a nslookup output file
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:AW: UNIX : script help/input
Hi
Speaking of Perl, ... maybe somebody (Jared) can help out with some Perl /
Windows problems:
I'm using ActiveState 5.6 with DBI module, which works fine. Now, since I
]
Sent by: [EMAIL PROTECTED]
10/02/2003 05:54 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: UNIX : script help/input
XOR that gives me some painful memories in recent days ... xor is possible in pl/sql
, October 02, 2003
2:20 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: UNIX : script help/inputRaj, I did consider doing
it this way, but the thought of writing stuff to the bit level for a prototype was just too painful.
Left pad with zeroes, take a substring,
feed
[EMAIL PROTECTED] wrote:
Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.
Jared, what Oracle edition do you use? I'm asking because you might
want to consider not to use 'handy-dandy' hex/oct/bin/dec converter
package, but
Jamadagni, Rajendra wrote:
unfortunately we _had_ to do it in pl/sql ... it is part of the
encrypted feed that we send out to our clients ... it is decoded by a chip.
Oh well I am back to array of references ...
I'd suggest to consider external C function -- it's faster, it's
easier to
Title: RE: UNIX : script help/input
it was actually C code ... but because data is going on a modem, the pl/sql speed is acceptable (in fact we have to _wait_ after sending out each message). Had fun doing that though ... it is critical, tied to our SLA ... so must be up all the time. I'd
-L [EMAIL PROTECTED]
cc:
Subject:Re: UNIX : script help/input
[EMAIL PROTECTED] wrote:
Left pad with zeroes, take a substring, feed it to the handy-dandy
hex/oct/bin/dec converter package - much easier.
Jared, what Oracle edition do you use? I'm asking because you might
want
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: UNIX : script help/input
Jamadagni, Rajendra wrote:
unfortunately we _had_ to do it in pl/sql ... it is part of the
encrypted feed that we send out to our clients ... it is decoded by a chip.
Oh well I am back
Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file?
'File content:
Server: dns1.mci.comAddress: 199.249.19.1
Name: WCOM-4NXZGAPWY5.mcilink.comAddress: 166.50.73.209
Delimited file should have the following line(s); (using |
Anybody with a quick and dirty (elegant would be
nice too), to munge output from a nslookup output
file to a delimited file?
'File content:
Server: dns1.mci.com
Address: 199.249.19.1
Name:WCOM-4NXZGAPWY5.mcilink.com
Address: 166.50.73.209
Delimited file should have the following
I supposed if you send to a file, we can read it using ORACLE to parse
it w/plsql and then using utl_file write it back out but seems like
overkill to use oracle for that, but then again this is an oracle list,
so i'll have to assume thats what you wanted, anyone up for the task :)
joe
Johan
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
@LB=split /\s+/;
if ($LB[0] =~ /^name:/i) {
$NAME=$LB[1];
}
if ($LB[0] =~ /^address:/i) {
$IP=$LB[1];
write;
}
}
format STDOUT=
@ ,@
$NAME,$IP
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~
On Wed, 2003-10-01 at 13:24, Johan Muller wrote:
Mladen,
It worked!
Did you have any doubts? That's precisely what perl is good for.
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From:
Johan Muller
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 8:24
PM
Subject: Re: UNIX : script
help/input
Mladen,
It worked!
Heartfelt thank you
-LSubject:
Re: UNIX : script help/input
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From:
Johan
Muller
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 8:24
PM
Subject: Re: UNIX : script
help
:)
On Wed, 2003-10-01 at 10:24, Johan Muller wrote:
Mladen,
It worked!
Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).
Mladen Gogala [EMAIL PROTECTED] wrote:
#!/usr/bin/perl -w
use strict;
use bytes;
my ($NAME,$IP,@LB);
while () {
chomp;
Thank God for Jared -Original Message-
From: Tanel PoderSent: 10/1/2003 10:37:55 AMTo: [EMAIL PROTECTED]Subject: Re: UNIX : script help/input
Thank God for Perl and Mladen ;)
Tanel.
- Original Message -
From: Johan Muller
To: Multiple recipients of list ORACLE-L
On Wed, 2003-10-01 at 14:34, Jamadagni, Rajendra wrote:
Funny .. I am currently sitting in a Perl class, so I can actually
read what MG has written. I'll be soon Perl-literate ...
Raj
Good! The more the merrier! Welcome to the club.
Note:
This message is for the named person's use only.
-
From: Johan Muller mailto:[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:24 PM
Subject: Re: UNIX : script help/input
Mladen,
It worked!
Heartfelt thank you
Good! The more the merrier! Welcome to the club.
Oh most definitely.
As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.
I finally bit the bullet and used string
Jared
Jared Still wrote:
Good! The more the merrier! Welcome to the club.
Oh most definitely.
As I just finished writing a prototype package for assigning MAC
addresses ( we make network stuff - that's a technical term ), I
have endured the agonies of doing hex math in PL/SQL.
I finally bit the
Hello:
I was wondering if anyone knew of a source that listed what each of the
scripts in RDBMS (catproc, etc) functionality.
So far I have only been able to find a small listing (10 common scripts),
and was hoping someone might have a more complete list.
I know that they are different version to
Jay
Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level script
: Oracle Script Documentation
Jay
Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need
.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/09/05 Fri AM 11:24:29 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle Script Documentation
Jay
Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing
PROTECTED]
Subject: RE: Oracle Script Documentation
Date: Fri, 05 Sep 2003 07:24:29 -0800
Jay
Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must
check http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScrId=993
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 10:44
PM
Subject: perl/shell script for alert
log
I am sure you guys
I am sure you guys might have some nice
perl/shell script to analyze alert log for errors or potential problem . Can you
share it with me /list .
Ohh thanks in advance guys .
-ak
HTH
#!/bin/sh
# This Script search for Oracle error messages in last
100 lines in the alert log file ,
# keep log to a file.
# You should pass name of ORACLE_SID as a parameter.
#!/usr/bin/sh
#
# Comments: Script checks last 100 lines of
# the alert log for specific
# Oracle errors, e-mails
http://www.oracledba.co.uk/
Check out the alert log script in the admin section. Doesn't
repeatedly check the same segment of the alert log file.
- Ethan
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, August 27, 2003 12:14
PMTo: Multiple
AK - Go to Google and search on oracle alert log monitor script. This will
give you an array to select from. What you want will depend to a large
extent on your requirements:
- Something you can easily modify?
- What platforms should it run on?
- Email you alerts?
- Which errors do you wish
When I grep something from the alert log,
it never tell me the date and time of the error.
Is there a setting for appending a timestamp on each error?
-Original Message-
Sent: Wednesday, August 27, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
HTH
#!/bin/sh
# This Script search
If you use Connor's script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email. Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.
One enhancement I suggest
script you can modify it to send you the entire chunk of
file it is currently checking in the body of the email. Ideally you are
checking at a frequent interval so the time of the alert is usually about
the same time you get the error message.
One enhancement I suggest to every script is to configure
Hi!
I would add a check for Checkpoint not complete in alert just in case as
well.
Tanel.
One enhancement I suggest to every script is to configure the a
SERVERERROR
trigger to throw certain errors out to the alert log. ORA-1555 is one
that
will show up at the session level
Hey, awesome tip! Been here, lurking. Does that generate a trace file with
more than just session id and serial# in it? Nice thing about SERVERERROR
is I can get machinename, username, osuser etc and stuff it in alert log
so I see who caused the error when I get the email, but your way is
Yeah, I log those. Some of the db's I support run with very small redo logs
and I can't change. They get those quite frequently at times so I pretty
much ignore them. My script also reacts (log,email,page, or run some
script) in the event of startups, shutdowns and alter database structure
Hi All,
If poss, could someone please provide me the script to
compare two schemas?
Thanks in advance,
Sami
__
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Thanks all. The replies have been really helpful.
Reuben D. Budiardja.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
Title: RMAN Script Question
Thanks
Samir, but I already tried that one too and it didn't work
either.
Best regards,
David B. Wagoner Database Administrator Arsenal Digital
Solutions-Original Message-From:
SARKAR, Samir [mailto:[EMAIL PROTECTED]Sent:
Wednesday, August 06, 2003 9
Title: RE: How to tell Oracle the directories of script files
Use SQLPATH.
Alan Martin
Defense Logistics Info Service
Battle Creek, MI
-Original Message-
From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 14, 2003 2:09 PM
To: Multiple recipients of list
Hello,
Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin
directories, etc.
If I start 'sqlplus' from console in /home/user directories, I can
load/execute the script by doing:
SQL @scriptname
But what if I don't start sqlplus from that directories? How do I tell
:
[EMAIL PROTECTED] Subject: How to tell Oracle the
directories of script files
om
Title: RMAN Script Question
I believe I have an RMAN script syntax error. The following script works fine:
resync catalog;
run {
allocate channel t1 type 'SBT_TAPE';
backup incremental level 0
skip inaccessible
tag hot_db_bk_level0
filesperset 5
format 'data_full_%d_%U_%p_%c.bak' (database
RDB,
It is always best to include the path for the script that you want to
execute. That way you make sure that you execute your script and not
someone else's. There can be many scripts of the same name in the
directory path.
Ron
[EMAIL PROTECTED] 08/14/03 03:19PM
Yes there is a way. In UNIX
Title: RMAN Script Question
David,
Change the
following line in ur script :
backup database plus archivelog delete
input
to
backupincremental level = 0plus
archivelog delete input
Hth,
Samir
Samir Sarkar Oracle DBA SchlumbergerSema Email : [EMAIL PROTECTED] Phone : +44 (0) 115
/user directories, I can
load/execute the script by doing:
SQL @scriptname
But what if I don't start sqlplus from that directories? How do I tell
Oracle
to find the scripts in /home/user, then if it's not there in
/usr/local/bin,
for example? So that I can be anywhere in the filesystem when
start 'sqlplus' from console in /home/user directories, I can
load/execute the script by doing:
SQL @scriptname
But what if I don't start sqlplus from that directories? How do I tell Oracle
to find the scripts in /home/user, then if it's not there in /usr/local/bin,
for example? So that I can
1 - 100 of 983 matches
Mail list logo
