Maybe they do not want to reinvent the wheel I mean, there are
so many tools out there that allow you to dump a table out. Take
a Perl script that would take 3 minutes to write for example. The
account I joined has a rather nifty C script. You get to modify it
to perfectly suite your envir
The problem is getting data into a flat file.
Recently I had to direct our development group to try
out some product like PDQOUT. And that reminds me,
Sybase has nothing similar to export/import to move
the data across platforms. The only way you can do
that in Sybase is to extract the data int
Biggest disadvantage with utl_file is it cannot be
used to extract data on the client. You also have to
consider the effort required and the performance.
Regards,
Denny
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> - bcp out - It's time Oracle came up with some
> utility to extract the
whoopse. pasted the wrong URL. I'll send the correct one as soon as I can
find it.
-Original Message-
Sent: Monday, April 01, 2002 11:00 AM
To: '[EMAIL PROTECTED]'
S
There is code for a basic "SQL Unloader" tool available at
asktom.oracle.com. Completely dynamic. Limited support for LON
There is code for a basic "SQL Unloader" tool available at
asktom.oracle.com. Completely dynamic. Limited support for LONGs and no
support for LOBs or objects, but generally pretty good. Does bulk fetches.
http://osi.oracle.com/~tkyte/flat/index.html
-Original Message-
Sent: Monday, Apri
Oracle does provide Export/Import. And, if you can get the data in a
delimited flat file there's always SQL*Loader.
What else do you need?
Ken
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, April 01, 2002 9:18 AM
> I've never underst
Here is the URL for the PRO*C code to dump data from a query to a flat file.
http://asktom.oracle.com/pls/ask/f?p=4950:8:646297::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:459020243348,%7BSQLDA%7D
-Original Message-
Sent: Monday, April 01, 2002 11:10 AM
To: Toepke, Kevin M; '[EMAIL PROTE
Denny,
Re the Sybase Replication server: It is a separate product and
truly an impressive piece of work.
While I was very impressed with Rep Server, the database is
what's lacking.
Jared
PS. to all: if you've never used Sybase, you haven't developed
a true appreciation for SQL*Plus.
On Su
, March 31, 2002 7:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OT (RE: Oracle From a Sybase DBA perspective| What is a
> Database to S)
>
> Out of curiosity, what do SyBase DBAs think of SQL Server and Microsoft?
>
> Regards,
> Patric
> Also appeared that you are stuck with one block size, anyone know if this
has changed?
Sybase 11.0 and prior had only 1 "page size" - 2k (except for 1 obscure
platform that i can't recall which was 4k). With 11.5(?) they added a
feature called Large I/O which allowed you to have 2k, 4k, 8k, or
I've never understood Oracle's business plan when it comes to
development/data extraction tools. It's like they are only "half
interested" in that end of the market.
Sure, they have Forms, Reports, Graphs, JDeveloper, Discoverer etc. But
they always seemed weaker than even the nearest competit
- bcp out - It's time Oracle came up with some utility to extract the data
in
ascii format other than recommending "sqlplus and spool"
What about utl_file functions?
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Any
In old days when I used to work on Ingres, you could bring up one db server
and start different databases akin to bringing up only one oracle.exe
serving different processes. That probably is similar to Sybase.
Raj
__
Rajendra Jamadagni
Out of curiosity, what do SyBase DBAs think of SQL Server and Microsoft?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'in
Denny,
Great analysis... thanks, I haven't worked with Sybase in quite a
while, my memory isn't as clear as it could be :)
Rachel
--- Denny Koovakattu <[EMAIL PROTECTED]> wrote:
>
> Having worked with a lot of Sybase DBAs and having discussed why
> "Sybase
> Architecture is Inferior to Orac
Having worked with a lot of Sybase DBAs and having discussed why "Sybase
Architecture is Inferior to Oracle's" and having helped them understand/learn
Oracle, I know why Sybase DBAs find it difficult to understand Oracle. But there
are a few things Sybase is better at.
- Ablility to return res
yes and no, technically you could have other owners in the same Sybase
database, so it's more akin to a tablespace than a schema. But both are
basically correct.
--- Jared Still <[EMAIL PROTECTED]> wrote:
> > Sybase database = Oracle tablespace
>
> My impression was that a Sybase database was
There's a lot of junk here, that's for sure. The reason for replying
to it is that this thing get's passed around among the Sybase types
and it's rather misleading.
I'm not trying to foment a religious war, just answer the half truths
and misinformation.
Jared
On Friday 29 March 2002 14:3
> Sybase database = Oracle tablespace
My impression was that a Sybase database was more akin
to an Oracle Schema.
Mind you I've had the training for Sybase, but haven't done
much with it. I'm thankful too, I didn't care for it much.
Jared
On Saturday 30 March 2002 04:23, Rachel Carmichael
oops, well, I haven't SEEN Sybase for at least 4.5 years so am I
forgiven?
So, how would you translate the dbo user? SYSTEM? Any account with DBA
role?
--- Mark Leith <[EMAIL PROTECTED]> wrote:
> You pretty much hit it on the head Rachel, except:
>
> Sybase sa user = Oracle sys user
>
> ---
Oracle does not use the redo logs to create the index. It uses the redo
logs to RECORD the creation effort if logging is on.
Semantics perhaps but important.
If Sybase does not write to the journal file when an index is created,
then if the database has to be recreated, how does it know that the
Hmm, what about the LOGGING/NOLOGGING option of the CREATE INDEX
statement ?
Jan
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 29, 2002 11:58 PM
> Jared,
>
> There are too many mistakes in that "document" to even begin to an
You pretty much hit it on the head Rachel, except:
Sybase sa user = Oracle sys user
-Original Message-
Carmichael
Sent: 30 March 2002 12:23
To: Multiple recipients of list ORACLE-L
S
Ian,
Having worked with Sybase years ago, I developed this "translation"
Sybase instance = Oracle dat
Ian,
Having worked with Sybase years ago, I developed this "translation"
Sybase instance = Oracle database
Sybase database = Oracle tablespace
Sybase dbo user = Oracle sys user
Sybase master database = Oracle SYSTEM tablespace
anyone have a better explanation?
Rachel
--- "MacGregor, Ian A."
Well, that certainly was interesting!! No database will always compare favorably to
others for every feature. There are some tings SYBASE does better than Oracle.
However, he is either ignorant of such things as the "no logging" directive, or
refuses to consider them because they are not pa
Jared,
There are too many mistakes in that "document" to even begin to answer.
However, one I do love
#26 Oracle will use the redo logs to create an index.
Obviously the author is working from that same INACCURATE book that
says that Oracle doesn't write to the datafiles when a tablespace is
Glenn Travis
sas.com> cc:
Sent by: Subject: RE: Oracle Fr
I read (most of) it and it made my day. People who write this kind of
stuff know they are only telling half truths (did you see any quotes or
references?). It's email spam for techies. And a reply does nothing more
than make their day. If some of it is true, fine. Let the Oracle kernel
write
I can only speak to Sybase 11 since that is the book I am reading but the
book actually makes the suggestion to speed up backups on large databases to
split your database into multiple databases because you can backup each
database independently. This also appears to be how they exert more contro
I've used Sybase (along with Ingres and Informix) in a DBA role in the past and the
one thing about Oracle I can say is;
At least Oracle doesn't have an entire chapter in the manuals on corruption and how to
detect, prevent and fix it. (see dbcc). To me, that is an admission of failure.
Our
Part III of
Point 23: "Only one database per server" Oh no! Now what do I do with
our HP that has 3 or 4 Oracle instances on it!?
OK, OK, I need to stop reading this and get back to work...
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Part II of ???
The author states in point 1 "Oracle has no provision to store numbers in
the computer's own native format, namely IEEE." I'm not sure what he means
by "the computer's own native format", but the last I knew, IEEE was a set
of software libraries on most machines, and not a "native
I'm inclined to agree with the "extraordinarily incompetent" part, or at
least in one case. On point number 38, the author states that Oracle's LDAP
server (assuming Oracle Internet Directory) is "to cover up the severe
problem that all users in an Oracle database cannot readily share the tables
I will say I sat in a meeting with a customer recently who is a big Sybase
shop and they were having huge difficulties because the generate 9 GB of
redo on one database each day in a high replication environment. In their
minds this was really a lot. I have also been reading up on Sybase and all
34 matches
Mail list logo