 | | | Oracle List | |
Thanks Ron
I can see only the PPT file hosted on this site. I think there is an
accompanying document which (I guess) must have more details on the points
made in presentation. That is what IJ.Velikanovs@(protected) wrote
> Hi list
> I am new person in this list and need help on search capabilities usage of
> http //www.freelists.org.
> I wouldn?t like bore list with duplicated questiSlightly off-topic but relevant to anyone who uses bespoke scripts on Unix.
I 've got a bunch of SQL ksh and perl scripts that I want to organise
archive and delete where obsolete. I 'd like to gHi
Do you have multiple versions of Oracle (incl 10g) on the same box?
If so running everything can be tricky.
Summary
You can remove 10g paths if you need v9 utilities or you can hack
Hi 20
This is a 9.2 feature. 20
The correct syntax is INSERT INTO MYTABLE VALUES vRow
Chris
>-----Original Message-----
>From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)
--
http //www.freelists.org/webpage/oracle-l
All.
Has any one of you configured a workable solution using Hitachi shadow image
and 9205 for duplicate database creation? I am looking for some reference on
doing it without putting the source
Every single client wants help with Sarbanes Oxley.
But they all want something a little bit different.
Anyone know of a decent package for Oracle or even better a package that has
interfCheck your NLS_LANG setting on the client .. Make sure it is the same
as the Database
HTH
Cheers
Ganesh
On Thu 7 Oct 2004 18 13 01 -0400 Harvinder Singh
<harvinder.singh@(protected) >
>So I do recovery I roll forward and I try to do an open resetlogs
and I get ERROR at >line 1
>ORA-01152 file 85 was not restored from a sufficiently old backup
>ORA-01110 data file 85 Hi
Database instance is not started automatically after server reboot. I have a
9i instance on Windows.
OracleServiceSID is set to start automatically under services and I see this
started aftHow can convert the original db into standby instead of copying the files? Re-create controlfile as standby?
Thanks
"Parker Matthew " <matthewp@(protected) > wrote
Depends on why you flipped fromHi thanks to every one who helped
In my 10.1.0.3.0. database I tested and got the following
Setting both I got an error so I tried only discrete transactions as you
can see.
alter systemAll 20
I 'm trying to restore a hotbackup (v7.1.3.2) on a partition with little
extra space. I cannot add space or modify much on this server so I
placed the new version of the oracle hotbOn Thu 7 Oct 2004 19 25 37 +0100 Niall Litchfield
<niall.litchfield@(protected) > wrote
> No kidding. I also often find you can find later drivers on otn than
> on metalink - go figure.
>
ComeHi
Yep. Same thoughts here.
On Thu 7 Oct 2004 07 27 06 -0400 rjamya <rjamya@(protected) > wrote
...
> 'urgent ' problem and insteading of calling Oracle they send email
...
Typically for none that I know off there is some performance penalty but usually
goes unnoticed.
Raj
On Thu 7 Oct 2004 12 09 35 +0200 Jose Manuel Quesada
<jmquesada@(protected) > wrote
> Are there any Chiku
I can think of the following reasons for the problem
1. A table is being given in the exp script (tables 3D ) not found in
the database?
2. Export do need some data dictionary tableJurijs
I think that if your miss of sql in the shared pool is 10% that most
statements that are not frequently executed will quickly be aged out
and re-parsed during subsequent execution.
If Sorry I meant to paste the direct link to the article
http //www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html
On Tue 12 Oct 2004 10 49 19 -0700 Jared Still <jkstill@(protected)Hello all
We are starting to research the process of upgrading our OPFS (oracle parallel fail safe - HP-UX) from 8i to 9i. Before I go to MetaLink next I thought I would post here for any ideas frHi 20
I never installed it on RH (I 'm a SuSE user...) but my advice is to use
ASM without ASM Lib. You don 't need it! Just map your raw devices to the
ASM disks.
Chris
>-----Original MeHi
I am not able to set Remote_login_passwordfile none.
sqlplus "/@(protected) as sysdba " is not working and fails with ORA-01031
insufficient privileges. Presently Remote_login_passwordfile SHARED.
Todd
Think of it as a long-running query on the parent table. It should not
throw any locks.
I also agree with Mladen. Create the Fk with the 'enable novalidate '
option. It will create theThank you to several people who responded to this earlier request and
gave me good ideas. I was able to perform some tests and wanted to
report on the outcome. The situation is a daily SQL*Loader I 've seen this before with the Java EM on both 9i and 10g. It appears
that
Java just gets confused after several days of staying open and me
having
around a dozen different apps/windows runniHi
Interesting... Jan 2005 Oaktable
http //www.amazon.com/exec/obidos/tg/detail/-/1590594487/104-7863760-5281538
HTH
Regards
Mike Thomas
--
http //www.freelists.org/webpage/oracle-Excellent point Carel-Jan
Consider Platypus 's QikDATA If after testing like Carel-Jan on a just for
fun basis you calculate the speed increase would justify about $16 000 USD
and if you can Hi Alex
If you are using OEM DGM to manage and adminster your DataGuard environment
it 's all just couple of clicks but the requirment is you should be using
OEM Repository to use the GUI. UsiNOTE I _KNOW_ what the risks are.
Just for fun I created a ramdisk on Linux and put my online redologs
there. They are copied there on system startup by an rc-script. A
graceful system shutdown |
|
|
