Hi List,
Sorry to post this again.Hope i will get some replies this time.
I don't find Doc 52576.1 (Reg. cleaning up a RMAN catalog) on metalink.
Can someone mail me if u have a copy of the same ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khann
Hi Mladen,
please excuse me. Since I try to improve my knowledge
about the English: what do youmean with muave? Some
kind of wood?
Please enlighten me.
Greetings,
Guido
>>> [EMAIL PROTECTED] 11.09.2003 20.49 Uhr >>>
And the database must be muave.
--
Mladen Gogala
Oracle DBA
--
Please
I'd probably use a trigger to dump all session information when the update
happens.
At 09:34 PM 9/11/2003 -0800, you wrote:
An unwanted update - del_flg=Yis happening while an application is
underway with thousands of Concurrent Users
We need to trap & get as much info on this update which i
Gurevich,
RMAN> change backupset XXX delete;
this deletes the backupset from disk.i have tried it.
Hope "change backuppiece XXX delete;" also does the same on tape.
Jp.
12-09-2003 06:34:27, Gene Gurevich <[EMAIL PROTECTED]> wrote:
>Hi
>does a command change backuppiece ... delete delete
>the i
An unwanted update
- del_flg=”Y” is happening while an application is underway with thousands
of Concurrent Users
We need to trap &
get as much info on this update which is somehow happening from somewhere in
the application code .
How as a DBA can
we do this?
Thanks
db_block_size=8, db_file_multiblock_read_count = 32
That is a Peoplesoft ERP system, a hybrid of oltp and dss with heavy
reporting activity at month end. The dfmrc value was established through
trial and 10053 trace analysis. Some report sql still require use_hash
hints in order to avoid silly
Trying to create an RMAN 8.1.7.0.0 catalog in an Oracle 9.2.0.3 database
ran into a PL/SQL bug fix. Oracle 9.2.0.3 expects the PL/SQL
specification default values and body default values to match.
Unfortunately, the RMAN 8.1.7.0.0 create catalog fails since the rman
package defaults do not ma
Surprising.
Take a look at
http://asktom.oracle.com/pls/ask/f?p=4950:8:3074025580820147889::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:286816015990,
However, it is a totally different story with Application Servers (atleast 4.0.7.1).
In case of compiling of procedures (say A), 'B' becomes invalid
Hi,
I have a package that has a lot of variables. Used by many procedures triggers etc.
1) I had an existing SQLPLUS connection running applications that use this package.
2) I changed and compiled the package. It compiled successfully and so did all other dependent PL-SQL.
3) The existing
Absolutely correct.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Gudmundur Josepsson
Sent: Thursday, September 11,
Hi!
> Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up
into
> "heaps" (Oracle terminology) but whatever fancy stuff they were trying to
> accomplish by doing this (I think part of the magical self-tuning
> initiative) was buggy and this hastened the fatal 4031 situation. The
I would go with second one. Good effort.
GovindanK
On Thu, 11 Sep 2003 08:09 , Tanel Poder <[EMAIL PROTECTED]> sent:
>
>
>
>
>
>
>
>Hm, yep, it seems it works only in insert select
>command (I tried an update with subquery) but didn't succeed).
>In this case
>try following:
>
>1) if you g
Not sure if this would be of 1% help. I remember getting into similar trouble
when i was working on 9iAS stuff.
- Is there any reference to server name? If so replace it with IP address.
- Do you have original copy of the conf file. If so do a unix diff to see
where all the difference arises. May b
You might as well take a look at the following asktom link:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:663024378020
HTH
GovindanK
On Thu, 11 Sep 2003 11:24 , Pardee, Roy E <[EMAIL PROTECTED]> sent:
>And don't forget file permissions issues either--especially if there
>w
AFAIK, XDB is created by dbca if you use 9iRel2 ; If you migrate 9iRel1 or 8.1.7.x to
9iRel2
then it is not created. You need to run a set of scripts. There is some reference on
Metalink about this.
Search on XDB;
In 8.1.6.3 you need to edit and run
$ORACLE_HOME//xml/OracleXSU12/lib>ls -l ora
Title: RE: 9.2.0.4 anyone
Parameter name "_kghdsidx_count", default in 9.2.0.3 is 1, description "max kghdsidx count".
Do not know what it is for.
Alex.
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:29 PM
To: Multiple recipie
Title: RE: how can I see which database I am logged into without
In 9.2, in SQL*Plus
prompt &_connect_identifier
Alex.
(Thanks to Connor McDonald)
-Original Message-
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 11, 2003 2:54 PM
To: Multiple reci
Hello list, seeking your personal opinions and experiences about
db_file_multiblock_read_count.
What do you all set your db_block_size and db_file_multiblock_read_count
to?
How did you all come to decide that those values would suit your systems ?
Any windoze user here who can tell me how can
Funny.
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> How about:
>
> SELECT 'RUMPELSTILSKIN' FROM DUAL;
>
> That should be a good guess.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> > Behalf Of Jose Lu
Stephane,
No time to look at it enough to do it. Also, not a lot of time is
spent tuning our test/dev environments.
But I'd like to do it.
Stephen
>>> [EMAIL PROTECTED] 09/11/03 01:37PM >>>
HI,
I was wandering if a lot of people are copying statistics using
dbms_stats
from production to test
I use it a lot. I create mock databases where I just load the schema (from
export rows=no) and then copy the statistics on top. That lets me do
what-if scenarios, changing sql, init parameters, statistics, or even the
Oracle version, without impacting anyone. When I find something that looks
pr
Hi
does a command change backuppiece ... delete delete
the info about a backup piece from a rman catalog only
or does it also delete the backup piece itself from
the tape?
thanks
gene
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design softwa
Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up into
"heaps" (Oracle terminology) but whatever fancy stuff they were trying to
accomplish by doing this (I think part of the magical self-tuning
initiative) was buggy and this hastened the fatal 4031 situation. There is
a para
By chance, do you have Tom Kyte's latest book? Effective Oracle by Design??
He states his opinion on this approach on page 30, section entitled "Test Against
Representative Data".
-Original Message-
Stephane Paquette
Sent: Thursday, September 11, 2003 4:38 PM
To: Multiple recipients
How about:
SELECT 'RUMPELSTILSKIN' FROM DUAL;
That should be a good guess.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Jose Luis Delgado
> Sent: Thursday, September 11, 2003 4:38 PM
> To: Multiple recipients of
At my university we were "given" Oracle licences .. as well as substantial
gifts from Sun (Servers, workstations etc)... that way we finished
University with good working knowledge of Solaris and Oracle on Solaris...
Which is of course in their best interest... :S
-Mensaje original-
De
I don't use it a lot, since our test systems are currently complete copies
of our li'l ol' 30GB production DB. But it's nice to have for things like
the 9i RAC test, where we can't have a complete copy of the data (although
I've yet to try it on there). And it has worked well so far from 8.1.7.4
Can you try:
select global_name from global_name;???
compare it with your
select ora_database_name from dual
Are they the same?
HTH
JL
--- David Wagoner <[EMAIL PROTECTED]> wrote:
> You might get some surprising results from SELECT
> ORA_DATABASE_NAME FROM
> DUAL; (see below). I have a DEV d
how about select from v$database;
bs
-Original Message-
Sent: Thursday, September 11, 2003 9:40 AM
To: Multiple recipients of list ORACLE-L
Hi,
this statement returns the GLOBAL_NAME value rather than the database name.
Admittedly the 2 should usually be the same but often (following a
O/S is AIX 4.3.3
/usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is
capable of either 32 or 64 bit operation.
/usr/sbin/bootinfo -K returns "32" meaning that the kernel is running
in 32 bit mode.
When I run sqlplus the server says:
Oracle8i Enterprise Edition Release 8.1.7.0.0 -
Title: RE: how can I see which database I am logged into without
When
the database was cloned from prod, did the global name changed (alter databeas
db rename global_name to ...)
Maybe
ora_database_name takes it from global_name.
Stephane Paquette
Administrateur
de bases de donnees
D
Hi List,
Has anyone ever seen this erro while creating
interMediatext index? If so please help me out to
resolve the same.
TIA
create index hibm_taxonomy.taxcategoryvalue_value
*
ERROR at line 1:
ORA-29855: error occurred in the execution of
ODCIINDEXCREATE routine
ORA-2: interMedia Text err
It's sys.props$ if it reflects global dbname.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 11:37 PM
>
> Just a guess..most possibly it is fetching from v$databaseAfter
cloning
> from production, if you
Gurus:
How can we find out if XML is installed in DB? I looked @ the v$option and
it doesnot say.
I have queried the dba_users for XDB user...is this the correct way? Please
help.
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Mu
Example given below is for the same user.
/home/govindank> sqlplus user/[EMAIL PROTECTED]
SQL*Plus: Release 8.1.6.0.0 - Production
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
Have you tried the kb?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowto&sd=MSDN&ln=EN-US&FR=0
this one caught my eye:
How to Configure IIS to Connect to Oracle from ASP and ADO
http://support.microsoft.com/default.aspx?scid=kb;en-us;193225
HTH,
-Roy
Roy Pardee
Programmer/Analys
Maybe from service_name in init ora file. David Wagoner <[EMAIL PROTECTED]> wrote:
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the na
Munish
How close do you need to be on sizing? The most accurate method is to
create a test table, load a sample of your data, analyze the table so you
get data in user_tables. Then you need to figure out the average number of
rows per data block. Then calculate the number of blocks your table
Just a guess..most possibly it is fetching from v$databaseAfter cloning
from production, if you don't change db_name explicitly for dev database ,
it will show production databse name in v$database
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <
Good point. Then run the following query:
select name from v$database;
HTH
GovindanK
On Thu, 11 Sep 2003 11:44 , Wolfgang Breitling <[EMAIL PROTECTED]> sent:
>What is your point? Mike Hately's statement is still correct. It returns
>the global_name which should be, but not necessarily IS, the
Title: RE: how can I see which database I am logged into without
My point was that you can see different names by using different queries. But, you and Mike brought up a good point- I need to use the "alter database rename global_name to XXX" after cloning databases to avoid any such confusio
HI,
I was wandering if a lot of people are copying statistics using dbms_stats
from production to test environment to see what will be the access plan.
If not used, why ? no time to look at it, bugged, not usefull ,... ?
Stephane Paquette
Administrateur de bases de donnees
Database Administrat
What is your point? Mike Hately's statement is still correct. It returns
the global_name which should be, but not necessarily IS, the same as
db_name since it can be set to any arbitrary value. Of course, if you are
using replication you better set it to the correct value or it will not work:
s
And don't forget file permissions issues either--especially if there
will ever be a firewall between your db and your users. If the docs are
in the db, users won't need OS perms to read/write/delete anything on
the filesystem...
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extensio
And possibly more than 20 tables in the hotel's restaurant ...
Tanel Poder wrote:
>
> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or whatever security desk
> operators I've had to turn down in past when they've looked for DBA
Title: RE: how can I see which database I am logged into without
You might get some surprising results from SELECT ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned from Prod. and it still lists the Prod. DB name with that query. Where is it reading the name from? You c
We are getting ready to migrate one of our instances from AIX 4.3.3
to 5.2. Do I need to get different media for this?
Thanks,
Peter Schauss
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-53
There is at least 2 Stephane : Stephane Faroult (Oriole), Stephane Paquette
(Standard Life)
Stephane
-Original Message-
Mladen Gogala
Sent: Thursday, September 11, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Standard life? I thought that you work for Oriole corp.?
--
Mladen G
At the time, no policy. Yes we were paying for the software.
Small market but a lot of visibility : IATA (International Air Transport
Association), ICAO (International Civil Aviation Organization) those 2 run
Oracle, plus all the UN organizations are non profit organizations.
Stephane
Title: RE: URGENT REPORTS WONT START
Getting error:
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException
One note I found on web said to comment out some tags. Doesn't seem to help.
Any ideas?
/u005/oracle/product/rdbms/admin> ls -l dbmstrig.sql
-rw-r--r-- 1 oracle dba 8657 Apr 28 2002 dbmstrig.sql
/u005/oracle/product/9.2.0/rdbms/admin> sed -n '76,85p' dbmstrig.sql
Rem returns the current database name
create or replace function database_name return varchar2 is
begin
retur
And the database must be muave.
--
Mladen Gogala
Oracle DBA
-Original Message-
Guang Mei
Sent: Thursday, September 11, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
There must be a "G" missing there. It should be "(20G or more Oracle
tables)".
Guang
-Original Messag
Standard life? I thought that you work for Oriole corp.?
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Stephane Paquette
> Sent: Thursday, September 11, 2003 11:39 AM
> To: Multiple recipients of list ORACLE-L
> Sub
Tanel...
thanks for your input...
both options are placed...
standby_archive_dest for managed recovery (that's the
goal)
and...
log_archive_dest_1 because when Oracle 'looks' for the
archive log files... uses this parameter to find them.
really, my problem is why my db are not synchronized!
:-
So that's what happened. OTN says "Due to Thursday's events at Moscone
Center, VP Product Strategy Ken Jacobs' keynote has been rescheduled for
11am on Friday.", but they didn't say what it the "events" were.
Bummer for OracleWorld folk that have to catch planes, I guess.
Rich
Rich Jesse
Nothing is known, except that the call came from the area code 425.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Johnston, Tim
> Sent: Thursday, September 11, 2003 1:54 PM
> To: Multiple recipients of list ORACLE-L
not according to the oracle documentation. A physical standby has to be
on the same platform/same operating system (including patches)/same
database release
logical standby databases do not have to conform to that restriction
--- Murali_Pavuloori/[EMAIL PROTECTED] wrote:
>
> Can we setup a phys
Hi!
standby_archive_dest only applies in managed recovery mode e.g. when you
issue "recover managed standby database".
In regular recovery case logs are searched from log_archive_dests by
default.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Hi...
I'm experiencing a problem with standby databases...
This is what I did:
1.- Setup primary database for failover with and
standby database ...everything ok.
2.- Setup standby database, setup ALMOST ok...
Why almost?, because I put (by mistake):
standby_archive_dest = "location=path/x"
af
Can we setup a physical standby on a different OS (Win 2003) than the
primary db (Win 2000).
Thanks in advance.
Murali.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://ww
Excellent..but most difficult part to pass through recruiters these
days...
Date: Thu, 11 Sep 2003 09:29:24 -0800
It is because of some oxes in HR departments
-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Tanel,
As I am st
http://news.com.com/2100-1012_3-5074383.html?tag=fd_top
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnston, Tim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.
You and Rachel are right, I meant to say background_dump_dest. I am
unfortunately on Windoze.
However--I have just realized that my standby is running under 9.2.0.4
and primary under 9.2.0.3, which is, uh, wrong! I'm going to upgrade
the primary machine and try again...
Thanks!
--- Stephane Fa
In Estonian language, the word "administrator" also means receptionist.
Guess how many former hotel receptionists or whatever security desk
operators I've had to turn down in past when they've looked for DBA job. Oh,
yes, some of them had over 20 years administrator experience in large
organization
It is because of some oxes in HR departments
-Original Message-
Sent: Thursday, September 11, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Tanel,
As I am still in the job market looking for any full time assignment, I see
all type of requirements like 5+ years 9i experienc
Hm, yep, it seems it works only in insert select
command (I tried an update with subquery) but didn't succeed).In this case
try following:
1) if you got partitioning option and have enough
space to store a temporary copy of your table in database, then:
SQL> create table t (id number,
lo
Tanel,
As I am still in the job market looking for any full time assignment, I see
all type of requirements like 5+ years 9i experience etc and will see in
coming weeks same for 10g( 5+ years experience with Oracle 10g)..
What you can do for this when dealing with recruiters who even don't
Title: Message
9.2.0.3 catalog works with 8.1.7, that I have tested personally. I don't
have a clue about 8.0.6.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]Sent: Thursday, September 11, 200
It's not trying to load another form. When you click OK, you get gray
box. If you look into test.fmb, you'll see "exit_form;" under button "OK"
John Shaw wrote:
Just a guess - but you might need to create / configure a provider for
forms - also you might check your display setting in the conf f
Speaking of non-profit organisations, what is Oracle's policy on that?
Do they sell Oracle software to non-profit groups?
Probably it's a small market at best, but Personal Oracle might meet their
needs.
Another group that comes to mind are high schools and colleges, they might
want to purchase
Alternately check in $ORACLE_HOME/dbs directory for alertSID. log. I
observed that people are still using defaults while creating databases
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 08:24:26 -0800
Unless th
Tanel,
Thanks. By the way congrat for becoming an OCM
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 11 Sep 2003 03:19:24 -0800
Hi!
Yes, the problem with own scipts was, that they tended go get "old",
especially when the sa
This is because you have the Applet loaded and that grey portion is the applet portion whose height and width is been defined in your dynamic HTML file generated by Forms servlet. This applet is used to talk to the Forms and displays them on the browser and after pressing the OK button, you are ex
Initial testing indicates that the bug(s) that caused index create/rebuild
online to lock a table and then get permanently stuck in a hung state have
been fixed.
It looks like 9.2.0.4 does NOT fix the problem of fatal 4031 situations that
can only be cleared by restarting the instance. So you ar
Do you have any more info??
If it's a variable problem, then try tracing (response.write) the global
variable locally, if it shows nothing, then that's the problem (IIS acting
childish again!!), if it does then check the connectivity by testing ODBC...
I've had no problems with either Microsoft o
Oracle9.2.0.4 on Windows.
I installed it yesterday and upgraded my test database, with OID, and it
worked fine.
It is available since 15AUG2003.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 12:2
You need to configure your TNSNames in your 9i Box.
Luis
-Original Message-
Sent: Monday, September 08, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Dear List,
I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on
oracle 9.0.1(two separate box) I have created
Unless they have radically changed how they handle physical standby
databases, you should have an alert log for that database.
Have you logged in as sysdba and checked the location of the
background_dump_dest in v$parameter?
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I've created a physica
This appears to be standard appearance. The
browser is not trying to display anything else. All you have done after you
press the OK is close the form. After forms closes it simply keeps the gray box
there.
-Original
Message-From: John Shaw
[mailto:[EMAIL PROTECTED]Sent: Thur
This seems strange to me, because things are written to the alert log file when the
instance starts, even when the database is not opened.
It should have been background_dump_dest (not user_dump_dest) and sometimes stuff is
written to $ORACLE_HOME/rdbms/log.
If you have looked for the file with f
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6, 8.1.7, 9.2.0
Before I begin
I have an rman catalog currently in 8.1.7
it supports catalogs for databases in 8.0.6
I wish to migrate using database migration assistant to 9.2.0 and keep the older catalogs in-place.
Wi
There
must be a "G" missing there. It should be "(20G or more Oracle
tables)".
Guang
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent:
Thursday, September 11, 2003 11:49 AMTo: Multiple recipients of
list ORACLE-LSubject: What
That same mentality applies to organizations with 100-200 users! After the
latest meeting with the Oracle rep, damagement is seriously considering
alternate database systems.
Abey.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, Septemb
I got a mail from a recruiter searching for Senior
Oracle Developers.
"Minimum of four years hands-on application
programming experience using Oracle RDBMS, including two years using Oracle
version 8.0 or higher on large databases (20 or more Oracle
tables)."
I've always wondered, where
I've created a physical standby database that seems to be performing
properly, but there's no alert log in user_dump_dest, nor anywhere else
on the machine. Is there no alert log until/unless the standby
undergoes a role transition?
TIA
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive
It's probably just someone executing some arbitrary code on your Windohs
box. At least according to Microsoft Security Bulletin MS03-039 pushed out
yesterday (Sep 10).
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex
I used to work for a large but non profit organisation (.org) and we were
using Oracle, the sales rep never send us Christmas card for sure
Stephane
-Original Message-
Mladen Gogala
Sent: Thursday, September 11, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
There should be
when i get a failure and oracle writes to my alert log, the job number does not match
to the one in dba_jobs.
any way to map these two different numbers? other than figuring it out from the error
message and the 'what' in dba_jobs?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.ne
There should be a low level pricing for home users, so that people who
download oracle may use metalink. I would pay for home support if it was
something like $150/ year for my Linux box. There should also be a low
price for small companies wih <16 users. One should be able to buy a 16
users
lice
Hi!
I wouldn't call it a real negative experience, but:
C:\Work\Oracle>sqlplus "admin/admin"
SQL*Plus: Release 9.2.0.4.0 - Production on N Sep 11 17:21:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Pr
Actually, I was wondering why Robert would care about 9.2.0.4 since his 10g
New Features book (Oracle Press, 0-07-222947-0) is due out this December.
Isn't 9i a little passé? :D
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech I
Just a guess - but you
might need to create / configure a provider for forms - also you might check
your display setting in the conf file.>>>
[EMAIL PROTECTED] 9/10/2003 4:49:29 PM >>>
Hi
1) Write a perl script which will rewrite the control file on the fly.
2) Write a script which will generate a symbolic link for the file du jour.
3) Do PURGE *.txt/KEEP=1 (I couldn't resist, it was the best OS ever).
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PR
I believe Mr. Ellison is responding to a lot of market pressure, and failing DB sales.
I know it would be a relief here to see this inplace soon, but as always the "DEVIL
is in the details".
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, Septe
Linking issues with installing 9.2.0.4 patch on HP/UX...
Had migrated a 8.1.7 database inplace to 9.2.0.2 whcih went fine and went to
apply 9.2.0.4 patchset and the relink splattered all over the place. Patch
requirments were vauge at best and found a list of required OS patches on
HP's tech site
Hallo,
Anyone whom could tell me if it is in an sqlloader possible to write for instance this
if you dont know the exactly name of file.
infile '/d31/datafiler/sema/incoming/konkurrenter.*'
If there are going to be files with different extensions fo rinstance the first time a
file is going to b
The way I handled a similar situation was to create a default SQL*Loader
file with something recognizable in the place that you want to do the
substitution (in your case, the infile filename). Then, I wrote a shell
script that created the correct filename and copied the default
SQL*Loader file to
I wonder if there is a list somewhere of all the nice things DUAL can say.
: )
Patrice.
-Original Message-
Sent: Thursday, September 11, 2003 8:05 AM
To: Multiple recipients of list ORACLE-L
Thanks about this tip, I didn't know about this one :)
Tanel.
- Original Message -
T
One more thing my database is 8.1.7, think this alter table
modify from long to clob is 9i feature
With Warm Regards
Siddharth Haldankar
Cisco Systems Inc. ODC
Zensar Technologies Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: [E
I have been struggling with an asp-based IIS web application one server, it
is tarting to look like a global asp variable is not being passed down to a
local asp variable.
Has anyone ever seen this type of thing before?
I have had a number of problems with this system, I am starting to wonder
how
1 - 100 of 119 matches
Mail list logo
