information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I thought this might be relevant and interesting...
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr
ack=NL-93
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
responded by saying
the redundant constraints wouldn't be a problem in sql server. ...something
I'm almost positive they haven't validated either.
Thanks!
chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network
of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris
The logical explanation is that activity
in your database varies from day to day.
Try sitting back and keeping the size the
same for a while and watch the space taken.
Chris
-Original Message-
From: Mauricio Vilez
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004
://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
being a bug in 9203. Not sure which bug.
Support insisted that we patch to 9204 and the problem went away.
Thanks for everyone's help.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
-- global.client_dim?
Is it a [partitioned] table, [m]view or synonym for some other object?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Chris Stephens wrote:
SQL select sys_context('userenv','session_user
see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
SELECT count(*)
2 FROM global.client_dim a
3* WHERE TRIM(sys_context('userenv','session_user'))
=TRIM(a.REPORTS_LOGIN)
SQL /
COUNT(*)
--
0
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network
','session_user') = a.REPORTS_LOGIN;
Daniel
Chris Stephens wrote:
I just tried:
1 SELECT count(*)
2 FROM global.client_dim a
3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN
SQL /
COUNT(*)
--
1
...but we had a problem 2 weeks ago where
, WI USA
-Original Message-
From: Chris Stephens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL comparison addition:
I just tried:
1 SELECT count(*)
2 FROM global.client_dim a
3* WHERE
, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
Chris
There is a contradiction below:
Chris Stephens wrote:
SQL select sys_context('userenv','session_user'),
2 dump(sys_context('userenv','session_user')), a.reports_login,
3 dump(a.reports_login)
4 from global.client_dim a
5
Title: Message
Anyone have any experience in synchronizing
Apps HR (11i) information with OID (902)? We are looking at ways to
automatically generate portal accounts out of the HR module. There is documentation
on this in TFM's and it doesn't look all that hard. However,
I talked to
Title: Message
I am writing a procedure to generate a
company calendar and to allow for scheduling various resources in the
organization. This will run as a portlet and I need to verify that the
user has been authenticated through portal before I allow them to
add/edit/delete entries.
Title: RE: RE: Cary's Book - new topic
http://www.eweek.com/article2/0,4149,1312906,00.asp
Title: Message
I've been looking to do this for a
while...would you mind sharing the script??
Thanks either way!!
chris
-Original Message-
From: Sujatha Madan
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003
11:29 PM
To: Multiple recipients of list
ORACLE-L
be with you.
On Thu, 2003-10-02 at 18:39, Chris Stephens wrote:
Oracle EE 8.1.7.2HP-UX 11Can anyone explain this? 1* INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL)SQL /INSERT INTO EMPLOYEE_ROLE VALUES ('C', 'CSR',NULL) *ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00942
!!!...and everyone's help for that matter!
chris
-Original Message-
Sent: Friday, October 03, 2003 10:11 AM
To: Chris Stephens
Then, you have to use oradebug.
It goes like this:
oradebug setmypid
oradebug event 942 trace name errorstack forever, level 10
You MUST be connected as sysdba in order
?)
something other than a table?
Synonym that the inserter only has select on?
see what you can find in all_objects or all_tables
-Original Message-
From: Chris Stephens
To: Multiple recipients of list
ORACLE-L
Sent: 10/2/2003 5:39 PM
Subject: Seems odd to me(bug?)
Oracle EE
by an existing object
Any ideas?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: Message
http://www.business2.com/articles/mag/0,1640,51816,00.html
-Original Message-
From: April Wells
[mailto:[EMAIL PROTECTED]
Sent: Friday, August
29, 2003 1:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: The Coming Job Boom
Oh it's okay...
Title: nothing directly related to Oracle...but certainly relevant...
http://story.news.yahoo.com/news?tmpl=story=/nm/20030729/tc_nm/tech_jobs_dc_1
the world is changing quickly.
Chris
Current DBA in-progress...future ???
Yes it is. We actually had to do it for a
canned app that checked the exact version of the database...for no apparent
reason. The app would only run on 8.1.6 and we were running 8.1.7...so we
just created a table with the exact same structure as v$_version and update the
table to reflect
-
From: Chris Stephens
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 3:04
PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle Banner
Yes it is. We
actually had to do it for a canned app that checked the exact version of the
database...for no apparent reason. The app would only run
Title: bad press for oracle
http://rss.com.com/2110-1017_3-5053453.html?type=pt=rss=feed=news
Title: RE: faq broke? -- Other options
There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDNT want to do this.
-Original Message-
From: Hallas, John, Tech Dev
I believe
(I could be totally wrong here) the reason for the CURRENT OF is both for
performance and consistency.
The second example has to run the update statement seperately. CURRENT
OF can go directly to the row(s) affected. CURRENT OF still has to modify
each block header in the
]]
Sent: Friday, July 11, 2003 3:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: full usefullness of CURRENT OF ???
--- Chris Stephens [EMAIL PROTECTED] wrote:
Also, the CURRENT OF locks the table so that no one can modify (or
even read) it while the transaction is taking place
Title: Oracle text question
I briefly looked over the documentation and wasn't able to find what I was looking for so I thought I would check here before I spend the rest of my day searching
Anyone familiar enough with Oracle Text to give some estimates on the total amount of storage
it belongs on everyone's bookshelf!!!
[Chris Stephens]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!!
[Chris Stephens]
Title: RMAN question
List,
When I got into work this morning I noticed u01 was nearly full on out production OLTP machine. I found the files and the looked to be RMAN files.
They were all in '$ORACLE_HOME/dbs/.' My first thought was that they were the snapshot controlfiles. but
Title: RE: log buffer space
I think this might help...
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 14, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: log
Title: RE: Excessive SQL*Net message from client waits
This is an idle wait event that just means the server is waiting to be given some work from the client. Looks to me like you won't be needing to do any tuning on this database.
-Original Message-
From: Karen Morton [mailto:[EMAIL
Title: Oracle Database audit...
This may or may not be of value...
Under the Security:
Possibly users with the oracle account password on the machine?
This would obviously allow people to conn / as sysdba.
Maybe? :)
Have a good one!
Title: Oracle Database audit...
Oops.
This wasn't meant to go to the list.
sorry
-Original Message-
From: Chris Stephens
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003
12:20 PM
To: Multiple recipients of list
ORACLE-L
Subject: Oracle Database audit
Title: RE: update 30mil rows
You did enable parallel dml right?
=alter session enable parallel dml;
-Original Message-
From: Gurelei [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 25, 2003 3:27 PM
To: Multiple recipients of list ORACLE-L
Subject: update 30mil rows
Hi all:
Title: RE: newbie sqlplus ?
Launch $ORACLE_HOME/bin/dbassist and delete any database you have created.
Then launch the installer from your oracle cd and select deinstall option to deinstall the software.
chris
-Original Message-
From: Les Ayudo [mailto:[EMAIL PROTECTED]]
Sent:
still delete the old db
w/ dbassist after the install?
- Original Message -
From: Chris
Stephens
To: Multiple
recipients of list ORACLE-L
Sent: Monday,
February 24, 2003 1:30 PM
Subject: RE: newbie
sqlplus ?
Launch $ORACLE_HOME/bin/dbassist and delete
w/o the install going haywire? Can I still delete the old db
w/ dbassist after the install?
- Original Message -
From: Chris
Stephens
To: Multiple
recipients of list ORACLE-L
Sent: Monday,
February 24, 2003 1:30 PM
Subject: RE: newbie
sqlplus ?
Launch
Title: storing credit card numbers in a database
I've been asked to find out a way to encrypt credit card numbers and store that encrypted string in the database. ...any oracle functions or functionality to do this? or would we have to encrypt the numbers in the application and then pass
Title: RE: Oh Where Oh Where Is My Redo Coming From
I don't think this is possible but I
would like to confirm here.
I would like to create a function based
index to speed up the OH SO SLOW query that follows:
SELECT dmzu.ZIP_CODE
FROM dm_zip_unq dmzu
WHERE fnc_dist(some
Title: yapp_pack.zip
List,
I've recently run this EXTREMELY useful set of scripts from miracle A/S to chart various info from my statspack snapshots. They work without modification on 8.1.7 but not on 9.2.
I was just wondering (before I attempt to modify myself) if anyone had updated these
: Chris Stephens
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003
2:50 PM
To: Multiple recipients of list
ORACLE-L
Subject: yapp_pack.zip
List,
I've recently run this EXTREMELY useful set of scripts
from miracle A/S to chart various info from my statspack snapshots. They
work without
:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: yapp_pack.zip
google can't find yapp_pack.zip, where did you find it?
On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote:
List,
I've recently run this EXTREMELY useful set of scripts from miracle A/S to
chart various
Title: RE: Oracle 8i or 9i ?
The $3000 is true if he takes them through 'oracle' university but not if the local community college offers the classes.
What I did (and it seemed to work fine) for my 8i certification is to go to the community college bookstore and just buy the 'official'
Title: RE: [Q] how to start intelegent agent on ORACLE 9.2 version?
Agentctl start (from the command line...not in lsnrctl)
-Original Message-
From: dist cash [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 13, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: [Q]
Title: auto backup and spfile restore
Well,
I found the problem.
There
was still a pfile in the default location.
The
only entry in that pfile was 'spfile=...'
Since
that spfile had been deleted, the file not found error message was
returned.
When I
delete the pfile, the recovery worked
Title: RE: Configuring back up in Oracle 9i
look in your configuration-preferences-preferred credentials.
you not only have to have the sys password set for 'target type=database' but you also have to have the proper password set for 'target type=node' (machine where your database is.
chris
Title: auto backup and spfile restore
List,
We are in the process of testing every recovery scenario we can think of using rman. We don't use a catalog and controlfile autobackup is on which implies the spfile is automatically backed up.
So one of the scenarios was to delete the spfile and
Title: question about rman
I could test this myself but that would require coordination with the system administrators and they always seem to think their time is too important for testing. :)
i would like to implement RMAN in and 8.1.7.2 oltp environment and 9.2.0 warehouse environment. We
!
-Original Message-From: Chris Stephens
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003
10:45 AMTo: Multiple recipients of list
ORACLE-LSubject: question about rman
I could test this myself but that would require coordination
with the system
Title: RE: question about rman
...i didn't mean that the mount points disappeared. ...what i was getting at was that the data in the 'backup' mount point
was overwritten with each new backup. sorry about the confusion. :)
...i think my question has been answered. the required files need
and
it is ready to be written to tape. At least that's
what happens with Legato.
Regards,
Sujatha
-Original Message-From: Chris Stephens
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, 22 January 2003
7:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: question
Title: temp space
after
utilizing a pl/sql routine found on asktom.com we were able to catch the
offending query that was consistently causing the 1652. (this isn't
something that you can capture from the v$ views if the session has disconnected
(at least i know of know way)) ...anyways the
Title: 100% CPU utilization, urgent
we had
a problem with cpu usage and it ended up being the 'intelligent' agent.
...after some consideration we decide there wasn't any reason we HAD to have the
agent running so we just shut it down.
...just a shot in the dark.
chris
-Original
Title: RE: Positive comments
what has happened to Steve Adams? Please say he's too busy writing another book to bother with this list! :) I recently read his book 2 times through back to back. ...oh what a read!! ...but I also noticed he hasn't answered questions on his website since 2001.
Title: temp space
anyone know how to identify the session that caused a ORA-1652?
-thank you
There
are other reasons for this but...
I
think the primary reason is to server data warehouse functions. i.e.
if you have an oltp database with a small block size and want that data into a
staging area as quickly as possible, you are now able to use transportable
tablespaces because the
Title: RE: Ideas for future authors
care to share that method?? :)
-Original Message-
From: Stephen Andert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Ideas for future authors
I know I've really enjoyed
absolutely.
-Original Message-From: BigP
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16,
2003 11:29 AMTo: Multiple recipients of list
ORACLE-LSubject: one datafile lost.
Just wondering what will happen in this condition
.
supposse I have two tablespaces
Title: RE: RMAN backup - basic Qs
what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case?
many i'm missing something.
-Original Message-
From: Ruth Gramolini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 1:54 PM
Title: Internet file system
as per usual, technet website is confusing as heck. I am trying to locate the latest release on IFS. I am on the products website and see the following on the IFS webpage:
Content Management Software Development Kit (CMSDK)
Version 9.0.3
(Note: this release
Title: RE: Some of you may find this useful
what is it that i am looking at after running this query??
pardon the ignorance.
chris
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Title: RE: warehouse builder's dependance on oem job system.
wow. thank you. i will be testing this in the afternoon but before i do, i have one more question. we have ~50 jobs we would like to cron instead of submit to oem. so my question is, are these tcl arguments in the same order and of
Title: warehouse builder's dependance on oem job system.
ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for
-From: Chris Stephens
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002
11:31 AMTo: Multiple recipients of list ORACLE-LSubject:
warehouse builder's dependance on oem job system.
ok, here's the situation: we are loading our warehouse
via etl processes generated
. Thank you.
-Original
Message-From: Chris
Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 12:31
PMTo: Multiple recipients of
list ORACLE-LSubject:
warehouse builder's dependance on oem job system.
ok, here's the
situation: we are loading
recipients of list ORACLE-L
in the past there was a way described here on the list, TOTALLY
UNSUPPORTED by tweaking one of the underlying views.
joe
Chris Stephens wrote:
i'm 99% sure that can't be done. you'll have to explicitly name all
the other users with owner=user_a,user_b
Title: RE: export in full mode but exclude particular user?
i'm 99% sure that can't be done. you'll have to explicitly name all the other users with owner=user_a,user_b,... ...then you can do an import with full=y ...or flip/flop by full=y on export and owner=.. on the import.
...first
79 matches
Mail list logo