RE: Database Instance

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

RE: Database Instance

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

RE: Database Instance

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

RE: alter tablespace offline

Hi Jeroen, What is problem? Error msg or something? Sinardy -Original Message-From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]Sent: 16 December 2003 18:12To: Multiple recipients of list ORACLE-LSubject: alter tablespace offline Hi, This weekend I was

RE: Free Memory in v$sgastat

. of large pool. On 12/16/2003 12:24:25 AM, Sinardy Xing wrote: Hi Mladen, I try to understand 8i, and I am not using MTS, my current understanding is UGA and PGA only exists (I mean in use or in the picture) when you are using MTS. Oracle themselves said 'free memory' are more properly thought

Free Memory in v$sgastat

Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these "free memory" aremore properly thought of as wasted space? Thanks Sinardy

RE: Free Memory in v$sgastat

, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Multithreaded server - effect of POOLING=ON option

(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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Clean temporary tablespace

') 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: Sinardy Xing INET: [EMAIL

RE: Antw: RE: I wanna know how Oracle uses file organization in

') 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: Sinardy Xing

RE: I wanna know how Oracle uses file organization in their DB

://www.orafaq.net -- Author: Sinardy Xing 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: UNIX OT: deleting file starting with --

: Sinardy Xing 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: How to drop a datafile ?

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

RE: dba interview questions

://www.orafaq.net -- Author: Sinardy Xing 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

RE: Can I concatenate several rows without a procedure?

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

RE: Renaming Role

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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 Parameters

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

RE: consistent gets

If you want to reduce your consistent gets, you can reduce your sga size -Original Message-From: Sultan Syed [mailto:[EMAIL PROTECTED]Sent: 08 October 2003 14:14To: Multiple recipients of list ORACLE-LSubject: consistent gets Hi, What does the meaning for this

RE: Strange Request

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: Sinardy Xing INET: [EMAIL PROTECTED

RE: Strange Request

') 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: Sinardy Xing INET

RE: consistent gets

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Table not reusing deleted space

From: Sinardy Xing [EMAIL PROTECTED] Date: Wed, 1 Oct 2003 14:51:40 +0800 Subject: RE: Table not reusing deleted space Hi Kaing, Have you check the degree of fragmentation? have you check your extent size? Sinardy

RE: Table not reusing deleted space

://www.orafaq.net -- Author: Sinardy Xing 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: minus vs. where not exists, vs. where not in

. Sinardy Xing [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: two instances on same box (Suse Linux ES 8)

Title: two instances on same box (Suse Linux ES 8) Hi Helmut, when you do switch user su - newuser use the "-" it will run the .profile of that user, I assume your problem is because the env variables. Otherwise(or) you can open a new telnet windows to startup the other database?

RE: minus vs. where not exists, vs. where not in

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

...

Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not

RE: How to keep root out?

the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL

RE: How to keep root out?

if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services

RE: one question on backup and restore

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle client and DNS

: Sinardy Xing 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: more questions

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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City

RE: one question on backup and restore

-- Author: Sinardy Xing 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: more questions

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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network

RE: How to keep root out?

(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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: How to keep root out?

access via connect internal or / as sysdba? Thanks in advance. W -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: OT: Hey Jared!! -90 degree OT Joke

Yes, left brainconnect to the right part of your body right brain connect to the left part of your body When you do DB design your using more ofyour right brain. When you have SQL syntax error you useyour left brain more. -Original Message-From: A Joshi [mailto:[EMAIL

RE: OT: Hey Jared!! -90 degree OT Joke

pictureso either I am more highly evolved and use both sides of my brain (nothardly) or the theory needs some modification--- Sinardy Xing <[EMAIL PROTECTED]>wrote: Hi, This is my own theory, you can't find this information from Oracle Document. Well... talking about

RE: get sid (session id) and serial#?

://www.orafaq.net -- Author: Sinardy Xing 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: Question about Constraint

(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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: OT: Hey Jared!! -90 degree OT Joke

://www.orafaq.net -- Author: Sinardy Xing 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

RE: Need help with an error ORA-12640

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: V$cache

') 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: Sinardy Xing INET: [EMAIL

RE: Hey Jared

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

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Hi all, Thanks for your input... I am using Oracle 8i On-Line Generic Documentation CD-ROM Part #: A87860-01 The solution: I just copy all the d:\doc to my hd (quite huge) then open the index.htm This is huge man, I only have 30 gig storage Sinardy

RE: Online Document for Windows XP Home edition Severity 3

Title: Message Hi, Thanks this work. Sinardy -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]Sent: 22 August 2003 20:59To: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 Sinardy,

RE: Software Owner for Oracle8 and Oracle9

Hi, My answer Benefit using different users. 1. If the applications of thoese twodatabases should not access each other then you have better security, the owner of the instances processes are different. 2. If DBAs that manage thosedatabases are different person than they can change the

RE: Tough Oracle DBA experience

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

RE: Nature of Oracle-l has changed

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Online Document for Windows XP Home edition Severity 3

Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oraclefail to run when I clickInstall/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms toremovethe JVM? Can someonehelp me please.. Thanks Sinardy

RE: Installation problems (8.1.7 on AIX 5.2)

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

RE: HELP

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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network

RE:

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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City

RE: Canada and US friends (YOUR WISH IS COME TRUE)

and start sending in the good stuff. On 2003.08.18 00:44, Sinardy Xing wrote: Hi Canada and US friends, Can your systems survive the blackout disaster? Do you need recovery? Everything is ok out there? Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http

Canada and US friends

Hi Canada and US friends, Can your systems survive the blackout disaster? Do you need recovery? Everything is ok out there? Sinardy

RE: How to make SPFILE in sync with INIT.ORA ?

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

SQL need help

returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET

RE: service name

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

RE: Update and Join

Hi Castro, Can you set yourfont size bigger? You are not lawyer right? may be this can help you UPDATE table SET column = something_new WHEREprimary_key_or_just_keyin (select foreign_or_primary_key asusual) AND other_key in (other select foreign_or_primary_key asusual); Sinardy

RE: How to stop script

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

RE: Anyone using EMC Clarion Cx400 in a RAC environment?

Hi, One incident (first year or usage) the fiber card driver crash and zombie processes occur. IO hang, database down. DB cannot fail over to standby server, primary server cannot shutdown, shutdown abort can't help, physically power off server is require. I don't think is the EMC

Oracle RDBMS for Win XP

Hi all, Do you install Oracle RDBMS (maybe personal edition) with Win XP? Will that work? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: error configuration database oracle 9.2.0 on Redhat

Hi Pomin, This is syntax error, why don't you check your create database syntax including init.ora file and system environment variable. Just my speculation. Sinardy -Original Message-From: pomin [mailto:[EMAIL PROTECTED]Sent: 19 March 2003 09:49To: Multiple recipients

RE: Inband and Outband Net8 question

. On Tuesday 18 March 2003 07:48, Sinardy Xing wrote: Hi all, I have question about Inband break, please help me understand this Oracle said: There are 2 types of breaks: - Inband breaks: are transmitted as part of regular data traffic using the normal protocol read and write functions

Inband and Outband Net8 question

activity)? Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Unix variable question

-- Author: Sinardy Xing 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

RE: It takes too long to shutdown database

Title: It takes too long to shutdown database Hi David, These are what I think first, you are not using shutdown immediate (Oracle waitinguser to close the session) - unlikely for thiscase. or It has been so long you never shutdown your database, Oracle doing housekeeping, your rollback

Alert Log reporting question

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

RE: installation / recovery question

') 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: Sinardy Xing INET: [EMAIL

RE: [Q] create seperate DBA account on 8.1.7 but does NOT work?

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

RE: Case of the Missing Rows

Title: Case of the Missing Rows I think so too, perhpas you want to include the bad recordto capture those bad records make the nesassary changes then load that bad file repeat until all loaded into your db -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: 28

RE: one datafile lost.

Hi Big Planet, They db files are not consistence you can apply the changeswith archived redo log since. How you recover your database is depend on how you backup your database. For example you can use old "redundancy set" + latest exported dump file Sinardy -Original

RE:

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

OT: Urgent PDF to TXT Convert

Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL

RE: Urgent PDF to TXT Convert

IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED

RE: strange issue with setting transaction

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: Sinardy

RE: Help with IMPort

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

RE: functions/procedures and commits

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

RE: The best method for scheduled work

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

ORA-00600: [2662]

Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET

RE: ORA-00600: [2662]

of these. And of course, Tim should not work for free either. (Tim, it was 10% commission we agreed on, right ? ) :-) Ferenc Mantfeld -Original Message- From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Subject

RE: New year humor

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

imp table by table

' from user_objects where object_name = myuser order by creation; do you think this will work ? My problem is with referential Thanks Mery X'Mas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Unkillable Background process SHUTDOWN ABORT LEAVES UNKILLAB

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

/opt/oracle/product/jre/1.1.8/bin/jre

Hi all, Can I set this file to r-xr-xr-x ? rwxrwxrwx /opt/oracle/product/jre/1.1.8/bin/jre Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Unkillable Background process SHUTDOWN ABORT LEAVES UNKILLABLE PROCESSES

Hi all, When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ? because of this my cluster fail to failover Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED

RE: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..

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

Unix scripting need help

when I do echo $file_tag1 it should give me 001 Thank you sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Set unused column to normal

. An instructor from one Oracle class said he blew away a database by doing this. Caveat emptor. Jared Sinardy Xing [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2002 07:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc

RE: Hot Backup using EMC /BCV splits

') 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: Sinardy Xing INET: [EMAIL

RE: DB_FILE_NAME_CONVERT issue

: Sinardy Xing 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

RE: DB_FILE_NAME_CONVERT issue

every file in your RMAN script (set newname for datafile command) Jack Sinardy Xing

RE: Increase size of REDO log

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

DB_FILE_NAME_CONVERT issue

) Thanks so much. Oh by the way I am using 8i Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle 9i, can't break it?

: http://www.orafaq.com -- Author: Sinardy Xing 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

RE: !ls from sqlplus

: http://www.orafaq.com -- Author: Sinardy Xing 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

Oracle IAS

Hi all, I try to install Oracle IAS 8i into my Win 2K SP 2, and the universal installer is hang, any idea (I have huge RAM) Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Basic Question

Hi Santosh, Tablespace is logical storage, datafile is physical storage (OS file). Tablespace mustconsists of at least 1 datafile. Example Create tablespace my_tablespace datafile 'my_tablespace's_datafile1' NB: Storage is storing your database objects Sinardy -Original

RE: Basic Question Again..

Hi, SGA is Shared Global Area or System Global Area Redo Log Files are part of your "redundancy set files" storing before and after images of changes Control files are your one of your database controller, required at the first startup to identify where are allyour data files and the last

RE: Oracle IAS

into my Win 2K SP 2, and the universal installer is hang, any idea (I have huge RAM) Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

  1   2   >