How do you do backups?
Do you use RMAN with MML? Do you use NDMP?
Tia.
>>> [EMAIL PROTECTED] 07/16/02 08:28a.m. >>>
Dick,
We're using Netapp F720's to store all our datafiles (production and
test) in a small/medium OLTP environment and are quite happy with the
setup. YMMV.
We run out of two
HI AMJAD,
HOW TO DROP THE DATABASE
LINK.
ANAND
ITW SIGNODE INDIA
LIMITED
- Original Message -
From:
Amjad
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 11, 2002 1:43
PM
Subject: RE: dblink problem ( ORA-02019
)
CREATE PUBLIC DATABASE
HI AMJAD,
HOW TO DROP THE DATABASE
LINK.
ANAND
ITW SIGNODE INDIA
LIMITED
- Original Message -
From:
Amjad
To: Multiple recipients of list ORACLE-L
Sent: Thursday, July 11, 2002 1:43
PM
Subject: RE: dblink problem ( ORA-02019
)
CREATE PUBLIC DATABASE
Given SUN D1000 Storage Box Containing 12 Disks , For Database Layout what would be
the most optimal Setup ?
1) 1 Volume Software RAID 1+0 Containing 6+6 Disks ?
2) 2 Volumes - Each Volume consisting of Software RAID 1+0 Containing 3+3 Disks
3) 3 Volumes - Each Volume consisting of Software RAI
trying again...
--- Forwarded message follows ---
Responsibility / Re: OT
Date: Mon, 15 Jul 2002 15:14:39 -0400
| Original Message:
| -
| From: Johnson, M=2E
| Date: Mon, 15 Jul 2002 10:23:21 -0800
| To: ORACLE-L@fatcity=2Ecom
| Subject: RE: McCain on Larry Ellison and
trying again...
--- Forwarded message follows ---
Responsibility / Re: OT -unix
Date: Mon, 15 Jul 2002 18:55:37 -0400
Connect the dots, contrary to the highly postured false
rectitude that you
are conveying, Ellison has a very long track record of sleaze
that at a
minimum, ought to eli
This is a pure guess, and I don't have my own
OraApps system to check it upon first, so this might be embarrassing, but here
goes...
Often I see 2 sessions started for every dedicated
server process when Oracle Forms is in use with Oracle Apps, from R10.7 on
up. I think the Jinitiator app
Bitmapped indexes will be fast for the queryagainst the 'Y's, but a
bitmapped index may not be appropriate if you are getting lots of DML
activity on this.
Another option is to use NULL instead of the "vast majority" value ('N' - in
this case) and create an index. The nulls won't be indexed, so
password.txt
Description: Binary data
password.txt
Description: Binary data
FYI, I have a filter in that should catch this one from now on. Gack, I hate these.
;-)
The list should be safe again.
thanks,
bruce
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 11:34
> Bruce, looks like a virus may have made it through the list.
>
> Fu
Jim, since you sent that to the list, do i have a userid also? :)
joe
James Howerton wrote:
>All,
>
>Here is a sample of 9i new features. You all should have a user on
>DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
>
>...JIM...
>
[EMAIL PROTECTED] 7/15/02 10:48:28 AM >>>
>>
Thats were you're wrong, i dont use microsoft products, all of my
development and presentations that i make are non microsoft products.
for IOUG presentations, requirement is to put them in msword and
powerpoint, i convert from star office to those formatrs and have
someone proof them so i kno
Sorry, forgot to answer your question during all my ranting.
select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
,t.used_urec
,t.log_io
,t.phy_io
,substr(sa.sql_text,1,200) txt
from v$ses
It could be that pmon is rolling back the transaction.
It could also be that pmon is never going to clean it up, which sometimes
happens when killing an active transaction.
I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on
Unix to kill the process, rather than killing the
Cherie,
I summarised the ports used by Oracle for our Network support specialist and have
copied it below:
Metalink note 69511.1 refers to SNMP and the Oracle agent - hopefully that document or
some of the others listed can help you out.
"
Oracle & TCP IP Ports - for future reference
Oracle
On Mon, Jul 15, 2002 at 07:28:23AM -0800, [EMAIL PROTECTED] wrote:
>
> Not a "honeymoon" issue, just that Linux progresses much
The Oracle support matrix says SuSE 7.2 and RH 7.1. RH flagged
in the scheme about the time RH announced entry into the db
market with it's PostgreSQL port. Call i
sorry, CBO(Cost-based Optimizer).
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> What's CBT?
>
> > If we have a column of 'Y','N' values, the index
> will
> > not help with CBT(usually most of the values are
> 'N').
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
>
gotta love it, linux says "save to disk"?
bwahahaha, all ou m$ weenies, vulnerable again.
MacGregor, Ian A. wrote:
>It's a new one not KLEZ ...
>-BEGIN PGP SIGNED MESSAGE-
>
>A number of people have received email from contacts at other sites
>with the subject line "Your Password!"
>
I wish I had enough money to retire.
But I did get out of the market in the
Fall of 2000 so I at least have a fighting
chance.
This is only because I had parents
who forced me to study bull and bear markets
and let me know that money is important.
Otherwise I would be in the same boat
as ever
Gene,
Run this repeatedly - used_ublk will reduce as it
rolls back - after it is finished the session should
dissappear.
column sql_text word_wrapped
select vs.sid, vs.serial#,vt.used_ublk, vt.start_time,
vs.username, vs.osuser, substr(vsq.sql_text,1,75)
sql_text
from v$transaction vt, v$sessio
Ditto !
-Original Message-
Sent: Monday, July 15, 2002 2:02 PM
To: Multiple recipients of list ORACLE-L
OT - unix
Nope.
I just thought that people are innocent until proven guilty. One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell stoc
Hmmn, mutation in digital storage. Maybe that's why programs seem
to have a shelf life?
O> So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
O> block is written even if only one character in the block has changed? Seems
O> like hotspots, er, hot blocks could do a "mul
It's a new one not KLEZ ...
-BEGIN PGP SIGNED MESSAGE-
A number of people have received email from contacts at other sites
with the subject line "Your Password!"
This is a new email-based worm that hit many European High Energy
Physics sites earlier today and is now affecting sites in th
You should see some activity in v$transaction.
Regards,
Waleed
-Original Message-
Sent: Monday, July 15, 2002 5:39 PM
To: Multiple recipients of list ORACLE-L
Hi.
Here is my situation. I have killed an ORacle
transaction. Oracle came back with "session marked for
kill" and the statu
Hi.
Here is my situation. I have killed an ORacle
transaction. Oracle came back with "session marked for
kill" and the status of the session is now "Killed".
I presume that the reason is that Oracle needs to roll
back the changes made. Can I confirm whether this is
indeed the case via some syste
I'm see ORA-1594 and ORA-1595 errors ON A 9.0.1.3 database. There are no
accompanying ORA-601 or ORA=604 errors. The database is using automatic undo
management. Here is the trace file
*** 2002-07-13 02:49:08.842
SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (
So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K
block is written even if only one character in the block has changed? Seems
like hotspots, er, hot blocks could do a "multiplicity" thing. You know...
like the more you replicate DNA the more chance for mutation? :-)
Be
Work around: Yes
do not use spfile
Hire a DBA :)
-Original Message-
Sent: Monday, July 15, 2002 5:02 PM
To: Multiple recipients of list ORACLE-L
Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet, but
HELP
-Original Message-
Royce
Sent: Monday, July 15, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Subject:
CONFIRM L-ORACLE
Thnx & OK Bye
"Instant gratification
takes too long"
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
--
Please see the official ORA
Ramon,
I can not explain that. What platform are you on?
May be this is another bug with SPFILE.
- Kirti
> -Original Message-
> From: Ramon E. Estevez [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 2:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Wh
What's CBT?
> If we have a column of 'Y','N' values, the index will
> not help with CBT(usually most of the values are 'N').
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (85
Okay.. Oracle Support just informed me that Bug # 2462605 has been filed
regarding this issue with SPFILE not visible to public yet, but
following text is in my TAR:
---
Called customer lms on vm please call when avail
SME did see this.. but did not file a bug on thi
Nope.
I just thought that people are innocent until proven guilty. One thing
about someone in Ellison's position is that it would be impossible for him
to *ever* sell stock without having the unfounded accusations you've quoted
being hurled at him. So, are you saying that it is OK to throw such
SET ORACLE-L REPRO
END
Thnx & OK Bye
"Instant gratification
takes too long"
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
<>
CONFIRM ORACLE-L
Thnx & OK Bye
"Instant gratification
takes too long"
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
<>
Dick,
We're using Netapp F720's to store all our datafiles (production and
test) in a small/medium OLTP environment and are quite happy with the
setup. YMMV.
We run out of two sets of collocated servers. At each collocation
there are at least two filers and at least two servers. The filers and
t
CONFIRM L-ORACLE
Thnx & OK Bye
"Instant gratification
takes too long"
-- Carrie Fisher
Chris Royce
[EMAIL PROTECTED]
[EMAIL PROTECTED]
<>
Hi Kirti
I have something to add to the topic.
I "could" edit the spfile with VI and add a parameter with a value of 20,
later add the same parameter to the init file with a value of 30, bounce the
DB and it worked very fine.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE
there is a log file you can reference it has all the components; it's
something like:
installActions2002-01-08_11-09-21-AM.log
=-=-=-=-=-=-=-=-=-=-=
lerone
=-=-=-=-=-=-=-=-=-=-=
-Original Message-
Sent: Monday, July 15, 2002 2:28 PM
To: Multiple recipients of list ORACLE-L
Hi All! Happ
On Mon, 15 Jul 2002, Johnson, Michael wrote:
> Everyone should have been smart enough to sell stocks and
> put their money into cash or better yet short stocks
> when it was very clear that in the Fall of 2000 after the
> initial March 2000 sell off that we were going into
> a prolonged Bear m
>For Oracle, my guess is that their goal is to use Linux to look
modern
> and open and hope nobody asks why they are spending $40k/processor for
> Oracle and getting the Linux O.S. for free.
Dennis,
If you want to purchase heavy duty production ready, SMP capable Linux, it
ain't free.
RH
can't wait for replies to this ...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 1:58 PM
> Actually they were replaced in my previous company : > Not XP though but
W2K
> !!!
>
> On
If we have a column of 'Y','N' values, the index will
not help with CBT(usually most of the values are 'N').
My question is : how about bitmap indexes? Should it
help a lot, or just a little bit?
Thanks,
Chris Harvest
__
Do You Yahoo!?
Yahoo! Aut
It seems this message was sent by my mail server when receiving an infected
email from the list.
Waleed
-Original Message-
Sent: Monday, July 15, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
[Filename: decrypt-password.exe, Content-Type: audio/x-midi]
This message was generat
Hi All! Happy Monday.
When I run the Oracle installer and try to list the installed
software, I get a listing that is miles long and redundant and
repetitious and is way too much information.
Is there any way to:
1) Get a shorter list?
2) Parse the list I get into something useable?
3
I have a question to ask regarding Oracle server process (oracle) size. We have just installed Oracle Apps 11i, while monitoring the system using glance, I notice something strange, the oracle server processes - process which has a name oracle has a very big RSS size in glance, these processes were
AFAIK, the downside of RAID4 is the same as RAID5. Writes to the disk must
calculate parity data which impacts performance. Also, the parity disks tend
to be the hotspots on these arrays. Any writes must also write data to the
parity disk.
I took a one week course in NetApp filers a while ago. I
Jared,
That is what I believe, but of course the NetApp folks keep telling the
powers that be (PTB) that they can handle it & be cheaper in the long run. The
EMC folks on the other hand are telling me that it's risky due to the problems
you encountered with filers plus the network delay to g
Not defending Ellison for anything, but it appears
McCain is just another politician who is only interested
in his future and he constantly takes on these "reform
ideas" and just makes the matter worse.
Everyone should accept the fact that we are in a bear
market and as such all the boats go dow
I've no problem with what Uncle Larry did. Sure he made a pile of money, isn't
that what we're all about? What in this mess bothers me is that some folks,
like those at Enron, WorldCom, and Tyco, knew their stock was headed for the
crapper on a permanent basis due to the kitchen treatment the bo
Steve,
The network latency is one of the issues I wish there was a fix for. That's
the reason they recommend direct connects. OH, it's also the reason they
recommend a large 'non-volatile' ram cache where the data initially arrives.
According to the sales droid ( a crowning example of why
Oh yes, and mainframes will all be replaced by XP next year as well.
ltiu <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/15/2002 09:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: OT - uni
Actually they were replaced in my previous company : > Not XP though but W2K
!!!
On Monday 15 July 2002 09:44, [EMAIL PROTECTED] wrote:
> Oh yes, and mainframes will all be replaced by XP next year as well.
>
>
>
>
>
> ltiu <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/15/2002 09:14 AM
>
How timely! It just so happens that we've got some NetApp sales droids
coming in on Wednesday and we're gonna get an eval box to play with... but
don't tell anybody. ;-)
NAS "toasters" (appliances) are implemented with RAID 4 enhancements and
WAFL technology from NetApp.
NetApp wants to claim t
Tim,
It is my understanding that Oracle's stocks have gone
up and down wildly several times.
As you say, the only time I've heard that Larry
Ellison cashed out before a plunge happened was the
recent one that McCain brought up.
I'm afraid I fail to see what you think people should
conclude
OOPS, looks like a fat finger!!
Reply Separator
Author: "James Howerton" <[EMAIL PROTECTED]>
Date: 7/15/2002 9:24 AM
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know
Thanks, Tony.
If that were the case, the second test (scope=spfile) should not have
failed.
Oracle Support left a v-mail to me stating that they are considering this a
bug. And wanted to talk to me about more testing. I will get with them
later today (or tomorrow).
Regards.
- Kirti
> ---
Dick,
I had a recent bad experience with a NetApps Filer.
Due to circumstances beyond my control, I was about to run
out of space on our most critical application.
( SAP. I predicted in January that we would run out of space
in the first week of July. It happened on June 28th )
Our SA's ma
All,
Here is a sample of 9i new features. You all should have a user on
DBA9 (moray.hs.uab.edu) to try this out, if not let me know.
...JIM...
>>> [EMAIL PROTECTED] 7/15/02 10:48:28 AM >>>
Welcome to the latest installment of 9i new features. This will not be
all exhaustive but just a sample.
-- Andrey Bronfin <[EMAIL PROTECTED]> on 07/15/02 07:33:33 -0800
> "Good bet that smaller Unix vendors will run to Linux before vendors like
> Sun do."
> Not exactly , just look at homepages of sun , ibm , oracle .
> There are more appearences of the word "linux" there than any word in
> Britan
Erik - Very interesting, thanks for mentioning that fact. Of course, since
there's "no free lunch", what is the downside to RAID4?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 15, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
I th
wrong. it's :
'Have detected a virus (WORM_FRETHEM.K) in file decrypt-password.exe in your
mail traffic on 07/15/2002 16:40:46 with an action deleted from
[EMAIL PROTECTED]'
Tnank you virusscanner.
-Original Message-
Sent: Monday, July 15, 2002 6:08 PM
To: Multiple recipients of li
Title: Virus Warning (WORM_FRETHEM.K)
Hi list,
I got a mail from "[EMAIL PROTECTED]" with subject: Re: Your password!. This mail contains a "decrypt-password.exe" which is infected with virus "WORM_FRETHEM.K".
DON'T open the exe.
Volker Schoen
E-Mail: [EMAIL PROTECTED]
http://www.inplan.
We have a third-party application that needs to use the SNMP agent
associated with OEM. They want to be able to get to it via a particular
port.
We have a port assigned to each database, based on which Oracle version it
is running. However, as far as I know, there is not a particular port
nu
I think that NA uses RAID4. This is the same as RAID5, but the parity info
is not stripped across the disks. This allows them to add disks from the
spare spool very quickly, as parity info does not need to be recalculated.
Spare disks are simply 'zeroed-out' prior to use.
> -Original Message
On Mon, 15 Jul 2002, ltiu wrote:
> But do all these matter though? Everyone's moving to MS software and *nixes
Who is "everyone"?
And what software in particular?
> are getting rarer and rarer. The fact is that everyone's losing money (Sun,
> IBM, HP, SGI even RedHat and Caldera) - except MS.
It is the LocalSystem user...
I have tried sysman/oem_temp but it does not work either...
Thanks
Per-Olof
-Ursprungligt meddelande-
Från: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]För Mark Leith
Skickat: den 15 juli 2002 18:08
Till: Multiple recipients of list ORACLE-L
Ämne: RE: Insta
Andrey
I think it is important to understand the situation from the vendor's
point of view. That will lead to more accurate predictions of their future
behavior. At this point, I feel Linux has great momentum behind it,
virtually guaranteeing its success, and your statement about vendors
splash
If you look under your services (under control panel), what user is used to
start the OMS service? The user *should* be the default system (LocalSystem)
user..
Also, have you tried the default username/password of sysman/oem_temp?
-Original Message-
Hermansson (MMS)
Sent: 15 July 2002 16
Bunyamin,
Did you pick up a copy of worm_klez somewhere?
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 7/15/2002 6:53 AM
ATTENTION!
You can access
very important
information by
this password
DO NOT SAVE
password to disk
use your
But do all these matter though? Everyone's moving to MS software and *nixes
are getting rarer and rarer. The fact is that everyone's losing money (Sun,
IBM, HP, SGI even RedHat and Caldera) - except MS. It's an MS world like it
or not.
ltiu
On Monday 15 July 2002 08:33, Andrey Bronfin wrote:
Dick -
We use NetAppliance to store Oracle datafiles on our test system. I am
pretty sure the NetAppliance is configured as RAID5. I would rate it as
quite satisfactory for that purpose. We have many test systems and they are
only used sporadically.
I have had no reliability issues with th
Welcome to the latest installment of 9i new features. The reason for
this one is its the latest thing that I've been studying for the OCP 9i Upgrade
exam on this friday :), this will not be all exhaustive but just a sample to
make your brain think, RTFM the docs :)
Here is the table scrip
Title: RE: Where is Oracle 9.2 init.ora?
On my version of UNIX (Solaris) moving/removing a file that is in use only affects the directory entry and not the actual payload on disk. I suspect that the spfile was held open by your sqlplus program and it executed the I/O operation using the open
Hi
I have installed personal Oracle 8i, but cant log on to OMS, and also on to
database config assistant.
When trying to log on to OMS I get the following error message in oms.nohup
Error starting Oracle Management Server. OEMCTRL for Windows NT: Version
2.2.0.0.0
Copyright (c) 1998, 2000, Orac
Philippe,
You could use PL/SQL exceptions.
Example :
for c in c1 loop
begin
select a into v1 from table1 where a > 1 and b < 2 and ...
exception
when no_data_found then
null;
end;
end loop;
Luc
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED
"Good bet that smaller Unix vendors will run to Linux before vendors like
Sun do."
Not exactly , just look at homepages of sun , ibm , oracle .
There are more appearences of the word "linux" there than any word in
Britannica ;-)
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
hi!
i want to write blob data (binary) into a file on 8.1.7.
UTL_FILE package is for text data only.
is there a possibility to do it with PL/SQL or is
a C(OCI) function required???
n.e. 1 experience with it?
thx
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Auth
I assume you have job_queue_processes = n # where n > 0
After submitting the job you did issue a commit in that session?
-Original Message-
Sent: 15 July 2002 16:28
To: Multiple recipients of list ORACLE-L
Hi
I had same situation before. Check owner of the job and security and ad
password.txt
Description: Binary data
-- Ray Stell <[EMAIL PROTECTED]> on 07/15/02 06:38:28 -0800
> The support matrix at metalink includes other distributions,
> and does not include RH7.2, only the antique 7.1. I have
> to conclude that the ora/rh honeymoon is over. They did
> just add Red Hat 2.1 Advanced Server to the 9i ma
Have you set job_queue_processes and job_queue_interval parameters? If
job_queue_processes is zero, the job will always run manually but never
automatic.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot c
Title: RE: SQL query
You can use USER,ALL or DBA view to find the constraints...
--table constraints
select constraint_name, constraint_type
from user_constraints
where table_name = '&table_name'
/
--table column constraints
select column_name,position
from user_cons_columns
where table_na
Title: RE: Triggers are getting disabled
Ron,
From 9i docs:
Direct Loads, Integrity Constraints, and Triggers
With the conventional path load method, arrays of rows are inserted with standard SQL INSERT statements--integrity constraints and insert triggers are automatically applied. But
On Sat, Jul 13, 2002 at 08:18:24AM -0800, [EMAIL PROTECTED] wrote:
> ... and Oracle only supports Red Hat so that
> is probably what you'll end up with.
--
The support matrix at metalink includes other distributions,
and does not include RH7.2, only the antique 7.1. I have
to conclude that the
Folks,
I've been asked to validate/invalidate a contention made by two storage
vendors.
NetAppliance has stated that you can use a netapp filer with Oracle for
datafiles, although their configuration looks more like a DAS(direct attached
storage) configuration using 10baseT cables vs.
Hi
I had same situation before. Check owner of the job and security and add
necessary privilege.
Mitchell
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 10:33 AM
> Dear gurus !
> I submit a job via the DBMS_JOB package ,
Jared - Good point. In addition, other costs to an independent Unix vendor
are:
- Staff costs of a large development staff. This cost doesn't vary,
regardless of the number of customers. Therefore, vendors with a small
market share have proportionally higher costs.
- Costs of attracting soft
Hi Vladimir
date --date '1 day ago'
Works on my O/S (RedHat Linux) - your O/S may not support this.
Regards
Dale
-
DataBee: Create referentially correct small versions of large Oracle
databases for development and test. http://www.DataBee.com
--
Please see the official ORACLE-L F
There
are lots of different discussion forums at otn.oracle.com. You may find
some helpful.
-Original Message-From: César Aracena
[mailto:[EMAIL PROTECTED]]Sent: Sunday, July 14, 2002 6:58
AMTo: Multiple recipients of list ORACLE-LSubject: Just a
question
Hi all,
and sorry to b
Dear DBAndrey,
use :
A.> assuming start_date to be of dd/mm/
select trunc(ADAY,'DD') , count(...),sum(...),...
from THETABLE
where trunc(ADAY) >= :start_date /* changes done here add TRUNC function
to ADAY */
group by trunc(ADAY,'DD')
B.> assuming start_date to be of dd/mm/ hh24:mi
My understanding is that this was the very first time Ellison had ever sold
Oracle stock, in over 25 years of the company's existence, in 2000, which is
the occasion that McCain (and you) are referring to. As you might be aware,
there was a far greater "opportunity" for Ellison to "cash out" and
BDY.RTF
Description: RTF file
Hi Philippe
You can write the following after the select statement:
exception
when no_data_found then null;
regards,
Ams.
www.medicomsoft.com
Hi List !
how can I can make a "continue" statement in my loop when a request return
no data
e.g :
cursor c1 is .
for c in c1 loop
selec
Hi there,
Where I am working we will order the TSM module pretty soon.
I can write the whole installation process on how to interface RMAN with
TSM.
Jean Remacle
-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent:
cursor c1 is .
for c in c1 loop
begin
select a into v1
from table1
where a > 1 and b < 2 and ...
/* if my "select into" return no data ?
how can I tell him to goes on into the loop
Vladimir,
Found this on the net (can't recall where though) for touching a file with
yesterdays date.
touch `TZ=GB+24 date +%m%d%H%M%y` filename
You'd need to change the GB to what is appropiate for you and change the
format variables to the format you wish
eg
echo `TZ=GB+24 date +%y%m%d` to
BDY.RTF
Description: RTF file
No, it seems to me that's what CACHEd sequences are there for. If your
requirements insist on NOCACHE, serialization is inevitable as the data
dictionary must be updated with the last value.
Cheers,
John Thomas
In article <[EMAIL PROTECTED]>, Thomas Jeff
<[EMAIL PROTECTED]> writes
>
1 - 100 of 107 matches
Mail list logo
