Thanks - I am going to "play around" with this and see what happens. Since each job is linked to a target, the database jobs should may still work but I am...
Folks, We are on a Solaris Sparc system. It has Oracle 9i Enterprise Edition software already installed along with a database. I am trying to install Oracle...
Hello, I tried to use the DBMS_LOB and a procedure here attached. I have a DIRECTORY created and used the directory_name as the parameter, the file name, and...
Hello all, I am tasked with getting an Oracle 10g database up on RHEL 3.... I munged the install, and would like to uninstall the database software. When I...
Larry Blankenship
lblankenship@...
Apr 21, 2006 6:34 pm
859
Larry, Just delete the oracle home directory (and everything in it)... You can then start over... Unlike Windows, there are no registry entries to worry about...
Michael Glover
glovermj@...
Apr 21, 2006 8:01 pm
860
Larry, Don't forget to delete the inventory. Especially in your case, you want to make sure you start with a clean slate. You told the installer where to ...
Larry, You probably already did this but I forgot to mention shutting down all oracle programs and demons running before deleting the directory (that may be...
Michael Glover
glovermj@...
Apr 25, 2006 2:32 pm
862
I've never done this with the DBMS_LOB package, but there are several ways to do this. In fact, I'm in the middle of writing an ODTUG presentation on the...
My experience has been that for this to work, the physical directory (p_Directory) must be on the database server. You must copy these files to the db server...
Worthington, Richard
worthinr@...
Apr 25, 2006 2:34 pm
864
Why would a query of all_constraints cause 7 million consistent gets and take nearly two minutes ? On a similarly configured instance it only takes about 700...
Sjmnetx, Hi. Hmm, well the knee jerk reactions are 1) No index to help 2) The data in ordered differently between the two tables causing more page fetches. ...
Allen Shepard
ashepard@...
May 1, 2006 1:47 pm
866
I had no chance to review the trace yet today. However, I checked dba_indexes and dba_ind_columns for the tables that comprise all_constraints view; Namely,...
-- Interjection by listserv moderator: -- Please email Victoria directly at nichollsvi@... -- if you interested in responding to this post (don't -- reply...
Sjmnetx, Hi. Ok, when you get a chance to add the line " set arraysize 1000 ' and re- run the query let us know. Have you analyzed the table? I would think...
Allen Shepard
ashepard@...
May 8, 2006 1:52 pm
869
Hiya All, I posted a note on VOUG a couple of weeks ago asking for help cleaning up a linux box after an failed install, so that I could try to re-install...
Larry Blankenship
lblankenship@...
May 8, 2006 1:52 pm
870
+ Interjection by listserv moderator: + Alrighty folks, I think this is what we've all + been looking for ;) Hi all, Feel free to revert all the quires about...
Hello from a newbie, I've installed 10g DB on one server running Suse Enterptise and now I'm attempting to install the Companion CD on another server. This ...
Folks, We are running Oracle Enterprise Edition 64 bit on Solaris Servers. We have a 220Mg xml file that needs to be parsed and then loaded into Oracle tables....
If you are using Oracle Java libraries to parse the file then check the value for init parameter JAVA_POOL_SIZE. Probably this value needs be set higher....
Ihtesham Uddin
ihtesham_u@...
Jun 13, 2006 4:15 pm
874
There are two models for parsing XML, Document Object Model (DOM) and Simple API for XML (SAX). DOM parsers have the advantage of letting you see your XML...
Hi Everybody, It is interesting. Oracle adopted Document Object Model (DOM) (worked with CLOB data type) for XML in Pre 9I version. It introduced XML DB ,...
If you've worked with prior versions of Oracle, at least back to 7.3, you're probably used to the output from a SELECT with a GROUP BY or from a SELECT...
This was a side-effect of the fact that Oracle was doing a GROUP BY or DISTINCT by sorting the data. Oracle would have told you even back then that they don't...
I just wanted to seek your opinion on a design issue that we're trying to resolve. Basically, users want two tables A and B. Both will be about a terabyte in...
Nana Bonsu
nmbonsu@...
Aug 5, 2006 2:38 am
880
Please verify whether the two tables contain the same data (same column structure, same rows) or if there are any differences between the two tables. Please...
Mark C. Stock
mcstock@...
Aug 7, 2006 5:58 am
881
Has anyone been using Oracle Discoverer? A group that I work with is changing from Oracle Browser to Oracle Discover (with our upgradeto Oracle 10g) and are...
Laureen L Branting
laureen.l.branting@...
Aug 8, 2006 1:58 pm
882
Hi Everyone, The HROUG & GROUG user groups are very excited to announce that registration for OCOJ - the Oracle Conference On The James - is now open. The...
Hi, I am working on configuring Oracle Portal for Discoverer reports. We have a J2EE application that also has reports in Discoverer. We are working on ...
Hiya All, I am testing/learning how to make java and oracle work together. My test system consists of a windows XP based pc that has oracle 10g XE and java sdk...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
