RE: Is it possible to copy one db to another if the SID is differ

2002-10-09 Thread Stephen Lee
the same catalog database. -Original Message- Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: Is it possible to copy one db to another if the SID is differ

2002-10-09 Thread Stephen Lee
or consider note: 174625.1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Advice needed on move to Sun 15K (losing spindles)

2002-10-11 Thread Stephen Lee
might be a good idea. Thus far, all I have ever gotten on this subject is a lot of religion and very few proven facts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Advice needed on move to Sun 15K (losing spindles)

2002-10-11 Thread Stephen Lee
and disks. If I can believe the Sun rep (ehem) there should be no interference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Advice needed on move to Sun 15K (losing spindles)

2002-10-14 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: Password_grace_time and JDBC

2002-10-15 Thread Stephen Lee
Message- set up a Password_life_time of 30 days and a Password_grace_time of 5 days. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Over Consumption of CPU ?

2002-10-15 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: Need help from anybody using veritas netbackup on Nt

2002-10-16 Thread Stephen Lee
If the NT admins are backing up up your data files, there is a high probability that your files are getting locked by that. You must tell the admins not to backup any file system ... er "folder" ... that contains files used by the Oracle instance. In other words, your problem might have

RE: Multiple Listeners

2002-10-16 Thread Stephen Lee
LIST_V817 $ORACLE_HOME/bin/lsnrctl start LIST_V817_2 export ORACLE_HOME=$ORACLE_BASE/product/8.1.7.4 $ORACLE_HOME/bin/lsnrctl start LIST_V8174 etc. etc. etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: Multiple Listeners

2002-10-16 Thread Stephen Lee
-- Author: Stephen Lee 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 this mailing list, send

RE: Multiple Listeners

2002-10-16 Thread Stephen Lee
-Original Message- even Oracle will tell you that running multiple listeners is worse than foolish.:) Please supply the link to Oracle's article with this statement. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: Multiple Listeners

2002-10-16 Thread Stephen Lee
: Stephen Lee 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 this mailing list, send an E

RE: Specify Rollback for an Export

2002-10-18 Thread Stephen Lee
the export time using the direct=y parameter. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to pass value from SQL*Plus to Unix scripts?

2002-10-25 Thread Stephen Lee
$HOST_NAME irvlvru01 # echo $INST_NAME sdu1806a # -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Multiple Listeners

2002-10-17 Thread Stephen Lee
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: how to release blocks of table?

2002-10-17 Thread Stephen Lee
]*MINEXTENTS nil t) (replace-match INITIAL 1M NEXT 1M MINEXTENTS nil nil)) (save-buffer) Run the following to fix the dump file test.dmp: emacs -batch test.dmp -l fix-extents.el -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: SQL*Plus COPY error solved (sort of)

2002-10-25 Thread Stephen Lee
, 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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: SPARC-III v Alpha

2002-10-28 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Scripts for creating Tables/schema's

2002-10-28 Thread Stephen Lee
- i wanted a script which contains the create table/schema's for a existing database. How to get this script ? any utitlity or which option to be selected for achieving this after i install Oralce ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET

RE: RAID5+

2002-10-28 Thread Stephen Lee
And the date of the paper. Excuse my ignorance: I know what RAID 5 is, but what is 5+ ? -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAID5+ What would interest

RE: Unix Q: Substring-ing an output.

2002-10-28 Thread Stephen Lee
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL*Net Message to client/SQL*Net more data to client

2002-10-30 Thread Stephen Lee
of unexplained behavior. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Moving datafiles, controlfiles, and redos.

2002-11-04 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: Unkillable Background process SHUTDOWN ABORT LEAVES UNKILLAB

2002-11-05 Thread Stephen Lee
= -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: full exp/imp of user to new tablespace; same user

2002-11-07 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: CPU Problem

2002-11-08 Thread Stephen Lee
not be based on some percentage of CPU usage, but on what is normal usage for this particular database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: When will Oracle 10i be out?

2002-11-08 Thread Stephen Lee
FAQ: http://www.orafaq.com -- Author: Stephen Lee 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

RE: Destination address unreachable

2002-11-08 Thread Stephen Lee
ever actually WORK in a database shop; or have you spent all your time studying certification? Or are you just an amazing genius who is able to do both (in which case, you certainly don't want to work here!)? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee

RE: When will Oracle 10i be out?

2002-11-08 Thread Stephen Lee
? The old strategy of Planned Obsolescence? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Data Purging Strategy

2002-11-08 Thread Stephen Lee
? Another option might be a typical fruit cake -- the season for which is almost upon us. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Solaris vs Windows 2000

2002-11-11 Thread Stephen Lee
be an excrutiatingly painful experience ... If you even succeeded at all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Solaris vs Windows 2000

2002-11-12 Thread Stephen Lee
machines, I think you'll find that those don't come cheap either. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Schedule Backup in UNIX

2002-11-12 Thread Stephen Lee
-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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

RE: Solaris vs Windows 2000

2002-11-12 Thread Stephen Lee
-Original Message- Unisys, however, does make a 32-way box. --- Didn't I see somewhere that they are going to change their name to Winisys? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: Oracle 10i features

2002-11-12 Thread Stephen Lee
-- Author: Stephen Lee 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 this mailing list, send

RE: Oracle 10i features

2002-11-12 Thread Stephen Lee
replacement I started... sigh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Backup/Restore

2002-11-12 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Backup/Restore

2002-11-12 Thread Stephen Lee
: Backup/Restore Stephen: Thanks a lot for Ur response. How do U restore from the backup? have a script? --- Stephen Lee [EMAIL PROTECTED] wrote: You don't say if you are using catalog or not. If not, be sure to backup control files at end of backup

RE: Solaris vs Windows 2000

2002-11-13 Thread Stephen Lee
of support available for it already today - Dell, RedHat, Oracle IBM all support Linux. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Solaris vs Windows 2000

2002-11-13 Thread Stephen Lee
18 Gig SGA. And there are two other (smaller) databases on this box. -Original Message- I don't understand. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: AIX vs Solaris

2002-11-13 Thread Stephen Lee
to consider is the amount of third-party vendor support. -Original Message- What are the major differences between AIX and Solaris regarding operating system features? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: Installing 8.1.7 on a machine with an existing 9.0.1 installa

2002-11-14 Thread Stephen Lee
Could you please say which window and when? -Original Message- I'm about to throw my laptop out of the window -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Monitoring Unix Question

2002-11-14 Thread Stephen Lee
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread Stephen Lee
: Stephen Lee 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 this mailing list, send an E

RE: surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread Stephen Lee
of the OS (Tru64) doesn't work properly with the cache on this storage system. They are in the process of changing the version of the OS. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: RE: surprising result:8CPU Sun 3500 VS 4CPU Dell 6650

2002-11-15 Thread Stephen Lee
. One thing is for sure: There is certainly a lot to consider! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: AIX vs Solaris

2002-11-19 Thread Stephen Lee
for easier Solaris syatems admin? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Password Generator...

2002-11-21 Thread Stephen Lee
time; and it's free. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Problem doing RMAN backup of Clone?

2002-11-25 Thread Stephen Lee
it has the same database id as the original. Is this true or not? If so, how to get around it? --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: A way to restore a DB

2002-11-25 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: how do I calculate the Oracle's usage

2002-11-25 Thread Stephen Lee
/ {sum = sum + $1}; END {print sum}' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE:

2002-11-25 Thread Stephen Lee
this guy the table is not there. What else can I do? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
hardware errors when it can't reliably maintain redo logs? Pending further evidence to the contrary, I'll take mirroring external to Oracle as the better choice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: Oracle 9i installation - Basic Qs

2002-11-26 Thread Stephen Lee
PC Client IP Address Xlib : cannot set display to PC Client IP Address NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
to exist. That being the case, I must go with the arrangement that I think offers fault tolerance with the best performance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
-Original Message- Stephen, Nothing is gained by personal attacks in this forum. Please enlighten me. Exactly what personal attack was made? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: LGWR using lots of CPU time, low CPU usage

2002-11-26 Thread Stephen Lee
I don't think changing the logmembers will do much good I agree. 4 groups, they are on the local drive. BOOM!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: SQL tuning help

2002-11-26 Thread Stephen Lee
sid from v$session where last_call_et 100 and sid 10 and osuser is not null) and w.session_id = a.sid and h.session_id = b.sid; -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
courses and come away entirely untrained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: LGWR using lots of CPU time, low CPU usage

2002-11-26 Thread Stephen Lee
writing will definitely incur overhead. Now, the part about it all being on the local drive: That still is BOOM!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Imp of all users tables

2002-11-26 Thread Stephen Lee
to all the tables of that user. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
on top of the array to boot. What will your vaunted Oracle multiplexing do for you then? Huh? Well, smarty pants, I'm waiting! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-26 Thread Stephen Lee
the database and application were running full blast. It never failed once (except for early Veritas on Motorola 88K which was a mess). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: OSF11 in TRU64 Unix

2002-11-27 Thread Stephen Lee
)/oracle/app/oracle uname -a OSF1 box.domain.com V5.1 732 alpha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
to be rampant out there, with mischievous people running around deleting files. I kept reading about it and thinking you've got to be kidding. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
actually caused disk writes to be unreliable (OH MY GOD!!). And we wound up with a G.D. mess in spite of the redos being duplexed all nice and official. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Oracle OS level security

2002-11-27 Thread Stephen Lee
-- Author: Stephen Lee 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 this mailing list

RE: redo log file setup with mirrored drives

2002-11-27 Thread Stephen Lee
and survive in these environments. You have your debates; break a few chairs in the ensuing fight; then go out for lunch. It's all a nice break from the daily routine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: is it possible ?

2002-11-27 Thread Stephen Lee
separate environments, it should work ... we're talking Unix here right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Oracle 8.1.6 Installation error

2002-11-27 Thread Stephen Lee
a different installation location, the installer would not find the other inventory file and, consequently, have no idea what was on the box in the other location. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: patches

2002-11-27 Thread Stephen Lee
: cd /path/path/product/8.1.7 find . -print | cpio -pvmud /some/backup/directory -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: redo log file setup with mirrored drives

2002-11-30 Thread Stephen Lee
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE:

2002-12-03 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE:

2002-12-04 Thread Stephen Lee
-- Author: Stephen Lee 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 this mailing list, send

Something that might be of use

2002-12-04 Thread Stephen Lee
written by Stephen Lee because we've ** ** been needing something like this real bad for a while. ** ** If you leave the section that opens the files commented, ** ** then the syntax would be something like: ** ** modify_extents dumpfile modified_dump_file

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
-Original Message- it has GUI interface and a lot finer control over the GUI's are evil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Archived logs backup

2002-12-05 Thread Stephen Lee
TO TAPE if [ $? -ne 0 ]; then print SOMETHING BROKE else rm $i (or maybe safer to move it to a pre-delete filesystem, then delete it later) fi fi done -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: Archived logs backup

2002-12-05 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: DB corruption question

2002-12-05 Thread Stephen Lee
-- Author: Stephen Lee 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 this mailing list, send

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
-Original Message- GUI's are evil. Sure, blinking LEDs are much more better. Especially when the admins are epileptic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: Something that might be of use

2002-12-05 Thread Stephen Lee
from a collection of xterm command line interfaces. (Pick up mouse: Computer Oh Computer? A keyboard? How quaint!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Are Oracle courses required for Oracle Certification now?

2002-12-05 Thread Stephen Lee
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: DB corruption question

2002-12-06 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: To_Number

2002-12-06 Thread Stephen Lee
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Implementing Continuous Managed Recovery on a Standby Databas

2002-12-06 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: imp table by table

2002-12-10 Thread Stephen Lee
Most likely, you will have to run the imports to get the data and the primary keys. Then run them again with ignore=y and rows=n to get the foreign keys. My problem is with referential -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL

RE: trapping errors from assignment of SQL*Plus Input Variables

2002-12-10 Thread Stephen Lee
., a letter). I had hoped the WHEN OTHERS exception would handle it but it does not. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: archiving redo logs

2002-12-10 Thread Stephen Lee
Oh yeah. I forgot to say, if you create a script with a password in it, be sure to change the permissions so nobody but you can read it. For example chmod 700 (or 500) script_name -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: archiving redo logs

2002-12-10 Thread Stephen Lee
in the home directory on the source box. -Original Message- If UNIX script is the only option, I appreciate if you can share it here. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: archiving redo logs

2002-12-11 Thread Stephen Lee
for doing that would be to create a soft link to point to last file you copied in the previous invocation). You will need to have a .rhosts file set up on the other box to use rdist. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Recovery Scenarios

2002-12-11 Thread Stephen Lee
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN Reporting?

2002-12-11 Thread Stephen Lee
://www.orafaq.com -- Author: Stephen Lee 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

RE: Backup DB files to the Tape

2002-12-18 Thread Stephen Lee
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: RMAN scripts - archived logs

2002-12-19 Thread Stephen Lee
Attached (If the list supports attachments) are one for tape (Legato Networker) and one for disk which later gets backed up by OS. These are generated by a ksh backup script every time the script runs. The disk backup does not use a catalog server; so you have the line at the end that backs up

RE: Footprint of 9i

2002-12-19 Thread Stephen Lee
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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
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.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Backup DB files to the Tape

2002-12-19 Thread Stephen Lee
of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: RMAN, recatalog backup set

2002-12-20 Thread Stephen Lee
When you are not using a catalog database, the control file is your only catalog. If you destroy all copies ofit, then you have destroyed your catalog. It's gone. It is a late catalog. It is no more. (I wish I could remember the Monty Python dead parrot bit.) That's why you must backup the

RE: Disable Database Startup While COLD Backup is in Progress

2002-12-20 Thread Stephen Lee
Rename the init.ora? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8i OCP DBA Exams

2002-12-20 Thread Stephen Lee
They are trying to catch up with Sybase. Larry feels bad about falling behind. -Original Message- Not to mention 10i is coming out soon. Too fast man. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

  1   2   3   4   >