 | | | Oracle List | | Just to help clarify and make sure I understand correctly - I think
what you 're both saying is that you could use the copied data control
and online log files to start another copy of the database iYou would use lcr 's set_value meber procedure to modify column values
(inside your dml handler).
It 's pretty straightforward.
http //download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/t_lcr.htm1.Oracle Applications DBA -
Location Chicago (Oak Brook IL)
(No relocation assistance offered)
Salary $90 000 - $110 000
Comments
The firm has nearly 400 in its IT staff when corporate and rAnyone else catch the presentation this morning? I caught some of it
but was on a conference call and getting the kids ready at the same time
so I was in and out and only got brief notes. Besides select * from dba_dependencies
start with referenced_name tabname and referenced_owner owner and
referenced_type objtype
connect by prior name referenced_name and prior owner referenced_owner
a
Bill
A warning here do not downgrade glibc libraries on a production box.
So many things depend on them. I had a really bad experience once
where I had to recover using Linux rescue CD. No OS coRam
Algorithms for implicit conversion are subject to change across software
releases and among Oracle products. In this case Oracle 's implicit
conversion rule is to convert varchar to number in an all
I found that FGA (Fine Grained Auditing) can do auditing on per DML or
even select statement.
is there any such shortcut way to do counting table hit by another
script? I thinking of capturing Hi Anant
You need to do a bit more study to get this one right try the ignore
parameter and the fromuser and touser parameter to import indiviudal
user objects in a schema I would highly recommend aAre there ODBC data sources defined which the VB app is expecting to use?
And if so are they all defined the same way?
There is an ODBC panel under
Control_Panel- >Administrative_tools- >Data_sources(
Folks
This is yet another request for your participation in a RAC survey.
The poll is linked to the
Following blog entry
http //kevinclosson.wordpress.com/2007/07/09/yap-yet-another-rac-poll/
It 's the necessary plan
Hacking the predicates to make things clearer
where
1 'XXX '
or ( 2 ! 'XXX ' and FPGI.PC_ID 3)
If you enter 'XXX ' as the value for 1 then Oracle MUST
retuDid you try it serially?
I 've usually seen these types of errors with corruption.
Try analyze table table_name validate structure.
Or run a query that does a full table scan and see if you get the samHi Peter
the export is simply doing a select. And when it moves from table to table
it uses the same SCN ( "snapshot " of the database) as it did when starting to
export the first table. A select willWell since nobody else has said it I suppose I might as well...
RTFM.
Try the "Utilities " manual which covers Export/Import quite thoroughly.
In the meantime I 'll give you a hint... Your soluHi all
User is trying to create an index on a table.He is getting the following error
ORA-12801 error signaled in parallel query server P038
ORA-08103 object no longer exists
I checked the objec Hello gurus
I have some problems with Oracle 10.2.0.3 on Windows 2003 32-bit. We have PGA_AGGREGATE_TARGET set to 350 MB and a SGA of 2200 MB. Some of the sessions are shared server ones (which taHi All
Have a doubt on transaction isolation.
My requirement is to query several tables several times inside a piece of
code. The data needs to be consistent across multiple queries. The
underlyingHi Ujang
Gee you get all the good ones to work out.
http //jonathanlewis.wordpress.com/2006/12/04/resizing-the-sga/ has some
comment about the use of SGA_TARGET
The following metalink notes may ass
Analyze index validate structure
checks the index for self-consistency
analyze table xxx validate structure cascade
checks that the table is valid and consistent
with all its indexes. Anyone have semi-reliable word on when 10.2.0.4 will be released? I 've
searched MetaLink and the Oracle-L archives but wasn 't lucky.
Thanks.
Jack C. Applewhite - Database Administrator
Austin (Testatus
--
http //www.freelists.org/webpage/oracle-l
I 'd be curious to hear anyone 's reasons for preferring OS cache to DB
cache.
It seems pretty clear cut to me that it is better to allow Oracle to
manage its own cache since it has much more knowleOne thing I noticed that 's usually left out of the "abort " threads is a list
of what memory structures that aren 't flushed to disk. Not everyone uses
them but as some do it should at least be notedHi
I just configured a flash recovery area using ASM I was wondering if anyone
know the command to add a logfile member to FRA?
ALTER DATABASE
ADD LOGFILE MEMBER
TO GROUP 1
does not work
ALTER DOnce I 've got in trouble when striping conflicted with each other.
It was for redo logs that are striped with fine striping in ASM (128K)
and this collided with stripe size of underlying volume so thaI have the same error regularly and it seems we can ignore it. I
normally re-run suggested command and it says that operation (like
home attach) has already been done.
I only observed it with shared Robert
My only comment is that AFAIK most of the OEM Advisories require one of the
chargeable packs e.g. Tuning Diagnostics etc. How many sites are actually
licensed to use these packs and hence thAll
Does anyone know why ODM is granted restricted session after
an upgrade to release 9.2.0.8.0?
Maureen English
University of Alaska
Fairbanks AK 99775
--
http //www.freelists.org/webpage/oracleHi folks
We 're trying to install Oracle Enterprise Manager Grid Control on a RHEL5 server. We 're getting the following error when OPMN is started either via the installer or manually
--------
07 |
|
|
