Title: Oracle Discoverer Report Query
Hi All,
I need to create a report in Oracle Discoverer. I would like to know if it is possible to create a report with the following logic. If yes, then how do I go about creating a report.
I have a table TBLREPORT with the following structure from
I would have been tempted to get a catheta fitted.
http://www.stadiumpal.com/
It will change your life forever gentlemen !!!
Lee
-Original Message-
Sent: 06 September 2001 19:27
To: Multiple recipients of list ORACLE-L
Harrisburg,
Don't remember the name of the place, but I think
Try the /*+ APPEND*/ hint
--- Gene Gurevich [EMAIL PROTECTED] wrote:
Hi,
I'm running the following command:
insert into owner1.table1 nologging (select * from
owner2.table2);
There is no indices or constraints on table
owner1.table1, yet oracle is generating redo logs
for
this
Title:
set oracle-l nodigest
Hi Cherie,
I think you can't turn this feature off at the instance level as it became
internal
for 8i.
But if you did it you would loose an excellent path for some queries with
'cover
indexes'. Certainly, you can use hints for that. In generall I don't like
using hints
I prefer to rely on CBO's
Hi, Jared,
I ran your scripts and indeed strange behaviour.
First of all I now tested my earlier statement (never had to work much with
jobs before) and it appears to be incorrect. Interval is evaluated before
the job starts and not after completion (As it says in the manual, that I
have now
Title: Hardware requirements when migration oracle from NT to Linux
Hi list,
I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need for the linux machine to hit the same performance than on NT
This is toppa!
DreamWorks announced today they plan to make a film of the momentous
football match that took place on Saturday 2nd September 2001. Five-One
is the tentative title of what could be next year's big summer hit,
depicting the American national soccer team's stunning victory over
There is an administrator account, but individual users can configure
access control lists on their files (right-click, properties, security)
that would prevent the administrator from reading them. The only way
that an administrator could then read them would be to take ownership
first. Unlike
Not like that...
-Original Message-
Levin
Sent: Thursday, September 06, 2001 21:59
To: Multiple recipients of list ORACLE-L
How about 8.1.7 ? Any chance I could trace index usage?
Saludos,
Veronica Levin Enriquez
Administrador AIX
Compañía Cervecera de Nicaragua
-Mensaje
Eric:
While I can appreciate that your opinion of the Compaq Services division
might be less than positive, would you please, for the sake of those who
actually work for these companies, be a little less dramatic in your
expression of that opinion.
Jon Walthour
Oracle Database Administrator
I wanted to turn it off in testing so I could try some other indexes as an
alternative. I'm not sure that I trust it to make a good decision.
Even with an alternative index hint, it's not using the index I'm trying to
get it to use, but rather the fast full index scan. I can't see any typo
Isn't that a little unfair? It hardly seems possible
that an entire organization could be full of induhviduals.
More likely, some bad experiences have colored
your judgment.
Please bear in mind that there are several Compaq
employees on this list as well.
Jared
On Thursday 06 September
Hi
Part 2:
you have to run the script utlexcpt.sql to create the exception table and
then issue
alter table table enable primary key exceptions into exceptions;
This will give you the rowids for the violating rows.
Jack
Rusnak, George A. [EMAIL PROTECTED]@fatcity.com on 07-09-2001
We use rman for all production database backups (except backing up the
database which hold the recovery catalog). We do a leve 0 every morning
before users get on and a level 1 incremental each evening before batch
processing. These are online backups. We do a backup of our archivelogs
each
Ian,
The last one I looked at it was cached, I guess. I could purposely cache
the
table (and index) if it was small, though.
I'm confused though. Isn't the whole benefit of the fast, full index scan
that you
don't have to go against the table, thereby avoiding those physical reads?
Or, in
It's good to be the king :)
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Alter tablespace add datafile
Date: Thu, 06 Sep 2001 19:50:51 -0800
It was still happenind today, so I unsubscribed him
Jared
Yeah, it's in ORACLE_HOME/rdbmsversion. It's a plain text file with lots of
comments, some of which look very interesting. Oh, this could be real fun!!
Dick Goulet
Reply Separator
Author: Scott Shafer [EMAIL PROTECTED]
Date: 9/6/2001 3:35 PM
Kim,
We're using OmniBack from HP. Very easy integration with RMAN, just re-link
Oracle.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 9/6/2001 1:18 PM
Just wondering what product(s) organizations are using for enterprise
The point is, you only need one, single trusted person to hold the
administrator account (someone from your audit firm, for example) and
almost everything can be done by sub-administrators who only have the
precise permissions they need and no more. In theory, anyway :0)
There's that single
Oracle's got the list of presenters and presentations up on the site
of 287 presentations, 85 are by non-Oracle employees.
Of the 202 presentations by Oracle, I wonder how many are just marketing
hype?
Ya know, if the company wasn't paying, and if one of my dearest friends
didn't live in
you can find the duplicate records which vilate primary key with this sql
select count(*) from table name
group by
DODAAC,
NSN,
CONTRACT
having
count(*)1
Shahid Malik.
-Original Message-
Sent: Friday, September 07, 2001 5:41 PM
To: Multiple recipients of list ORACLE-L
Good
I have not done it but you should be able to capture records into an
exception table.
1. Create exception table
create table exceptions(row_id rowid,
owner varchar2(30),
table_name varchar2(30),
constraint
Hi all,
I have to buy new db server.
I'm using Oracle on *nix with cca 10GB db for 3-tier architecture software.
The IS will have about 300-500 users (parallel cca 200) and the operations
are mostly transactional.
My question is about HW.
Have I use Intel or Sparc?
What do you recommend
This combined with a DBMS_STAT job for stale is a great option for handling
statistics.
And you can write your own header to use it for indexing like Ethan
mentioned.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have
can be done by changing the contents of the files under
'$ORACLE_HOME/sqlplus/mesg',
BUT not recommended.
Don't know exactly as never tried.
Suren
-Original Message-
Sent: Thursday, September 06, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L
Does anyone know how to change
He has the technology to make things better
a rough quote from the 6 million dollar man show.
It's good to be the king :)
From: Jared Still [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Alter tablespace add datafile
George,
Here is one way:
select distinct a.DODAAC,b.NSN,c.CONTRACT count(*)
from tablea a, tableb b, tablec c
where (whatever your where clause is)
group by a.DODAAC,b.NSN,c.CONTRACT
having count(*) 1
This will give you the PK values of those records from your select where you
are producing
Take what you have, strip out one processor since I don't think Red Hat can use
more than one processor, and have fun. BTW: Your duhvelepors will probably see
a 100% performance boost since Linux has a lot less overhead than NT.
Dick Goulet
Reply
a simple 486/60 with 4 meg ram.
Only joking but I loaded redhat linux 7.0 Oracle 8.1.7 on a Dell Gx200 with Intel 850
mz cpu,
128 Meg ram, and 3 drives 1-10GIG, and 2 -40GIG. The data on the linux is the same
data as on the production Dell 6300 server with a 450 mz cpu, 1 GIG ram and 2 -10GIG
Ussually the leaf blocks will cause physical reads, but generally the root
and branch blocks stay in the cache. But it is very possibly for them all
to be in the cache and it is also just as possible for none of them to be in
the cache.
Oracle favor's caching index blocks, but doesn't mean
Now that I have your attention:
here's the scenario:
3rd party vendor app (I'm beginning to REALLY hate that phrase and company)
database running on 8.0.5.0
registration database (home-grown) running on 8.1.6.0
database link from the 8.1.6 db to the 8.0.5 db
programmer changing a report,
The real key here is to put some of the pain of their sloppy work back on their
backs. I've had this problem before as well with our CIM (Computer Integrated
Manufacturing) group. The solution was simply to shrink the shared pool size by
50%. Yeah this sure put one heck of a strain on the db
Ruth,
Is RMAN a purchased option? Does it come with the OEM management packs? I
thought it did but have installed those and don't see RMAN.
Thanks,
Shirley
Systems Admin Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch
Rachel Carmichael wrote:
Oracle's got the list of presenters and presentations up on the site
of 287 presentations, 85 are by non-Oracle employees.
Of the 202 presentations by Oracle, I wonder how many are just
marketing hype?
201.
bill [who's too damn cynical ALL the time.]
--
Hi
One way would be to do
select dodaac, msn, contract, count(*)
from table
group by dodaac, msn,contract
having count(*) 1
There is also a feature in Oracle that will send all the bad records to an
exception table if it violates a constraint but you'll have to read the
fine manual to find
Have you modified your two index_caching init parameters? If not, this can
prove to make some really weird things happen. Also consider first rows to
favor index use.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and
Rachel,
Feelings of cynicism with regards to anything Oracle are usually accurate.
;-)
I presented at OOW '98 and found the same situation. The Oracle
presentations I got into were pretty much marketing. The non-Oracle
presentations were usually (not always) in the smallest rooms and were
Don Granaman wrote:
I distinctly remember at least two. Pardon me for butchering them...
One was the overpromoted database guru whose head exploded when exposed to
actual code after he said something like You would be fools to ignore the
anti-binary least squares approach! - evidently
Sure you can, but its kinda tricky... There are .msb files in ORACLE_HOME
for different Oracle utilities. I guess oraus.msb is one for ORA msgs. I had
changed it such that the number of characters in the message remained
same... It worked :)
Shailesh
-Original Message-
Sent: Thursday,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Silvina Botindari
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Jan,
I'm not totally sure on all of what your asking, but that's OK, my
recommendation would be:
HP-9000 L2000 2 way
Support is great, especially if you buy into Predictive Support but that can get
costly depending on your needs. Upgrades are available and are easy. These
machines
I noticed the same thing. let's hope that the presentations are not all
hype, and top-rate...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 07, 2001 10:07 AM
To: Multiple recipients of list ORACLE-L
Oracle's got the list of presenters and
Scott,
I believe Oracle uses the binary version of the message file (*.msb) so
changing the text file won't be of any use. but then again I might be wrong.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
Cherie
You could turn it off using _fast_full_scan_enabled=false at the instance level. fast_full_scan_enabled is simply an underscore parameter in 8.1.7. But, I would turn on the event 10053 and run the statement to find why CBO is not using.. Could it be possible that this behaviour is
I went to replace my QC database from production yesterday (we do this about
once a month) and discovered that there wasn't enough room in one of the
filesystems to copy all the hot backup files. No problem I thought, I just
copied one of the larger files to a different filesystem, mounted the
I can't say anything either positive or negative about Compaq as I've had no
experience with their support organization. On the other hand I did watch DEC
support go from great to abysmal in just 5 years. HP on the other hand has been
the 'cats meow' for the last 10 years that I've had
I get the cache_blocks.sql from this site. While I was executing this
scripts I found a mistake.
select
e.owner||'.'||e.segment_name segment_name,
sum(cur) cur_buffers,
sum(cr) cr_buffers
from
( select
min(file#||'.'||dbablk) fb,
sum(decode(state, 1, 1, 0))
Light plane pilots know all about the H.E.R.E. (Human Element Range
Extender), for when your plane can fly longer than you can.
Robertson Lee
Schoen Volker wrote:
Hi list,
I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5)
to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do
I need for the linux machine to hit the same performance than on NT
machine.
Hardware NT machine:
2 * PIII 500
On a good day, I'm challenged to spell HTML so I need advice.
I have a strightforward SQL query that produces our internal
phone list. I'd like to make this data available on our Intranet.
What is the simplest way for me to webify this output?
This can really be a static webpage; rather than
Hi All,
THis message file is used only by OERR utility and kernel
has its own error messages built-ins.
SO the changes in the oraus.msg will not be actually
used by the kernel.
Best Regards,
K Gopalakrishnan
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, September 07, 2001 5:52
erm...
realised as I hit the button.
That was a harmless joke.. apologies if it offended anyone.
Lee
-Original Message-
Sent: 07 September 2001 16:10
To: '[EMAIL PROTECTED]'
How Long is a chinese man ?
-Original Message-
Sent: 07 September 2001 16:33
To: Multiple
Dang, and I know how to jitterbug :)
there are some presentations I want to be at... Steve Adams, Cary Milsap,
Craig Shallahamer, Gaja, Jeremiah... and others I can't remember.
but I look at it this way. 85 is a lot easier to find time to get to than
287 :)
From: Jack C. Applewhite [EMAIL
How Long is a chinese man ?
-Original Message-
Sent: 07 September 2001 16:33
To: Multiple recipients of list ORACLE-L
Who audits the auditor's auditor?
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have
RMAN is part of your oracle license, although you need to purchase the media
layer if you want to go to tape.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone:
Title: Full IMP hangs at the same spot
We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a
full exp/imp into a clone database. The imp hangs at the same location
every time, on a table that has only 2 rows in it, although the table does
have 2 VARCHAR2(2000) columns. We're unable
The file oraus.msg is in ORACLE_HOME/rdbms/mesg/
The message should be limited to a maximum of 76 characters.
That's all.
Happy typing. :-]
JP
Dne pá 7. zá?í 2001 15:17 jste napsal(a):
Sure you can, but its kinda tricky... There are .msb files in ORACLE_HOME
for different Oracle
That looks like Steve Adam's script, he is pretty busy now it seems.
I guess his is right, but I haven't looked at what your talking about to
closely.
I have one on my site that does something similar.
Do not criticize someone until you walked a mile in their shoes, that way
when you
Help! Can anyone throw any light on the following:
I run the following:
declare
cursor c1 is
select to_char(nvl(a.foo,0),'999')
from
(select '0' foo from dual) a;
begin
null;
end;
On Oracle 8.1.6 (Solaris and Linux platforms):
Statement Processed
On
I wouldn't use Intel Solaris.
But NT and Solaris are both good for this type of task.
Perhaps a E450, Blade 1000, Quad Xeon 700 would be what you are looking for.
All three should be able to support what you mentioned, depends on the size
of the transactions and such, but it seems like a
Who audits the auditor's auditor?
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North,
Thanks.
Now is it the first item on my list.
JP
Dne pá 7. zá?í 2001 15:21 jste napsal(a):
Jan,
I'm not totally sure on all of what your asking, but that's OK, my
recommendation would be:
HP-9000 L2000 2 way
Support is great, especially if you buy into Predictive Support but
Note the space between the . and the first letter of the synonym's name.
SQL drop synonym xlink. ps_sl_projectsu_vw;
Synonym dropped.
SQL c/. p/.p
1* drop synonym xlink.ps_sl_projectsu_vw
SQL /
drop synonym xlink.ps_sl_projectsu_vw
*
ERROR at line 1:
ORA-01434: private
The oerr script will use the oraus.msg file.
However, Oracle kernel will still use oraus.msb file that is a binay version
of the msg file.
Oracle does not give you any tool to convert your customized msg to msb.
But, that's where the fun begins ;) ( I have played with this thing in my
own
Jon, you need to get some thick skin. My company is destroyed quite often
in this list (although it has been a while).
-Original Message-
Sent: Friday, September 07, 2001 4:50 AM
To: Multiple recipients of list ORACLE-L
Eric:
While I can appreciate that your opinion of the Compaq
Linux (Redhat and others) can certainly use more than
one processor - the Linux kernel may need to be
recompiled, but I have a few machines with Oracle
setup on Redhat and SuSE that make great use
of multiple processors.
-Joe
- Original Message -
To: Multiple recipients of list ORACLE-L
quotes around the 0? maybe an artifact of implicit function overloading?
-Original Message-
Sent: Friday, September 07, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Help! Can anyone throw any light on the following:
I run the following:
declare
cursor c1 is
Errr...I beg to differ. I just tried it for fun this morning, and it
worked. I have 8.1.7 installed on my NT laptop.
-Original Message-
Sent: Friday, September 07, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
Hi All,
THis message file is used only by OERR utility and
correct.
years ago, when the Galaxy was young, somebody
posted a C util that allowed the ..er...safe
modification of oraus.msb. Is that person
still here? LISTening?
You wanna talk about *fun*...whoo-boy.
Ross Mohan
-Original Message-
Sent: Friday, September 07, 2001 9:36 AM
To:
Hi,
Can someone explain how the named-user licensing
works? Also, has concurrent usage licensing gone away?
We have a need for an additional database to use for
mapping/geo-coding purposes. The primary application
will periodically perform a query against this new
database to look up some
Title: Full IMP hangs at the same spot
truss,
strace whatever.
v$session_wait
the
usual
-Original Message-From: Thomas Jeff
[mailto:[EMAIL PROTECTED]]Sent: Friday, September 07, 2001 11:46
AMTo: Multiple recipients of list ORACLE-LSubject: Full
IMP hangs at the same
To produce a simple page, at the sqlplus prompt type set markup html on
then issue your query and spool it to a file.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Charlie
Mengler
Sent: Friday, September 07, 2001 10:56 AM
To: Multiple recipients
Hello,
Can anybody help me with a script or tool that will generate SQL to recreate
all tables and all indexes in a schema? I DO NOT want the script to
generate storage parameters.
If anybody has a script that does this, or can suggest a free tool, please
let me know. I need to recreate all
Thanks. I didn't have database access when I sent the original
message. Maybe if I can dig up a binary editor - this has too much fun
potential to leave alone...
--Scott
Jamadagni, Rajendra wrote:
Scott,
I believe Oracle uses the binary version of the message file (*.msb) so
changing
13 characters if you count the spaces, 14 with the question mark.
[EMAIL PROTECTED] 09/07/01 12:10PM
How Long is a chinese man ?
-Original Message-
Sent: 07 September 2001 16:33
To: Multiple recipients of list ORACLE-L
Who audits the auditor's auditor?
Do not criticize someone
I've written Perl scripts using DBI/DBD to create HTML pages. You would
then put the HTML file on your web server. If you have Perl on your web
server, you can alternatively, write the output as a Perl script with CGI
Perl module syntax. This is more compact and less cryptic but there is
Yeah, and try getting the auditor in at 3am, weekends, or over a three-day
holiday when you REALLY need root (that's Administrator for you Windoze
folks) privileges.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
I find it easier, takes less keystrokes, I am the world's worst typist, to SCHEDULE A
JOB TO RUN AT 9:45 pm and run every five minutes thereafter
exec dbms_job.submit(:jobno,'procedure;', trunc(sysdate) + 21.75/24,
'trunc(sysdate,''MI'') + 5/1440')
Also bear in mind the job_queue_interval
https://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1
and got
JSP Error:
Request URI:http://oraclestore.oracle.com:443/OA_HTML/ibeCCtpSctDspRte.jsp
Exception:
java.io.FileNotFoundException: /http:/oraclestore.oracle.com:443/OA_HTML/ not
contained in
Recreate the control file.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Miller, Jay
LOL! Kirti. I'm thinking of trying out a binary editor on a TEST COPY
of the oraus.msb file. It will at least be educational, whether
successful or not.
--Scott
Deshpande, Kirti wrote:
The oerr script will use the oraus.msg file.
However, Oracle kernel will still use oraus.msb file that
Did you run out of room in the target database?
Rutg
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 11:45 AM
We're running 8.1.7 on RS6000, AIX 4.3.3. We are trying to do a
full exp/imp into a clone database. The
Chris:
If you know some basic HTML, I would think the best way would be to send the
output of the query to a file via UTL_FILE, formatting it into HTML along
the way. I saw a Oracle sales geek do this once demonstrating how to use
DBMS_JOB and UTL_FILE to refresh static web pages on a website on
That is actually a published Bug Fix in 8.1.7 I don't have the bug #, but
its there.
-Original Message-
Sent: Friday, September 07, 2001 1:13 PM
To: Multiple recipients of list ORACLE-L
quotes around the 0? maybe an artifact of implicit function overloading?
-Original
I just tried the URL and it worked for me.
-Original Message-
Sent: Friday, September 07, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
https://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=1
and got
JSP Error:
Request
If you are using rman try doing a switch on the datafile which you moved.
If you need more info write me directly.
Ruth B. Gramolini
ORACLE DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L
Bill,
the problem is that your inline view is selecting '0' and returning a
string, while the nvl function is trying to convert this string a number.
the result is that you are attempting to perform a to_char function on a
char variable - doesn't work that way.
either remove the single quotes
You need to make a dynamic HTML page to query the table of phones.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:55 AM
On a good day, I'm challenged to spell HTML so I need advice.
I have a strightforward SQL
I want it, I need it, I gotta have it. Pleeeaase.
Henry
-Original Message-
Sent: Friday, September 07, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L
correct.
years ago, when the Galaxy was young, somebody
posted a C util that allowed the ..er...safe
modification of
Title: Message
Any
triggers?
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275
Fuelspot 73 Princeton Street North,
I don't have an NT database in front of me now, but I thought it didn't have
both the oraus.msg and oraus.msb files. Is that correct?
Henry
-Original Message-
Sent: Friday, September 07, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
No, I updated the file, started the
Hi All,
Is Anybody using Advanced Queues of oracle,If yes, can u share if's and
dont's of this product, Is it really worth to go into this product.
We are planning to implement this on the middleware level.
THANKS
_
Get your FREE
This Textiles Client in Greensboro, North Carolina needs an Oracle DBA
to join its' I.T. staff. This is a Jr/Mid level position.
* Candidates local to the Greensboro-Burlington area only will be considered.
This is a full time staff position so no sub-contractors or third parties
please.
Take a look at my site, www.vampired.net, you will find a script to do both,
it can be modified pretty easily to remove the storage clauses.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher
Hello all,
I would like to drop a particular index. Before I do, I'd like to check
to see if has been accessed recently (or at all). How can I check this?
Chris Rezek
Oracle DBA
Digital Music Network
http://www.dmn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
you are correct Henry. NT only has the binary files (.msb).
The error messages can be changed, but vary carefully. A friend here used a
Hex Editor to change the error messages.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 07, 2001 3:21 PM
Our Win2k 8.1.6 EE installation only has three *.msg files - one for DRG
(interMedia) and two for hs (heterogeneous services). The DRG message file
is truly ascii, but the hs *.msg files are really *.msb. All the RDBMS
message files are *.msb - not a single *.msg.
Jack
Oracle 8.1.7 on my NT laptop only has, what I believe to be the binary file,
oraus.msb. A quick search of the entire Oracle directory did not find
oraus.msg, tucked away in some other directory.
Chris
-Original Message-
Sent: Friday, September 07, 2001 3:21 PM
To: Multiple recipients
Hi Christopher, Silvina and list,
The 8.1 version of cached_blocks.sql script on the Ixora web site does not have the
incorrect +1, but it did once for a
period of a week or so. The 8.0 version had it until a few minutes ago. I got some
strange results once and concluded
incorrectly that the
1 - 100 of 129 matches
Mail list logo
