Ross;
Prety soon you are going to have enough p.p.p...s's to sink a
battleship. Ain't political correctness fun.
-Original Message-
Sent: Monday, June 18, 2001 3:22 PM
To: Multiple recipients of list ORACLE-L
Yea, Paul, what gives?
Are you saying that we should all
just stop
il: [EMAIL PROTECTED]
> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 18, 2001 11:12 AM
> To: Multiple recipients of list ORACLE-L
> Subject: NT Script
>
> Hello all,
> I know, I know, NT. Anyway, I was wo
What the?:)
-Original Message-
Sent: Monday, June 18, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L
Yea, Paul, what gives?
Are you saying that we should all
just stop learning, give up, FDISK /MBR
our NT hard drives, Bobbetize our nether parts
and head for the coast?
Huh?
Ar
Yea, Paul, what gives?
Are you saying that we should all
just stop learning, give up, FDISK /MBR
our NT hard drives, Bobbetize our nether parts
and head for the coast?
Huh?
Are ya?
Gawd, I wish Eric were here; he'd slap
you around with the Barbie you so clearly need.
:)
(that was the oblig
ng your export .par file dynamic.
Call an sqlplus script that produces (spools) either the export.bat
(and include the file= in the command line)
or the export.par file.
In this manner, you won't have to know every trick in the nt scripting world
- and better yet - its a more cross-platfor
Kevin.
"Stick to what you are good at."
Are you good in working with sqlplus?
Leverage that skill into making your export .par file dynamic.
Call an sqlplus script that produces (spools) either the export.bat
(and include the file= in the command line)
or the export.par file.
In t
e-
> From: Mercadante, Thomas F
> Sent: Monday, June 18, 2001 1:47 PM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: NT Script
>
> Kevin
>
> Attached is a TODAY.BAT file that, when called, creates three
>
Attachment(s) from this message have been deleted because they were named
with one of the following extensions:
ADE, ADP, BAS, BAT, CHM, CMD, COM, CPL, CRT, EXE, HLP, HTA, INF, INS, ISP,
JS, JSE, LNK, MDE, MSC, MSI, MSP, MST, PCD, PIF, REG, SCR, SCT, SHS, URL,
VB, VBE, VBS, WSC, WSF, WSH.
These
I did this on another server and can't remember the exact details, but it
went something like this:
1) In SQLPlus create a rename.sql file with:
Spool rename_export.bat
select 'HOST REN export_file_name
export_file_name_'||to_char(sysdate,'MMDD')
FROM DUAL;
spoo
Hello all,
I know, I know, NT. Anyway, I was wondering if anyone knew how to append
the system date to a file created through a script. Basically, what I want
to do is have files set up to run exports every night, however, I need to be
able to appened the system date to the file when it
On Monday 11 June 2001 10:21, Henry Poras wrote:
> Jared,
> Thanks for the summary. Any comments on where Tcl fits in to the mix?
>
I've not used TCL, so I can't really say too much about it. It is generally
considered simpler than Perl, and likewise less robust.
TK is another matter. If you
Message-
> Sent: Friday, June 08, 2001 01:46
> To: Multiple recipients of list ORACLE-L
>
>
>
> Well, you've got the right idea, just in the
> wrong order.
>
> The korn shell does not compile the whole script
> and then execute as say Perl does.
>
> It
ers
>
> Dorothy "Red Shoes"
>
> -Original Message-
> Sent: Friday, June 08, 2001 01:46
> To: Multiple recipients of list ORACLE-L
>
>
>
> Well, you've got the right idea, just in the
> wrong order.
>
> The korn shell does not co
com> cc:
Sent by: Fax to:
root@fatcity.Subject: Re: du
r
> invaluable knowledge..
>
> Cheers
>
> Dorothy "Red Shoes"
>
> -Original Message-
> Sent: Friday, June 08, 2001 01:46
> To: Multiple recipients of list ORACLE-L
>
>
>
> Well, you've got the right idea, just in the
> wrong order.
>
>
;Red Shoes"
-Original Message-
Sent: Friday, June 08, 2001 01:46
To: Multiple recipients of list ORACLE-L
Well, you've got the right idea, just in the
wrong order.
The korn shell does not compile the whole script
and then execute as say Perl does.
It executes it a line at a time
Well, you've got the right idea, just in the
wrong order.
The korn shell does not compile the whole script
and then execute as say Perl does.
It executes it a line at a time.
So rearrange your script like so:
==
#!/bin/ksh
function quick_test {
Thank you Michael and Balaji. It works! I'm still in
vb mind. vb is what I was doing. shell script is a
mistery to me.
--- Janet Linsy <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> This must be a really dumn question. :-<
>
> I have a script which doesn't work
Hi all,
This must be a really dumn question. :-<
I have a script which doesn't work well, since it
doesn't recognize a subroutine. I compared my code
with other codes that work fine with sub function, and
didn't see any difference. (at least look the same
style to me.)
S
, it is relatively simple:the_val=$1
#set a script variable to the passed
valuecat text_file | sed "s.abc/xyz.$the_val.g" >new_filemv new_file
text_fileKeep it as simple as possible.-Original
Message-From: Satish Iyer
[SMTP:[EMAIL PROTECTED]]Sent: Tuesday, June 0
For something as you have described, it is relatively simple:
the_val=$1 #set a script variable to the passed value
cat text_file | sed "s.abc/xyz.$the_val.g" >new_file
mv new_file text_file
Keep it as simple as possible.
-Original Message-
From:
>Hello List,
>
>This must be piece of cake for the UNIX gurus.
>
>Trying to pass parameters to a simple awk script. Getting stuck.=20
>First q., can we do that.=20
>If yes I need to solve the foll. problem,
>
>In a huge text file locate for "abc/xyz" and re
That's easy.
At 04:30 PM 6/5/01 -0800, you wrote:
Hello
List,
This must be piece of cake for the UNIX gurus.
Trying to pass parameters to a simple awk script.
Getting stuck.
First q., can we do that.
If yes I need to solve the foll. problem,
In a huge text file locate for "ab
wrote:
> Hello List,
>
> This must be piece of cake for the UNIX gurus.
>
> Trying to pass parameters to a simple awk script. Getting stuck.
> First q., can we do that.
> If yes I need to solve the foll. problem,
>
> In a huge text file locate for "abc/xyz"
Hello List,
This must be piece of cake for the UNIX gurus.
Trying to pass parameters to a simple awk script.
Getting stuck.
First q., can we do that.
If yes I need to solve the foll. problem,
In a huge text file locate for "abc/xyz" and
replace it with a supplied param
;
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: NT script question ???
>Date: Mon, 04 Jun 2001 16:20:49 -0800
>
>Go to http://www.activestate.com, get perl, DBI & DBD::Oracle and you'll
>have all the cripting t
cripting tools? Mladen, is that some new Egyptian software?
>From: "Gogala, Mladen" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: NT script question ???
>Date: Mon, 04
Go to http://www.activestate.com, get perl, DBI & DBD::Oracle and you'll
have all the cripting tools that you'll ever need. Associative arrays, state
of the art reuglar expressions, functions, format commands and well
documented
ways of accessing the oracle database from w
un,
Bruce
-Original Message-
Sent: Monday, 4 June 2001 2:35
Hi,
Thank you all very much for answering my NT batch
script question. Do you mind I ask another one? I
pass in SID as a parameter, if they don't pass it in,
I'd like to echo out an error message. So how to
check wh
Hi,
Thank you all very much for answering my NT batch
script question. Do you mind I ask another one? I
pass in SID as a parameter, if they don't pass it in,
I'd like to echo out an error message. So how to
check whether the parameter is passed in or not?
I never write bat file be
se subdir's) or be
blank.
echo.
echo eg "%0 c:\temp *.* 5 -s" would delete ALL files
echo in c:\temp directory (incl subdirs) 5 or more days old
goto end
:end
rem - batch file finished
set envdelold=
-
t;
> Hi, one more question about bat script in NT 4.0:
>
> when I put del c:\test\*.* in the bat file, and run
> it, I got Are you sure (Y/N)?, how to surpress this
> question?
>
> Thank you.
>
del /Y
Paul
C:\>del /?
Deletes one or more files.
DEL [/P] [/F] [/S] [
Andrea Oracle wrote:
>
> Hi, one more question about bat script in NT 4.0:
>
> when I put del c:\test\*.* in the bat file, and run
> it, I got Are you sure (Y/N)?, how to surpress this
> question?
>
> Thank you.
>
del /Y
Paul
C:\>del /?
Deletes one or more
Hi, one more question about bat script in NT 4.0:
when I put del c:\test\*.* in the bat file, and run
it, I got Are you sure (Y/N)?, how to surpress this
question?
Thank you.
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
Hi,
I have couple of questions about bat file in NT 4.0
for Oracle 8.1.5.
1. how to make bat file take parameters. I had a
backup.bat, and like to pass in Oracle SID, so the
script can backup any database.
2. in the bat file, how to dynamically append
date/time into a directory name, like
Hi Gurus,
Thanks to those who replied. We feel that Unix account is easily hacked, so
we will not implement the method that Rachel mentioned. We will probably
"encrypt" the password in another file. Before exporting, we will decrypt
the password before passing the password to the exp
TED]>
Date: Thu, 31 May 2001 05:07:24 -0800
a) Changet the script to
print "system/password" | exp full=y ...
so no-one can see it with a 'ps'
b) chmod 700 daily_exp.sh
so no-one except the (presumably) oracle account can
see the script
hth
connor
--- "CHAN Cho
The system password is stated clearly in the export script file. Has anyone
> encrypt/decrypt the system password before passing it as a variable to the
> export script ? If yes, could I have a copy of your script ? Thanks.
>
> Regds,
> New Bee in Unix
>
Create an externally i
> -Original Message-
> From: Fisher, Julie [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to encrypt Password in Export script file ?
>
> I also did this on all my databas
ct"
grant this account create session and exp_full_database
then change your shell script to read userid="/" and run the script from
the exportacct account
this way you don't need to hardcode a password ANYWHERE
Rachel
>From: "CHAN Chor Ling Catherine (CSC)" <
SC) [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 3:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to encrypt Password in Export script file ?
>
> Hi Unix Gurus,
>
> My daily export file (daily_exp.sh) contains :
> exp userid='system
ortacct"
grant this account create session and exp_full_database
then change your shell script to read userid="/" and run the script from
the exportacct account
this way you don't need to hardcode a password ANYWHERE
Rachel
>From: "CHAN Chor Ling Catherine (
a) Changet the script to
print "system/password" | exp full=y ...
so no-one can see it with a 'ps'
b) chmod 700 daily_exp.sh
so no-one except the (presumably) oracle account can
see the script
hth
connor
--- "CHAN Chor Ling Catherine (CSC)"
<[EMAIL P
OTECTED]>
Date: Wed, 30 May 2001 08:26:45 -0400
Subject: Script examples for NT. (yuk!)
Quick question..
ALL of my experience has been on UNIX platforms... Recently, I have been
asked to work on an Oracle DB that runs on NT.. My scripting capability in
the NT world is "weak" at
Hi Unix Gurus,
My daily export file (daily_exp.sh) contains :
exp userid='system/password' file=file_name.dmp grants=y rows=y
constraints=y compress=y full=y inctype=complete log=file_name.log
The system password is stated clearly in the export script file. Has anyone
encrypt/d
You can download CyGWin from Redhat for free that will give you a very nice
cloned shell of linux environment, full compatable with Bash/Sh scripting.
Wish i could find a ksh shell for it, but it has ALOT of the tools normally
available with Unix. ps, kill, grep, tail, head, piping, shell script
My suggestion would be to install cygwin
(http://sources.redhat.com/cygwin/).
> -Original Message-
> From: GLoughmiller [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 8:25 AM
> To: ORACLE-L
> Cc: GLoughmiller
> Subject: Script examples for NT. (yuk!)
>
AIL PROTECTED]> ]
> -Original Message-
> From: Andrew S. Baker [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 29, 2001 8:46 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Yet another scripting question
>
>
> >>However, if the user
Quick question..
ALL of my experience has been on UNIX platforms... Recently, I have been
asked to work on an Oracle DB that runs on NT.. My scripting capability in
the NT world is "weak" at best. So I am trying to compare ksh type
activities with the NT world. SO I was wondering if any of you w
Hi,
Within your *.sql script you can jump to the OS and give OS commands.
e.g: host sqlldr. (start with host).
I have used it with import and it works.
Jack
th Oracle 8.
> I would like to know if it's possible invoke SQL Loader inside a script.
>
> Example:
> - inside the script I want to create a new table TABLE1
> - copy some data inside TABLE1 using SQL loader
> - work on TABLE1 using SQL language.
>
> Is it possib
:Re: Script and control file
see the host command in pl/sql
>>> [EMAIL PROTECTED] 05/29/01 11:15AM >>>
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script
ssage-
Sent: Tuesday, May 29, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L
Andrea,
Is this UNIX or NT.
In UNIX ( I don't know NT that well), the most simple method would be to use
a shell script.
The following is about as basic as it comes but would need to be embellished
with e
Andrea,
Is this UNIX or NT.
In UNIX ( I don't know NT that well), the most simple method would be to use
a shell script.
The following is about as basic as it comes but would need to be embellished
with environment settings and error checking etc..
eg.
Start of S
see the host command in pl/sql
>>> [EMAIL PROTECTED] 05/29/01 11:15AM >>>
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the sc
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want to create a new table TABLE1
- copy some data inside TABLE1 using SQL loader
- work
On Thursday 24 May 2001 17:20, Helmut Daiminger wrote:
> Does anybody out there have a script to compare to database schemas and
> list the differences?
I'm forwarding a post I made on this topic a few days ago.
Jared
-- Forwarded Message --
Date: Sun, 13 May 20
Hi!
Does anybody out there have a script to compare to database schemas and list
the differences?
I know this has been posted a few times, but I don't have the emails anymore
and can't find anything in the archives... Sorry.
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see th
On Friday 18 May 2001 18:01, Jacques Kilchoer wrote:
> I hope Mr. Still won't mind if I post another script in the same vein, that
> I used after hearing him recommend this approach. This one also drops
> public synonyms for objects in the schema being dropped. Pl
DUHHH !
> >
> > I could write the algorithm to solve the logarithm .. IF I ONLY
HAD A
> > BRAIN ..
> >
> > Thank you to all of you, and special thanks for not bashing me
> >
> > Luis Octavio
> >
> > Luis DeUrioste wrote:
> > &g
Title: RE: A drop schema script ??
> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
>
> I've found that when dropping a schema owner, it's much easier
> to drop their objects individually, then drop the user.
I hope Mr. Still won
Thank you Jared for the words of encouragement and specially for the "SCRIPT"
Luis Octavio
Jared Still wrote:
> Luis,
>
> Don't feel bad, this is a valid question.
>
> DROP USER CASCADE is not always the most efficient way to
> drop a user, especially a us
> uhhh DUHHH !
>
> I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
> BRAIN ..
>
> Thank you to all of you, and special thanks for not bashing me
>
> Luis Octavio
>
> Luis DeUrioste wrote:
>
uhhh DUHHH !
I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
BRAIN ..
Thank you to all of you, and special thanks for not bashing me
Luis Octavio
Luis DeUrioste wrote:
> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema sc
GROAN
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 10:50:39 -0800
>
>Mr
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 4:48 PM
> How about:
>
> drop user cascade;
>
>
> --- Luis DeUrioste <[EMAIL PROTECTED]> wrote:
> > All mighty and powerful DBA supremes !
> >
> > Do any of you hav
Login in as system:
drop user user_name cascade;
-Original Message-
Sent: Thursday, May 17, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be gr
How about:
drop user cascade;
--- Luis DeUrioste <[EMAIL PROTECTED]> wrote:
> All mighty and powerful DBA supremes !
>
> Do any of you have a drop schema script that would be willing to share
> ??
> It'll be greatly appreciated
>
> T I A
>
> > begin
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated
T I A
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
versio
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:
> Who was the half person?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Deal! :)
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows from table
>Date: Thu, 17 May 2001 09:31:33 -0800
>
>
nt: Thursday, May 17, 2001 1:32 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: Re: Script that will remove redundant rows from table
> ||
> ||
> || How about we split the difference?
> ||
> || | 1* select (25.25+27.5)/2 from dual
recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
||
||
|| How about we split the difference?
||
|| | 1* select (25.25+27.5)/2 from dual
|| |SQL> /
|| |
|| |(25.25+27.5)/2
|| |--
|| |26.375
|| |
||
|| (no this is not the m
HELP
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Script that will remove redundant rows from table
||
||
|| How about we split the difference
How about we split the difference?
| 1* select (25.25+27.5)/2 from dual
|SQL> /
|
|(25.25+27.5)/2
|--
|26.375
|
(no this is not the mean)
On 16 May 2001, at 19:36, Rachel Carmichael wrote:
> now now, don't exaggerate it was only 25 & 1/4 people
...
> >didn't 27 & 1/
ED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows from table
>Date: Wed, 16 May 2001 17:45:22 -0800
>
>didn't 27 & 1/2 people post the answer to this yesterday???
>
>On 16 May 2001, at 17:10, H
7;t 27 & 1/2 people post the answer to this yesterday???
On 16 May 2001, at 17:10, Haskins, Ed wrote:
> A few months ago I remember seeing a script that enabled the removal of
> redundant rows in a table.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: E
On Wed, 16 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
->de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to
->the punch.
Hi, I'm Bill and I'm a Goddess Groupie.;-)
->
->Now. in 8i (not sure which flavor) you can have export do the split as
->pa
s are a life saver.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 5:27 PM
> 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
delete from table the duplicates.
> -Original Message-
> From: Haskins, Ed [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 17, 2001 04:10
> To: Multiple recipients of list ORACLE-L
> Subject: Script to remove redundant rows in a table?
>
> A few months ago I rem
Rachel Carmichael wrote:
>
> de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to
> the punch.
>
> Now. in 8i (not sure which flavor) you can have export do the split as
> part of the export. I don't think it compresses it but it will at least
> break the files down
>
now now, don't exaggerate it was only 25 & 1/4 people
>From: "Eric D. Pierce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Script that will remove redundant rows
el A" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Export Split Script
>Date: Wed, 16 May 2001 14:05:29 -0800
>
>Thanks, Rachel. You're a sweetheart.
>
>Michael Arms
A few months ago I remember seeing a script that enabled the removal of
redundant rows in a table. Can someone please forward or point me to such a
script.
I have an Oracle Names server that stores the database connect descriptors
in a table within the Region Database. I've loaded these co
didn't 27 & 1/2 people post the answer to this yesterday???
On 16 May 2001, at 17:10, Haskins, Ed wrote:
> A few months ago I remember seeing a script that enabled the removal of
> redundant rows in a table.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Title: auditing tables
A few
months ago I remember seeing a script that enabled the removal of redundant rows
in a table. Can someone please forward or point me to such a
script.
I have
an Oracle Names server that stores the database connect descriptors in a table
within the Region
t; To: Multiple recipients of list ORACLE-L
> Subject: RE: Export Split Script
>
> 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
; Glaxo SmithKline
>
> > -Original Message-
> > From: Rajaram [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 16, 2001 4:31 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Export Split Script
> >
> > If you are using Or
16, 2001 4:04 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Export Split Script
Rajaram,
Please give me details on how to use mknod to split export files larger
than
2 GB. We have broken our jobs into over 50 separate export jobs on the
tabl
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
Pharmaceuticals IT
Glaxo SmithKline
> -Original Message-
> From: Rajaram [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Export Split Script
>
> If you are using Oracle on Unix , You may want to u
essed export and the output is still over 2G. Does
>anyone have the export script that splits the export files into multiple
>files?
>
>Ron Smith
>Database Administration
>[EMAIL PROTECTED]
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: S
ent: Wednesday, May 16, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L
Subject:Export Split Script
I tries using a compressed export and the output is still over 2G. Does
anyone have the export script that splits the export files into multiple
files?
Ron Smith
Database Administrat
the output is still over 2G. Does
> anyone have the export script that splits the export files into multiple
> files?
>
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
http://www.oracle.com/oramag/code/tips1998/index.html
1/16/98
>
>I tries using a compressed export and the output is still over 2G. Does
>anyone have the export script that splits the export files into multiple
>files?
>
>Ron Smith
>Database Administration
>[EMAIL PRO
http://www.oracle.com/oramag/code/tip01168.html
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Export Spli
On Wed, 16 May 2001,Smith, Ron L. scribbled on the wall in glitter crayon:
->I tries using a compressed export and the output is still over 2G. Does
->anyone have the export script that splits the export files into multiple
->files?
->
->Ron Smith
->Database Administration
I tries using a compressed export and the output is still over 2G. Does
anyone have the export script that splits the export files into multiple
files?
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L
--Original Message-
Sent: Tuesday, May 15, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
A few months ago I remember seeing a script that enabled the removal of
redundant rows in a table. Can someone please forward or point me to such a
script.
I have an Oracle Names server that
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Script that will remove redundant rows from table
>Date: Tue, 15 May 2001 09:40:47 -0800
>
>A few months ago I remember seeing a script that enabled the removal of
>redundant rows in a table. Can someone
801 - 900 of 1050 matches
Mail list logo
