Keep on dreaming.
On Sun, 13 Oct 2002, Sinardy Xing wrote:
Hi US friends,
How high is your income tax ?
90-110K is this the take home pay ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services--
Didn't cover all of the 9i upgrade material? Why not? As one who is soon to
purchase some 9i upgrade preparation materials then I would be interested to
know the reasoning behind this (offline if necessary).
Are the missed topics from Robert's book covered in the book by Daniel
Benjamin?
Just for the record (and perhaps to confirm that there are always two sides
to a story). Readers may like to see the article Chris Date wrote to Ralph
Kemball on the subject of business rules and integrity constraints:
http://www.dbdebunk.com/kimball1.htm
peter
edinburgh
-Original
Hi,
I've cloned the Oracle HRMS 11I Application to another machine. I can access
the form but still cannot view output and change HRMS Oracle password.
I need to scramble or delete the data (not sure which api?) in Oracle HRMS
Applications. Any advice ? TIA
Regds,
New Bee
--
Please see the
FrTvcvc5-7_Hgfdft_ijn6(789jgr6.
HTH
S Faroult
- Original Message -
From: hukangang [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Sun, 13 Oct 2002 19:38:19
encoded content removed -- binaries not allowed by
ListGuru
--
Please see the official
Hi all,
Does anyone have the appropriate time on implementing replication for a
newbe?
I am given a time frame on doing the replication for 10 days which is
including testing on test server and move to production. I've never done
that before, now just start reading. This DB is about 30G on
Title: hot backup mode
Does the unmodified image of the datafile block
get recorded in the redo log as well as the modified
image when a tablespace is in hot backup mode?
I'm being told that it does, but that is not
my understanding. Is this documented somewhere?
Matt
Matt Adams -
Peter - What does this article have to do with snowflake vs. star schema? I
didn't see where Chris Date was advocating snowflaking.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 14, 2002 4:59 AM
To: Multiple recipients of list ORACLE-L
Figure on paying about 30% of that to Federal, State, and Local taxes, Social Security, Medicaid Taxes, etc..
On Mon, 2002-10-14 at 02:43, Lyndon Tiu wrote:
Keep on dreaming.
On Sun, 13 Oct 2002, Sinardy Xing wrote:
Hi US friends,
How high is your income tax ?
90-110K is this
Robin
Your management sounds like some people I dealt with that assumed they
would just flip the replication switch. How much of the 30-gig. do they
plan to replicate? What replication interval? What tools do they plan to
use? What is the replication direction - master-slave, peer-peer? How
Hello,
Could you explain me how to deal with folowing error:
select * from sysaudit@tg.big
*
ERROR at line 1:
ORA-28509: unable to establish a connection to non-Oracle system
ORA-02063: preceding line from TG.BIG
(HP-UX 11, Oracle 8.1.6, tg4ifmx 8.1.6, Informix 9.2)
Title: Phew ... Finally Migrated
Over the weekend we migrated all our production systems on 9201 on AIX.
I know it is not all that important, but thought I'd let everyone know. I also learned the magic of commit=y/n setting on imp. I have one table (it had a long column) that was taking
I have recently heard some people say it had taken them several months to master, and
*now* it would take them about 15 days to implement.
- Original Message -
From: Robin Li [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 14 Oct 2002 05:58:24
Hi
We too are moving to a Sun Fire 15 K box, with 8
partitions and 40 CPUs. But Our storage is on EMC. And
since we have many partitions they are like separate
machines. We will be housing two production warehouse
databases and 5 production OLTP databases, with all
other environments supporting
Theoretically, if the activity of the database doesn't involve too much
disk writing, and the cache is large enough, etc., etc., you can use
parity. When disk drives cost a lot of money, there was some justification
for it. Now that drives are cheap, there really is no justification. To
Ok i've been thru all of the 817 docs multiple times, searched metalstink,
read the chapters in backup/recovery 101 multiple times.
Where in the heck is the "spool" command for rman?
Can i only spool stuff(and its an either to a file or to the screen, not
both?) using the log parameter when
No no - it wasn't to do with the specifics of snowstorms or cosmic
radiation, rather a further discussion of the issues of database design,
which ultimately has to be the reference point in any discussion of star
schemas etc.
peter
-Original Message-
From: DENNIS WILLIAMS
Title: hot backup mode
No, it
does not. Being in hot backup mode does not affect the generation of UNDO, only
redo. When you modify a column, Oracle stores only the column address,
operation, original data (if update or delete) and some internal
information.This is the same whether the
Dpeneding on the state of course . at least here in Texas
there is not (currently) state income tax.
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 9:54
AMTo: Multiple recipients of list ORACLE-LSubject: RE: *
Sr. Oracle 8i
Yeah - replication - a tasty subject.
I too have been working on it for years (about 15 - how long has Oracle had
a replication facility?!).
I've cut the implementation time down to about, h, a few minutes all
done using scripts which build scripts which call scripts which build
scripts
and, if possible, start with Anita Bardeen's white paper Replication DOs
and DON'Ts. (You'll probably find it at OTN). This is only a few pages,
but it's full of invaluable tips.
Barb
--
From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent:
Joe are you on UNIX? you could pipe the
stdout to a program called tee
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:14
AMTo: Multiple recipients of list ORACLE-LSubject:
stupid RMAN question
Ok i've been thru all of the 817
Title: Phew ... Finally Migrated
I
appreciate the feedback Raj.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002
11:24 AMTo: Multiple recipients of list ORACLE-LSubject:
Phew ... Finally Migrated
Over the weekend we
Joe - quoting from Oracle RMAN Pocket Reference, p. 107
SPOOL (Oracle 9i only)
Causes output generated from RMAN to be written to a log file.
Syntax
SPOOL LOG { OFF | TO filename } [APPEND][;]
As for 817, you might try not logging the output, and run the script from a
ksh (Unix)
You are correct - only the log command is available in 8i, spool is
available in rman in 9i.
-Joe
--- JOE TESTA [EMAIL PROTECTED] wrote:
Ok i've been thru all of the 817 docs multiple times, searched
metalstink, read the chapters in backup/recovery 101 multiple
times.
Where in the heck is
Peter - I wouldn't even presume to pass judgements on two such titans of
their respective industries, but taking it down a notch, here is what I
would make of their discussion.
The relational model has been extremely powerful, based as it is on a
firm mathematical foundation. I would count
(IMHO) There ain't none...dontcha just love it!
Once you've entered the dark side (ie the rman prompt)
there is no turning back...
hth
Connor
--- JOE TESTA [EMAIL PROTECTED] wrote: Ok
i've been thru all of the 817 docs multiple
times, searched metalstink, read the chapters in
Replication implementation for a newbie in 10 days?
Having worked on replication for two and half hears,
I would say it should not be done.
Replication is way too complex. Read the Anita Badreen's white
paper and it would emphasize the importance of understanding
and planning repliction.
Raj,
The effect of commit=y is greatly effected the the setting
of buffer=N. How big was your buffer?
If you left at default, that would seriously slow down your
import. I think the default size is platform dependent and
possibly db block size dependent ( too lazy to RTFM ), but
it's always
Peter - I entered PLOUG in Google, and it returned the Polish Oracle User's
Group. I doubt that I will be able to attend. Any chance you could post your
presentation afterward?
Dennis Williams
DBA - Still being threatened with replication
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Title: Phew ... Finally Migrated
Raj,
Thanks
for sharing this.
When
COMMIT=y, and if the table has columns with LONG datatype
(among a few others), IMP will not use array inserts (BUFFER=) and will commit
each row.Committing each row for large tables with
thesedatatypesadversely affects
On the link below is this quote from C.J.Date:
I don't want you to think that my SQL solution to your problem means I
advocate the use of nulls. Nulls are a disaster.
Of course, he doesn't expound upon it (probably not a need except for
dummies like me). Anyone care to comment? (On the
Didn't cover all of the 9i upgrade material? Why not?
Because the we wanted to get the book out as quickly as possible to the
Oracle community so they could start using the more important 9i New
Features ASAP. We were trying to be a first strike new features book (as
evidenced by the
Hello,
BACKGROUND:
We've been planning a 300GB datawarehouse architecture for Oracle 9.2 on
Solaris, and have proposed the following:
1) 2 separate instances of Oracle 9.2,
- Instance A will be the staging instance, all ETL processing will
take place here
- Instance B will be the
Dear Listers,
I hope you won't mind a question that (I think) looks unfit for this list:
Can we prevent a delete trigger from deleting a row?
To make it clear, here's the code for a trigger:
CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW
???
END;
What
That holds true for New Hampshire as well (for the time being), course there are
few high paying jobs up this way either so we end up paying Mass income tax
instead.
Dick Goulet
One of the many NH residents who work in MA.
Reply Separator
Author: Kevin
Text of a previous email reply where I answer this question:
What I would suggest is that you goto
http://www.oracle.com/education/certification/objectives/index.html?dba9i_tc
c.html
and download the test objectives for the exam. In those objectives you will
find each subject area that is
Title: RE: Elementary question about triggers
Basics:
1. Delete trigger doesn't delete the row, the DELETE command does it.
2. DELETE command invokes the delete trigger (if the trigger conditions are met).
Solution:
1. Revoke delete priv so no deleted can take place.
2. Create a
Hey Dick,
Thanks for your response. The reason I ask the question is because I *wish*
our ERP system supported NULLs, at least in date fields. To properly
explain why, I need to preface it with a short explanation:
Our 3rd party ERP system is one that was designed in the '80s using indexed
Rich,
NULLs are one of those religious war topics.
They have a legitimate place in an RDBMS, but I think you
need to be judicious in using them.
If a column is to be used as part of a where clause, I prefer
to use a default value, particularly with dates.
NULLs can be a real performance
Jesse,
I'll refrain from personal comments, but on CJ's quote, he's correct. Nulls
are an oddity. They cannot be true or false (column_name = NULL or
column_name != NULL), nor can they equal anything. They are in effect a third
logical state of nothingness. You also have to code most
Is this simply replicating data to another system read only?
Replicated for what purpose? High Availability? Querying and reporting?
Jared
Robin Li [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/14/2002 06:58 AM
Please respond to ORACLE-L
To: Multiple recipients of
Title: RE: Oracle and Informix on one server memory issues
Guys,
Are there any known issues with running both Informix and Oracle on the same box with Solaris 2.6 and Oracle 8.0.6, Oracle 8i and Oracle 9i - reason is we are using same box for disaster restore/recovery testing for Oracle
Why seperate instances? Why not seperate schemas in the same instance?
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hello,
BACKGROUND:
We've been planning a 300GB datawarehouse architecture for Oracle
Rich,
Several years ago in the old Database Programming and Design magazine (a
really useful publication, IMHO - too bad it's gone), C. J. Date and
another database guru (I can't remember his name) carried on a debate that
lasted several months about the badness (Date) vs goodness (the other
Jesse,
You would not happen to be talking about ManMan-X now would you??? Oh, the
wonderful days of ManMan on HP TurboImage where the maximum date that it would
populate was 32767 and date 1 was actually 31-OCT-1971. Yes, ManMan stored
dates as a number where the starting point was
Wow! This is a completely new view on the TKPROF.
So far, I've been inclined to look upon the TKPROF output as
on the holly scripture. Mentioning the tkprof bugs is like
discovering Kumran rolls!
-Original Message-
From: Cary Millsap [mailto:[EMAIL PROTECTED]]
Sent: Monday, October
http://metalink.oracle.com/metalink/plsql/showDoc?db=NEWid=215900.996
Oracle Security Alert #45
Dated: 04 October 2002 (Updated: 10 October 2002)
Severity: 1
Security Release of Apache 1.3.27
Description
Apache has released version 1.3.27 of its HTTP Server that contains fixes for the
Rich
If you were to give each of your developers a pop quiz on nulls, how many
do you think would pass? I agree with Dick, that nulls are a confusing
concept that usually only the DBA really understands. I feel that an
important decision when beginning a new application is whether or not to
Here's one way:
drop table d;
create table d( x integer );
create or replace trigger d_nodelete_trg
before delete
on d
begin
raise_application_error(-2,'No Deletes Allowed!');
end;
/
show error trigger d_nodelete_trg
Jared
Charu Joshi [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
Bill,
Why use two instances? If you believe that the second instance can be
protected against performance degradation during ETL processing your wrong.
Both instances will be looking for the same resources (CPU memory) and worse
if your using net attached storage, they will end up
CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW
BEGIN
RAISE_APPLICATION_ERROR(-2,'Do not delete ...');
END;
/
Bala.
-Original Message-
Sent: Monday, October 14, 2002 1:14 PM
To: Multiple recipients of list ORACLE-L
Dear Listers,
I hope you won't
Title: RE: Oracle and Informix on one server memory issues
In the past, we ran an older incarnation of
Informix SE here, on a Solaris 2.6 box along with 8.1.6 and 8.1.7. There were no
issues / problems.
Brian
--
| Brian McGraw /* DBA */
Why not just remove delete authority from anyone not authorized to delete
from it ??
-Original Message-
Sent: Monday, October 14, 2002 2:34 PM
To: Multiple recipients of list ORACLE-L
CREATE OR REPLACE TRIGGER temp_trig BEFORE DELETE ON temp_tab FOR EACH ROW
BEGIN
Rich,
I piqued my own curiosity and looked at Database Programming and Design
On-Line. Below is a link to a lengthy response (1995) by Date and others
to Tom Johnston's article defending MVL (Multi-Valued Logic). Plenty to
chew on.
http://www.dbpd.com/vault/dateresp.htm
Jack C. Applewhite
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
No application that I can reasonably think of should
use NULLS, except those pre-81
where there are obsolete columns.
Everytime somebody says this to me, I ask them:
How do you handle still employed employees in an
Rich - Good point! I haven't used Oracle Resource Manager, but in theory it
should be able to do a better job of implementing priorities than the
operating system can.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, October 14, 2002 1:54 PM
To:
Thanks to all who replied.
The idea comes from the application manager. Because there is a new
server for his application, we have to move the DB from the old server
to the new one. Our original plan was by using RMAN's duplicate method
which I've done for couple times and feel confident. By
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
END_EMPLOYEMENT date for still employed employees equals to
"01/01/4000" (or any other pre-defined date in distant future).
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Adams,
*** Comments by BECKER, BILL Mon Oct 14, 2002 -- 02:24:00 PM
Thanks for the response, Don. RichG. also wondered why 2 instances.
I should have included the fact these will be running on 2 different
platforms as well. Apologies for the confusion. Actually, I didn't include
that fact
How about:
Copy your database to the new server. This needs to be
done in real time. I've done this a number of times by
putting the database in hot backup mode, copying the
datafiles to the new server.
Then when you're ready to switch, shutdown the old
database, copy all archive logs
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
The
problem I see with NO NULLS is that artificial data must be created, where the
data is truly not known. Whether you deal with NULLs or artificial data, you
will always have to code accordingly, so it is a wash. Igor's
I'll agree with Igor. Actually my 'preferred' option would be to use their
birth date + 80 years which is the generally accepted life expectancy of a human
being. Lets face it, you aren't going to employ the guy/girl after their dead!
And if their not dead by then, then sure as heck they'll be
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
I disagree with the use of "dummy" values to
represent missing data. It reminds me of the olden days when we coded in
12/31/99 and such. Shades of COBOL HIGH-VALUES! You're introducing a
lot of dependencies and
Dennis,
See below is an email conversation that I had with the 'Goddess' in 2000 on
the same subject. Those were the days when Goddesses had to sleep and
de-stress on their way home
(Ducking as the Goddess takes out her six-shooter magic wand)
John
Reply from Rachel:
==
Geek!
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
Or you'll have to explain to the HR manager why all of the
employees appear to be terminated!
they aren't terminated! at least not yet :-)
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Bruno
I don't believer that many people on this list use the Informix gateway.
Also, I feel that if the subject line of the email is filled in, you stand a
better chance of getting a reply. That said, my experience with a gateway
product is zero, but I'll post the output of oerr on the off
Title: Message
Hmmm...but what about the index? Which is
faster?
select
* from table where END_EMPLOYMENT IS NULL;
OR
select
* from table where END_EMPLOYMENT = '01/01/4000';
I like
NULL, but I am leaning towards Igor, and others, to agree upon and use a default
value, or a "business
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
Actually, you don't have to deal with "01/01/4000" date (at
least on "select"), all you have to do in order find currently employed
employees, is:
where END_EMPLOYMENT sysdate
asfor inserts, all you have to do, is define
John - Wow! An impressive memory tour de force!
My problem is that I am driving during my commute. You get the strangest
looks when the next driver glances over and sees your face buried in a PDA.
Actually that last phrase might become prophetic. I was just asking if there
was a way to get a
Hi,
My agent asked me these couple of questions through
email, can any one give me some idea? Thank you!
Leslie
---
What are a couple ways to detect block corruption
within an oracle database?
What is the wait interface?
What v$view would you query to get a list of
Both would likely do FTS since at any given time more than
50% of your employees will be current (have an end date
of 1/1/4000' making it very unlikely that the cbo would choose
this index. The RBO, would, but it would likely degrade
not improve your performance.
John
Grabowy, Chris
Dennis,
I also have a driving commute, and I was also thinking about asking her
to voice record her book. But I think I would get into an accident
hearing her sexy voice describing how to recover a database...:P :) :P
:)
-Original Message-
Sent: Monday, October 14, 2002 5:34 PM
To:
It's a little difficult to see how code samples and illustrations
(which I find invaluable) could be translated to audio
It's technically copyright infringement (I believe) to translate the
books. I don't own the copyright, so I'm not about to call out the
lawyers. I am supposed to contact
Thats what we are planning on doing here with our data warehouse.
Unfortunately, your CPU's have to be at 100% for resource manager
to become effective. I'd like to be able to have a bit more control
over sessions than that.
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX
Title: RE: No Nulls? (was: Warehouse design: snowflake vs star schem
This is true. But you still need to add logic
to your application to suppress displaying the termination date when it is =
"01/01/4000". Ican pretty well guarantee your users will not like
seeing a "dummy" date on their
Thinking about Matt's question, would it be proper to move the column to a
EMP_TERMINATED table with an outer join on EMPNO? There wouldnt be any
NULLs...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex,
Hi
How to check which query is using full table scan?
Thx
-Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
But from a practical, operational standpoint, NULLable columns can cause
problems, the least of which is lack of index-ability (for lack of a better
term) when issuing queries containing NOT NULLs and the like. Of course one
might say that one should know the database one is issuing a query
Title: Message
That's
not a problem for me...I told all my duh-velopers that RBO was dropped from
Oracle8i(big grin)
-Original Message-From: Ora NT DBA
[mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 5:53
PMTo: Multiple recipients of list
Is this for a job interview?
I for one, am not going to help proliferate the number of DBA's
that don't know what they're doing, when there are many available
that do.
If I'm way out of line here, then let me know, but this sure looks like
a good opportunity to recommend some RTFM.
Jared
If you're on Unix, you can use the
UnixSCRIPT command to write the terminal output to a file.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 10:14
AMTo: Multiple recipients of list ORACLE-LSubject:
stupid RMAN question
Ok i've
Hello All,
This problem pertains to local bitmap index in dw env.
We are using informatica to load our fact tables.
i have a fact table partitioned on period key (range partition).
We have built local bitmap indexes on the foreign keys.
During the loading of the fact table for month 1, we are
Robin,
If you can have an hour of downtime, you could probably just create a
clone of the original database and be done with it (but make sure you
change the DB Name and the DBID if you are using RMAN). Of course,
depending on your disk and network speed, this could take more or less that
smart aleck! :)
I've spent time on the train reading and working. I've learned that I
need the time between leaving work and getting home to turn off my
brain and relax before dealing with reading this and the OT lists at
home!
I can't believe you saved that email. Sheesh, you really ARE a
Leslie
Instead of just providing the answers, I'll show you how to find them. Go to
http://www.google.com, and search for Oracle block corruption and Oracle
wait interface. You'll find several articles that will teach you more about
these subjects. For the last question, click on
Bruno
Are you using HSODBC for connections between ORACLE and INFORMIX?
Adriano Freire
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adriano Freire
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
That was a great magazine. I've clipped and saved or
printed from the web site and saved, a number of articles
from that mag.
If you *really* want to discuss dates, read the Snodgrass
series on temporal data, then by his book. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
Unix SCRIPT command? Never heard of it.
Hmm.
man script | col -b
Thanks! Learn something every day on this job.
Jared
SCRIPT(1) System General Commands Manual SCRIPT(1)
NAME
script - make typescript of terminal session
SYNOPSIS
script [-a] [-f] [-q] [file]
We could put together a whole Namesakes series about Oracle stuff...
Morgan Freeman reads Oracle 9i New Features by Robert Freeman
Patch Adams reads Oracle8i Internal Services by Steve Adams
Apologies to Spinal Tap for the distorted idea...
-Original Message-
Sent: Monday, October 14,
In Informatica there is a stored procedure transform (runs any Oracle SP)
that you can make it pre source load.
So the SP would be called before loading the table.
Regards,
Waleed
-Original Message-
Sent: Monday, October 14, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L
Hello
Here, Here! Bravo! AMEN, Brother...
I'm with you on this.
-Original Message-
Sent: Monday, October 14, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
Is this for a job interview?
I for one, am not going to help proliferate the number of DBA's
that don't know what they're
Seems in line to me... There is a big difference between Help me with this
problem at my current job and Help get this job that I'm not qualified
for...
Tim
-Original Message-
Sent: Monday, October 14, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L
Is this for a job
smart aleck! :)
I've spent time on the train reading and working. I've learned that I
need the time between leaving work and getting home to turn off my
brain and relax before dealing with reading this and the OT lists at
home!
I can't believe you saved that email. Sheesh, you really
Thats what we exactly did except that iniformatica starts a separate
session when it is loading the target
which results in the error unusable state .
sathish
On Mon, 14 Oct 2002 15:44:02 -0800, Khedr, Waleed
[EMAIL PROTECTED] said:
In Informatica there is a stored procedure transform (runs
I could not start database due to ORA-03113 error, someone please advise
what it means and how to fix it ASAP. I really appreciate your help.
Thanks,
David
SVRMGR startup
ORACLE instance started.
Total
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
At least one of your control files is corrupted, or the disk it
is on is bad:
00204, 0, error in reading (block %s, # blocks %s) of controlfile
// *Cause: A disk I/O failure was detected on reading the controlfile.
// *Action: Check if the disk is online, if it is not, bring it online and
Your instance crashed because the lgwr died... There should be a trace file
for lgwr in the bdump directory... What does it say in the trace file? Are
you having any filesystem issues? The LGWR: terminating instance due to
error 204 means that there is an I/O error when accessing the
reminds me of my most favorite BAD review of DBA 101:
I consider myself as an Oracle DBA beginner and want to lie on my
resume. Though I have completed the whole book I still feel confused
about the Oracle architecture and basic Oracle DBA commands. This book
is not a good reference book for a
1 - 100 of 107 matches
Mail list logo