Hi All,
I have tried the Oracle Doc's but can't find the answer to what is the
difference between the two
Anybody can explain??
TIA
Jack
===
De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
de
I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old
tables / data to the new application on my conversion server. Now I have to
load it onto a test server at a different site. I will be using tables=
parameter to a select group of tables / data. I have not found the answers
change ...
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
HOME_COUNTER=2
DEFAULT_HOME=OraHome81
LAST_HOME=1
to
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
HOME_COUNTER=2
DEFAULT_HOME=OraHome81
LAST_HOME=0
Raj
__
Rajendra Jamadagni
Jack,
I assume you are asking this question in reference to the access path, or
explain plan, for a query.
Sort (Aggregate) -- Query returns a single row using a summary function but
does not include a GROUP BY clause.
Sort (Order By) -- Query includes an ORDER BY clause.
Sort (Group By) --
Title: RE: Exp / Imp Utility Questions
1) You cannot have read the docs to well not to know the answer to Q1
Hint - look at the ignore parameter to imp
2) It all depends if the triggers have been run once to change the data that is now in the conversion db.
You may have a trigger that adds 1
Although there are already so many responses I would like to add one more
You can of course put all logic in one trigger and then have control over
events
Sometimes it is impossible in the trigger because there is limitation of
trigger size (32 K)
So in that case You have to put logic in
Earlier versions of ORacle did not wrap the packages. Since the
source code was available well meaning dba's decided to help Oracle by
changing and recompiling these packages. This led to more than one
corruption and many a confused support analyst.BTW, the wrapped
package bodies
Ken Janusz wrote:
I'm doing a DB conversion to 8.1.7 on W2000. I have converted the old
tables / data to the new application on my conversion server. Now I have to
load it onto a test server at a different site. I will be using tables=
parameter to a select group of tables / data. I
Not quite true. Wrapped packages take same space (in fact more in dictionary
cache
and same space in library cache).
Best Regards,
K Gopalakrishnan
(408) 934 9310
-Original Message-
Sent: Friday, December 28, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L
Earlier versions of
You can use imp to move just the data. Just set ignore=y so that
when the object already exists it will move on. You are right
about the FK's and disabling them. As for triggers, it really
depends on whether or not you want them to fire...
-Original Message-
Sent: Friday, December 28,
I havn't tested, and did use the very ambiguous "supposedly", this was
in the documentation
when they first came out. Thanks for the correction.
John
[EMAIL PROTECTED] wrote:
Not quite true. Wrapped packages take same space (in fact more in dictionarycacheand same space in library
Actually, you bring up a good point. I never put logic in my triggers. I
always
use packages. That way, you can modify one piece of logic without affecting
the whole trigger. In many ways its much easier to maintain.
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, December 28,
Does anyone know how to put more than one control (.ctl) file in a single
parfile?
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat
Evelyn WoodDavid A. BarbourOracle DBA, OCPAISD512-414-1002Boivin, Patrice J [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]12/27/2001 10:50 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: RE: RE: database administration questions A
I am looking at my 2002 training schedule and would like to know if you can
recommend a class in any of the following dba topics :
1. RMAN
Setting and configuring RMAN
Backing up using RMAN
Recovery using RMAN
Note that I have taken the Oracle Backup and Recovery class for 7.3 before
they
Is she an OCP DBA? ;-)
-Original Message-
Sent: Friday, December 28, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Evelyn Wood
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/27/2001 10:50 AM PST
Please
What's the DBA_DML_LOCKS.LAST_CONVERT column ??
In catblock.sql for the DBA_LOCKS view it's described as follows:
last_convert - time (in seconds) since last convert completed.
What precisely does that mean? (Is it a religious term? :-)
Steve Orr
Snowing nicely in Montana now and the
I think the number of seconds since the lock was established (or converted
from/to) in this mode.
My guess.
Regards,
Waleed
-Original Message-
Sent: Friday, December 28, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
What's the DBA_DML_LOCKS.LAST_CONVERT column ??
In
List,
I plan
to upgrade to 9.0.1 soon, and looking through the documentation it is not clear
to me whether the 9.0.1 listener needs to be running prior to the upgrade
migration utility or not. My thinking is it should be running and tested
prior to the upgrade.
TIA
M.Godlewski
Title: DDL alter in execute immediate pl/sql procedure - dynamic sql
Anybody
using the "ALTER TABLE tablename MONITORING;" functionality? Just
wondering what the performance impact of implementing the features outlined in
MetaLink Doc 102334.1 was. Or is this another performance debate like
Hagedorn, Linda wrote:
If someone has a few minutes to read through this, I'd be most
appreciative. I could use a second set of eyes looking this over.
This procedure is designed to maintain a table/sequence map, executed
after an import and increment any sequences which have a lower
Of course Ross. How else do we know how long sadists like you are at work??
:-)
Dick Goulet
Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date: 12/28/2001 12:55 PM
LoL timed sadistics
-Original Message-
Sent: Friday,
LoL timed sadistics
Must be a RDBSM.
--
Regards,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
I've seen references that it is less than 1% impact, though I haven't
tried it myself.
You might try Steve Adams' site at www.ixora.com.au.
Jared
Brian
Pat, thats easy, geekcruises.com.
www.geekcruises.com, oracle odyssey, may 2002.
i personally will be talking about backup/recovery concepts(which will
include rman), oracle 9i data guard(failover, etc), both of those 3 hr
presentations.
check out the .pdf brochure, i'm sure what you are
Joe, when people ask questions during these presentations, do you
reply:
a. RTFM
b. Try it yourself and see
c. nope
?
;-)
--- Joe Testa [EMAIL PROTECTED] wrote:
Pat, thats easy, geekcruises.com.
www.geekcruises.com, oracle odyssey, may 2002.
i personally will be talking about
The DBMS_STATS.GATHER_SCHEMA_STATS procedure (with the GATHER STALE
option), which uses the information produced when a table is in
MONITORING mode, does not work properly in any current release of
Oracle (see bug 1890016 on MetaLink).
__
Do You
D: all of the above.
joe
Paul Baumgartel wrote:
Joe, when people ask questions during these presentations, do you
reply:
a. RTFM
b. Try it yourself and see
c. nope
?
;-)
--- Joe Testa [EMAIL PROTECTED] wrote:
Pat, thats easy, geekcruises.com.
www.geekcruises.com,
we have view named gain_view
which was created with this sql
SELECT co.name, sec.alias, sec.security_name, sec.security_symbol,
sq.open, sq.high,
sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume,
sq.total_value,
(((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS
29 matches
Mail list logo