 | | | Oracle List | |
Tim
Nice testing - but here 's a thought to make you worry.
When you update a row in a table Oracle
records some information about the previous
version in an undo block.
When Oracle chan
But at least you can add an A4 sheet to the
stack without re-booting.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the Anything in the alert.log?
On 02/09/2004 09 20 16 AM "Duret Kathy " wrote
> The etc/system is set up exactly like my production box.
> I checked my $HOME $PATH $ORACLE_HOME etc look just likBut of course there is after all only one data model required
http //www.tdan.com/i005fe03.htm
Everything else is fluff.
Jared
On Sat 2004-02-07 at 20 16 TOMPKINS MARGARET wrote
> JI think I 'd get more out of turning into an Anjokolkologist. At least
I 'd learn stuff )
I knew I wasn 't going crazy. At least not in that direction.
--- Mogens_N?rgaard <mln@(protected) > To my knowledge PL/SQL can do "update ...where current of cursor ".
The problem arises when you commit. There is a very popular and
lovely error called "fetch accross commit ".
On 02/06/2004 10 36Did you do a full backup or a level 0? If you want to do incrementals you
first have to have a level 0 as a starting point. A full is not quite the
same. See the docs for the differences.
HTHThere 's no way to tell which roles are currently enabled in another session.
> -----Original Message-----
> Nuno Souto
>
> Isn 't that only for the current session?
> I need to know for ANY givI certainly have never heard that PL/SQL is dead. Java with
all those new languages and worsening situation of SUN Microsystems
looks like more probable candidate for an early demise.
On 02/06I haven 't. That book is out since December 2003 which is not very
long. As I too am searching for a replacement for the Guy Harrison 's
book I 'd like to hear your opinion about it when you read itHi Lisa
This sounds very similar to a recent discussion on this list.
I believe that the temporary solution was to go back to using
sort_area_size though I could have it wrong.
Try searching
Is that the fount of knowledge
where everyone turns to drink ?
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questio
I 'm talking outside my area of expertise here
so don 't take this as guaranteed
B+
When a leaf block is full it splits and half the
contents will be moved to the new leaf. (In
fact Steve AdOn 02/09/2004 09 44 09 AM Tim Gorman wrote
> So to repeat my original question is there something about NTFS
> (or
> whatever file-system Windows is using) that is susceptible to this
> problOn 02/06/2004 03 07 41 PM Wolfgang Breitling wrote
> NULL is NULL. It is not equal anything and it is not unequal
> anything.
> It
> is just NULL
>
Actually I 've noticed that many people haSorry just testing reconfiguration of @#$* Lotus Notes rules.
<br > <font size 2 face "sans-serif " >Sorry just testing reconfiguration of @#$* Lotus Notes rules. </font >
<br >
<br >Solaris 9
Oracle 9iasr2
emctl won 't start
Could not contact EMD.... at http /////
Metalink is down?!?!
Help?
Here 's the test shown inline below. The only thing that may slow down
your reproducing it is the use of view_trace.sql which I believe you
can download from Steve Adams 's www.ixora.com.au
<http /Hello
I 'm trying to create a series of SQL Loader files which will work the same
on Unix Linux and Windows.
Each column as a Terminated By and an Enclosed By statement.
Do I need to worr
Are you allowed to hint ?
Try
/*+ no_index (alias index_name) */
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The educated person is not the person
who can answer thOn 02/06/2004 10 42 50 AM "Smith Ron L. " wrote
> Can someone send me the instructions on how to join the new list? I
> am
> getting email but my friend isn 't
>
> Thanks!
Send an email wi
Autotrace calls explain plan.
It is susceptible to the same errors.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the quesI have a problem with a java function that I use to run unix commands.
It works OK for most commands(for example touch works fine) but I am having
problem with the echo command.
I am wondering whe
Try the following URL which (points to a Word document)
describing how Oracle works. There is a diagram of how
a split works (and one of how it doesn 't work).
Regards
Jonathan Lewis
http Hi I?m new in here
You can go to my page and maybe find something interesting.
http //www.geocities.com/juancarlosreyesp/
In this paper there is a complete article about flashback.
http //www.geoIs oracle 10g for Linux out yet?
On 02/05/2004 03 36 54 PM "Bobak Mark " wrote
> The subject says it all.
> Michael
You can migrate the tablespace to local and assign either USER or
SYSTEM for the extent allocation algorithm. It 's not going to affect
the existing extents.
By the way SYSTEM alYes it does. Install is quite similar to Unix or MS2000.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From Smith Ron L. [mailto rlsmith@(protected)]
Sent Thomas there is a good paper about ASSM
on Tanel 's page http //indegrid.info/Poder_Freelists_vs_ASSM.ppt
nothing wrong with the perl.
You might consider getting gnu grep though.
grep -3 string file
This will display the 3 lines before/after the target string.
STEVE OLLIG <sollig@(protected) |
|
|
