 | | | Oracle List | | I figured it out )
Thank you!!!
Saira
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Saira
Somani-Mendelin
Sent March You should sign up for Oracle Magazine! This same question was answered in the Ask Tom column in the March / April 2004 issue. I 'm going to skip his long explanation and go straight to the solution. MHi Jay
Can you clarify your question? What failover do you mean? Data Guard?
Transparent( Better transclucent (Pete Sharman)) Application Failover .
TAF? Some automagic failover whenever you At 01 19 PM 3/2/2004 you wrote
>Your original error indicated that your undo_retention value was too
>small to process the original query. This is different than the size of
>the undo_tablespSet colsep '| '
Jack
-----Original Message-----
From Roger Xu [mailto roger_xu@(protected)]
Sent Tuesday March 02 2004 9 26 PM
To Oracle-L@(protected) Org (E-mail)
Subject Delimiter
WHENEVER SQLERROR EXIT will do nicely.
On 03/02/2004 03 07 09 PM M Rafiq wrote
> Hi
>
> I need help for following sql script. I want to put condition before
> truncate that table creation m
Mark
Didn 't we hammer out a list probably not complete
of the possible different costs. I seem to recall you
Tanel and I throwing odds and ends into the pot until
we got
Hard parse
You need a database link created between PR2 and QA2.
Igor Neyman OCP DBA
ineyman@(protected)
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)
9.2.0.4
SQL > create table gtt (n1 number)
Table created.
Elapsed 00 00 00.00
SQL > select sid username from v$session where user_name 'TEST_USER '
SID USERNAME
----------BATSUIT? Will he also arrive in the batmobile?
On 03/02/2004 03 49 41 PM Tapan Trivedi wrote
> It depends upon whether or not Rich puts on the batsuit again !
> Tapan
> P.S. I am going and tThe other day I was asked to deliver comment on intention of customers
of ours to use Legato RepliStore to keep a copy of production database
in synch with master database. Apparently this solutioWe have a production oltp that has logs build on tables necessary to
reporting so that we and replicate them to the reporting database. I am
trying to set up a valid test environment with exp/imp. 9.2.0.4 on HP 11.11
Has anyone seen the following -
$ sqlplus /nolog
SQL*Plus Release 9.2.0.4.0 - Production on Tue Mar 2 14 11 40 2004
Copyright (c) 1982 2002 Oracle Corporation. AllHi
you can run alerts for that. We have purging alerts in apps.
HTH
senthil.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)]On BehalfYes that would be the ideal situation.
But don 't forget lots of apps will do one parse per execute.
They will be soft parses and perhaps even session cache cursor hits
but they still get couI use balsa with mailboxes in "mbox " format. I archive only posts that I see as interesting.
Once a month I burn my mailboxes on CD. Archives are searchable via zgrep.
On 03/02/2004 08 53 40 ACheck $ORACLE_HOME/rdbms/mesg/oraus.msg file.
----- Original Message -----
From "Syed Jaffar Hussain " <sjaffarhussain@(protected) >
To <oracle-l@(protected) >
Sent Tuesday March 02 2004 4 49
1. Create another Undo Tablespace (CREATE UNDO
TABLESPACE UNDOTBS2 DATAFILE ...)
2. Switch to that Tablespace (ALTER SYSTEM SET
UNDO_TABLESPACE 'UNDOTBS2 ' {with SCOPE BOTH if using an spfilePlease don 't start a new thread by replying
to another post and changing the subject line.
Those of us using capable MUA 's don 't appreciate it.
Instead create a *NEW* thread by creating a new
On 03/03/2004 06 55 52 AM "Jamadagni Rajendra " wrote
> Beware .... TORA was recently bought by Quest.
>
Yes and Quest didn 't say whether they actually intend to do anything
with the tool sqlplus "/ as sysdba " < con
select 1 from dual
select 2 from dual
exit
CON is a special device "console " in DOS&Windows.
Tanel.
----- Original Message -----
From "Reardon Bruce (CALBI 'm surprised they knew that hehehe. -)
--- "Boivin Patrice J " <BoivinP@(protected) >
wrote
...
> I logged a TAR but so far the response I got was
> how about setting your
> databasThanks to Jonathan Gennick the Doc 's about emctl at Metalink and despite
my stubberness to have the (custom) database created by the scripts my 10g
database is up and running and accessible throCheck Params-Check and Getopt Long on CPAN.
On 03/01/2004 06 50 09 PM Oracle DBA wrote
>
> Hello All
>
> I would like to use a parameter file in an Unix script. This parameter
> file w
Possibly lack of bind variables. Without them the shared pool gets filled
up with a bunch of doo-doo then you get waits while Oracle manages all that
doo-doo. If you 're just playing around yo
Notes in-line.
Regards
Jonathan Lewis
http //www.jlcomp.demon.co.uk
The Co-operative Oracle Users ' FAQ
http //www.jlcomp.demon.co.uk/faq/ind_faq.html
March 2004 Hotsos Symposium - The Scott
I think one of your dates is just *slightly* off. If you do
select to_date( '02-13-2004 17 14 06 ' 'MM-DD-YYYY HH24 MI SS ') - 38030.7181 from dual
You get a date of 1899-12-30 00 00 0
No. It 's not a column/literal thing it 's
a number/varchar thing.
A clause like
... where numeric_column character_literal
will convert the literal to match the column type.
RegarHi list
A server here that houses a secondary ONAMES server has been targeted for
decommission.
The simple fix would seem to be to setup a DNS alias (CNAME) for the box.
However I have noIt does exist. Take a look at Princeton Softech
http //www.princetonsoftech.com
Very good tool very good company. Alternatively there is
a UK company called DataBee which does the same thi |
|
|
