 | | | Oracle List | | J.Dex
Do you mean to export the data that the View returns or the sql that
makes up the view?
If it 's the data you can always create a temporary table from the view
and export that table.
Create Alex
What Oracle version?
Dennis Williams
<div >Alex </div >
<div > </div >
<div >What Oracle version? </div >
<div > </div >
<div >Dennis Williams <br > <br > </div >
.. .Or does perhaps someone have any clues how I could alter the stats of
the involved table to get the optimizer to favour inline execution instead
of materializing the subquery ?
Stefan
.. .Or doeHere 's a perhaps wild thought. Could you establish Physical Standby
databases on (an)other server(s)? Then you could let your Prod datbases
automatically shovel the archived redo logs to them Use bbed - http //orafaq.com/papers/dissassembling_the_data_block.pdf
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounYou can get the tape volume from rc_backup_piece.media at least I do
with Netbackup but it may be different with other MMLs. Actually I
used to get this info back when we went straight to tape buUwe
Does the approach at
http //www.niall.litchfield.dial.pipex.com/2004/06/we-have-one-of-those-irritating-issues
help? Note larry wolfson of this list pointed out that in 9i don 't try
to monitor eHi Peter
> Should I be using the dbms_stats package or the analyze
> command for this version of Oracle?
If you have partitioned objects I would advise to use dbms_stats.
Otherwise analyze.
> LookiLooking for comments & experiences regarding sizes of datafiles.
We have a large (6+ TB) OLTP database which currently has 2300+
datafiles.
A while ago we stopped adding datafiles and were exclusiOn 5/2/07 dba1 mcc <mccdba1@(protected) > wrote
> Recentlt I have interview and two questions I may need
> your opinion on it.
>
> 1. what is difference between ASm and hardware RAID?
> Pro/con.
>
> 2.it only needs to run on one instance - if that instance is down then it
will connect to the other one based on your tns entries
On 02/05/07 Nizar Ahmed <gnahmed.c@(protected) > wrote
>
> Currently Maureen
If you are just talking the Rdbms install then it has no impact. As
long as you run the root.sh script before you try and start various
database components you will be fine. Specific exaOn 5/1/07 Jeremiah Wilton <jeremiah@(protected) > wrote
>
> Robert
>
> SSH has a verbose option. Issuing ssh -v will produce more verbose
> information on connection and authentication progress. MHi Bill
> One of my users sent me this URL for a paper on improving security
> http //www.oracle.com/technology/pub/articles/jucan_security.html.
Be careful that paper covers/mixes different techniOn 5/1/07 rjamya <rjamya@(protected) > wrote
>
> BN
>
> you could write a creative query against dba_extents using header_block
> and number of blocks for each extent of each segment and see for yoursHas anybody ever created their Oracle Text index as transactional?
Such as
create index myidx on mytable(mycolumn)
indextype is ctxsys.context
parameters ( 'transactional ')
I have been reading orI am trying to run the 10.2.0.0 client on Windows Server 2003 (Service
pack 2). As soon as I try to connect OEM to a database the program
quits spitting out what looks like a Java stack trace in thHi Ujang
The latch free is taking less than 10% of the response time. So if you
have a problem is not the latch... The main problem I see is that you
have no partition key in the WHERE clause. ThereHi
Does anyone know where on the Net I might find Oracle 8.1.6 for Windows NT
or a patch-set that can be applied to the 8.1.5 release for Windows NT.
Thanks
Pete
Hi <br >
Does anyone know where onMaybe try creating a stored outline for the query under the Apr CPU and
then try to use the same outline to force good execution with the Oct
CPU or just try to manually apply some/all of the hints fOK I had heard that perhaps there are issues because of the interconnect
uses UDP. The goal would is to for example allow say 3 databases access to
machines A & B during the day while another databaAre there any technical limitations in regards to running multiple databases
across the same set of servers in the same cluster?
Are there any technical limitations in regards to running multiple datIt is funny that in the online training section that you see they are still
charging for content like below. Now perhaps they are still raking in big
bucks selling Oracle 8 MTS training but I tend toIf you 're up for a move we have an open Sr. DBA position here at
LodgeNet Entertainment Corporation.
http //www.lodgenet.com/employ/descriptions/sr_dbase_admin.html. We
use BO are migrating to Does anyone know how to use EXCLUDE at the table level for a full export?
Here is the partial parfile
directory dpump_exp_dir
dumpfile Full.%U.dmp
full y
logfile Full.log
exclude statistics
parallelAjay
Depends (as usual). If the DB Links are FROM the Prod system TO others
and you 're careful about which User you connect to on the other end then
you 're probably OK though others might have Hello everyone.
It is safe to drop the objects of the logminer after finishing using them?
Thanks in advance
--
Alfonso Leon
Hello everyone. <br > <br >It is safe to drop the objects of the logminer all
I have a physical standby database but a little error comes when open
read only and again MRP apply.
startup nomount
alter database mount standby database
alter database managed standby dataWhy not?
As long as you want you can certified on anything you want I know people
who holds over 10 certifications if you think you will feel better having
SCSA then just do it.
On 4/29/07 SyedHi
> Are there any official announcements?
> I don 't see anything in the metalink.
Have a look to Metalink note 161818.1.
> If the above is believed to be true then its really
> very short time t |
|
|
