 | | | Oracle List | | I 'm trying to get an XML result set from an Oracle 9i server using ANT 's
SQL task with the Oracle JDBC Thin Driver. I can successfully connect to
the database and issue standard SQL through the ANT With 10g worry nomore
Just find out this feature today...
Hey Everyone
I 've been given a rather exciting project on which to work. 20
Management wants to look at migrating one of our large in house
developed systems from PostgreSQL to Oracle. Does anyI am a first time poster to this list. I work as a PL/SQL developer for a
company called Quinstreet in Foster City. We can see the Oracle buildings to
the south from our 8th floor balcony. I 've beHave you checked your environment to see if NLS_LANG is set?
On 6/15/05 John Dunn <jdunn@(protected) > wrote
>
> I have just migrated an application from test to prod. On the prod machine
> I
Hi Thomas
I think the column PTIME of USER$ data dictionary will tell you when the password got changed.
select name to_char(ptime 'dd-mon-yyyy ') from sys.user$
Please let me know the rExported dropped and imported a table. The next extent was NOT set to
the correct value. I found some notes on metalink stating that
next_extent is set to the size of the second extent. The noteDoes anyone on the list have experience positive or negative running M
anugistics on Oracle 9i RAC (Redhat Linux) 3F I haven 't been able to fi
nd any interesting white papers success/horror stI have just migrated an application from test to prod. On the prod machine I
get the following error from sqlldr
SQL*Loader-128 unable to begin a session ORA-12705 invalid or unknown
NLS pa
Hi all
Sun launched the Open Solaris project. They are opening the source code
of Solaris 10.
http //opensolaris.org
Yasin
Bu mesaj ve onunla iletilen tum ekler gonderildigi kisiFor windows you must manipulate with the registry
For unix re export the user profile will do
Sinardy
----- Original Message -----
From "Rabinowicz Barbara " <Barbara.Rabinowicz@(protected) >
> "...you generally do not want to transfer anything that you
> don 't have to. I prefer transporting just data
> and then rebuild indexes on the target. "
Really? How would you handle a realHi Onkar
I would like to refer you a link please check this link. Hope that will help you -)
http //www.psoug.org/reference/sys_context.html
Regards
Sunil Bhola
Onkar N Tiwary <onkhi all
I have one simple but interesting question
How to reset the modified date of an object in oracle database to its
original date irrespective of the date it has been modified?
--
TInteresting. Glad you found a solution.
On 6/14/05 Arvind Kumar <arvindk@(protected) > wrote
>
> Hi Jared
> to check the high water mark i created a new table without any rows and
> trieRanko
I used the second method extensively. We build the where clause
depending on input variables and then use "open cursor " and fetches to
get the data.
Take advantage of substitution vari > > Is there any security risk of giving "SELECT ANY DICTIONARY " to
> > the developer from the DBA perspective?
Can 't think of any in particular. Oracle passwords are encrypted and
everything elseHi Juan
Thanks for suggesting the same. Due to management decision
there wont be any upgrade. However i can change the session level
parameter for the particular program . I am thinking for d
As promised here 's my longer explanation of what is happening. Because
IOTs must maintain order there 's exactly one block that any given row can
reside in. Just as with B-tree indexes when a blocFYI - The demo_proc.mk is on the Companion CD 's.
LeRoy Kemnitz wrote
> I installed 10.1.0.4 in development but I am missing the demo_proc.mk
> file. Did they change it? Am I missing somethingI wonder if you know why this person needs what he/she asks for? And
of course you can and will use any undocumented means if you are in
need. For instance Oracle puts start up script/link in /etc/rcThe basics
RAC
+
DataGuard
*or*
RAC
+
Sync data copy with your storage hardware (if you have hardware that is
certified with oracle)
or
talk to Veritas they got the bestHi
I 've got an application query that is taking hours to run. After tracing and running tkprof I see the execution plan below. Yes it 's a monster of a query but Oracle seems to handle it pretThank you Lex.
Which means that the docs are now available on OTN!
Jared
On 7/7/05 Lex de Haan <lex.de.haan@(protected) > wrote
>
> Hi all
>
> I remember we had a recent email thre <div >Oracle does supports collecting stats on dict objects </div >
<div > </div >
<div >but in your case it looks like that you have some issues with
obj$ </div >
<div > </div >
<div >does you dbHi
Just got back from the travelling VMWare seminar. It was great.
In my opinion from what I saw at the seminar and reading the current
Oracle support position I expect Oracle to change and We are about to setup 10g database using RAC (two node instance) using ASM
as the shared disk just read a note stating that ASM can only be backed up
using RMAN. Is this true?
Peter Dixon
DatOn 6/14/05 Hemant K Chitale <hkchital@(protected) > wrote
>
>
> Even if you had created it with an .. AS SELECT * ... that would not
> automatically re-read the new column as the "local " deHi All
We recently implemented V.C.S. The only problem we had so far is with
the "CRONTAB ". Whenever the database(service group) fail-over to the
other server in cluster I will have to manuallyUnless of course you created them with manual refresh only
in the first place.
Jared
On 6/15/05 Sami Seerangan <dba.orcl@(protected) > wrote
>
> If you use refresh group you have to remove |
|
|
