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,
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, De
: "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
> constra
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-- Ma
12/30/2003 11:24 AM
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 t
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
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_constra
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
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
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
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
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 '
> 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
&g
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_
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, Pet
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 useful
--_=_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,
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
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 o
pond to ORACLE-L
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 co
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
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
Often 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, T
script has more than one slashes(/)
inside it?
code
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:
Ora*PePi is a superset of the Oracle export/import tools
gt; Regards
>
> Lee
>
> -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, 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
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
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 paramet
part in your 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
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
ob Metelsky wrote:
%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
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 PROT
new_data blob;
begin
select data into new_data from table for update;
dbms_lob.writeappend(new_data, ,
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
hem 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 t
%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
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 in
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
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 d
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
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 de
ra" <[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 me
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 emai
a"
><[EMAIL PROTECTED]>
>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
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, 200
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
To: Multiple 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
ltiple recipients of list ORACLE-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
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
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 writ
[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 TO_CHAR/T
: Thursday, 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 it to the
t; <[EMAIL PROTECTED]>
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 pain
e respond to ORACLE-L
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
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 f
> 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
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 ho
An: Multiple recipients of list ORACLE-L
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 en
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 b
> 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
> Tanel.
>
> - Original Message -
>
> From: Johan Muller <mailto:[EMAIL PROTECTED]>
> To: Multiple recipients of list ORACLE-L
> <mailto:[EMAIL PROTECTED]>
> Sent: Wednesday, October 01, 2003 8:24 PM
> Subjec
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 on
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
:)
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 (<
RACLE-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
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
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 confidenti
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] =~ /^a
#!/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
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 M
>
>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 fol
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); (usi
I am trying to test a hot backup script I downloaded from one of the
Oracle sites. Everything works great but there is one statement that
backs up the control file to a specific file. I can't get the command
interpreter to handle it properly. The script is generating a SQL
script which is
of list ORACLE-L <[EMAIL 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 ot
a copy of that source code lying around? Id like a copy.
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 leag
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 the scripts is that many of the
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 s
Hi Jay,
I know this is obvious but each script generally has a short description
at the top of each file. Some of these are pretty short one liners bear
in mind but it is a start!.
If you do find a complete list let us know it sounds like it could be
useful to know where a list for the future
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
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
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 str
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 cl
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 sessi
recipients of list ORACLE-L
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.
On
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 sugge
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
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 to
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
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
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
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-- Mail
ntrol\Backup01o920.ctl' REUSE;
ARCHIVE LOG LIST
SHOW PARAMETER ARC
ALTER DATABASE OPEN;
spool off
exit
Note: the listener does not have to be shut down for a cold backup.
Have Fun :)
mike mon wrote:
Does anyone has NT cold backup script for ORACLE that
I can reference?
The script I ne
ECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: How to tell Oracle the
directories of script
Does anyone has NT cold backup script for ORACLE that
I can reference?
The script I need include :
shutdown listener
shutdown service service
shutdown DB
backup files
startup DB
startup Service
startup listener
Thanks.
__
Do you Yahoo
2003 2:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to tell Oracle the directories of script files
>
>
> export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin
>
> before you run SQL*Plus
>
> HTH
> Stephen
>
> >>> [EM
Btw, did you know that you can use:
@http://www.servername.com/script.sql and
@ftp://ftp.servername.com/dir/script.sql in 9i sqlplus :)
It can be nice in environment where you continously have to work with random
different servers and cant copy your script set over every time..
Tanel
; 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 be
To: Multiple recipients of list ORACLE-L
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
1 - 100 of 1050 matches
Mail list logo
