And with ascii files, security becomes an issue.
Its easy to change data and load it back without errors...
And its easy to see confidential data too.
=)
[EMAIL PROTECTED] wrote:
Lyndon,
Beacuse it's proprietary. Any dunce can create a flat ascii text file,
which probably accounts for
I too have seen too many DBA wannabes...mainly because of the pay
Once they're in to it...only then do they see how complicated the job really is...
Lyndon Tiu wrote:
On Wednesday 12 February 2003 08:14 am, DENNIS WILLIAMS wrote:
Lyndon
A rule of thumb in job-seeking is when you don't
Going back to the topic.
I've been trying to avoid using RMAN for a long time...
I've always been confident with my own scripts...
But once you start getting more and more servers...more and more databases
and
on different platforms...you can get tired making separate scripts
for windows and
On Thursday 13 February 2003 07:08 pm, Maria Aurora VT de la Vega wrote:
I too have seen too many DBA wannabes...mainly because of the pay
Once they're in to it...only then do they see how complicated the job
really is...
It is very complicated I agree. PostGreSQL does not come close to
On Thursday 13 February 2003 06:58 pm, Maria Aurora VT de la Vega wrote:
And with ascii files, security becomes an issue.
Its easy to change data and load it back without errors...
And its easy to see confidential data too.
You are right. That's where encryption comes into play.
--
Lyndon
Lyndon
A rule of thumb in job-seeking is when you don't have experience, your
education counts all the more. This applies when you are just starting your
career or when you are changing careers. I haven't seen too many DBA job
postings that require a BSCS (always glad to be educated, though),
On Wednesday 12 February 2003 08:14 am, DENNIS WILLIAMS wrote:
Lyndon
A rule of thumb in job-seeking is when you don't have experience, your
education counts all the more.
I agree. No Comp. Sci. education means - To quote Oracle 9i: Unemployable,
Can't break-in, Just can't get it.
This
PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 05:14
An: Multiple recipients of list ORACLE-L
Betreff: Re: RMAN: I don't trust it
On Monday 10 February 2003 07:23 pm, Richard Ji wrote:
Lyndon,
You are comparing Apple with Orange here. I can backup my hsql database
which is stored in a text file
Lyndon,
pg_dump equals export in Oracle. Actually pg_dump all = export full=y.
It's just a syntax difference. And if you have a full export all you need to to
recreate the database is create the system tablespace. And yes it is easy with
Oracle, if you keep it simple.
Dick Goulet
]]BRBSent:/B Monday, February 10, 2003 5:04
PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B RMAN:
I don't trust itBRBR/FONT/DIVFONT size=3BRAs a longtime Oracle DBA
who has used many products, including RMAN, I find myselfBRguilty of a
paradoxical mistrust of RMAN, dating back
Quoting [EMAIL PROTECTED]:
pg_dump equals export in Oracle. Actually pg_dump all =
export full=y.
It's just a syntax difference. And if you have a full export all
you need to to
recreate the database is create the system tablespace. And yes it
is easy with
Oracle, if you keep it
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database
server. Not
suitable for large amounts of data, more the way to go if you're
looking for
an SQL database to embed into your Java app.
I thought we were talking about Oracle
for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 16:54
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it
Quoting Stefan Jahnke [EMAIL PROTECTED
Well no. Since you are comparing Postgresql with Oracle, why
can't I compare it with HSql or any other database for that matter.
And is postgresql scalable compare to Oracle? Can it handle my
Terabyte database?
-Original Message-
Sent: Tuesday, February 11, 2003 10:54 AM
To: Multiple
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi
I just posted that as reply to your question about hsql (what is it
?).
I misunderstood your previous answer. I thought you were talking about
an Oracle command that can export a plain text sql script like pg_dump
that's why I asked.
Thank you.
: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 16:54
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database
server. Not
suitable
Quoting Richard Ji [EMAIL PROTECTED]:
Well no. Since you are comparing Postgresql with Oracle, why
can't I compare it with HSql or any other database for that
matter.
You can compare anything here.
I misunderstood hsql as an Oracle command/script/package (new?,
hidden?, secret??) that I
Quoting Richard Ji [EMAIL PROTECTED]:
I wonder how scalable PostGreSQL is by default using default configs?
I know Oracle in it's default configuration ain't scalable. Funny
cause I know certain companies use Oracle thinking this is the
solution to their database scalability problem. Only to be
It does sound like a database command, doesn't it?
There are a quite a few open source database out there,
depends on what you need, they might just do the job as good
as any others.
-Original Message-
Sent: Tuesday, February 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Lyndon,
True, an export file is peculiar to Oracle. The difference between a
commercial database and an open source one. IBM and MicroSludge do the same.
The functional purpose though is the same.
Dick Goulet
Reply Separator
Author: Lyndon Tiu
Why should the default be scalable? Please tell me, how does Oracle know
how many CPU, Memory, the type of IO system, transaction volume and whether
it's OLTP or DSS, on and on... Every database application is different.
Scalability means different things to different database environments.
And
recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database
server. Not
suitable for large amounts of data, more the way to go if you're
looking for
an SQL database
Richard,
In theory, yes it can. Would I want to push a postgresql database that
hard, maybe not. But I will agree with Lyndon, it is a very nice open source
db.
Dick Goulet
Reply Separator
Author: Richard Ji [EMAIL PROTECTED]
Date: 2/11/2003
Quoting [EMAIL PROTECTED]:
Lyndon,
True, an export file is peculiar to Oracle. The difference
between a
commercial database and an open source one. IBM and MicroSludge do
the same.
The functional purpose though is the same.
Question:
Why a binary file? More efficient? I find the
[mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 11. Februar 2003 16:54
An: Multiple recipients of list ORACLE-L
Betreff: Re: AW: RMAN: I don't trust it
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database
server. Not
suitable for large
Quoting Richard Ji [EMAIL PROTECTED]:
Why should the default be scalable? Please tell me, how does
Oracle know
how many CPU, Memory, the type of IO system, transaction volume and
whether
it's OLTP or DSS, on and on... Every database application is
different.
Scalability means different
Lyndon,
Beacuse it's proprietary. Any dunce can create a flat ascii text file,
which probably accounts for the wide audience it gets. But it takes a PHD to
read a binary one. BTW: IBM and M$'s dump files are binary as well.
Also, Oracle's default installation does scale, although not
Quoting [EMAIL PROTECTED]:
Beacuse it's proprietary. Any dunce can create a flat ascii
text file,
which probably accounts for the wide audience it gets. But it
takes a PHD to
read a binary one. BTW: IBM and M$'s dump files are binary as
well.
Also, Oracle's default installation
Lyndon,
I take it from your reply that 1) your not the primary DBA and 2) everyone
is using Personal Oracle or Standard edition on their desktop. Sounds like one
heck of a mess.
Dick Goulet
Reply Separator
Author: Lyndon Tiu [EMAIL PROTECTED]
Date:
Title: RE: Re[2]: Re[2]: RMAN: I don't trust it
Two words - Speed and Performance.
-Original Message-
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Re[2]: Re[2]: RMAN: I don't trust
Quoting Nick Wagner [EMAIL PROTECTED]:
Two words - Speed and Performance.
gotcha. Thanks.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
Quoting [EMAIL PROTECTED]:
Lyndon,
I take it from your reply that 1) your not the primary DBA and
I work with Oracle and PostGreSQL, but not as a DBA. I'm a wannabe
DBA but will most probably never be a real DBA since:
1) I do not have B.Sc. in Comp. Sci.
2) I got into Hi-Tech right
Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Quoting [EMAIL PROTECTED]:
Lyndon,
I take it from your reply that 1) your not the primary DBA and
I work with Oracle and PostGreSQL, but not as a DBA. I'm
Lyndon
To me, being a DBA is more an attitude than an HR position. Study what
DBAs do and that will carry you forward.
I don't see what having a BSCS has to do with it. And I speak as someone
who has done a lot of computer science at the graduate level.
During the dark days, prepare, so
Quoting Jeremy Pulcifer [EMAIL PROTECTED]:
I take it from your reply that 1) your not the primary DBA
and
I work with Oracle and PostGreSQL, but not as a DBA. I'm a
wannabe DBA but will most probably never be a real DBA since:
1) I do not have B.Sc. in Comp. Sci.
Ha!
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
Lyndon
To me, being a DBA is more an attitude than an HR position.
Study what
DBAs do and that will carry you forward.
I don't see what having a BSCS has to do with it. And I speak as
someone
who has done a lot of computer science at the
Title: RE: Re[2]: Re[2]: Re[2]: Re[2]: RMAN: I don't trust it
From: Lyndon Tiu [mailto:[EMAIL PROTECTED]]
Quoting DENNIS WILLIAMS [EMAIL PROTECTED]:
Lyndon
To me, being a DBA is more an attitude than an HR
position. Study
what DBAs do and that will carry you forward.
I
As a longtime Oracle DBA who has used many products, including RMAN, I
find myself
guilty of a paradoxical mistrust of RMAN, dating back from the time when
Oracle has tried
several products, including integration with Legato and other
hardware/software backup vendors,
without a consistent
If only Oracle can come up with a Postgresql command such as:
pg_dump dbname | gzip dbname_backup.gz
Then backups would be easy. I know, I know Oracle can do the same with
export, and sqlplus but hell it ain't that easy with Oracle.
--
Lyndon Tiu
--
Please see the official ORACLE-L FAQ:
PROTECTED] To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
fu.ca cc:
Sent by: Subject: Re: RMAN: I don't trust
:
Sent by: Subject: Re: RMAN: I don't
trust it
[EMAIL PROTECTED]
om
11/02/2003
10:03
Please respond
Lyndon,
You are comparing Apple with Orange here. I can backup my hsql database
which is stored in a text file with:
cp my_db my_db.backup
using OS command only. :)
Richard Ji
-Original Message-
Sent: Monday, February 10, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
If
On Monday 10 February 2003 07:23 pm, Richard Ji wrote:
Lyndon,
You are comparing Apple with Orange here. I can backup my hsql database
which is stored in a text file with:
What's hsql ?
cp my_db my_db.backup
I do not undertstand this command. Oracle database files are in binary format.
43 matches
Mail list logo