 | | | Oracle List | | Does anyone *design* databases these days aren 't they just patterns and models and objects or generated on the fly by application code?
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 Hi!
When you upgrade you should check from Metalink whether there are any
interoperability patches you require to install for 9.2.0.4.
Otherwise there should be no major problem.
Tanel.
what is the difference between a child cursor and a parent cursor?
>
> From Riyaj Shamsudeen <rshamsud@(protected) >
> Date 2004/03/31 Wed PM 12 15 42 EST
> To oracle-l@(protected)
> Subje
I have requirements like total sales by areas or total sales by
customer categories ... these structures
areas categories.... are of recurrsive nature Ie.i have to show for
Note in-line
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-operative Oracle Users ' FAQ
http //www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http //www.indexI 'm looking for people who use the HTML capabilities of
SQL*Plus. If you 're one of those people and wouldn 't mind
talking to me about how and why you use those HTML features
please shoot me an em
There is a potential problem with foreign keys.
You need indexes to support foreign keys if
a1) you plan to update or delete the corresponding
parent key values and
a2) you wanTry delsrv.exe
http //www.microsoft.com/windows2000/techinfo/reskit/tools/existing/delsrv-o.asp
Jared
Jonathan Gennick <jonathan@(protected) >
Sent by oracle-l-bounce@(protected)
Go to Cary 's web site http //www.hotsos.com <http //www.hotsos.com > . There
is a tool available that lets you upload a trace file and have it analyzed.
You may be allowed a free trial.
DennisDear All
We are upgrading from 8i to 9i. It would be really great if someone have 9i upgrade checklist and willing to share.
Thanks in advance
Jay
> I have about 12 databases installed on the Oracle8i oracle home. One of the database takes more than 30 seconds to disconnect from SQL*Plus
> when connected using SQL*Net. Connections using ORACLE > then at a minimum Oracle MUST FTS the driving table. That 's because
there are no filter predicates. If the statement looked something like
Just a small out-of-context comment CBO can decid
anyone know anyone who has taken the 9iAS OCA exam?
Are there any good books out on the subject (iAS administration) available
anywhere real soon? I found that it is a performance objective of Barnes & Noble charges $27 and I got free shipping. Robert
why would you buy your own book?
On 03/30/2004 11 50 31 AM Freeman Robert - IL wrote
> In fact the discount you get on Amazon orAny help would be appreciated.
Oracle 8.1.7 on Windows 2000 Server.
We have a complex process here written in VB. It takes about 4 hours to run. Last week it crashed with ORA-03113 showing on thePaulsa
The source of the Oracle CDROMs is ORAKNOWLEDGE. I fell for the same
option when the 9i upgrade info was "free ". I never received the
material requested and after many emails to the supporJuan there are many poverty stricken people in the world but I
don 't think that Bill Gates and Larry Ellison are among them. It is
about what you need to do not about marketing materials. If you IIRC you can 't do that.
Consider the preparatory steps in using DBMS_SQL.
parse a cursor define and\/or bind the columns and execute.
An unkown number of parameters kind of precludes the uHi gurus
Is it possible that a
"...trigger before Insert on test for each row "
trigger throws away that Insert without raising any application error ?
Conditions
-It is not alHas anyone used the practice of placing a controlfile
(in this case 4 of them) so that if either an online
redo log group member 's partition is offlined or an
archived redo log destination 's partTrying to research an Oracle Alert for HP/UX
http //metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id NOT&p_id 241160.1
(pasting required for long link above)
We 'Thanks Rich that 's a very useful search.
Hey all
Back in '02 I had a Hint-O-The-Day to search for Metalink "library index "
pages. These are the pages that are jumping points to get you
On 03/29/2004 03 42 37 PM Paula_Stankus@(protected) wrote
> Guys
>
> When I first setup rman on a centralized remote server I had to ensure that I had a copy of the init file for the targ
On 03/29/2004 02 58 30 PM mkline1@(protected) wrote
>
> Even so does that eliminate the problem?
>
No. For tables that big and such extreme requirements I 'd recommend massively
paralI second that. Jared does a great job despite the fact that "Mladen " would
be much prettier name for a mailing list then "oracle-l ".
On 03/29/2004 02 47 26 PM DENNIS WILLIAMS wrote
> What RuthHi
After reading a lot from
OPTIMIZER_INDEX_COST_ADJ and
OPTIMIZER_INDEX_CACHING
The conclusion seems to be.
Even when the default values are horrible
1)you can work with the default 11i Forms Compilation on aixYou have to use the application oracle_home for adadmin. You have to source the APPSORA.env file that should set the TWO_TASK parameter in your shell (or LOCAL parameter iPhilip
I think I found what you are referring to. Take a look at the following.
I didn 't want to post material from asktom but I could only find this
posting in Google 's cache section.
+++++Hi thanks to all suggestions I did my best to fixe the paper based on your
commentaries about cost adj it tookme some time to investigate to have a
more serious and global opinion.
The only iAll
I am attempting to perform Rman disk backups on a data warehouse. While the
disk backup runs fine the size of the output files are of course huge.
What I would like to do is to pipe the |
|
|
