RE: POLL: Database to DBA ratio

you can't just say I have NNN number of databases and therefore need NN number of DBAs. Richard Ji -Original Message- Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list ORACLE-L I'm trying to build a case for management that we need additional DBAs so I'

RE: sql query: to_date() :ORA-01830: date format picture ends bef

lso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Tablespaces - datafiles

tGuru') 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:

RE: can't create database

st 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Dieg

RE: Is async IO configured on HP-UX?

t 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: backup the tablespace

he HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: oracle cluster file system

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: User Package

UB 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: OT ksh day of week yesterday

27;) 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.com -- Author: Richard Ji INET

RE: replicate schemas

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.com -- Author: Richard Ji INET: [EMAIL

RE: e: when is an error msg not an error msg ?

AIL PROTECTED] (note EXACT spelling 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 offic

RE: A way to restore a DB

lling 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.com --

RE: Do user processes apply against shmmax limit?

an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). -- Pleas

RE: 9i Lite

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

RE: RE: How do you audit a DBA?

MAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTE

Re: Automatic database start in sun solaris

Just create one under /etc/init.d and softlink both the S and K script to it. The one under /etc/init.d must accept stop and start as an argument and do startup and shutdown accordingly. You can check out any script under /etc/init.d as a example on how to write one. Richard Ji >>&g

Re: char vs. varchar2

o 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

phantom queue table

ssage. It seems I got a phantom queue table. Has anyone seen this before? Any suggestions are welcome. Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: UTL_FILE and ksh

te EXACT spelling 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.

multiple temp tablespaces

Hi all, Someone suggested to me to have seperate temp tablespaces for each user. I don't see any advantage of doing that? So I want to pick everyone's brain on this list. What's your thoughts on that? Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Aut

Re: phantom queue table - solved

Thanks to Brian, The queue table somehow still have an entry in the system.aq$_queue_tables. After removing that entry everything is fine. Richard Ji >>> [EMAIL PROTECTED] 08/30/01 17:10 PM >>> Actually, yes. I don't have the specific details - that would be helpf

Re: listener question ??

The instance upon startup registered itself with the listener on the default port. It's the new feature. Richard Ji >>> [EMAIL PROTECTED] 09/05/01 06:26PM >>> Hi, when I do a lsnrctl status, there are two lines for one database. I checked listener.ora and tns.ora file,

RE: Alter tablespace add datafile

(note EXACT spelling 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://

RE: STOP THE PRESS!!

Are anyone from NYC okay? My boss saw WTC collapsed with his eyes. I was late for work, fortunately. I am still in a compelet shock. My prayer goes out to all people who suffered from this. Richard Ji >>> [EMAIL PROTECTED] 09/11/01 01:30PM >>> Time to test all the weapons w

RE: Standby Database

send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling 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). --

RMAN, Netbackup question

Oracle, it's won't allow multiple data sterams. That option is greyed out. Thanks Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: RMAN, Netbackup question

ve 4 channels, but they are queued at the Netbackup Server. I want them to go in parallel. Now, it seems that for the Class Type Oracle, it's won't allow multiple data sterams. That option is greyed out. Thanks Richard Ji -- Please see the official ORACLE-L FAQ: http://www.ora

RE: Standby Database

) 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.com -- Author: Richard Ji IN

Re: BMC Patrol DBXray / CA Unicenter

on (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Hi

This is a virus. >>> [EMAIL PROTECTED] 12/04/01 03:05PM >>> How are you ? When I saw this screen saver, I immediately thought about you I am in a harry, I promise you will love it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET

Re: Oracle 8.1.7 on Suse 7.2

Did you try "unset LANG" before you run the installer? I didn't need to download the JRE from blackdown. Richard Ji >>> [EMAIL PROTECTED] 12/17/01 02:00AM >>> Hi People anyone having problems with their installation of Oracle 8i on Suse pay heed and download JR

RE: The OCP bar is being raised

o know the benefits of having a certificate but I think the companies are taken it too far with all those "You must ... blah blah" requirements. Why don't they just say "You must pay $10,000" and we will give you a certificate. Richard Ji >>> [EMAIL PROTECTED] 01/10/02

RE: Griping about auditing (not the Oracle Kind)

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Die

Re: EMN0 process problem

ning: 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services--

RE: OT RE: 24 x 7 on NT?

e of clicks, he/she might think "hmmm, that was easy". ;) Richard Ji >From: "Mark Leith" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT RE: 24 x 7 on NT? >Date: W

Re: Linux profile - a little offtopic

spelling 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.com

OT: Re: Sizing Raw Vols and Oracle Datafiles

sage 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.com -- Author: Richard Ji INET: [EMAIL PROTECTED]

RE: CA ARCserver Vs. Veritas Backup Exec?

I looked at the CA ARCServer and Legato a while ago. I believe the CA ArcServer uses their own Oracle Agent. Thus you don't use RMAN, so you can't do incremental backups at the block level etc. Which is the reason I didn't go with CA. Richard Ji >>> [EMAIL PROTECTED]

Re: OT: UNIX SA

, etc ... - user/programmer/DBA level , not a sys. admin. level). Can U please recommend what to start with ? I prefer free resources on the web over the books i'll have to buy, off course. Thanks a lot for your recommendations. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq

RE: How to execute Unix Command/program within a pl/sql block.

e 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.com -- Author: Richard Ji INET:

Re: gzip does not want to work with files > 2G

What version of gzip are you using? I had the same problem before, just had to get the latest version. Richard Ji >>> [EMAIL PROTECTED] 07/09/01 07:12PM >>> I have Solaris 5.8 angzip does not want to work with files > 2G - tells that file is too large. Anybody has any id

RE: gzip does not want to work with files > 2G

ORACLE-L What version of gzip are you using? I had the same problem before, just had to get the latest version. Richard Ji >>> [EMAIL PROTECTED] 07/09/01 07:12PM >>> I have Solaris 5.8 angzip does not want to work with files > 2G - tells that file is too large. Anybod

Re: Rename alert log

CTED] (note EXACT spelling 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://w

RE: UNIX

tGuru') 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.com -- Author: Ric

Re: Rename alert log

27;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.com -- Author: Ri

Re: Rename alert log

ED] 07/11/01 11:47AM >>> My take on this is... if modifying the script won't hurt anything, do so. I'd rather do MORE than less when it comes to being proactive with Oracle. >From: "Richard Ji" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: M

export/import object types

like this. But just wondering why would Oracle retain the object id for TYPE? It certainly didn't keep the same object id for other objects like table, etc. Any thoughts? Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PRO

RE: A danger in cloning databases

ntaining: 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Serv

RE: export/import object types

Kevin, Thanks for letting me know that I am not the only one had to go throught this. :) Thank God I have VI editor, can't imagine if I had to use notepad on windows to edit that file. There are 106 types! Richard Ji >>> [EMAIL PROTECTED] 07/11/01 01:15PM >>> I'v

Re:RE: A danger in cloning databases

ng 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Netw

Re: URGENT ORA-03113

EE on Solaris8. Do you have both 8.1.5 and 8.1.7 installed on that machine or just 8.1.7? Richard Ji >>> [EMAIL PROTECTED] 07/12/01 06:45AM >>> Hi ALL: Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run

HELP: ora-600

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Unix compress question

You are not trying to backup a database on floppy disks are you? You can compress it then use the "split" command to split into smaller pieces and copy it on to each disk. Maybe even write a script to do all this and share it with us. :) Richard Ji >>> [EMAIL PROTECTE

OT: Re: Oracle Internet Directory

n 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 F

RE: Long Raw size 7.3.4

ail of the LONG RAW is bigger than 30k or so. If you store something bigger than that in your LONG RAW column, you have to resort to write a program in C, or Java ,etc. to read it and calculate the size. HTH Richard Ji >>> [EMAIL PROTECTED] 07/17/01 03:46PM >>> Don't be a

RE: Solaris 8 Question

It depends. If a root partition fills up then it could crash the box. Otherwise, if it's for the database, it might crash the database depends on what's on that partition. HTH Richard Ji -Original Message- Sent: Thursday, July 19, 2001 11:55 AM To: Multiple rec

RE: How to compile objects of type TYPE

alter type type_name compile body; Richard Ji -Original Message- Sent: Thursday, July 19, 2001 3:26 PM To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> After our ugprade to 817 from 815 and fully following all the procedures in the manual ended u

RE: How to compile objects of type TYPE

alter type type_name compile body; Richard Ji -Original Message- Sent: Thursday, July 19, 2001 3:26 PM To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> After our ugprade to 817 from 815 and fully following all the procedures in the manual ended u

Re: export/import object types

MP-63 FROMUSER/TOUSER Import of Table With Object Column" HTH, -- Anita --- Richard Ji <[EMAIL PROTECTED]> wrote: > Hi all, > > I wonder if anyone has seen this before. > > I export an user A, then import it into user B in a > different database > and everyth

Re: Metablink .... down again?

7;) 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.com -- Author: Richard Ji INE

Re: tnsnames.ora in clients

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Wildly OT. - Air fares

ohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED]

Re: Solaris 8 Question

You should try to query the archive destination select * from v$archive_dest see if it says ERROR And do alter system archive log stop followed by alter system archive log start This will fix the broken archive process. Richard Ji >>> [EMAIL PROTECTED] 07/24/01 11:05AM >>>

Re: (Fwd) Oracle 8i and clustering [NT]

nclude 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: Richard Ji INET: [EMAIL PROTECTED] Fat Cit

RE: Solaris Release Vs. Version

- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of

RE: Oracle vs. MySQL

True, but how can they(MySQL guys) call it a RDBMS if they don't support transaction? Isn't the ACID is what the RDBMS is all about? Richard Ji >>> [EMAIL PROTECTED] 08/01/01 01:56PM >>> Certain things don't need transactions. "Do not criticize someone

Need opinion on storage and backup solutions.

MC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: RE: Sad News - Jets crashed into World Trade Center

Judging from the video. The building started collapsing from the top first, not the bottom. Richard Ji >>> [EMAIL PROTECTED] 09/11/01 14:01 PM >>> I hardly believe the crashes took the buildings down, I think there were bombs placed that later fired to bring it down. I har

Re: RE: Sad News - Jets crashed into World Trade Center

It will never be the same even if we build them back. I know the place all too well. I am still sitting here in disbelieve. And yes, I feel like crying watching it collapse and people jumping out. Richard Ji >>> [EMAIL PROTECTED] 09/12/01 14:51 PM >>> No. building them

OT: Terrorists are like Cancers

And what do you do with cancers? You don't wait until the cancer gets you. You kill it. And I don't care if Osama Bin Layden is involved this time or not. If not this time, he certainly will do it next time, like what he has done before. This is WAR. Richard Ji -- Please see th

Re: Strange performance problem

-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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Determining Oracle status

Don't know how to change it to only 1 login attempt. But I would do a "select sysdate from dual;" after connect via sqlplus. This way if the 1st login failed, the SQL statement will cause the next two attemt fail as well and sqlplus will exit. Richard Ji >>> [EMAI

Re: How to move a databse from Solaris to Llinux

You can't use backup and restore to move a database between different platforms. A while ago, someone on this list posted a message that he/she was going to make a tool that allows this to happen. But until then, you will have to do export and import. Richard Ji >>> [EMAIL PROTE

RE: coalesce tablespace

ation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

Re: sys.obj$, type# desc

SOURCE 29 JAVA CLASS 30 JAVA RESOURCE 31 JAVA JAR 32 INDEXTYPE 33 OPERATOR 34 TABLE SUBPARTITION 35 INDEX SUBPARTITION Richard Ji >>> [EMAIL PROTECTED] 10/19/01 12:10PM >>> hI gurus' [EMAIL PROTECTED]>; 1* select obj#, name, type# from sys.obj$ where name like &#

RE: Tools

bing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

8.1.7.2 and AQ

Just a FYI, For anyone who is going to patch to 8.1.7.2 and are using AQ should check out Note 151613.1. Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: backup of large databases

ery ? Do you use disk or tape ? Do you use RMAN or other backup tools ? What are the customer's expections for recovery and how do they effect your backup strategy ? I appreciate your input. ed -- Please see the official ORACLE-L FAQ: http://www

Re: FAST MIGRATION OF DATA

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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 53

Re: FAST MIGRATION OF DATA

production instance name is "prod".Can I create standby database with same name like "prod" on another box. If the configuration of both servers are diffrent then what will be best approach of data migration. Thanks -Seema >From: "Richard Ji" <[EMAIL PROTECTED]

Re: Spam - Re: Oracle Training from InterTrain

ichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Ma

Re: Root to connect as system

You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Int

Re: Hosing of Data Dict by "catalog.sql"

ing 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.co

Re: recovery database!!

ru') 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.com -- Author: Richard Ji

RE: Startup error

MAIL PROTECTED] (note EXACT spelling 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

RE: Operating Systems

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: Metalink gone to sleep ?????

ing: 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Netwo

Re: Morpheus killed my Oracle! Help!

and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Reporting Solutions

I had good experience using Brio's reporting solution. Richard Ji 387 Park Ave. New York City, NY 10010 >>> [EMAIL PROTECTED] 05/15/01 09:20AM >>> For reporting we are currently using Oracle Reports and Seagate Info. Would like to know with which other products you&#

TNG vs BMC Patrol

Hi All, I am looking for opnion on using CA's TNG for monitoring Oracle. I have used BMC Patrol before but never TNG. If anyone has used or evaluated both products, please let me know what you think of it. Thanks Richard Ji 387 Park Ave. New York City, NY 10010 -- Please see the off

Re: Multiple schema's or multiple databases

If each schema has it's own tablespace, then you can do Point In Time Tablespace Recovery. If all schemas share tablespaces then that would be a problem. Richard Ji >>> [EMAIL PROTECTED] 05/23/01 02:45AM >>> Off the top of my head I can see this problem also. Is there

RE: Steve Adam's Removal

I guess the lazy DBAs got tired of reading Oracle Internals. They just want simple answers. :) Richard Ji >>> [EMAIL PROTECTED] 05/25/01 07:15AM >>> you're right -- Henry isn't the list owner here in any case. For those of you who want to discuss this, Henry set u

Re: Re[2]: About parallel server

Dick, Just curious, I can see putting the control file on a file system but I failed to see how can you put online redo logs on file system in OPS. Unless you are using distributed file system? How does one node do instance recovery for the failed node? Richard Ji >>> [EMAIL PROT

Re: About parallel server

ECTED] (note EXACT spelling 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: htt

Re: About parallel server

A couple of years ago, no vendor has a distributed file system (one that will let all nodes in a cluster to mount and access the same file system simultaneously). And that's why we had to use raw device. Maybe DG had it? So which vendor has it then and who has it now? Richard Ji >&

RE: How to prevent oracle from committing a transaction?

No Oracle doesn't do commits for checkpoint, log switch or shutdown normal. It will only commit data explicitliy (using the commit command) or implicitly (DDL). SQL*PLUS by default auto commits for you if you just exit after doing some DML. But you can turn that off. Richard Ji >&

Re: How to remove corrupted blocks from datafile.

Did you check your disk to make sure that's not where the corruption started. There maybe some physical disk problem or file system problem. If you have some bad blocks on your disk you need to fix them first. Richard Ji >>> [EMAIL PROTECTED] 06/05/01 04:42PM >>> Hi,

Re: Oracle 8i database & ER diagram

I believe ERWin is now a CA product, so you could go to CA's web site to check it out. You can also use Oracle's Designer which is a more high end product and cost more money. Visio can also reverse engineer your db and generate a simple ER diagram if that's all you ne

Re: OT: Pin a CPU in Solaris

Y, 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: Richard Ji INET: [EMAIL PROTECTED] Fat City

RE: Shared server model

EXACT spelling 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.orafa

<    1   2   3   4   >