Re: Is there a simple perl utility or program similar to Oracle's dbms_profiler?

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

Re: SQLPlus Substitution Variables

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

Re: Perl DBI/SQL question - For those who use it...

Title: Perl DBI/SQL question - For those who use it... Hi Lisa, It's been awhile since I've used Perl DBI, but from what you said, I think you're mixing up two different ideas. Ksh doesn't know how to talk to a database, so you just use it to invoke sqlplus, which handles the database

Re: sqlplus /nolog

Title: sqlplus /nolog sqlplus /nolog starts sqlplus, but does not connect you to any database, nor does it prompt you for a username/password. - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 8:29

Re: backup controlfile to trace

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

Re: backup controlfile to trace

: http://www.orafaq.com -- Author: Philip Douglass 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: RMAN backup to remote dir. - how ?

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

Re: Copy one user's table to another user's table

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

Re: mixed case text

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

Re: connect to the databases without using tnsnames.ora?

file, that is a valid complaint. And it isn't even limited to 3rd party tools. Some of Oracle's own tools only give you the option of connecting to databases that are listed in your tnsnames.ora file, which when using the host naming method is not required! -- Philip Douglass Internet Networking Group

Re: bind variables

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

Re: Oracle User identified EXTERNALLY

FAQ: http://www.orafaq.com -- Author: Philip Douglass 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: Sql loader loads - what is the name of the counterpart that exports

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

Re: Default Location of RMAN backup sets

see files in there that I suspect are my backup sets but they have wierd file names. Such as: 01e1el7h_1_1 with no file name extensions. ltiu On Friday 30 August 2002 19:53, Philip Douglass wrote: Hmmm... IIRC they should be in $ORACLE_HOME/dbs - Original Message - To: Multiple

Re: SQL*Plus in 10i

') 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: Philip Douglass INET

Re: woo hoo

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

Re: Default Location of RMAN backup sets

-- Author: Philip Douglass 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: arg list too long in unix

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

Re: arg list too long in unix

, 2002 12:23 PM -- Philip Douglass [EMAIL PROTECTED] I'm not sure xargs will work -- it seems to me that since xargs is typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same arg list too long error. I think the best way to delete the files would be: 'find . -name cz\* -exec

Re: Identify unused indexes in 8i ?

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

Re: working with datafile 2Gb in HadHat 7.3

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

Re: password aging and expiration in oracle 8.1.7

Title: RE: How to notify the password expiration in oracle? The 8.7.1 SQL*Plus does not handle ORA-28002 warnings when connecting to an 8.1.7 database account that is in the grace period (dba_users.account_status = 'EXPIRED(GRACE)'). It is listed as BUG# 1326865 on MetaLink, with a patchset

Re: PL/SQL Editor

I'll second that -- I haven't used Benthic's PL/SQL editor very much, but I use Golden almost religiously as a replacement for SQL*Plus because it is small and fast and has a tabbed window interface with spreadsheet style output that works well for me. -- Philip Douglass Internet Networking Group

Re: What is an API?

API stands for "Application Programming Interface". An API is the rules that must be followed in order that the program you are writing can interface with the program whose API you are writing against. An API usually means that the developer of the application has given you the developer,

Re:

a better idea to me than just listing backupsets for a specified time frame. You can always edit rman1.sh to keep some obsolete backups, eg. 'report obsolete redundancy 4' -- Philip Douglass Internet Networking Group Database Administrator SIRS Publishing, Inc. - Original Message

Re: Unix question: how to display SID and path in prompt

Title: Unix question: how to display SID and path in prompt Put $PWD in there somewhere. I use ${PWD#${PWD%%*([!/])/*([!/])}} to display the last two directory levels, so my prompt never gets TOO long. The substring extractionof $PWD is ksh specific. You could do it other ways, but this way