 | | | Oracle List | | But be careful I 've encountered several situations where revoking
privileges (according to oracle recommendation) breaks certain oracle
components. One example is Grid Control which recommends you tHi
if you only need to distinct between the partitions you may use the build
in function DBMS_MVIEW.PMARKER
something like ?
select DBMS_MVIEW.PMARKER(rowid) max(column) min(column)
from your_taStephanie
>From what I have read the scheduler doesn 't allow scheduling
>dependencies.
This is only true in 10gR1. As of 10gR2 dependencies are supported and work good.
HTH
Chris
--
http //www.fFor retrieving passwords at the command line
(scripts cron etc) I use a Perl based password repository.
It retrieves passwords from a server.
For sharing passwords with other users we purchased
EnWe use passwordsafe. It is free and available on the net.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Adams Matthew (GE
IndusAll
A fast growing wireless company based in New York City is looking for
a mid-level Oracle developer. This is not an agency. And if you are
an agency don 't contact me. If you are interested in
Have you all noticed how certain errors come and go throughout the ages
and versions? The memory leak which can be fixed with an event the
4031 which has been permanently fixed in every single rHi Alessandro
First off this is an ORA-0060 not an ORA-4020. (ORA-60 is an enqueue
deadlock ORA-4020 is a library cache deadlock.)
Second it 's a TX (transaction enqueue) deadlock.
Third the Allesandro
There were two theories concerning where a commit statement should be
issued from.
The first theory I heard from Oracle when PL/SQL first came out was that
packages should not have commiDate math-ish things in the shell in the shell (I am using bash)
$ date -d "-2 day "
Check the man page for find to see how to find files with a ctime less
than 2 days.
--
Ron Reidy
LeadWell established company in the Nashville Tennessee area has a position
available for
an Oracle DBA to support their SAP and SAP BASIS environment.
Relocation assistance and excellent benefits ....Rich
It 's not you it 's me. I feel like we 've grown apart these last few
months. Our interests are different. You want me to be responsive and
helpful. I just can 't be there for you right now.
3 node RAC listener cross-registration question...
Clients are connecting to the "hostname " of the RAC servers not the
"hostname-vip " - I am thinking this is because the listeners are
allowing tSve
David 's suggestion is one way top do this.
I would follow another approach.
Create a new temporary tablespace in the new location using the script
below. The next day (or maybe later the same <FONT face "Default Sans Serif Verdana Arial Helvetica sans-serif " size 2 > <DIV >I believe you are right and it would certainly not be good if the ASM instance failed but Oracle might argue that ASM isTim
What you describe about PK is often a limitation of the O-O implementation.
It isn 't just something stupid that one person thought up. My suggestion
would be to yield on this aspect. Now there Oracle doesn 't allow me to change log_archive_format to something sensible
SQL > startup
ORA-19905 log_archive_format must contain %s %t and %r
SQL >
$ oerr ora 19905
19905 00000 "log_archive_forHi
I am looking for a book on reports related to oracle 10g.
Type of the book should be from beginner to advance...
Something related to oracle forms and reports building..
PLEASE CAN ANYONdid you check wait events at instance level ? or using sql trace
alter session set events '10046 trace name context forever level 12 '
alter table xyz move
alter session set events '10046 traceYou could try using a user-defined data type that returns your date in the
desired format
Stefan
On 5/6/06 raja rao <raja4list@(protected) > wrote
>
> Hi All
>
> My nls_date_format is dd-mm-rr
>
> iHi
- check the logs in $ORACLE_HOME/sysman/log
- also has any of the passwords been changed ? sysman/dbsnmp/sys
- or did you perhaps change the listener port ? check
$ORACLE_HOME/sysman/config/emo
On 05/06/2006 12 46 09 AM oracle sos wrote
> Hello everyone
>
> I installed 10g RAC on Linux OS couple of times but never work on SUN. Now
> I need to configure a 2-node 10gR2 RAC on SUN 5.8. CHi I 'm becoming a more serious dba and trying to start a project.
For it I would like to know if you can take the time to read it and
give an opinion
not about the content else about the way the inWell it is out for many platforms already. For example Linux HP-UX
and even AIX if I 'm not mistaken.
2006/5/5 Tim Levatich <TPL10@(protected) >
> >Does Oracle post planned release dates? I see t > exp/imp is not an option as it would be too slow and generate as much
> redo as my entire database. It must be a no-logging operation.
>
> I dont have all month to rebuild the indexes it will be Hi
>Hi is it possible to connect to http servlet in oracle10g
>with user name and password somethink like pubic access.
>
>Today I 've to write http //user pass@(protected) port/oradb/...
> <- I 'm tLaura
I know which is the underlying table but frankly creating triggers
on SYS tables isn 't something I would advise ...
Except perhaps on SYS.AUD$. What about turning audit on and puttingHi All
I have a 10g R1 database its dbconsole worked fine before I configured the
database service into a 2-node windows cluster with Oracle Fail Safe. Now
dbconsole seemed to not able to get the Is my memory fading me but is there not a parameter the will (specifically)
force a redo log(s) to be archived.
I thought LOG_CHECKPOINT_INTERVAL or LOG_CHECKPOINT_TIMEOUT did that but as
I re-readWhat does "FP underpinnings for scalability " mean? If you 're concerned
about performance it is quite likely that FP operations are faster than
integer operations with the same size on any hardware |
|
|
