 | | | Oracle List | | Hi Matt
I ran into this a while ago on boxes where the swap configuration was
pretty skimpy. We had cases where we could not fully utilize available
RAM due to swap shortages and the fact that Sdear all
could anyone have experince with activating async io on redhat 7.1 and oracle 9ir2.0.1 database?
[root@(protected) /root]# uname -a
Linux localhost.localdomain 2.4.2-2smp #1 SMP Sun Apr 8 20Hey Brian
I personally use both OEM and RMAN to do backups at my
site. I find OEM pretty useful for scheduling
backups(NOT RESTORES) and scripts. Also I like OEM
because it is easier to train a noHi
Has anyone read the following artical about oracle9i label security
http //www.oracle.com/technology/deploy/security/ols/pdf/ols9ir2_fov.html#top
when talking about POLICY ENFORCEMENT O
Me thinks you mean
select col2 from r1 r2 where col2 like '% '||col1|| '% '
- i.e. compare col2 with the contents of col1 not the (sub-)string 'col1 '!
HTH
Michael
-----Oprindelig meddelelse-----
I would suggest a modified UNION-ALL version (a solution I have myself used
on occasion (3VL may - as always - bite you though))
---
SQL > select * from v$version
BANNER
hi
you can use minus or union depending on your requirements to find same rows
On 4/13/06 Bob Robert <mssql_2002@(protected) > wrote
>
> Gurus
>
> I would like to compare two columns from two diffeI tried to upgrade 10.1.0.4 to 10.2.0.1 following official procedure.
After a week of pain and feedling with all possible fixes for upgrade
actions done during installation I finally couldn 't do anythI have been going through oracle 's web site trying to find a page listing
what is included in Oracle 9i Rel2 Enterprise Edition. Not what options
cost extra I have a link to the pricing site. A bI expect it has to do with "Abstract DataType (DATE in this case)
semantics ". You can subtract a Date from a Date the result is a number of
days (a difference). You can subtract a number of days frHi
I have Oracle 10.1.0.3 database on 4 node RAC and has single Node Physical Standby database and using Data Guard. I am able to perform the successfull Switchover. But now I want to test the FHi Helmut
If you got anywhere with this setup - please share your experience.
Perhaps anyone else on this list has tried this configuration in the
meantime?
Thanks
Alex
2006/4/13 Daiminger Heldg_config is specific to DataGuard.
Any reason why you are not using DataGuard .. It is quite mature in in
10g.
> cat f
$Log Blah
> grep "\$Log .*\$ " f
$Log Blah
I am actually looking for a line which has Dollar Log Colon ...any
characters...dollar...any characters...but this still returns the line evenI am scratching my head trying to track down a 9.2.0.6 RAC issue (db
stops responding to queries for 5 to 10 minutes at random times) and I
am thinking about using RAC-DDT (Meatlink 360926.1) and OS WI need to extract data from a remote database to local database. One
of the column to extract is blob. Each single extract will fetch
approx. 1 GB of data. Connectivity between the database is 10 mbps10.1.0.4 10.1.0.4 patch 10 standard edition
w2k adv svr sp4
I 'm wondering if anyone has seen this type of error before?
Had contention on a single tempfile in a temp tablespace.
Only one tempfile oHi
The sys_context could have leading wild cards trailing wild cards or infact a
wild card in the middle. I 've convinced the developer to use an operator
thanks!
Josh C.
_____
On 04/12/2006 11 25 50 AM Simone Saravalli wrote
> hi to everybody
> I use Oracle 10g Express and I 'm dealing with the connection to the
> database in php through the use of pear. In order to cHave you checked to make sure that disk stats are on? Use (cautiously)
"diskperf " from command line to check. I usually turn 'em off because
they do add some overhead.
HTH! GL!
Rich
-----OriFly the steps should be documented pretty well in the release
notes/readme after you extract the .zip file. I followed those in the
past without any real difficulty. There 's not much to it if you > If you are talking about JDBC connection from within the DB 's JVM
> through server side driver ...
[...]
Could you give an example?
Thanks
Dimitre
--
http //www.freelists.org/webpage/oracle-lHelmut
Yes. 10gR1 with HP-UX 11.11 and VCS 3.5 which is not very
straightforward (issues between VCS and CRS integration).
Using stadard HP MCSG clusterware should be easier and more or less
followyes and I told the poster Alexander Kornbrust that his company is very
careless and irresponsible by revealing so much detail. It took little
time before I was able to delete data that wasn 't mine You cannot substitute union/union all for "or ". If both conditions satisfied
for a single tuple than union all would bring duplicates that you wouldn 't
see in the original results. Union on the otherTrying to ftp a patch from a unix server never tried it this way before. So
far I guess I don 't know what I am doing. Can not do a dir won 't let me.
{ <foo >} $ ftp updates.oracle.com
Connected to biSome metalinkisms
http //www.red-database-security.com/wp/oracle_metalink_hacking_us.pdf
--
http //www.freelists.org/webpage/oracle-l
Never had a problem with editing that file Paul.
Cheers
Lee
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Paul Vincent
Sent 11
Please specify the schema name as follows. This solves the issue.
SQL > UPDATE T set NUM 2
UPDATE T set NUM 2
*
ERROR at line 1
ORA-01502 index 'SCOTT.I ' or partition of such index is in unus |
|
|
