 | | | Oracle List | | if you put it into shared storage you can load with PQO as well...
requires CFS or NAS
Hi Raj
If the exception list grows I think you could improve your
procedure putting the domain exceptions in a table and looping on that
table to find the domain you need.
the domain table could h > > >
> > >It was quite a while since this thread posted but in the
> > >meantime I figured out that ASM needs ocssd daemon because
> > >this is the way of establishing communications between
> > >database actually policies don 't affect anyone who has 'EXEMPT ACCESS POLICY '
privilege. Since SYS owns all those things (privileges etc) it is
exempt by default and no you cannot change that fact.
Raj
On 4Sorry.. stopped reading this article after the first line
"Oracle Streams is a popular free alternative to Oracle RAC for failover and
disaster recovery... "
2006/4/10 ramick <ramick@(protected) > Hi LiShan
The cpio/tar backup of the home is a base line for restore like a level 0
rman backup and requires an outage.
The bkp_restore -m backup_config command is like an incremental backup oI doubt that anyone else on the list noticed this but the cute little red
biplane that is displayed at most OpenWorlds crashed and was destroyed last
week.
The pilot Sean Tucker was executing a 7.If there is anyone here that has dealt with Dell Storage Support with
respect to attempting to restore the metadata (provisioning LUNs) on a
Clarion unit please contact me. If you know of someone onHaving never run SE this may be a non-issue but... Does SE limit you on
how many processors are 'presented ' to the database vs you doing the
calculation? Will SE even start up if the O/S is preseI need to load data from one table to two tables. It is kind of
noramlizing the data.
As an example
Source table
Table A(col1 col2)
A1 B1
A1 B2
A2 B3
A2 B4
A3 B5
Could anybody detail why increasing the value for sga_target should increase
the memory used by a shadow process. I am running 10.2.0.1 on hpux.
--
http //www.freelists.org/webpage/oracle-l
Anybody ever see this error message from Grid Control
Error caught processing purge policy MGMT_IAS_TOPO_PURGE ORA-20000
Error executing purge proc MGMT_IAS_TOPO.TOPO_PURGE for purge policy
MGMT_ICould you specify what unsigned constraint does (for those familiar
with MeSQL)?
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of S
Hi Ray
declare
CurrentDate varchar2(30) ' < < ' || to_char(sysdate 'dd/mm/yyyy
hh24 mi ss ') || ' > > ' TraceFile constant number 1
AlertLog constant number 2
BothLogs constant number We are working on that. It can be done with Oracle Advanced Security using
kerberos tickets. We have a paper from Oracle on how to accomplish it and
have done it in test. I am rushing to get done w
Morning Paul
> > I 've written a package that calls DBMS_METADATA (10g) to produce the
DDL to recreate an entire schema and it
> > works great.
Isn 't there a bug in DBMS_METADATA that causes 'scripHi All
Is it possible to run RAC on nfs similar to the configuration used in the article "Learning Oracle RAC with the NetApp Simulator " on OTN but without using NetApp.
Thanks.
JoHi All
Could you tell me what I 'm doing wrong?
I need pass different schema owner in SQL also in some tables there are multiple records will be returned.
DECLARE
m_dated DATE
m_count NThose are two distinct objects and Oracle would need to keep track of both
in case one of them or threir dependants or the objects that those depend
on are changed. Their text commonality isn 't realHello list
When I grant execute on a function to a user the session is wating on
'library cache pin ' wait event. I have waited for 20 min. still
session waits on the same wait event.
Any ideas?
OS
On 04/05/2006 11 34 35 PM xiaoyan wrote
> SQL >conn system/manager as sydba
>
> SQL >create user wxy identified by wxy
>
> SQL >grant sysdba to wxy
>
> SQL >conn wxy/wxy as sysdba
>
>
>
> HoJohn
I agree with Jared. Write some wrapper procedures that calls the
procedures within the package as separate units and grant these procs to
the users.
For example
If the original package has On Wed Apr 05 2006 at 05 02 10PM -0400 Mark W. Farnham wrote
> employ tax accountants in efforts valuable to each tax paying company and
> worthless to mankind as a whole.
"Hear all ye good peoUm a physical standby doesn 't have online redo logs.
If you drop the log on production then that will be carried over to the
standby.
Thanks
Jay Miller
Sr. Oracle DBA
x68355
-----Original Messa > > >Oracle claims the create pfile from spfile command results
> > >in an ascii file which technically is correct but it 's got
> > >special ascii characters so notepad or the like isn 't
> > >suitable tA simple-minded solution would be to create a two column User_Campus table
- User Campus (could be ID or Name whatever works for your situation).
Most folks would have one row in that table. The Add a new tablespace temp2 size it as you want it switch over all you users
to it and then drop the original one. If you are version 10g you can also
rename temp2 to temp if you felt so inclined.
Hi!
Wouldn 't it be better to manipulate the sql instead of making an fbi eg
replace select * from a where b 2 with select * from a where b '2 '...?
/Greetings
Bj?rn
----- Original Message -----
DBSNMP is your oracle agent and I would guess you are running jobs from oms using SYSMAN to connect. That being the case your capture is normal.
-----Original Message-----
From oracle-l-bounI have a question about buffer pools. I 'm working on a 3rd party app
Oracle 9.2.0.6. I notice that several tables are defined to use the
recycle pool but the init.ora parameter for buffer_pool_re |
|
|
