Title: RE: XP vs. W2000
So, Jared, I have heard of VmWare which is not as far as I know Open Source(Free).
I don't know of Win4Lin, is it Open Source? and won't you email me a link to the site.
Regards
Denham
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sen
Rachel,
I'm Sorry for quoting wrong book. Actually I have both books and both are
excellent!
Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
http://www22.Brinkster.com/rpapnoi
-- Origi
I neither pull my hair or chew my nails. I find other ways to
relieve my stress. Course, the folks at work are not to happy
about it. Well, at least when the plant was open. There are
very few activities I do that are not considered 'risky'. DBA
work is relatively stress free for me I
I'm experiencing a weird issue I've never encountered before. One of my clients runs a moderately active database being connected to by a group of webservers running mod_perl, making a 'standard' set of queries to generate dynamic content. 'standard' in this sense means that the queries are uncha
Nah, I'm no DBA, just a %X*$@?! developer that gets a secret joy
out of watching DBAs pulling their hair out.(or chewing off their nails...)
Robert Chin
- Original Message -
> Robert, you're a DBA, and you still have hair? ;)
>
> Jared ( hasn't pulled it *all* out, yet )
--
Pleas
As we are treading towards OT land, I've got a Dell PIII 750 with 512MB on
my desktop running WIN2K Pro. I just bought a laptop, Compaq Presario PIII
1.0 Gig Chip with 512MB running XP Pro. I run 8i and 9i on both machines.
The laptop is definitely snappier when running OEM 9i. With comparably
con
I quite agree with Kimberly. I used to be a full-fledge Oracle programmer
but wanted to dabble with database administration. I asked my boss whether I
could be a database administrator. His answer is yes but I still need to
maintain my current systems. Now, I am a database
administrator-cum-progr
Steve,
"nm" parameter is used as event name. i.e what to do if that triggering
event occurs.
You can set either SYSTEMSTATE or PROCESSSTATE or ERRORSTACK to dump those
things.
Consider a case , you want to dump the errorstack when ORA-00060 (deadlock)
occurs.
Here you use SID,SERIAL#,60,65535,
>This question is a little off the mark. I will be ordering a new Dell PC
>(8200) in the near future. I would like to know which OS I should go with.
>XP Professional or W2000? Any suggestions? Anyone have any experience
>with XP Prof.? Pluses / minuses?
>
If you need to run windows, I'd use
Title: RE: What's Oracle Trying to Hide ???
because the list is so slow today, I'll add my response to it...
I agree with Jared... but have one other thing to mention.
Working for a company that continually delves into the internal structures and workings of Oracle I learned to respec
I generally share your "speculation" but in the case of dbms_system it is
referenced by other sources yet it is undocumented. If you can do a describe
on it from SQL*Plus then it should be documented. So dbms_system is
undocumented and incomplete but available for our use??
In dbms_system there's
Oh C'mon... Don't you consider numerous daily reboots as "reasonable
alternatives?"
I understand that if you use XP and the Internet your system is wide open to
intrusion... so it turns out that MS is an "open systems" software company.
:-)
Steve
-Original Message-
Sent: Wednesday,
I suspect that they are trying to prevent headaches
by hiding 'features' that are intended for internal
use only.
Sometimes a "DBA" will get hold of some undocumented
feature and use it just because it's there, sometimes causing
database problems in the process.
This type of behavior is common
It's dogma only when there are reasonable alternatives. ;)
Jared 'just the facts' Still
"Orr, Steve"
Could be, but how do I read it?
Ken
-Original Message-
Sent: Wednesday, December 26, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Odd SQL Loader Problem
Could you have a special character like cr or nl that is causing this
problem or indicating the en
Hi Stephane,
>I agree with you for a full export, and (I have just checked) a
> OWNER=SYS export exports everything but tables. But there is no such
> limitation with a TABLES= export :
Thanks for the inputs. Guess this is something new 7.x plus since I think
that was true before.
Guess the
Could you have a special character like cr or nl that is causing this
problem or indicating the end of record before reading all fields?
-Original Message-
Sent: Wednesday, December 26, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
I am loading data into an Oracle table (8.1.7 o
I am loading data into an Oracle table (8.1.7 on W2000 server). I am
skipping fields (via filler) because I don't need to load them. However, I
am getting an error on one of the input fields (being skipped) - field in
data file exceeds maximum length. The record is a tilde "~" delimited flat
fi
Robert, you're a DBA, and you still have hair? ;)
Jared ( hasn't pulled it *all* out, yet )
Robert Chin
It's really not that difficult. You do HAVE TO READ the readme's and the
info on Metalink first. There are some things that need to be done to
install on RedHat. These are fairly well documented on Metalink. The
installation is not a point-click-and forget type install. Once all the
stuff lis
I agree with Jared. Even though I posted a response pointing to a website
that discusses some of the pros/cons of XP and W2K, Linux is my first choice
and I love it (and will love it more once I get SuSE 7.2 to work with my
NVidia card so I can install Oracle again).
-D-
On Wednesday 26 Dece
Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script:
Rem dbms_system - database system level commands (moved to
Rem prvtutil.sql for more obscurity)
Not only do they want to "obscure" the dbms_system package but I can't find
the p
How dogmatic of you Jared! Are you suffering windoze xenophobia?
On my laptop I've got VMWare with Win2k and RedHat. I confess with shame
that win2k is my primary O/S and that I need windoze for MS Outlook. Also,
I'm addicted to MS Office. Addiction as in dependence on unhealthy things.
Sigh...
>
> Forget it.
> Get Suse 7.2 or 7.3, or the latest version of RedHat.
Yeah, LINUX is great but get ready to pull (some of) your hair
out installing Oracle. God help you. (or find a LINUX guru and pay him to do it)
Robert Chin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Forget it.
Get Suse 7.2 or 7.3, or the latest version of RedHat.
If you want to run Windoze too, get VmWare or Win4Lin.
Win4Lin works with win95/98.
Vmware is more flexible and will work with Win2k.
I've found Win98 with Win4Lin to be more stable
than Win98 by itself.
Jared
If you work on a site like I do you could always cross train. I am always
looking for suckers (um, people) to be my backup. Right now I use one from
the Unix team and one from the development team. Its the only way I get to
take vacations and what no. Check with your current DBA and see if the
This question is a little off the mark. I will be ordering a new Dell PC
(8200) in the near future. I would like to know which OS I should go with.
XP Professional or W2000? Any suggestions? Anyone have any experience with
XP Prof.? Pluses / minuses?
Thanks,
Ken
--
Please see the official
Have a look at rman. It allows online backups of databases if they are in
archivelog mode. If you don't want to put your databases in archivelog mode
then rman can only backup them up when they are in mount state and
inavailable to users.
HTH,
Ruth
- Original Message -
To: "Multiple rec
Position: Oracle DBA / System Administrator-NT Required
Location: Huntsville, Alabama
Salary Range: 55-75K (includes bonus)
Description:
This manufacturing company in Huntsville needs an Oracle DBA/System
Administrator to provide
hardware and support support in an NT/Oracle/SAP environment.
MUST
Try this...
Create or replace trigger cre_PK
before insert
on tableA
for each row
SELECT seq.nextval INTO :new.col1 FROM dual;
end
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the
You can create a Universal Installer response file which will automate the client
installation. You can mount the CD on a network device, or just copy it to a disk on
a server so that you don't have to walk the CD to each PC.
e.g. setup.exe -responsefile "l:\apps\oracle\816\User_Cdrive.rsp"
With your current background, your more likely to land a job as a network
administrator LONG before you'll end up in a database position. Access is still
looked on as a single user system and frankly I haven't run into any large scale
applications that use it, period. One of my current tasks is
and eventually, when they realize they can't find that omniscient
person, they come back to reality
--- Robert Chin <[EMAIL PROTECTED]> wrote:
> > I liked the interviews where they told me about their project, and
> > I told them how I could contribute - strengths and weaknesses.
> > I'm great a
Hi Friend :
Does anyone use Oracle Internet Directory ?
How does it work ?
What is the password and the user that need I to use to connect with
the
utility oidmon ?
Why is it used ? For to build hierarquical structure ? Just it ?
Regards
Eriovaldo
dba 101 is not by gaja and kirti -- that's performance tuning 101 which
is indeed an excellent book
dba 101 is theriault, carmichael and viscusi.
--- [EMAIL PROTECTED] wrote:
> Dear Ravi
> DBA 101 book - BY Gaja and kirti is available in India (indian
> edition). I
> already have one. Excelent
you can get the documentation online. read it.
according to the publishers, DBA 101 has been released in India.
and it is available on the internet at any of the online book stores
--- Dharani Ravi <[EMAIL PROTECTED]> wrote:
> Dear Rachel,
>
> Thanks for your reply and guidance. Also thanks
i wrote some
reports in informix(.ace files). but recently we r shifting to oracle database.
anybody having idea how to configure .ace files ?? any tool in oracle which we
can use without much effort from our side to configure .ace files
?
i hope i am
clear. if not, please revert back to
Hi,
I develop applications with
Delphi 5 Client/Server suit. I used Oracle Database. (with BDE connection)
I have a problem with client side. To run my program on some client
machine , I install oracle client for this machine. Is there any way to run my
program on client without ins
Title: RE: RE: Change PCTINCREAE for SYSTEM Tablespace
Hi Tom,
Can you review my views in changing pctincrease value:
If i'm creating database manualy without dbassistant,
The steps are,
1) CONNECT INTERNAL
2) CREATE DATABASE ( LOGFILES, A SINGLE DATAFILE FOR SYSTEM TABLESPACE AND other i
Dear Ramesh D Papnoi,
Thanks for the info. I will buy it.
Regards.
Dharan.
--- [EMAIL PROTECTED] wrote:
> Dear Ravi
> DBA 101 book - BY Gaja and kirti is available in
> India (indian edition). I
> already have one. Excelent book!!
>
> Regards,
> Ramesh D Papnoi
> Oracle DBA @ Chemtex Global
Title: RE: Trigger
Hi
if (col1,col2,col3) are forming primary key means, then how come you
insert value for any one of primary key columns, if so it would not give error for NOTNULL
nIRMAL,
-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent:
41 matches
Mail list logo
