Re: Lost ofall redo logs

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

Re: Best method to move Filesystems to RAW Devices.

will be more beneficial, Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Best method to move Filesystems to RAW Devices.

for us. Please let me know, if any of you went through this exercise and any suggestions and tips will be more beneficial, Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

OT: ok so i'm bored working on rman scripts

so i took the first 2 stories and put them on http://www.oracle-dba.com/bdbafh nothing pretty, maybe i'll mess with it later today, text only so far. feel free to submit your part of the on-going saga to [EMAIL PROTECTED] joe

OT: oracle-dba.com up for sale on ebay.com

For those of you who don't know, i've put in place a plan to leave the oracle field and move back into the medical field, saying that, i've decided to offload the oracle-dba.com domain that i purchased quite a few years ago. Its on ebay with a starting price of .01 with a reserve price. If

oracle-dba.com domain

email me at [EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery

books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Should I post a preview of Oracle9i RMAN Backup and Recovery

books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: oracle-dba.com domain

. - Douglas Adams -Original Message- *From:* JOE TESTA [mailto:[EMAIL PROTECTED]] *Sent:* Thursday, September 26, 2002 4:11 PM *To:* Multiple recipients of list ORACLE-L *Subject:* oracle-dba.com domain email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] as I'll be out of office

OT: oracle-dba.com domain auction

With as much interest as i'd seen, i'd thought it would have been above $102.50, oh well unless you all run up the price in the last few days, guess i'll just be holding onto it for a while. joe

Re: ok so i'm bored working on rman scripts

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

re: logon trigger

George here is how we did ours" create or replace trigger olap1_logon_trigger after logon on olap1.schemabegin execute immediate 'alter session set optimizer_mode = first_rows';end;/ Customize it to your liking. Joe

Re: Oracle DBA Needed with Shareplex and Factory Works

standard reply, no aliens(foreign or outerspace kind). joe OraStaff wrote: snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

rman fun :), nightmare and long

Ok so the qa environment we've been fooling around with rman for testing backup/recovery. tonite they say " we want a backup restored from rman from 2 incarnations ago(for those of u who dont know what an incarnation is, its a new version of the database that gets created when you do open

Re: rman fun :), nightmare and long

that, rman: reset database; full catalog sync AND we're good to go. Where did go wrong in using RMAN to do the recover/restore ??? joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: rman fun :), nightmare and long

controlfile' and then restore/recover in the normal way. I think this functionality came in when they allowed a no-catalog mechanism, so if you lost everything, you could still make use of a backup. hth connor --- JOE TESTA [EMAIL PROTECTED] wrote: Ok so the qa environment we've been fooling around

Re: rman fun :), nightmare and long

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

Re: Client not using tnsnames.ora?

Dont forget the .tnsnames.ora (private tnsnames.ora). joe Jacques Kilchoer wrote: RE: Client not using tnsnames.ora? Do you have several Oracle Homes on the client? If so you need to modify the tnsnames.ora in each %ORACLE_HOME%/network/admin directory. Do you

Re: how to clone a DB ?

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

java, etc

Ok one of my last tasks here(besides implementing RMAN) is to tell the developers how to call an external java program from like pl/sql. (unix-based) Does this require me to have java loaded in the database(from what i've read I dont think so). Does this require me to have an external proc

oracle 9i desupport dates

9.01, aka 9ir1 Error correction support(ECS) ends jun 30, 2003. -- yes in like 8 months 9.2, aka9ir2, ECS ends sep 30, 2005. joe

Re: oracle 9i desupport dates

technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- *From:* JOE TESTA [mailto:[EMAIL PROTECTED]] *Sent:* Tuesday, October 08, 2002 4:59 PM *To:* Multiple

Re: 9.2 on Red Hat 8.0

-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: 9.2 on Red Hat 8.0

-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: 9.2 on Red Hat 8.0

, Mladen wrote: Has anybody tried installing it? Any experiences/remarks/problems/rantings? Any RH 8.0 comments in general? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

stupid RMAN question

Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in backup/recovery 101 multiple times. Where in the heck is the "spool" command for rman? Can i only spool stuff(and its an either to a file or to the screen, not both?) using the log parameter when

Info on ILT and OCP

by the experts at Oracle, will give you the in-depth Oracle9i knowledge you need to be successful in your job. And having an Oracle9i DBA Certification can give you secure footing in these uncertain times. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa

standby database question.

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

RE: linux

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

Re: standby database question.

to see it if was already running. If not, it would do the recover automatic. It would fail when it ran out of archived logs to apply, but the cron would restart it and check for more. Worked pretty well.. Rachel --- Joe Testa [EMAIL PROTECTED] wrote: I'm back on 8i for a different client who

Re: oracle or mssql

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

Re: linux

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

Re: Theory v Practice

by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: ORA-600

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

Re: Get together at OOW

the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe

Re: Creating new user

this ? any help will be appreciated. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: CodeNotes for Oracle9i...

, if for some reason you are or will be using .Net, the CodeNotes eBook version is free... http://www.codenotes.com/do/downloads/downloadsNETbook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Joseph Testa has sent you a 10% discount]

This is a multi-part message in MIME format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Joseph Testa has sent you a 10% discount]

Anything http://www.amazon.com Joe Testa wrote: This is a multi-part message in MIME format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Sorry - Out of question ! - Regarding FTP

: Joe Testa 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: Database Creation(RANTING)

which are necessary. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 9iR1 vs 9iR2 ?

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

RF RMAN Books

Excellent read. Got mine today from amazon. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Joseph Testa has sent you a 10% discount]

Paul, I am its just not immediate, 5 year plan, i start EMT basic in jan 2003. joe Paul Baumgartel wrote: What a guy that Joe is. ;-) But Joe, I thought you were getting out of the DBA business. --- Joe Testa [EMAIL PROTECTED] wrote: well that didnt work, ok how about cut/paste

Re: Oracle 10i new releases

Dell Corp. -Original Message- Sent: Thursday, November 07, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED

Re: Oracle 10i new releases

the memories... Tim -Original Message- Sent: Friday, November 08, 2002 4:04 PM To: Multiple recipients of list ORACLE-L anyone remember the 6 days, 6.0.36 on sunos :) joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City

Re: OT: PIC 9(9)V99 ??

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

Re: OT: PIC 9(9)V99 ??

data would have a decimal point? So in this case, for a total of 12 characters? 123456789.99 ? TIA!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: RMAN backup

FAQ: http://www.orafaq.com -- Author: Joe Testa 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

Anyone using Net appliance near store r100

I've got a new client thats just about sold on it but they are looking for third party verification of anyone using it and if it works as stated. thanks, joe

Tivoli and RMAN

Hello all, just finished reading the chapter on RMAN/Tivoli and a .pdf on installation. It appears NO environment variables are read when using tivoli that all "enviroment stuff" has to be put in the tdpo.opt file. so all of the scripts that we wrote that uses enviroment variables will

Re: Anyone using Net appliance near store r100

on it but they are looking for third party verification of anyone using it and if it works as stated. thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Where to Find Sample QUESTIONS for OCP-DBA Exams?

to pass exam, please help me. Syedriyaz. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: DBA Manager Needed in Florida..

No Aliens, either domestic or outer-space kind. Sorry felt the need. joe OraStaff wrote: Position: DBA Manager another let's make sure to exclude people up front job posting snipped here -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL

Re: Rant

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

Cube Definiition

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

Re:

. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re:

: Joe Testa 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

IOUG call for papers

IOUG has announced call for papers for IOUG Live 2003 in Orlando FL. http://www.ioug.org/call Check it out, i've submitted my 2 proposals already :) Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services

Re: RMAN guru question

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

Re: Oracle Data Compression

://www.orafaq.com -- Author: Joe Testa 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

Re: Houston, do I have a problem?

-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: How do I restore an old RMAN backup

a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL

RMAN example scripts

http://www.oracle-dba.com/rman joe

Re: Why use a Unix Pipe to uncompress a file?

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

Re: How To grant execute to user on DBMS_LOGMNR package

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

Re: How To grant execute to user on DBMS_LOGMNR package

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

Re: rman examples scripts

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

Re: rman examples scripts

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

Re: To_Char Problem

-- Author: Joe Testa 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

Re: To_Char Problem

-- Author: Joe Testa 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

Re: how to force a log switch

) Now, i only found parameters related to the frequency of the CHECKPOINTs and not log switches. Any help , please ... DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL

Re: Catalog target db on different version O/S

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

Re: Recall: drop tablespace including contents

Brooks, Russ, your request to recall the message, drop tablespace including contents has been DENIED. Brooks, Russ wrote: Brooks, Russ would like to recall the message, drop tablespace including contents. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe

Re: Exportable Users?

* * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

utl_file_dir versus create directory

in 9.0.2, you can use utl_file commands against directory objects, quickie example: create directory tmp as '/tmp';grant write on directory tmp to public;grant read on directory tmp to public; declare ft utl_file.file_type; begin ft:=utl_file.fopen('TMP','x.gf','w');

rman question(allocating channels)

I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe

new email address

the [EMAIL PROTECTED] email addy has evidently been sent on to spam lists, i'm getting way too many. Since I own that domain, i'll be dropping the [EMAIL PROTECTED] and be replacing it with [EMAIL PROTECTED] Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe

Re: Sequential Tables' Selects Versus Joins

the Cursor Values as Arguments to the where Clause of a 2nd SQL Query Running on a 2nd Table thus so on ... thereby finally getting the Output from the 6th Table -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City

Re: PL/SQL Editor

-- Author: Joe Testa 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

Re: arg list too long in unix

, 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: Joe Testa INET: [EMAIL PROTECTED

ADV OT: Oracle-dba.com domain for sale

If you're interested, email me for the asking price. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: ADV OT: Oracle-dba.com domain for sale

:48 PM To: Multiple recipients of list ORACLE-L If you're interested, email me for the asking price. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: new email address

: Joe Testa 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: SQL*Plus in 10i

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

Re: ADV OT: Oracle-dba.com domain for sale

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

Re: Who don't I see my posting ?

its showing up, ur test works. cease and desist. joe Diego Cutrone wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re:

-- Author: Joe Testa 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

methodology to keep only certain programs to connect to

I've been tasked to ensure only certain app programs access the database. I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the view that tells me only MY info during login. I only want the sid, serial#,

9ir2 install on linux(removal)

try removing the /etc/oraInst.loc and the oraInventory file(the location of it is in the .loc file). Joe

Re: methodology to keep only certain programs to connect to

Jared(and others) thanks, a bunch you all had what i was looking for perfectly. joe [EMAIL PROTECTED] 09/10/02 12:55PM Joe,Try this:select s.username, s.sid, s.serial#from v$session swhere userenv('SESSIONID') = s.audsid;Jared"JOE TESTA" [EMAIL PROTECTED]Sent by: [EMAIL PROTE

Re: Recover an unrecoverable database

://www.orafaq.com -- Author: Joe Testa 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

Re: 9ir2 install on linux(removal)

beats me but its one of those things that happens during the first time you run root.sh. joe Peter Barnett wrote: Did it, it worked. Now, why the heck do they put it in /etc? --- JOE TESTA [EMAIL PROTECTED] wrote: try removing the /etc/oraInst.loc and the oraInventory file(the location

Re: Consulting Position Available-Oracle DBA/Developer/NYC

!? Yahoo! News - Today's headlines http://news.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

rman

Ok i hear people complain about the DBID issue when duplicating a database. Does this only occur when using OS utilities to do the duplication because the DBID can't be changed until 9ir2?, if you use the RMAN duplicate command, it appears it works ok, truth or fiction? thanks, joe

Re: Lost ofall redo logs

-- Author: Joe Testa 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: Lost ofall redo logs

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

Re: Lost ofall redo logs

-- Author: Joe Testa 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

Job postings was:Re: Lost ofall redo logsOTHER...

any response,other than yours.If you've any thoughts(why)or could suggest another location to post/to make ORACLE people aware of career alternatives,I'd appreciate your insights, Bill Christison --- Joe Testa [EMAIL PROTECTED] wrote: KG, doesn't anyone think not having a backup is a bad thing

Re: TEST

you've been ignored, forever RAJESH DAYAL wrote: TESTING .. PLS IGNORE . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

  1   2   3   4   5   6   7   8   >