What Monitoring Activities Need to be Carried Out on Large Databases (
Excess of 100 GB ) ?
Any Experiences , best Practices , Documents , Links ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (
Title: Clarification on External procedure in Oracle 8.1.6
Hi all...
I believe any of u Would be of GREAT help...
I have been trying Calling C functions from pl/sql using Oracle 8i's External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it
May be I'm a naive idiot (Forrest Gump :-)), but
have somebody asked Oracle to sponzor this community of Oracle users?
Jan Pruner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Hi lists
how to do the folloiwng inserts into a table?
table xyz has col1,col2, col3.
I need to populate the values to col1 from table dummy1 (cola)
col2 table dummy2(colb)
col3 table dummy3(colc).
there is no relation
Hi Srini
SELECT * FROM Table
WHERE (rowid, 1)
IN ( select rowid , mod(rownum, 2) from Table )
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:05 PM
> Hi lists
>
> can anybody post me to find alternative rows in a t
Jared,
Please suggest an Aussie rate for contributions. May be we from Australia could
contribute $AUD30 or so( I could do may be more, when my next sal comes), what ever,
"I Here by Pledge my Allegiance.." This list is good has helped me a lot in the
past, and "I will endeavour... what ev
Andrey, The Oracle failover stuff is documented in the
net8 guide and I believe there are some examples as
well. The TNS syntax you are using is not failover but
more or less a load leveling across the listeners. If
you want to do TAF you will need to use this syntax.
ALIAS1.WORLD =
(DESCRIPTIO
is that part of Larry's "reducing complexity" thangy?
[via: ORACLE-L Digest -- Volume 2001, Number 241]
>
> --
>
> From: [EMAIL PROTECTED]
> Date: Tue, 28 Aug 2001 13:41:03 -0400
> Subject: Oracle VS. DB2
>
> Any comment on the following:
>
> IBM enlists ISVs
Title: RE: tab ascii value
>-Original Message-
>From: Bryan S [mailto:[EMAIL PROTECTED]]
>
>I'm not sure about the tab.
>I did the following ('tab' is between the ' '):
> ...
Well OK, for non-printing characters, just enter the word "Ascii chart" into a google search.
Here's one of
HI lists
when I do select
select dump('k',1010) from dual (decimal)
i get 107 as the ascii value
to get an octal we substitute 1008
in the place of 1010 and the result is 153 for 'k'.
andselect chr(107) from dual (decimal)
value is ''k'
if i use
select chr(153) from d
Thanh-truc,
Do you have the Installation Guide for 7.3.x Oracle for Sun Solaris
Platform? If you do, I suggest you refer to it first. If you still have
questions, we will be glad to address those.
If you do not have the Installation guide, please search for it at
http://technet.oracle.com. I b
all miscreants will write "Mladen Gogala is a dba-god" 100 times in
their event logs.
all miscreants will write "Mladen Gogala is a dba-god" 100 times in
their event logs.
all miscreants will write "Mladen Gogala is a dba-god" 100 times in
their event logs.
all miscreants will write "Mladen
HI lists
can anybody throw this sql statement
I need to create a trigger that will fire on shutdown (just before
shutdown) of the database.
It has to collect the flwng infm into a table called free_mem_prc
1. The time in minutes the system has been up( means my instance is
running since 20
Hi Gurus,
I am trying to use Perl to find files with a particular extension (*.bat) on
remote machines on our network.
I'm running Windows NT 4.0. I'm using ActivePerl v5.6.1 Build 626 May
2,2001.
This is the script I got after running find2perl with the unix find
specification and redirecting
Title: RE: tab ascii value
I'm not sure about the tab. I did the
following ('tab' is between the ' '):
SQL> select dump(' ') from dual;
DUMP('')Typ=96 Len=1:
32
SQL> select chr(32) from dual;
C-
It looks like a tab, but since it is a nonprinting
character, it's hard t
Lisa,
The cygwin package works well, it will even install perl for you.
http://sources.redhat.com/cygwin/
As for the script to gen sqlldr control files, get dump.sql from
www.cybcon.com/~jkstill/util
and just edit out the part that actually dumps the table.
Jared
To All,
I've seen a number of messages on Oracle's 9iAS and since we're evaluating
the product, is there anyone out there using the Discoverer 4i Plus WEB based
query tool? If so, what is your opinion?
Dick Goulet
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
What about the Ozzie rate???...whatever it is, this list is great even
though I've only been subscribed for a short time - I'm learning heaps ...
so I'm in for donating whatever the set fee is.
Cheers,
Sujatha
-Original Message-
Sent: Thursday, 30 August 2001 5:02 AM
To: Multiple
So am I, especially considering the "silence" on customer connection.
Dick Goulet
Reply Separator
Author: "MacGregor; Ian A." <[EMAIL PROTECTED]>
Date: 8/29/2001 3:30 PM
We'll be moving both human resources to Peoplesoft 8 before year's end. I for
We'll be moving both human resources to Peoplesoft 8 before year's end. I for one am
very interested.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 29, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
OK, the subjec
Title: RE: User access within/outside of app
Here is a trigger that we use to change the optimizer goal at logon based on the operating system account. You would be looking into the value of the v$session.program column instead of the OSUSER used below. Instead of the 'alter session set opt
amen! I know I work in NYC and that it's expensive here but trust me, $20 or
even $10 is NOT barely the cost of lunch or dinner.
2 slices of pizza == $3.00throw in a soda and you're still under $5
>From: John Lewis <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients o
With me sitting here two hours after I should have left, you had better duck!!
:-)
Reply Separator
Author: [EMAIL PROTECTED]
Date: 8/29/2001 2:58 PM
You're surprised at those willing to pay?
You have to realize that most DBAs are over-payed and unde
Paul, ask my wife, i hate sports, she's like college football fanatic.
joe
> > Paul Baumgartel wrote:
> >
> > Lisa,
> >
> > The stereotypical football fan is, of course, a male, whose
> > wife/significant other usually wants nothing to do with the sport.
> > I've often wondered what might inspi
Hello listers,
I have to install a server Oracle (7.3.4) on Sun Solaris but i've never done
that before. Could some one show me the steps to follow or give me some
address where i can find the informations please ?
Thank you very much.
Thanh-truc Nguyen
--
Please see the official ORACLE-L FAQ
Tight pants on those nicely toned legs. Oh yeah, margaritas during the game
make it better as well.
-Original Message-
Sent: Wednesday, August 29, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Lisa's really a Dolphins phan in purple viking drag...
--Scott
> Paul Baumgartel wr
Hey Paul,
Great point, but don't be jealous I don't really have the time.
However, there are a lot of things that I dont understand about 9i (rollback
tablespace :?) so I figured I would have to read to get the basic
understanding of this thing.
However, you bring up a great point, I shoul
I know Lisa and she is no dolphin fan :)
Gene
*Fin Fan*
>>> [EMAIL PROTECTED] 08/29/01 06:35PM >>>
Lisa's really a Dolphins phan in purple viking drag...
--Scott
> Paul Baumgartel wrote:
>
> Lisa,
>
> The stereotypical football fan is, of course, a male, whose
> wife/significant other usua
Kevin:
sqlplus /nolog
connect / as sysdba;
startup;
joe
Kevin Kostyszyn wrote:
>
> Just wanted to say I loaded it today. Wow, this thing sucks so far, now it
> won't even start, where in the he__ is server manager!!! Well, looks like
> Barnes and Noble for me, I sure hope there is some good
Isn't CHAR a declining feature, which is why Oracle is forcing the
conversion to VARCHAR2 whenever possible?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cal
You're surprised at those willing to pay?
You have to realize that most DBAs are over-payed and under-worked
<>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 1:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject:
Dennis,
I'm stunned...
How about:
- Data Integrity (Referential Integrity and all the other constraints on
data)
- Concurrency (Readers don't block Writers and vice versa)
- Scalability
- Accessibility (no 3rd party tools could ever access your flat files for
analysis or reporting)
- Security
Y
I have no web site for this but here is a begining list for you:
Pros:
1. Relational in Nature.
2. You can access it from any location on your network with a multiple of
programs. These can range from Excell, Word, SQL Plus, Toad, etc. etc. etc.
3. Multiple people adding, deleting, chang
Kevin;
I believe they did away with server manager. Supposedly SQL Plus is now
allowed to do anything Servermanager did.
-Original Message-
Sent: Wednesday, August 29, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L
Just wanted to say I loaded it today. Wow, this thing sucks s
>we're throwing out figures
>like $10, $20, $50 etc. for us in the US, this is
>barely the cost of lunch or dinner,
Your lunches must be REAL nice. Is that with or without the wine?
;-)
(The place I usually eat has beans and rice with 4 corn tortillas for $3.
And its in a downtown area)
-O
Kevin,
I really admit that I am jealous.
Where do you find the time to read the entire 9i - Concepts Manual,
Administrators Guide, Installation Guide and Release Notes?
I wish I had time to cover all of that. There's a few sections of those for
8.1.6 (with updates for 8.1.7) that I haven't finish
Has anyone run across this problem and come up with a way around it?
This morning we had a change of IP-addresses on a cluster of
machines. Our production server is now returning
The listener supports no services
whenever we try to start the listener. We have tried creating a new
liste
I also have a question, who besides myself have multiple(i think i use 4
a/o today) email accts to post from, how will we handle that concept,
would I need to pay 4 times(i'm thinking not, but how could we tell if
its the same person?).
joe
--
Joe Testa
Performing Remote DBA Services, need so
Lisa's really a Dolphins phan in purple viking drag...
--Scott
> Paul Baumgartel wrote:
>
> Lisa,
>
> The stereotypical football fan is, of course, a male, whose
> wife/significant other usually wants nothing to do with the sport.
> I've often wondered what might inspire a woman to follow
>
Just wanted to say I loaded it today. Wow, this thing sucks so far, now it
won't even start, where in the he__ is server manager!!! Well, looks like
Barnes and Noble for me, I sure hope there is some good material out there:)
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL P
my 2 cents. i think it was re-iterated that payment
was not necessary so i don't think folks should feel
guilty if they can't pay. we're throwing out figures
like $10, $20, $50 etc. for us in the US, this is
barely the cost of lunch or dinner, so no big deal.
but some other folks in other part
I think keeping the list free is the way to go. My reasoning behind this is
that newbees to the list, like myself, don't know the benefits they will
reap from a list such as this until they use it. They will just use another
list that doesn't charge. Some of you might think this is a good id
AMEN to that.
George
-Original Message-
Sent: Wednesday, August 29, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L
I like Jeremiah's idea.
All the "sermonizing" about the value of the list and how we should be
required to put something in the "offering basket" is just so much
And you are suprised at the response ??? Not from this end !! There is
a lot of info out here that is just not available without a lot more
research than I have time for.
-Original Message-
Sent: Wednesday, August 29, 2001 1:43 PM
To: Multiple recipients of list ORACLE-L
This li
OK, the subject is a bit redundant. We recently upgraded our HR system to
PeopleSoft8, and I have noticed some strange stuff with 2-tier connections.
Just thought I'ld toss this out and see if anyone else has seen the same
kind of stuff.
In the past, when a user logged on 2-tier, an entry would
I'd be willing to pay a monthly/yearly subscription fee.
pramo
>> Original Message <<
On 8/29/01, 1:10:59 PM, Kathy Duret <[EMAIL PROTECTED]> wrote
regarding RE:
!! *Very* important Oracle-L message !!:
> IMHO
> How about a monthly and a yearly subscription
Hi all,
We are proposing a project to convert applications that use flat files to
Oracle databases. An essential piece of this proposal is to present to the
management the advantages of databases over flat files. Are there any
websites, whitepapers that talk about this? I know this probably is a
n
what man what else? are U leaving the office?
ekkada work vachi potundhi.
madala
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Inte
> Jacques Kilchoer wrote:
>
> > -Original Message-
> > From: William Rogge [mailto:[EMAIL PROTECTED]]
> >
> > Because of any synonyms (which are based off of object
> > numbers), Option 1
> > is the only way to go. That is of course unless you want to
> > perform extra
> > work dealing w
Title: OT: Lisa
Nope,
I don't think your wrong at all:) I love the names!
KK
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Wednesday, August 29, 2001 4:28 PMTo: Multiple recipients of list
ORACLE-LSubject: OT: Lisa
Nothi
Title: RE: How to loop call to SQL script in PL/SQL...
Lisa,
The stereotypical
football fan is, of course, a male, whose wife/significant other usually
wants nothing to do with the sport. I've often wondered what might inspire
a woman to follow football--care to satisfy my curiosity?
P
Sorry for being unclear. ReiserFS has much, much, much faster fsck then
Ext2.
With ReiserFS (a.k.a Ext3), fsck takes a second or two, not longer. With
ext2
it can go on forever, especially on /oracle, /mp3 or /usr/local filesystems.
-Original Message-
Sent: Wednesday, August 29, 2001 3:5
Ruth,
According to Michael:
>Tom:
>I haven't got a change to test it. I will try it sometime today. However,
>page 11-11 of Oracle8i Backup and Recovery Guide (8.1.5) states that Do not
>use this port-specific string if you have specified type disk.
>Thanks,
>Michael
I haven't tried it for di
You or J-Lo? I'd give you the nod, Lisa.
--Scott
> "Koivu, Lisa" wrote:
>
> Nothing wrong with combining a technical discussion with a bit of
> humor :) Tell me if I'm wrong !
>
> -Original Message-
> From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
> Sent: Wednes
Amen, I agree
-Oorspronkelijk bericht-
Van: Orr, Steve [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 29 augustus 2001 22:06
Aan: Multiple recipients of list ORACLE-L
Onderwerp: RE: !! *Very* important Oracle-L message !!
I like Jeremiah's idea.
All the "sermonizing" about the value o
> Do we get a t-shirt, like for PBS?
>
> My 5-year old son got a great DragonTales t-shirt.
>
> Now we have to think of a caption for the t-shirt.
Didn't we already cover the T-shirt question a while back?
Help!!!
Are You An Idiot?
;)
--
Please see the official ORACLE-L FAQ: http://www.ora
One thing you have to consider is the comparison semantic when using
CHAR vs VARCHAR. You should consult the Oracle Doc on this.
>>> [EMAIL PROTECTED] 08/29/01 03:35PM >>>
I think that this subject comes up now and then, but I don't remember the
conclusions
We are creating a Data Wareho
Thank you, I will check it out.
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Wednesday, August 29, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L
"Terrian, Tom" wrote:
>
> I think that this subject comes up now and then, but I d
I have been noticing this as
well, Bootylicious? hehheh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent:
Wednesday, August 29, 2001 3:16 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Lisa
Lisa, do you have a fil
This definitely the best Oracle list. Any chance of hacing the IOUG-A to sponsor it?
I remember quite a few years back the IOUG was sponsoring a Compuserve list run by
Chris Wooleridge. Chris, one of the first Oracle employees, was enjoying the
financial benefits thereof, living the good l
Hi Lisa,
MKS Toolkit or Unix Utilites for Windows (Microsoft). Both work very well.
-Rocky
--- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I'm working on sql*loader scripts and I realize that I'd probably be
> DONE by
> now if I had awk and sed to use. Of course, as unix-deficie
Waiting for the details
Suren
-Original Message-
Sent: Wednesday, August 29, 2001 2:43 PM
To: Multiple recipients of list ORACLE-L
This list is apparently a more valuable resource to many of you than I
realized.
I'm literally bowled over by the generosity. I've received so many
Title: RE: "Drop & Recreate table" or "alter table drop column". Which is
> -Original Message-
> From: William Rogge [mailto:[EMAIL PROTECTED]]
>
> Because of any synonyms (which are based off of object
> numbers), Option 1
> is the only way to go. That is of course unless you w
Hola,
I think a subscription is the best solution. I have learned too much reading
the solutions to the posts that everyday show up, and mines too.
Can count on me !!!
Regards,
Ramon E. Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
-Original Message-
Sent: 28 August 200
There is no problem with subscription of today's user.
I will pay too because I find this list excelent.
But what about new users? If I find a new list server with subscription,
I will never pay to try if is it valuable or not.
I think that free subscription is better way 'cause mail list is sti
Title: RE: LinuxFS for Oracle
> -Original Message-
> From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
>
> Oracle works on ReiserFS as well as on Ext2. My personal preference
> was ReiserFS because of the abominable fsck times with my big
> disks (32GB &
> 20GB).
I am confused - di
"Terrian, Tom" wrote:
>
> I think that this subject comes up now and then, but I don't remember the
> conclusions
>
> We are creating a Data Warehouse and the subject of char vs varchar2 data types
> came up. I searched google and found a little bit on the subject (mainly there
> is no
I dont think $12 is worth even speak to management.
Alex Hillman
-Original Message-
Sent: Wednesday, August 29, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L
The only problem with having my damagement pay for a subscription for this
list is that they may find out where I get a
Count me IN ...
-Original Message-
Sent: Wednesday, August 29, 2001 15:22
To: Multiple recipients of list ORACLE-L
Yes. $25 one-shot, $25 a year or "my fair share"
-Original Message-
Sent: Tuesday, August 28, 2001 6:29 PM
To: Multiple recipients of list ORACLE-L
Ok, now tha
Title: RE: Novice Question
> -Original Message-
> From: Kishore [mailto:[EMAIL PROTECTED]]
>
> I am in a position to export a user and drop it then
> create again and import it. Why I am doing this is
> because I want to change the default tablespace of the
> user to a different one a
Title: RE: How to loop call to SQL script in PL/SQL...
Denmark,
Every 5 seconds?? That's going to put an awful load on your database, dont'cha think? That's also going to be a very large file. We tried this a few months ago when jrun was acting suspect and we were getting a bunch of zomb
Title: OT: Lisa
Nothing wrong with combining a technical discussion with a bit of humor :) Tell me if I'm wrong !
-Original Message-
From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 4:12 PM
To: Multiple recipients of list ORACLE-L
Subject:
Jared,
Count me in for $20 (for now).
George
-Original Message-
Sent: Wednesday, August 29, 2001 11:49 AM
To: Multiple recipients of list ORACLE-L
Forgot one question;
Q. I would love to help, can I remain anonymous?
A. Certainly. We have no intention of publishing contributors.
Do we get a t-shirt, like for PBS?
My 5-year old son got a great DragonTales t-shirt.
Now we have to think of a caption for the t-shirt.
: )
I am willing to pledge some money as well, in US$ of course.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin.
I like Jeremiah's idea.
All the "sermonizing" about the value of the list and how we should be
required to put something in the "offering basket" is just so much
"preaching to the choir." :-)
I would gladly pay a subscription fee because I understand the value of the
list after having been on
Title: RE: results of analyze
> -Original Message-
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
>
> Someone asked me where the results of analying tables and
> indexes goes. Can
> anyone tell me what table(s) holds the statistics generated.
I think this is a complete answer.
Title: awk, sed, windoze, sql*loader, other fun stuff
One site that has the main Unix tools is http://virtunix.itribe.net/.
I have them and use them all the time.
Randy Pace Phone 801 495 9300 9662 S 700 E
Fax 801 495 9301 Sandy, Utah 84070
email [EMAIL PROTECTED]
- O
Forgot one question;
Q. I would love to help, can I remain anonymous?
A. Certainly. We have no intention of publishing contributors.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed" "The MONkey"
Boy ! arn't we busy today.
ROR mô¿ôm
>>> [EMAIL PROTECTED] 08/29/01 01:57PM >>>
Also - I ran into this problem on hp/ux: you may have to create the library
hard coded with the oracle home path. REferencing $ORACLE_HOME
Yes. $25 one-shot, $25 a year or "my fair share"
-Original Message-
Sent: Tuesday, August 28, 2001 6:29 PM
To: Multiple recipients of list ORACLE-L
Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com. It concerns the future of
I'd thought bootylicious would refer to Jennifer Lopez.
joe
>>> [EMAIL PROTECTED] 08/29/01 02:42PM
>>>"The Bootylicious " "Gimme a PC and I'll Break It, Guaranteed"
"The MONkey"Boy ! arn't we busy today.ROR mô¿ôm>>>
[EMAIL PROTECTED] 08/29/01 01:57PM >>>Also - I ran into
this problem on hp
Title: OT: RE: financial problems with fatcity.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Alex, that is an excellent idea! I second that notion.
"doh.state.fl.us"? Does that University count Homere Simpson amongst its proud alumni?
Please excuse
-->I am willing to donate up to $5 per month for up to 6 months paid either monthly or a lump sum depending on what he needs.
-->Just like in Public Television or Radio, I challenge everyone on the list to join me with an equal pledge.
Count me in...
Jarad/Bruce
Please let us know how yo
Dido.
Todd Carlson
Oracle 8i Certified DBA
Bunge North America
George
I second that. The amount is more then reasonable and the value that
this list provides is extremely high.
> -Original Message-
> From: Kevin Lange [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 12:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: financial p
I think that this subject comes up now and then, but I don't remember the
conclusions
We are creating a Data Warehouse and the subject of char vs varchar2 data types
came up. I searched google and found a little bit on the subject (mainly there
is no space savings between char(1) and var
Hi DBA's & Developers,
I first tried to call a batch file which calls SQL*Plus and executes an SQL
script from within Perl, but I had no success.
Perhaps I'm taking the wrong approach.
I'm sure it can be done using PL/SQL.
I want to run an SQL script repeatedly every 5 seconds throughout the day
Just had a chat to the boss, and we would happily pay $10 per month for the
"service", provided that there was an easy way for us to pay for it such as
a credit card since we are based in England.
Regards
Mark
-Original Message-
Sent: Wednesday, August 29, 2001 16:48
To: Multiple recipi
its called the migration guide.
joe
>>> [EMAIL PROTECTED] 08/29/01 11:48AM
>>>Can anyone point me towards the documentation for upgrading
Oracle 8i, from8.1.6to 8.1.7.Thanks in advanceSteven
H.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Steven
Hovington INET:
Lisa, do you have a file of "titles" or do
you keep coming up with new ones? I read your messages just to see things
like:
Dog Bone AdministratorThe Bootylicious DBA and many more
StephenNo funny sig line
It is good start...I think we all should start sending min $20(for USA) and
UKL 15 (for UK) to Jared/Bruce once we have address
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 29 Aug 2001 08:50:55 -0800
Just publish
I for one have learned a lot from this list. Heck ,I 've also learned how much I don't
know. There is a lot of valuable information to be gleaned from this list and I has
helped me with my learning curve. I do not have a budget item for open training here
or I would apply it to the list to help
Oracle works on ReiserFS as well as on Ext2. My personal preference
was ReiserFS because of the abominable fsck times with my big disks (32GB &
20GB). I don't see much overhead. With UDMA3/66 enabled, my disks are
performing
extremely well. Having 384 MB RAM also helps a bit. On the other hand,
Title: awk, sed, windoze, sql*loader, other fun stuff
Hello all,
I'm working on sql*loader scripts and I realize that I'd probably be DONE by now if I had awk and sed to use. Of course, as unix-deficient as I am, I don't have it. Does anyone know of a windows version of these utilities?
Jared,
I'm in for $12.
Jim Howerton
Senior Oracle DBA
University of Alabama at Birmingham
Health System Information Services
e: [EMAIL PROTECTED]
v: 205-934-9111
f: 205-934-0632
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
INET: [EMAIL PROTECT
Do not forget 'grant execute on utl_file to apps_user' before running..
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 29 Aug 2001 08:21:20 -0800
Ranganath,
First you have to specify a place where Oracle may write the file.
Rob
(Jo?),
This
is from the Oracle8i docs (Chapter 5 of "Oracle8i Standby Database Concepts and
Administration"), but it's so basic that I believe it would apply to
8.0
...
9.Write a script that you can periodically run to check
the log files in the managed recovery directory and
move
hi all,
do anybody explain me what is
happening when i'm creating a table with the following
constraints..
CREATE TABLE
TAB1(
ENUM NUMBER PRIMARY KEY
CHECK(ENUM IS NULL),
ENAME
VARCHAR2(10)
);
why i'm being able to create
table with such contradicting constraints.
both can't be true
The only problem with having my damagement pay for a subscription for this
list is that they may find out where I get all my answers to some very
difficult problems!! ;o)
Dave
-Original Message-
Sent: Wednesday, August 29, 2001 11:43 AM
To: Multiple recipients of list ORACLE-L
Whats t
Just shoot me an email if you get to San Antonio. We could even meet
for a long lunch in New Braunfels or sumthin', as I live an work in the
NE part of SA. That goes for anyone in the area. My schedule keeps me
hopping, but I can usually break free for a time.
Scott Shafer
San Antonio, TX
w: 2
1 - 100 of 211 matches
Mail list logo
