Cool Tools have a tool that can assist with this
The Extraction and load tool from Databee
http://www.cool-tools.co.uk/
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
Thanks you all for your response
Ofer
-Original Message-
Sent: Thursday, September 19, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Testing against 8.1.7.4, the drop index was successful and an error was
reported by my long running query:
ERROR:
ORA-08103: object no
IF you can identify the problem rows automatically, and flag them as such in
your production environment, then you can have those rows automatically
copied (or moved - your choice) to your development machine (presumably
using database links). For what its worth, we have been doing just this
Title: RE: DBA work load - BDBAFH #1
H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all.
-Original Message-
From: Conboy, Jim [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 3:58 PM
To: Multiple recipients of list
Title: RE: DBA work load - BDBAFH #1
I wish I could chuck my catholicism just a little to do something just a little like that - man!
-Original Message-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 5:53 PM
To: Multiple recipients of list ORACLE-L
Title: RE: DBA work load - BDBAFH #1
[EMAIL PROTECTED]
Title: RE: DBA work load - BDBAFH #1
[EMAIL PROTECTED]
-Original Message-From: Pablo Campos Durante
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002
5:58 AMTo: Multiple recipients of list ORACLE-LSubject:
UNSUSCRIBE
[EMAIL PROTECTED]
If the schema has any complexity then manually identifying and extracting
the required dependent records can be quite troublesome. There is a white
paper on the DataBee web site entitled Test Database Generation and
Management that discusses the issues in some detail.
GRIN
Hallo,
What is UNSUSCRIBE...I have function in Access but cannot find in Oracle?
Please help.
-Original Message-
Sent: 01 October 2002 12:13
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 01, 2002 5:58 AM
To:
Just go for it! That's what I did, out of necessity, I just implemented it
and waited until it got better. 8)
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 30, 2002 8:48 PM
Ruth, just some experiments, going to implement
Paula,
It just takes practice. You can learn to say no. I did. You just have
to work up to it :)
You start with:
If I do that for you now, I will fall behind x days on the critical
project I am working on for you
move on to:
I'm sorry. I have too much to do
then to:
not gonna happen
Yes I am here running 8.1.7 and 9i Release 1 ( not release 2) on the same Windows 2000
Server Box.
So far so good, this is my test machine.
Rajesh
- Original Message -
Date: Mon, 30 Sep 2002 09:13:30 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
This is
And it already is much better. There are some holes, such as the REPORT
NEED BACKUP command lacking any awareness of archivelog backups (i.e. only
reporting the state of datafile backups alone), but it's easy enough to
write custom queries to deal with that. But calling it a hole might be
too
My favourite when they come to your desk...
Ah, I see the f..k up fairy has come to visit
(Apologies for profanity)
:-)
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
Paula,
It just takes practice. You can learn to say no. I
did. You just have
to work up to it :)
You start with:
http://careers.peopleclick.com/jobposts/Client40_HomeDepot2/BU1/External/259-277.htm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
the vms user oracle needs rights to the directory.
[EMAIL PROTECTED] 09/30/02 10:53AM
List,
I have a package that creates files on the server. The directory
location and file name are obtained from tables in oracle. The procedure
works as designed on Novell 7.3.4 and no changes were needed
No, but it shouldn't matter, should it? Isn't Oracle supposed to convert
between different NLS_LANGs on server and client? I would think that would
be shown by the fact that SQL*Plus works just fine from the same client.
Thx,
Rich
Rich Jesse System/Database
Hi Friends,
I had one of the oracle production database with 7.3.2 on AIX, I want to go
7.3.4 base first and apply patchset 7.3.4.4. Could any body have document
that takes me step by step process!! The documentation is there in CDs, But
not step by step process!!
Thanks in advance
peter.
With the economy in the tank and most of the
successful web businesses being the old bricks and
mortar stores with another means to penetrate the
market, did you expect otherwise? A web presence is
so passive that it is not much of an investment
without the ability to do collateral advertising.
Hey,
Anyone have any advice on indexing SYS tables? Specifically, I've been
experimenting with putting a reverse index on the TIMESTAMP# column of AUD$,
since almost all of my queries against the AUD$ views end with ORDER BY
TIMESTAMP DESC.
In 8.1.7.4.0 test DBs on HP/UX, the index -- created
Title: RE: DBA work load - BDBAFH #1
An ENRON executive in training.
-Original Message-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 5:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA work load - BDBAFH #1
I don't know how he can
Nah - I go for the subtle approach -
'YES?' - very, VERY loudly! And looking them dead straight in the eye...
(You should see 'em jump!)
peter
edinbugh
-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:38
To: Multiple recipients of list
3. You can use export with QUERY option to export just the
rows you need from each table in Production and import those
into Development database. However, it will depend on how
easy it is to get to the required data by the QUERY option
(available with Oracle 8i).
Can you elaborate how
Reverse key index won't help you in ORDER BY DESC, will it?
AFAIK Reverse-key index will store 'Naveen' as 'neevaN' and 'Rich' as 'hciR'
and so won't be helpful in ORDER BY DESC
Regards
Naveen
-Original Message-
Sent: Tuesday, October 01, 2002 8:58 PM
To: Multiple recipients of list
Gurus!
Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade?
I have gone throught the metalink docs and Oracle Documentation.
Thanks,
-Rachna
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachna Vaidya
INET: [EMAIL PROTECTED]
Fat City Network
You don't need reverse index to do: ORDER BY TIMSTAMP DESC. Regular
index should do it, even if you want it DESC.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 11:28 AM
Hey,
Make sure you have the directory name entry covered in INIT.ORA
e.g.
utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
utl_file_dir = D:\directory name3
You need one entry per directory that you want to write to using UTL_FILE
Package
Hope this helps
Regards
Shiva
Yes, you are obviously correct. I really need to RTFM. sigh Too many
pots on the stove!
Just a regular index, then. Any other input?
Thx!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
Rich,
Though I've never had this problem with Perl, I have had it with SAP.
If NLS_LANG is set incorrectly at the client, it won't work.
In your Perl:
$ENV{NLS_LANG} = 'whatever';
Try it, you might like it. :)
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
Hi Gang!
Is there any trick, or any gotchas, for re-orging IOT-style tables?
I have one that's growing, and the initial builder put PCTINCREASE
at 100 and I cannot change it with an ALTER TABLE.
Any suggestions? Docos? Magic potions?
Thanks,
Mike
---
We are in 8.1.7.0 and the bug 2225065 is not there.
From: Jesse, Rich [EMAIL PROTECTED]
Date: Sat, 28 Sep 2002 08:27:34 -0500
Subject: RE: Setting Cursor Sharing = Force in 8.1.7.3
Nat,
We are currently using CS=F on 8.1.7.2 and we'll be patching to 8.1.7.4
soon. You need to be made
On Tue, Oct 01, 2002 at 07:48:33AM -0800, Rachna Vaidya wrote:
Gurus!
Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade?
--
1. Don't be tempted to run below 8.1.7.4.
2. Do patch the listener vulnerability.
===
Ray
Again since the indexes store the row in ordered fashion, I guess a normal
index should be able to do ORDER BY DESC by reading backwards
Not sure though
Regards
Naveen
-Original Message-
Sent: Tuesday, October 01, 2002 10:33 PM
To: Multiple recipients of list ORACLE-L
Yes, you are
Rich,
I think you're crazy adding indexes SYS tables. I would *never* add
anything to sys objects. What are you going to do the first time something
goes wrong and you call Oracle support and you mention you added an index
and they say - hey, you're on your own! Not to mention that when you
Title: RE: disable validate on a partitioned table?
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
This is probably b/c the unique key does not include the partitioning key.
The unique key did include the partitioning key. Here is my example (Oracle 8.1.7.2.1
Matt,
Have you done a 10053 trace on this query?
Jared
Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/30/2002 11:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
If you have java installed be aware that there are a lot of changes with
8.1.7. If you have problems with the upgrade you *cannot* simply run
rmjvm.sql and initjvm.sql
There are two documents on removing and installing java which are must reads
(I don't have the numbers handy, sorry). Allow a
Title: RE: extremely long parse time
I know what a 10046 trace does. What's
a 10053 trace?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Their fundamental design flaws are completely
hidden by their superficial design flaws.
- Douglas Adams
-Original Message-
From: [EMAIL
Actually I called the group that handles 24 hour monitoring and emailed
anyone else who might potentially be interested (hence getting in early the
next day).
The next day I was called on the carpet because I didn't get the name of the
person I spoke with the previous night and they had to wait
Title: RE: extremely long parse time
It reports all the parameter settings and the base
statisticsthat Oracle takes into account when choosing a plan.
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01,
2002 12:56
Oracle Corporation has a peculiar habit of providing scripts and solutions which it
does not support officially. One of them is moving sys.aud$ out of SYSTEM
tablespace. See note 1019377.6 on MetaLink.
inka
-Original Message-
Sent: Tuesday, October 01, 2002 1:18 PM
To: Multiple
Thats a CBO trace. Have fun trying to read it :) Actually, there was an
excellent presentation from a Wolfgang Breitling on this very topic at IOUG.
And I believe Cary's site carries it (hotsos.com).
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002
Listen to great,
i believe its
utl_file_dir=dir1,dir2,dir3,...
in your example, dir 3 would be the only valid dir.
hth,
gene
[EMAIL PROTECTED] 10/01/02 12:53PM
Make sure you have the directory name entry covered in INIT.ORA
e.g.
utl_file_dir = D:\directory name1
utl_file_dir = D:\directory name2
Title: RE: extremely long parse time
It is useddiagnosing optimiser problems. The trace
showsthe optimiser access
path.One of those "should NOT be
used unless explicitly requested by support"and not documented features.
inka
-Original Message-From: Adams, Matthew (GEA, MABG,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Yes, the site is http://www.hotsos.com/dnloads/1/10053/Breitling2002.pdf.
Requires free membership
John Kanagaraj
and the latest I have heard is that they no longer will support moving
AUD$. Even though it's listed on MetaLink
--- Inka Bezdziecka [EMAIL PROTECTED] wrote:
Oracle Corporation has a peculiar habit of providing scripts and
solutions which it does not support officially. One of them is
Thanks, Tom. That's the kind of feedback I'm looking for. Anyone else?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL
I also found that I had to use SVRMGRL instead of SQLPLUS
when doing the Java install. Dunno why. HP-UX 11.0 and 11i.
I think it takes so long because it is reloading and revalidating
the whole entire Java library. I guessing.
My 2ยข worth...
Mike
-Original Message-
Sent: Tuesday,
LOL.
Any Cicely Mary Barker JPEG of the fairy to put on my desk ?
Connor McDonald wrote:
My favourite when they come to your desk...
Ah, I see the f..k up fairy has come to visit
(Apologies for profanity)
:-)
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
Paula,
It
Title: RE: disable validate on a partitioned table?
Try
this before exchanging segments:
alter
table country_temp add (constraint country_uq2 unique (country_founded) disable
validate) ;
Waleed
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Tuesday,
Interesting. Depressing, but interesting. In Korn:
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
...and all's well with SQL*Plus. But with Perl/DBI:
DBI-connect failed: ORA-12705: invalid or unknown NLS parameter value
specified (DBD: login failed) at ./cursor_sharing_yes.pl line 17
Can't
Thanks to all of you for the assistance.
I have the package working by coding the directory into the
utl_file.fopen command and the files are being created okay. I got the
batch procedure to work with the SQLLDR command( I did not know you had
to set noon and each line starts with a $). It works
Title: Message
hehehe... yea or a
euthaniser
the Humane Society
;-
An ENRON executive in training.
-Original Message- From: Bob
Metelsky [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work
Here is how:
exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\
When executing this command, Export builds a SQL SELECT statement similar to
this:
SELECT * FROM EMP where job='SALESMAN' and sal 1600;
(From Utilities Guide)
- Kirti
-Original Message-
Sent:
This is in 8.1.x and higher, not 8.0.x, right? Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 3:39 PM
Here is how:
exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\
When executing this
Hope this helps.. look for Upgrading Oracle7 databases...
http://www.bijoos.com/oratom/ot_200101.htm
Google
-Original Message-
Sent: Tuesday, October 01, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Hi Friends,
I had one of the oracle production database with 7.3.2 on
If anyone out there is using SQL Backtrack to backup Oracle I am looking for
a home grown reporting
script that will give me start and stop times for all the backups on the log
file.
Thanks!
R. Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
Right, you are!
- Kirti
-Original Message-
Sent: Tuesday, October 01, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
This is in 8.1.x and higher, not 8.0.x, right? Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
Kirti,
You are always helpful. Just to add further...
It is more easier to use export.par file where you can put query clause very
easily ie without back slashes like
query= where invdate between '29-DEC-97' and '03-JAN-99'
HTH,
Regards
Rafiq
Note: Bob, this is for 8i and up
Reply-To:
Here is how:
exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and
sal\1600\
Wow! Very cool, thank you...
bob
When executing this command, Export builds a SQL SELECT
statement similar to
this:
SELECT * FROM EMP where job='SALESMAN' and sal 1600;
(From Utilities
Yes it does, at least on my test instance.
Thanks!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October
[first post bounced from fatcity.com with /var/spool/mail/autoresp:
Permission denied. among other errors]
I think I'm getting somewhere, but the research has given me the security
heebie-jeebies.
As I'm tracing at SUPPORT level on the server side of a test DB (can't trace
on the client
I am trying to find out for a given table the column names for the parent
table to which the referential integrity is built upon. for example, table B
has primary keys=id, date_exam that are a foreign keys to table a, which
has variable name pt_id, date_start. This is the query to deliver the
Rafiq,
Thanks.
Absolutely, using par file has many such advantages (hiding
username/password being one important other ;)
- Kirti
-Original Message-
Sent: Tuesday, October 01, 2002 3:03 PM
To: Multiple recipients of list ORACLE-L
Kirti,
You are always helpful. Just to add
Thanks...
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 01 Oct 2002 13:13:32 -0800
Rafiq,
Thanks.
Absolutely, using par file has many such advantages (hiding
username/password being one important other ;)
- Kirti
-Original
I see this now at the docs...
Bob Metelsky Client Services Development
Phone 203-245-5089 ext 113 Fax 203-245-5001 Office 203-245-5000
Continuum Performance Systems Inc. http://continuumperformance.com/
PGP Public Key http://continuumperformance.com/cps.gpg
-Original Message-
I'd appreciate it if anyone who has been down this road before can
summarize what they've learnt (DSN option values, MySQL config options etc).
We're using Solaris 8, Oracle 8.1.7, MyODBC 3.51 and have got as far as
getting a basic connection working so we can do simple selects.
Before I dive
Also only available on Enterprise Edition.
- Babette
-Original Message-
WILLIAMS
Sent: Monday, September 30, 2002 10:03 PM
To: Multiple recipients of list ORACLE-L
Brian - Since nobody seems to have responded to your question, yes, there
are plenty of opportunities for gotchas with
alter table move storage (pctincrease 0) should do the trick. For
speed, you might want to add parallel and nologging, perhaps. If you're
feeling frisky, you can add the online keyword as well...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Rachna - Decide carefully on which 8.1.7 version to upgrade to. Which
platform are you on? That may help someone give you advice specific to your
platform.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, October 01, 2002 10:49 AM
To: Multiple
Hi all,
I'll be seeing the dark side of the force as I'll be
the DBA on a DB2 UDB project.
Is there a list like this one for DB2 ?
Any links to DB2 stuff ?
I'd be interested in documents showing the
differences/similarities between Oracle and DB2 UDB.
Let's see our bargaining power with our
Dear all,
I have a situation where I need to find out the patches applied on
different Oracle Application 11i (11.5.5) env. We have two environment PROD
and TEST. It seems that there are some patches applied to TEST in the past
few months. I would like to know what patches are applied on
Ave !
I like to hear Your opinion about the most importat
issues, what should be monitored from the database (8.1.7, SUN) during
perfomance testing. The purpose in this case, is limit the
monitoring to concern only about 10 most important ones.
I have difficulties to make my mind to pick up the
1 October 2002 19:28, you wrote:
Hi Friends,
I had one of the oracle production database with 7.3.2 on AIX, I want to go
7.3.4 base first and apply patchset 7.3.4.4. Could any body have document
that takes me step by step process!! The documentation is there in CDs, But
not step by
76 matches
Mail list logo