Effectively so, unless you regularly put the same
value back into the index. I haven't verified it, but
in this case my understanding is that oracle does not
the work at all. Of course, any index operation could
invoke more work in terms of re-arranging blocks to
keep the validity of the index
Hello
list,
I wanted to know of some good
sites where i can learn the basics as well as advanced DBA topics. Could anybody
help me out ?
Thanks and Regards,
Santosh
Friends,
Find below the script of a table with a CLOB datatype
CREATE TABLE lob_content_display
( content_display_id VARCHAR2(30),
business_id VARCHAR2(30),
language_id VARCHAR2(30),
content_typeVARCHAR2(30),
detail CLOB DEFAULT EMPTY_CLOB(),
I heard Mogens talk about this at the UKOUG Unix SIG in London at the end of
last month (You Probably Don't Need RAC, or: pRos And Cons). It was truly
an eye opener! The upshot was, if you don't have a requirement to be up from
a failure within 5 minutes, then you don't need RAC. As has already
Friends,
Find below the script of a table with a CLOB datatype
CREATE TABLE lob_content_display
( content_display_id VARCHAR2(30),
business_id VARCHAR2(30),
language_id VARCHAR2(30),
content_typeVARCHAR2(30),
detail CLOB DEFAULT EMPTY_CLOB(),
guys,
SQL select A from test ;
A
---
1
2
3
4
.
.
.
10
i need the result as
A
--
1234...10
how to do this ? can someone help me ?
the env. is oracle 8.1.6.
TIA.
Prem J.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Hello guys,
I have an unexpected problem with this error. It
appears when I executeand select statement showing
bellow.
The strange things isuntil nowI don't
catch itnevermore. I
use two RDBMS: Oracle 8.1.7 EE for Windows NT4 andOracle 8.1.7 EE
for HPUX.
The select statemen is:
select
This
will keep you busy. Enjoy.
http://web.singnet.com.sg/~petermag/oracle.html
Dave
-Original Message-From: Santosh Varma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 12, 2003
4:09 AMTo: Multiple recipients of list ORACLE-LSubject:
Newbie to Oracle DBA
Hello
Hi everybody
Since I'm a networking dummy, here's a question that might be easy to
answer:
I have to setup client access (Oracle Net) to an Oracle Database through a
firewall. So far, I only know that the listener listens on a dedicated port
(like 1521). After a client requested a connection, a
I had fun at home, I have an old Pentium II with 700M of RAM running Windows
2000 Pro...
Installed 9iR2 -- no problem, I shrank the SGA as low as I dared. The
OracleHTTPServer service works OK.
Installed iDS9iR2 -- works, provided I stop most of the Oracle services in
the services applet. I
Thanks Waleed, that is exactly what I wanted.
And thanks to all the others who responded
John
-Original Message-
Sent: 11 February 2003 22:54
To: Multiple recipients of list ORACLE-L
I hope this helps:
--
drop table test_bal ;
Hello,
When mounted, oracle's cluster filesystem is listening on udp port specified
by parameter ip_port in /etc/ocfs.conf.
Does that mean, i can mount it over the lan? If yes, then how (mount -t ocfs
-o ...)? If no, then what is the true usage of this port?
Bruno Vanters
Junior DBA
TietoEnator
Boulder, Colorado company needs a Peoplesoft Developer/DBA (Oracle) for a
full time
staff position.
The opportunity is an engineering position requiring intimate knowledge of
PeopleSoft,
not just a PeopleSoft administration/DBA position.
Local Candidates preferred, but the company will consider
-Ursprüngliche Nachricht-
Von: Stefan Jahnke [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 12. Februar 2003 13:14
An: Multiple recipients of list ORACLE-L
Betreff: Oracle connection through firewall
Hi everybody
Since I'm a networking dummy, here's a question that might be easy to
Title: Message
Hermant, Sergey
The
table has 13 columns, the PK is formed for the first 11.
There
is no deletion nor update, just inserts in the table. I had truncated the
tables sometimes testing the procedure that load the rows.
This
is the result with an auto trace.
Vijay,List
When Updating to the Field to the SAME (Previously Existent) Data Value , Does a
DELETE RE-Insert of the Same Row to the index happen nevertheless ?
Thanks
-Original Message-
Sent: Wednesday, February 12, 2003 12:50 PM
To: VIVEK_SHARMA
Hi Vivek,
Index rows are first
That's approx 100 records per blocks.
What is the value of DB_FILE_MULTIBLOCK_READ_COUNT ?
Also, what is the elapsed time for the query if you re-run the query
immediately ?
[the first run fetched everything in physical reads, the second run
should still
find some or most blocks in the SGA,
It never hurts to diversify your skills. As everyone on this list will
tell you MySQL is no where near on equal footing with Oracle. However,
it is used in A LOT of small shops in the Linux/Apache/PHP/MySQL
combination. Keeping your options open and current is always a good
idea.
Rodd Holman
This is from one of previous postings:
Oracle has a registry setting that will force all traffic for a session
through the same port that the listener connection was made on (e.g.
1521).
Place the USE_SHARED_SOCKET parameter in the registry under
HKEY_LOCAL_MACHINE:Software:Oracle with a
Hi, friends:
We plan to buy new disk array for new splitted database server, Server will be
V880 with 8CPU and 8G memory, but we are considering whether to buy new T3 Disk array
or use diskarray from other vendor.
We have old T3ES with 256M cache, and it seems does not meet the
Title: Message
That's
not so bad: 14644 physical reads in 30 seconds..that's about 500 I/O sec.
Depending on your disk layout that's pretty optimal, I
think.
Mario
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: woensdag 12 februari
2003 14:19To:
Title: Message
Ramon,
Our Win2k boxes get between 1000-2000 gets a
second off a SAN.
Are you using
compressed folders to store your datafiles?
Whats
Multi_block_read_countset to?
Set MBRC to 32 (32x8K=256K). Make
your extent sizesare divisable by
256Kto reduce
gets
Regards
Adrian
Santosh - Web sites are excellent for finding the answer to specific
questions, but may leave gaps in your knowledge. If I may offer a
suggestion, get a good fundamentals book, and work through it trying all the
examples you can. A good recommendation is Oracle9i DBA 101
hi, dba friends:
some paper said, pqo should only be used in SMP machines, while others say,
We can also use pqo in uniprocessor machines in some case.
I am trying to use parallel index creation in the following env:
Dell 1650 with 3 scsi160 disks and 1 CPU and 2G memory.
Oracle
RMAN and export are two different animals. RMAN, in general, should not be
though of as a logical backup facility. That is to say, you should not
backup your database with the though of just recovering one table. RMAN
really isn't meant for that. However, that being said, it is very possible
to
List,
OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by Oracle
(software and data). A full backup works but an incremental does not
backup any files.
I'm fighting a view Someone hand me a big dagger with which to kill it.
I have a view that takes 6 minutes to run when I query it like this:
select
count(*) from TST_XVW a
where claim_carrier_key=41721;
Yet, if I take the SQL from the view, add the claim_carrier_key predicate to
it, I get a
Vivek - Just to add to Connor's statements (wow am I being rash here),
Oracle's strength is that it's architecture disconnects transactions from
disk writes. On one hand, block may be modified several times before being
written to disk (hot block, for instance). On the other hand, Oracle may
need
Michael Ivanov,
Hi, Thanks for your reply.
In fact, I builded the index several times like, and the result is
persistent across difference test case:
So, I think buffer is not the cause of the parallel execution slower.
But I really do not get
Hello,
Env: 9.2.0.2 on Solaris 2.9
We are currently considering a proposal regarding the use of the 3
buffer pools represented by db_cache_size, db_keep_cache_size,
and db_recycle_cache_size. I am wondering if this is a good idea
or a bad idea. The proposal follows.
The buffer pool space can
Good Morning All
Im looking at trying to grant privilidges to a guest user (who does
not own the tables)
I know I can do it for individual tables
Eg
GRANT INSERT ANY SCHEMA_NAME.TABLE_NAME TO Guest;
but I need to grant to an entrie schema
Like
GRANT INSERT ANY SCHEMA_NAME.* TO Guest;
Robert - I always try EXPLAIN PLAN as a starting point.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 12, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
I'm fighting a view Someone hand me a big dagger with which
Ron, man, you got me on the version thing. I yell at people who don't say
what version they are on, and here I am forgetting to do the same. I'm on
9iR2.
You are correct that the view would not use the index if I just did a select
* from it with no additional predicates. However, if I do a
Freeman Robert - IL,
Hi, can you show us the different execution path for the view and the
sql?
I think that is the key to solve the performance problem?Maybe hint
like no_merge help?
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China
Hi,
I got the Erwin(3.5.2) working for generate charts for
one schema. Thank you for all the help.
The chart doesn't show PK, FK relationship. There is
on lines between entities to show that they are
related. How does Erwin do that? Or maybe is there
other tools that can generate db chart
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),
Ron,
Are you saying that you use VMS backup commands to backup the database data files
while the database is open? This will result in unreliable backups unless you put the
tablespaces in hot backup mode. If you are not using RMAN, you should have a script
that backs up each datafile
Tim
Whatever you write is automatically copyrighted. In other words, someone
can't just freely copy what someone else has written and claim it is their
own (at least in the last dozen years). A good short resource is:
http://www.ott.caltech.edu/security/copyright_tutorial_Basic.htm
Now, as
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
Dennis,
We're going from 2 database servers to 1 for production. Therefore it's already
licensed as needed to be a standby served, saving us the extra dollars.
Dick Goulet
DENNIS WILLIAMS [EMAIL PROTECTED] wrote on 2/11/03 1:54 pm:
Dick
How is the standby database cheaper? I understood from
Hi all,
I have couple of questions about ERWIN.
-- I need to reverse engineer for just one schema. I
specify the login name/pwd for that schema, but ERWIN
generates charts for objects do NOT belong to that
schema too! How do I get charts for a specific schema
only?
-- When connect to the db,
Title: Message
Thanks
Ian,
Unfortunately I haven't been able to get this to work
either
Running
the command below from a Windows sqlplus session
SQL
update product set name = chr(2122) where sku = 'IB1';
1 row
updated.
SQL
commit;
Commit
complete.
SQL
select dump(name) from
Rick - I agree that it can't hurt. Looking at another database can even give
you a fresh perspective on Oracle. Some assignments involve converting an
application from MySQL to Oracle. The critical question in my mind is
whether you see yourself as more of a development DBA or a production DBA? I
Title: Message
Hermant and Chitale,
DB_FILE_MULTIBLOCK_READ_COUNT=32
DB_CACHE_SIZE big integer 16777216
DB_BLOCK_BUFFERS = 0
Tablespace is LMT with a uniform size of 128 MB, DB not in archive mode
is for a DW system.
The
time for the first run and the re-run last the same.
To my
Robert,
I will make the assumption that you are on a newer version of Oracle.
If I remember correctly, a view does not use an index and will use a
full table scan. That could be the cause for the time difference.
I know that this doesn't answer your question but it might trigger
other thoughts
CREATE ROLE GUEST_USER;
SPOOL GIMME.SQL
SELECT 'GRANT INSERT ON '||TABLE_NAME||' TO GUEST_USER;' FROM USER_TABLES;
SPOOL OFF
@GIMME
GRANT GUEST_USER TO GUEST;
Thnaks for the response. I realised that immediately after I posted.
This is what Ive done
/*@D:\createinsert.sql
drop user Guest;
create user Guest identified by *
default tablespace tables
temporary tablespace temp;
grant connect to Guest;
*/
set echo off
set feedback off
set pages 0
Hi DBAs,
Oracle 8.1.7 WinNT
I would like pros/cons on datafile sizes. It is better to have more of less
size or less with larger sizes and why?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Ron - I reread your question a little closer, and am still a little
confused.
Okay, you are doing both RMAN and cold backups? That is okay as long as you
don't shut down the database while RMAN is performing its backup. We have
been doing both for several months until we complete our RMAN
Bill
I don't think too many analytical studies have been done on multiple
buffer pools, but since I am extremely interested in this subject, I'll
provide my opinion, which is worth every bit you paid for it.
Just dividing the buffer pool into three pieces, in my opinion, would
degrade
Bob,
the best thing I can offer is the following:
set lines 150
set pages 2000
set trimspool on
select 'grant insert on ' || table_name || ' to Guest_Role;'
from user_tables
/
Create the role named in the script (or change the role name to the actual
Oracle username) and grant the role to the
Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered
select 'grant insert on '||table_name||' to guest;'
from user_tables
spool \tmp\grant_insert.sql
/
@\tmp\grant_insert.sql
there is no one shot command that I know of
--- Bob Metelsky [EMAIL PROTECTED] wrote:
Good Morning All
Im looking at trying to grant privilidges to a guest user (who
Ron
RMAN documentation uses the terms open and closed. RMAN can back up an
open database. RMAN can back up a closed database (not usual, except for a
non-archivelog database). You can shut the database down when RMAN is not
performing a backup. RMAN can even bring the database up or down. Just
Ron,
I'm not sure I understand your question. You are shutting down your database
for an OS level backup? The incremental backup you say is not working, is
this an RMAN incremental backup or an OS level backup?
As for the shutdown of Oracle, if RMAN is in the middle of a backup at that
time, the
Bill -
i certainly don't profess to be an Oracle PT expert, but i think you are on
a potentially fruitful path if there is a performance issue in need of a
solution. it can make sense to assign a large infrequently queried table
that has a history of flushing hot blocks to a separate cache.
My experience shows that a parallel degree of less than 4 is nearly always
slower than serial.
I would recommend tring parallel degree of 4.
-Original Message-
Sent: Wednesday, February 12, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
parallel with single cpu env?
Michael
Done that Dennis. The difference in the two is how the plan is being crafted
by the optimizer. Bottom line is that the excellent plan I'm getting from
the query by itself is not being replicated when it's moved into a view. It
appears that this is because the predicate is not being pushed into the
Here is some code, which creates synonyms and grants permissions:
REM This script create public synonyms for all Tables and Views owned by
SCHEMA_NAME
REM and grants privileges on those objects to 'other' users.
declare lSyn integer;
BEGIN
-- Get Table(View) name
FOR Objects IN
(SELECT
the ever popular answer it depends
how large are the tables you are storing in these datafiles? Is this a
data warehouse where you will be storing massive amounts of data? (1000
2GB datafiles to store one table's worth of data is somewhat obscene)
Is it a large database? Heavily used? OLTP?
Janet -
1. Piece of Cake. When you choose the Reverse Engineer tool, the 'Set
Options' window has an Options panel on the right-hand side. You should
see a 'Tables/Views owned by' choice. The default is 'All'. Change the
radio button to 'Owners (comma separated)' and type in the schema
If MySql continues as planned, I think Oracle will
find it a force to be reckoned with, much as MS
has discovered to be true about Linux.
Of course by that time, according to the latest IT
business intelligence as seen in Computer World,
most of our jobs will have been outsourced by then,
and
Ron,
While Vms *can* backup the open datafile, it is worthless when you need to
recover it. I know, I've been there. Worked on Open Vms for about 8 years,
including Oracle for 3 years. The file would need recovery immediately upon
an attempt to open it. And I would not bet my job that I could
Title: RE: View HELP Please!
I remember some parameter about Query re-writes... it may be only for Materialized Views... but could be the culprit here.
Also, do you have Oracle Label Security set on this table, or Fine-Grain Auditing?
-Original Message-
From: Freeman Robert - IL
Hello All,
We have Oracle 9.2.0.2.1 running on our server. When we run the following
command from Sql Plus, we get the end-of-file on communication channel.
This occurs consistently on all four of our 9.2.0.2.1 instances on this
server. It has also occured on a new installation of 9.2.0.2.1 on
Predicate - values in the where clause.
-Original Message-
To: '[EMAIL PROTECTED]'
Cc: Freeman Robert - IL
Sent: 2/12/2003 1:24 PM
Robert,
please excuse my ignorance, but what do you mean by predicate?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Ron - Yes they can back it up and recover it from their perspective. You've
brightened my day. Let us know if you want some more explanations to discuss
this with them again. ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you expect to gain?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, February 12, 2003
Ron -
the text below is from the fine VMS manual. I suspect your SAs are
referring to the backup/ignore=interlock command. I certainly would not
rely on it as part of my Oracle Disaster Recovery plan. The cold backup
decision sounds to me like a wise one.
BACKUP
Invokes the Backup
Freeman Robert - IL wrote:
Ron, man, you got me on the version thing. I yell at people who don't say
what version they are on, and here I am forgetting to do the same. I'm on
9iR2.
You are correct that the view would not use the index if I just did a select
* from it with no additional
Robert,
please excuse my ignorance, but what do you mean by predicate?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, February 12, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Done that Dennis. The difference in the two is how the plan is
H. It seems that I don't get replies to a lot of my posts. Do I ask
the hard questions or just stupid ones? On sencond thought, don't answer
that... ;)
In any case, in reinventing the wheel, I decided to just create a function
that uses a REF CURSOR to generically concat the column for me:
The explain plans indicate that the predicate is being filtered out after
the view itself executes. I don't see how a no_merge hint would help, since
I'm not getting view merging anyway.
Thanks!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 10:04 AM
Rick - Here is the way I see it:
Larger file sizes
- Fewer files to manage.
- May exceed O.S. limits (be careful on WinNT)
Smaller file sizes
- More flexible, can just back up or move a single file.
- Fewer tables per file, may be easier on tablespace recovery.
Dennis Williams
DBA,
Robert,
Have you considered the current values of _complex_view_merging,
_push_join_predicate, _push_join_union_view. Some of them may be obsolete in
9iR2, but there are some published and recommended setting for these for
specific Apps 11i environments. You could also look at/play with the value
I'd tell them, great, then lets test it.
Trust no one.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 10:23 AM
Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has
Robert,
have you tried recoding the view with the hint in the view text? Or am
I misunderstanding your original post which looks like you've put the
hints on the select count(*) statement?
Rachel
--- Freeman Robert - IL [EMAIL PROTECTED] wrote:
Done that Dennis. The difference in the two is
All...
One more submission to see if there are any takers, then I'll stop
nagging and keep looking...
I'm running Oracle 8.1.6 on Solaris 8.
Will someone please help me understand the Textkey parameter in
the ctx_doc.themes function? I am receiving a DRG-10826 error on:
exec
Rick,
The answer is (YES, 42, IT DEPENTS). Not ot be smart but there in NO
correct answer. The answer depents on may factors.
1. If the table is large, Why have it in may little extents. That could
hurt performance if the data becomes chained.
2. If the table is small, why have it in a large
There are 2 or 3 parameters, but none help.
Nope, no FGAC...
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 12:59 PM
I remember some parameter about Query re-writes... it may be only for
Materialized Views... but could be the culprit here.
Also, do
Ron,
Back when we had Oracle on VMS (Oracle 7.1 - pre RMAN), we used this backup command
for each datafile:
backup/log/ignore=(interlock,nobackup)/new
This will backup open files. But if your tablespace isn't in hot backup mode, it
doesn't help you for database recovery. You might get
Ron - Thought of a simple way to explain the situation to your VMS
administrators. I've simplified a few things, but it should suffice. If I've
missed anything critical, someone will correct me ;-)
Each Oracle datafile has a transaction number recorded. The Oracle
control file has a transaction
Title: RE: database file sizesmore of smaller size or less of larger size?
How about consistent file sizes? For raw the VLDB whitepaper recommends something like 128MB, 1GB, and 8GB but isn't it also a good practice for cooked? It depends...
-Original Message-
From: Rachel
Robert,
Is the view part of an application that you can make use of an
OUTLINE? I think that is the proper terminology. Then you could force
the desired optimization.
Ron
[EMAIL PROTECTED] 02/12/03 01:39PM
Done that Dennis. The difference in the two is how the plan is being
crafted
by the
Tom - Human grammar terms adapted to computer syntax :-)
http://www.student.math.uwaterloo.ca/~cs448/db2_doc/html/db2s0/frame3.htm#ch
2pred
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February 12, 2003 1:24 PM
To: Multiple
Hi Rachel,
I've actually tried it both ways, with no joy. best luck I've had so far is
turning max_purm's to about 100 which makes it run in about 2 minutes.
Still to slow though.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 1:54 PM
Robert,
have
Better utilization of the CPU. While one process is I/O-ing (or waiting on
an I/O) the other process can use the CPU.
Various tests I have performed on various unixes (unicies?) have shown the
parallelism usually scales to between 3 6 times the number of CPUs before
performance degrades.
Quite
Ron, the analogy I always use is who has to recover the database when it crashes?
When they say, well, YOU, then I say Fine. We are going to back it up the way I see
fit. End of story. Have fun testing~!!
Good Luck.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259
I think I fixed the problem... within my view, there was actually
aggrigation of the predicate going on. I'm thinking that this is why Oracle
could not push the predicate into the view. Once I removed the aggregation
(I moved it to a higher level view) it worked great.
Thanks to everyone for your
Hi Robert,
Can you suggest a good RMAN book to start out. We're
also in the process of looking at RMAN to replace
in-house scripts.
TIA
Tom P.
--- Robert Freeman [EMAIL PROTECTED] wrote:
We converted from SQLBacktrack to RMAN. RMAN is a
very robust product, and
offers more features that
I tried setting the NLS_DATE_FORMAT at the command line to try
and get some decent date formats. Worked fine from both linux and
Win2k.
Jared
Kurth, Michael J. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/11/2003 05:58 AM
Please respond to ORACLE-L
To: Multiple
Tom
Just in case Robert is too modest, I'll suggest the best:
Oracle9i RMAN Backup and Recovery
by Robert Freeman and Matthew Hart
The best, the most extensive. Covers the most popular MMLs.
There are only 2 others that I am aware of:
Oracle RMAN Pocket Reference
by Darl Kuhn Scott Schulze
All...
slapping hand to forehead STUPID, STUPID, STUPID!!!
Will someone please help me understand the Textkey parameter in the
ctx_doc.themes function? I am receiving a DRG-10826 error on:
I withdraw my question -- I was looking at it MANY layers too deeply,
and absolutely overlooked the
DBA's
Check the article's comment on Oracle trying to ban Teradata from IOUG
Teradata Steals Oracle's Data Mart Users ...
Teradata pushes consolidation and woos away Oracle customers. But
Oracle strikes back. Sort of. Will bean counters surf the Web with
Excel? Will Steve Ballmer and Larry
Nice to know Jared, I'll add that to the Oracle9i RMAN Errata and give you
credit! Thanks!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 3:39 PM
I tried setting the NLS_DATE_FORMAT at the command line to try
and get some decent date formats. Worked
Title: RE: Teradata baned from IOUG???
Guys,
With everything going on - should I take up a second career?
-Original Message-
From: James Howerton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 4:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Teradata baned
Hi,
I am doing some recovery testing and am testing the corruption of the rbs
datafile. However, I am running into some problems.
What I've done so far:
1) Shutdown db
2) Copied the backup datafile to proper location
3) Commented the rollback_segments parameter in the init.ora
4) startup
I can't imagine why they would want to replace Oracle with Teradata.
It's expensive. It runs only on NCR or Windoze.
The architecture is nothing special.
I imagine the PHB's had their fingers in those moves.
Been there, got the T-shirt, now it's a dust rag.
Jared
James Howerton [EMAIL
Title: RE: Teradata baned from IOUG???
should I take up a second career?
You're
only on your first career?Isn't DBA usually a second or third career at
the least? Environments change and the ability to
adapt/learn is an evolutionary survival factor.
Yours
truly,
Old
Dog learning new
Robert,
Why not run a trace on both the view and standalone SQL,
and share the results?
At least the explain plans.
Jared
Freeman Robert - IL [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/12/2003 07:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list
1 - 100 of 122 matches
Mail list logo