Title: Message
I
would create a new version of the procedure that took the date from and to as
parameters and output a file named appropriately for the date range. You would
then just call this 24 times.
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL
On 01/30/2004 09:29:26 AM, [EMAIL PROTECTED] wrote:
Hallo,
I would like to write the code to atrigger that makes insert into
another table inly if there is the condition
Oracle9i Application Developer's Guide - Fundamentals, Ch. 15. - Using
Triggers. There are examples there, too.
--
Please see
Enable auditing on COMPANY?
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
Hallo everyone,
I have the table system_change
and I I have the insert statement here below be run when there is an
update or insert of a value in any ofthe fields
The easiest way to write code for me is to use a text editor and sqlplus, always works
for me.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
that's what I get for not testing but just reading the manual :)
remind me not to answer questions when I don't have a database
handy.
sounds like Dan's going to have to add a column.
--- Kirtikumar Deshpande [EMAIL PROTECTED] wrote:
Rahcel, Dan:
I played with such things a long time
First time I've seen this post. And from the fine Data Warehousing
manual:
here's an example of range partitioning. Note the to_date in the
values clause. I don't see why you couldn't use
to_date(date_column,'MONTH')
Rachel
CREATE TABLE sales
(s_productid NUMBER,
s_saledate DATE,
Dan,
Good question, but unless I'm misinterpreting the results, the answer is
no...
SQL show release
release 902000100
SQL create table test
2 (a date, b number, c number)
3 partition by list (to_char(a, 'MON'))
4 (partition pJAN values ('JAN')),
5
The only way I see is using a system-maintained ( through a before-insert
and if necessary before-update trigger ) field that is set to
to_char(date_column,'mm') and then range partition on that.
At 03:24 PM 1/14/2004, you wrote:
Pardon if this is a duplicate, but the original has not shown up
Bear in mind though that the original query will only count rows where
b.award_number is not null whereas this new query will count all rows in
the result set.
Regards,
Dave
[EMAIL PROTECTED] wrote:
Can you change it to this query:
SELECT count(1) FROM RF_BALANCE_T b, rf_security_by_dceid s
David - Can you post the EXPLAIN PLAN for both?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, January 12, 2004 1:14 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I have following sql that runs in 1 sec:
SELECT b.* FROM RF_BALANCE_T b,
Can you change it to this query:
SELECT count(1) FROM RF_BALANCE_T b, rf_security_by_dceid s
WHERE
(s.award_number = 'ALL')
OR (b.award_number = s.award_number AND s.project_number = 'ALL')
OR (b.award_number = s.award_number AND b.project_number=
s.project_number AND s.task_number = 'ALL')
That's fairly typical behavior. Try the following
SELECT /*+ NO_MERGE(x) */ COUNT(*)
FROM (your 1 second query) x
Kevin
-Original Message-
Sent: Monday, January 12, 2004 2:14 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I have following sql that runs in 1 sec:
SELECT b.*
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to such person), you may not copy or deliver this message to anyone.
In such a case, you should destroy this message and
about 5
lines or so which was similar to implement than the mutating trigger
solution.
Regards,
N.
:--Original Message-
:-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
:-Behalf Of
:-GovindanK
:-Sent: 08 January 2004 21:20
:-To: Multiple recipients of list ORACLE-L
:-Subject: Re
Hi,
This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that.
***
Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to SORT_AREA_SIZE to a temporary
We'll thats exactly what I'm doing right now, studying Oracle University
instructor guides to temporarily start thinking like OU myself again -
I'll
be instructing an OCP Review course next week, meant for people who want
to
pass OCP. And in order to not distract the students, I won't even
After the students have scribbled everything down, he then leans forward
and
quietly whispers to them that in the real world, heart surgeons actual
first check whether or not it's actually necessary to cut out the heart
*beforehand*. He then gives them a little wink and a nod, the students
I'm sure I will be corrected if I'm wrong.
Answers inline
At 12:24 PM 1/8/2004, you wrote:
Hi All,
Firstly my apologies if this seems like a very *stupid* question but I'm a
tad confused (and it's late in the evening)
When an AFTER INSERT trigger is fired (row level) has the row been committed
See in-line replies.
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Nuala Cullen
Sent: Thursday, January 08,
Row has not been commited yet. The AFTER INSER trigger fires
after the row has been inserted. Rollback can still undo all
the changes performed by both insert and trigger. And no,
trigger cannot select from the table it is defined on, not
even through a procedure.
On 01/08/2004 02:24:25 PM,
Wolfgang,
Yes you may, within the trigger only, change values of that row only. it's
known as
:new.column_name := whatever;
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, January 08, 2004 2:39 PM
To: Multiple recipients of
You can do some funky stuff with Autonomous Transactions (trigger
independent from initiating transaction), but I need lots more coffee before
even attempting more detail on this.
Henry
-Original Message-
Mladen Gogala
Sent: Thursday, January 08, 2004 2:45 PM
To: Multiple recipients of
Of course. Silly me.
At 12:54 PM 1/8/2004, you wrote:
Wolfgang,
Yes you may, within the trigger only, change values of that row
only. it's known as
:new.column_name := whatever;
If so is it ok to call a package in the trigger that selects that row and
changes some values in
CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables( schema_owner IN VARCHAR2) AS
r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner) LOOP EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name; END LOOP;
END;
ERROR: Line 14 Column 55
Greg,
Try
this:
create
or replace procedure truncate_tables(in_owner in varchar2)
is
BEGIN FOR r IN (SELECT table_name FROM dba_tables WHERE
owner=in_owner)
LOOP EXECUTE IMMEDIATE 'truncate table' || in_owner || '.' || r.table_name;
END LOOP;END;/
You
will need to grant select on
Remove
the
r
number(10);
and it
should be fine.
Tom Mercadante Oracle Certified Professional
-Original Message-From: oranew2004
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
simple question
I'll add that if you have foreign keys, they will mess you up. Here is an
old script I have in my stash that you can modify with info already provided
by others.
procedure truncate_all(code_word in varchar2 default 'XXX') is
cursor c1 is select table_name,constraint_name from user_constraints
Why do you have r declared as number(10)?
On 01/08/2004 03:24:25 PM, oranew2004 wrote:
CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables
(
schema_ownerIN VARCHAR2
)
AS
r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)
LOOP
Ok. Here you go.
http://osi.oracle.com/~tkyte/Mutate/index.html
Let me know if you find this useful.
HTH
GovindanK
OCP 8,8i
Brainbench Certified Master DBA(8)
On Thu, 08 Jan 2004 11:24:25 -0800, Nuala Cullen [EMAIL PROTECTED]
said:
Hi All,
Firstly my apologies if this seems like a very
When an AFTER INSERT trigger is fired (row level) has the row been committed
to the database at this stage?
No
If so is it ok to call a package in the trigger that selects that row and
changes some values in the row?
No
See the following snippet from the fine SQL manual.
Jared
PS. Your
Dick, you cannot do that in an AFTER trigger.
Jared
On Thu, 2004-01-08 at 11:54, Goulet, Dick wrote:
Wolfgang,
Yes you may, within the trigger only, change values of that row only. it's
known as
:new.column_name := whatever;
Dick Goulet
Senior Oracle DBA
Oracle
Hi again Prem,
OK, I've changed my opinion of dear Boson. At first I simply thought they
had no idea, now I suspect it's all a big joke designed to make DBAs have a
bit of a giggle on warm summer nights ...
Sizing the temp tablespace by the formula you've given is really quite
witty. Perhaps a
Well, you've certainly gotten a few decent replies. I've never used Boson so
I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp
is a combination of things many of which are black magic at best. Number of users is
an interesting variable to add, but
1. Easier, but requires a bounce : Add the
following event into init.ora
event=1652 trace name processstate level 10
You should be able to set this dynamically as well (tested on 8.1.7).
SQL alter system set events '1652 trace name processstate level 10';
System altered.
What I have heard is that all the OCP questions are taken from the Oracle
University Student Guide. After all, you wouldn't you expect the class to
prepare you? Someone suggested that you think like a computer. Well, for
the philosophy behind the exam, think like an organization, namely
Oracle
Prem ,
OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and humbly, play by its
rules.
Right now if your are serious about giving OCP exams then please
enable suspension of disbelief , don't ask why and just mug up the
Fewcomments inline:
1. Easier, but requires a bounce : Add the
following event into init.ora event="1652 trace name
processstate level 10"
You can use alter system and dbms_system.set_ev in
combination to force an event for all new and existing sessions, without a
bounce (alter system
(repost)
Fewcomments inline:
1. Easier, but requires a bounce : Add the
following event into init.ora event="1652 trace name
processstate level 10"
You can use alter system and dbms_system.set_ev in
combination to force an event for all new and existing sessions, without a
bounce (alter
D is probably the answer, but most of the time oracle will choose nested
loop.
Beware the OCP tuning test. It is completely and totally inaccurate. I
emailed the author of the Sybex tuning book and he agreed with me. He said
he wrote the book to the test and knows its garbage.
- Original
Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other
methos despite the price.
On 2004.01.06 13:44, Jay Wade wrote:
Hello:
I was looking through some OCP questions posted on the web and came across
the one below.
I believe the answer is (D), because the join
thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.
btw, Ive been playing with first_rows lately. I've noticed that it has a
preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in
some test cases where you have two tables
Think like a computer.
Which execution plan will be the result?
result of what?
an insert statement?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Note in-line.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see
FIRST_ROWS would alter the behavior regardless of the number of rows.
-Original Message-
Jay Wade
Sent: Tuesday, January 06, 2004 1:44 PM
To: Multiple recipients of list ORACLE-L
Hello:
I was looking through some OCP questions posted on the web and came across
the one below.
I
What I have heard is that all the OCP questions are taken from the Oracle
University Student Guide. After all, you wouldn't you expect the class to
prepare you? Someone suggested that you think like a computer. Well, for
the philosophy behind the exam, think like an organization, namely Oracle
Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for
DW processing and not for OLTP will also be considered for NL context in First_Rows
mode.
Here is the proof, which also proves that I'm a lousy typist:
SQL set autorace on explain
SP2-0158: unknown SET option
What I meant is that the question cannot be answered without making human
assumptions about the question itself. It is a little difficult (Note
little not lot) to believe that such a poorly written question would
appear on a test that costs money to take.
-Original Message-
Someone
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: OCP Question (Perf Tuning)
Date: Tue, 06 Jan 2004 11:34:26 -0800
thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.
btw, Ive been playing with first_rows lately. I've noticed that it has a
preference
Jonathan noted that
Nope. The answer is b). In the FIRST_ROWS mode, optimizer
prefers NL
to
all other
methos despite the price.
Unless the alternative is a full tablescan on the inner
table - in which case merge or hash joins can be
considered.
For some reason hash joins were
I see you're running on Oracle 9 there, and that
can make a big difference. After posting my
hypothesis, I created a test case, which behaved
as I had predicted - but the behaviour changed
in Oracle 9, and I had to do some tweaking.
Turns out my test case highlighted what looks
like a but in
A bigger error in option (d) is that it leaves
open the ambiguity of whether the rows
should, or should not, be part of the answer
to the join.
Oracle's choice of join could be affected
by adding 100 rows to the table that
should be included in the join, but remain
unchanged if you add
Chris,
There are two options:
1. Easier, but requires a bounce : Add the following event into init.ora
event=1652 trace name processstate level 10
This will dump the processstate for processing that encounter an ORA-01652.
And you can even add the following to capture 1555 and 4031 errors
You could also use a trigger to get the info to a temp table as follows. This will probably fire after any error and could be performance hit. (happy new year to all).:
create or replace trigger system.server_1652_error_trig
after servererror
on database
declare
v_audsid number;
v_username
John has already shown you how to generate a trace when
an error is encountered via the 'events' mechanism.
If you would like to see what events are available,
peruse the file $ORACLE_HOME/rdbms/mesg/oraus.msg if
you are on *nix. If you are on win32, the file is
unfortunately not available.
I can answer that for you, as I had a discussion with
them 2+ years ago.
2 reasons:
* They don't pay nearly enough for a senior DBA. The job
requirement is really for a junior, and the pay is probably
OK for that position.
* They lost 50% of their business last year, and unless they
do
Sounds like you may have answered your own question -- a worthless stock
price for a telecom is not a good sign.
Constantly advertising for a position like a DBA doesn't necessarily mean
that they can't keep people. Just as likely that they have not yet hired
their first DBA -- possibly using
Ive found that companies paying rock bottom salaries advertise and advertise
until they get someone...
We give a pretty basic technical interview here. We ask most of the basic
questions people should know and it takes us a long time to find people who
can pass. Could be they ask decent
grep -v try file
will give you all the lines which do not contain try
cat file|sed s/try//g newfile
will strip the characters try from all lines
HTH,
Bambi.
-Original Message-
Sent: Monday, December 22, 2003 6:54 AM
To: Multiple recipients of list ORACLE-L
Hallo all of you,
Is
grep command will help you or you could venture to the
sed command. grep is probably the most used unix
command. To learn more, man grep .
[EMAIL PROTECTED] 12/22/03 07:54AM
Hallo all of you,Is there anyone whom could help me with
the unix command how to find all rows , that doesnt exists
patterns...
Hope this will help.
Regards
kesh
-Original Message-From: Gene Sais
[mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003
6:39 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: Unix question
grep command will help you or you could venture to the
sed command
hmmm... odd
there is no setting for pct_used on tables, but different settings for percent free.
Different settings for initial extent to between tables.
anyone have more info on how this 'intelligent' algorithm works? I heard kyte speak
last week and he assured us that the algorithm is good
ignore spcreate.sql actually puts pctfree,pctused, and really bad initial and next
extent settings on the tables. its an antiquated script that hasnt been updated.
my bad.
From: [EMAIL PROTECTED]
Date: 2003/12/22 Mon AM 09:09:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL
Your answer was better than the answer I got from SUN support.
Thanks and Happy Holidays.
At 09:43 PM 11/27/2003 -0700, [EMAIL PROTECTED] wrote:
It's hard to explain this better than the man page. It's short sweet and 2
the point. But alas, I'll try anyway.
Define RAM -
It's hard to explain this better than the man page. It's short sweet and 2
the point. But alas, I'll try anyway.
Define RAM - http://www.techweb.com/encyclopedia/defineterm?term=ram
A group of memory chips, typically of the dynamic RAM (DRAM) type,
which function as the computer's
man pages states(-y converts it to Kb instead of pages):
SZ (l)
The total size of the process in virtual memory,
including all mapped files and devices, in pages. See
pagesize(1).
What does this mean? Does this mean that peocess 27845 is
Something our Unix admins tend to do is move the files along different
directories.
E.g. they start in dir1; after succesfull backup, move them to dir2, etc.
and after succesfull backup in dir4 delete them.
So they should always get backed up 4 times even if you miss a run.
Of course your backup
Bingo!
I did pretty much the same thing for an 8i DW with plenty of ad-hoc queries.
I had no way of knowing what those ad-hoc queries might look like, and they
will change over time. So I set up a polling process to do a textual parse
of v$sql for those SQLs with highest disk_reads and/or
in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003
1:04 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: col_usage$ question
Hi
How about something like ...
find /your_dir_name_here -name '*.log' -mtime +4 -exec \ rm {} \;
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
How about something like
dir=foo
if [ `ls -1 $dir` -lt 4 ]; then
find $dir -mtime +4 | xargs rm
fi
On Wed, 2003-11-19 at 15:20, [EMAIL PROTECTED] wrote:
I want to store some files. I make a new copy every night. I want to archive it back
4 days. So after 4 days, I want to delete the old
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH CARE.USE WITH CARE.
COUNT=`ls -lrt dir/name|wc -l`
if [ $COUNT -ge 4 ] ;
then
find dir -name name -mtime +4 -exec rm -f {} \;
fi
USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE WITH CARE.USE
WITH
The following statement will delete all files older than 5 days:
find . -name 'files_you_want_to_delete*.log' -mtime +5 -exec rm {} \;
To test it, change the name of the file name and change the 'rm' to
'ls'.
It should just list the files older than 5 days. That way you know it
is working.
Ron
That is a new table in Oracle 9 and is used by Oracle to track what columns
are used in predicates. At present the only use of that information that I
am aware of is in the procedure dbms_stats.gather_table_stats ( ...,
method_opt = 'for columns ... size auto');
At 09:29 AM 11/18/2003, you
Raj:
Wolfgang is right. It is populated by SMON (I think every 15mins SMON
flushes the data to COL_USAGE) and the predicate columns are updated
(or collected) from the hard parse of the SQLs.
Best Regards,
K Gopalakrishnan
-Original Message-
Wolfgang Breitling
Sent: Tuesday, November
Thanks KG,
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent:
Thanks Wolfgang.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Title: col_usage$ question
Hi!
If you describe this table then you see that this
table stores column usage information in filter and join predicates for database
objects. From describe, you see there are several filter and join conditions
tracked for an object's (obj#) columns (intcol#).
Could the column info be used to 'recommend' indexing?
Daniel Fink
Tanel Poder wrote:
Hi!If
you describe this table then you see that this table stores column usage
information in filter and join predicates for database objects. From describe,
you see there are several filter and join
Absolutely
At 01:39 PM 11/18/2003, you wrote:
Could the column info be used to 'recommend' indexing?
Daniel Fink
Tanel Poder wrote:
Hi! If you describe this table then you see that this table stores column
usage information in filter and join predicates for database objects.
From describe,
At 11:04 AM 11/18/2003, you wrote:
Hi!
If you describe this table then you see that this table stores column
usage information in filter and join predicates for database objects. From
describe, you see there are several filter and join conditions tracked for
an object's (obj#) columns
Yes. There is a better way to model that.
Oh, you wanted a suggestion. How about including a LOADS table that has (at
least) 3 colums
truck_id
cargo_id
active_flag
That way when cargo is moved to a different truck you add a new record to
the LOADS table and update the
Title: RE: datamodelling question: updating foreign keys
Ryan,
You'll probably like my solution less, but it worked for me. You don't have a parent-child relationship as a Truck can have more than one Cargo and Cargo can be loaded on more than one Truck. Rather you have a many to many
I don't know if this is a better model at all. In fact, all this
accomplishes is leaving behind tons of useless records. I'd only
recommend this model if (for any reason) the trail of the
truck history for this cargo.
This way of marking records also leaves you open for the obvious
future
Well ,
How about cargo as table with primary key say cargo_id which unqiely
identifies cargo and weight . Now you should have a cargo detail table that
will have cargo_id , load , truck_id .
So
Cargo
-
cargo_id
total_load
date
blah
blah
cargo_detail
-
cargo_id
Have a table SHIPMENTS. When a CARGO moves to another TRUCK it becomes a
new SHIPMENT. SHIPMENTS has foreign keys to TRUCKS and CARGOES.
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: datamodelling question: updating foreign keys
Well ,
How about cargo as table with primary key say cargo_id which unqiely
identifies cargo and weight . Now you should have a cargo detail table that
will have cargo_id , load
Seems to me that the proper solution is to create a new record, and use
a status indicator to determine where the cargo is currently.
Updating the FK causes you to lose any history of where the cargo has been.
ie. no cargo tracking possible.
This is my off the cuff, didn't spend a great deal
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: datamodelling question: updating foreign keys
Ryan,
You'll probably like my solution less, but it worked for me. You don't have a parent-child relationship as a Truck
asktom.oracle.com
http://asktom.oracle.com/pls/ask/f?p=4950:8:2542717627406446060::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:124812348063,
or
http://tinyurl.com/r3lk
pivot a result set
-Original Message-
Teresita Castro
I have the next query:
SELECT COMPANY, ITEM,
Thankz Mladen Govindan.
I do have Velpuri's book besides me.
let me go thro' it once again.
Regards,
Scott.
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ:
PROTECTED]
Date: 2003/10/06 Mon PM 12:24:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj
-Original Message-
From: scott scottSent: 10/6/2003 2:37:24 AMTo: [EMAIL PROTECTED]Subject: Re: Basic question about controlfile recoveryListers, sorry for this basic questionnare. ...was reading the RMAN BR docs (9iR2).got these doubts and thought of claryfying it with u experts. Q1.after
RESETLOGS and try to rollforward.
/quote
The book is arguably one of the BEST written on Oracle Backup and
Recovery ever.
Better get one.
HTH
GovindanK
-Original Message-
From: scott scott
Sent: 10/6/2003 2:37:24
AM
To:
[EMAIL PROTECTED]
Subject: Re: Basic
question about
If you have to travel at the client's request / requirement, then you should be able
to bill for your travel time, beginning with the time you arrive at the airport and
ending with the arrival time. Any weekend work for the client should be billed for
the time onsite. (You may want to consider
In States things are probably different, but in few European companies I've
worked for, it's that you get paid for the hours you work (naturally), if
you work on the weekends you get paid as well - if don't then you don't. If
you arrive one day earlier for being able to start in the morning next
Bellow, Bambi wrote:
Friends --
I find it weird that I've been consulting some 25 years and have never run
into this situation, and really could use your two cents. Here's the deal.
I am supposed to travel for a client. They have me on a plane Sunday,
expect me to work M-F onsite *and
Mladen
Hm The company where my brother worked at last had hundreds of
perl scripts implementing most of their printing application. It has all
now been ported to java for similar reasons. Maybe you are better with
python then?, its not as huge as perl, that's for sure
cheers
Pete
--
Mladen,
Why python?, why not keep using perl?
cheers
pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.
--
Please see the official ORACLE-L
recipients of list ORACLE-L
Subject: Re: Isnumeric question
Mladen,
Why python?, why not keep using perl?
cheers
pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
specialists Book:Oracle security step-by-step Guide - see
1 - 100 of 1264 matches
Mail list logo