Hi
Can some one suggest whats wrong in this query?The same query run fine on
development db but not running on production?
select count(a.xxx_id)
from gorp_cats_stats_view a ,
static_pages b
where b.xxx_id = a.xxx_id
andb.words like '%test%'
anda.main not like '%test%'
and
Large Software Company in Atlanta, Georgia needs an Oracle DBA /Developer with
solid 9i experience to join its' IT staff.
This is an excellent company that will pay relocation expenses.
PLEASE Do Not send your resume for this position UNLESS you have the skills
outlined
below for this
WOW! I just got this one!! SLOW today...
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you.
Hey Gang...
If you have a SAP instance, what is your listener port?
Our SAP systems listen on 1527. All six of them. Yesterday, one
of the SAP/R3 admins asked us why we use 1527 instead of 1521. I
told her I thought it was a SAP requirement because it pre-dates
my working here. None of the
Rachel Carmichael wrote:
Dennis,
That's a good thought, and it works if you don't have grants,
constraints or dependencies on the original table.
If you drop table1, you lose them all
Rachel
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Deepak, If there are many columns on these
Title: Message
Well,
it's kinda like saying your backups will never fail. The backup script
works now, and it has for many months, so I should never worry.
Right?
Well
I'm paranoid, and Andy Groove is my god. So I have to put in place some
checks to make sure the data is ok, before I load
Yeah, well the developers are always pi$$ed about something anyway. ;-)
Seriously, good point, I've been spoiled, because most of my applications
have kept the RI in the application as was being discussed earlier. Now they
are switching to Java and in future projects will be implementing RI in
Stephane - You asked:
But why the second CTAS ? What about RENAME ? Seems faster to me ...
Well, it depends on whether you are okay with changing locations of the
table. Personally, I'm with you, just accomplish everything with one move of
the data. But I figured someone would object,
Title: RE: Flat file generation integrity ideas...
DBMS_OBFUSCATION_TOOLKIT has an (undocumented)
function called MD5 which uses that protocol (MD5) to calculate checksums.
Look at $OH/rdbms/admin/dbmsobtk.sql...
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple
Chris - Your comment about the other systems maybe sending you the wrong
file sparked an idea. XML! Yeah, it has been overhyped, but the basic idea
is that the file specifies the format. So you could get a file and ensure
the content conforms to your expectation. I am an XML novice, but I believe
David - I recently discussed this with an industry expert. Here is my note
from that conversation:
Look at Oracle Streams, which uses Oracle's Advanced Queuing facility.
This may be available in Standard Edition. The architecture is log-based,
similar to Quest Shareplex. This means that it has
Nice website, but the basic flaw with such formulas
is what to input into the field marked "average row size"...
If you know the "average row size", then you must
already have a sample of data present in a table somewhere. After all,
without actual data already in an Oracle table, you could
Joan Hsieh wrote:
Hi Listers,
I am trying to find a way to know the schema name. Say, if I logged in
as jjin01@ngd. When I run a program, how can I get the schema name
which should be ngd? If I logged in as bkrasnof@pr, in this case, the
schema name will be pr.
Thanks in advance,
The statement about no performance impact on the database being replicated
from may not be entirely accurate. In order to work, Oracle Streams (which
uses Log Miner) needs supplemental redo data to be generated by the
originating system, resulting from the ALTER DATABASE ADD SUPPLEMENTAL LOG
DATA
Test first
We discovered a bug on Tru64 that prevented this from working correctly
in at least a couple versions of Oracle. 8.1.7 was suppossed to fix
this, but it didn't. 8.1.7.3 did *I think*.
[EMAIL PROTECTED] 10/16/02 11:39AM
You can use the 'higher' version of the listener for all
Title: RE: Streams
The supplemental logging information adds quite a bit of into to each record.
1) it writes the actual column offset, rather than the logical offset (which it needs to query to find)
2) it writes the original head rowid for the row in addition/or instead of the rowid for
Unfortunately it is a trust issue...
Trust me when I say a file can get scrambled. I have seen it happen. In
our wierdest scenario two received files appeared to be merged into a
single file - on the source system they had two intact files, on our system
1.5 files merged into a single file and
Chris,
Our favourite footer (at a previous project) was:
#EOF#count_of_detail_recordssum_of_numerical_column1sum_of_numerical_column2...
Sometimes there were no numerical columns, sometimes 1 and sometimes 12 or
more. In most cases we were the recipients of the files, so we wrote a
utility
Stephane,
Well spoken- my bad. Our developer threw me this question when I was just
leaving from work. ( I copied from her email) Now I am at home to look it over.
I am not clear what she asked for. I think she wants to pass a variable based
on the @xxx to access this schema. I will make it
Stephane,
Well spoken- my bad. Our developer threw me this question when I was
just leaving from work. (I copied her email to the list) Now I am at
home and taking a chance to look it over again. I am not sure what she
asked for. My guess is she wants to pass a variable based on @xxx to
access
Stephane,
It's easy if there is only one level of dependency... but what if (as
they did in one of my systems) there are levels of dependency? It's
sort of like trying to write (or rewrite) the ideptree view. Only you
have to save off the scripts, in the proper order. Oh yes, don't forget
views
9i -- dbms_redefinition
should do it for you :)
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Yeah, well the developers are always pi$$ed about something anyway.
;-)
Seriously, good point, I've been spoiled, because most of my
applications
have kept the RI in the application as was being
I know this novice question for dba's but just wanted to refresh this ,
what is difference between SID and DATABASE_NAME , why init.ora file shouldhave database name same as SID and in what circumstances SID and DB_NAME can be different .
TIA
oramagic Do you Yahoo!?
Y! Web Hosting - Let the expert
Steve, You can create a RAC environment on SUN if you
get can get the necessary software. The hardware for
SUN is easy to get if you purchase it for eBay but the
clustering software is whole other story.
You need Sun Cluster 3.0 and and a LVM for the disks.
Getting SC3.0 may be easy but the LVM
At 06:08 AM 10/24/2002, MURAT BALKAS wrote:
Hi,
how can I be sure that the connection between our web server and
Oracle Server to be secure. What's the best method to accomplish this?
Any good links for Oracle Nwtwork Security.
I'd start with the Oracle Advanced Security
Dear All,
I wonder how long the life time of data in v$sqlarea. Is it a cumulative data
collecting in v$sqlarea since last database startup?or do the data in v$sqlarea only
reflect some recently data in Least Recetly List?
Why do I ask this is after I used alter system flush shared_pool, I
It will show you the SQL atatements that are residing in the shared pool.
Once you flush shared pool all the statements cached there gets flushed, and
so V$SQLAREA will only show information about the queries which are currently
held by open cursors and are not flushed.
Regards
Naveen
101 - 127 of 127 matches
Mail list logo