RE: dbms_sys_sql

2001-05-19 Thread Seley, Linda

We have a couple of issues with this.  I'm not worried about the SA, she has
access to the passwords if she needs 'em since I'm the only DBA.  I'm
concerned about the scripts because they will be on one of our servers on
the internet.  We've implemented a virtual private database to protect the
data.  Seems self-defeating to have the passwords out there somewhere.  The
scripts, as originally written (by a developer), would have shown the dba
userid/password, the production id/password, and each of the individual
userids and passwords on a ps command as well as hard coded in the scripts.
But, even more importantly, this code will go into CVS and will be
accessible by all of our developers and testers.  I don't want the
production passwords seen by any of them.  I also don't want to be the sole
person maintaining the code!

Linda

-Original Message-
Sent: Saturday, May 19, 2001 10:46 PM
To: Multiple recipients of list ORACLE-L


 unless your concerned about the sys admin having access to the passwords,
generally using file level security is suitable to protect scripts with
passwords in them.  But that depends on how comfortable you are with the SA,
and if the shop has a fairly stable security structure.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 6:11 PM

I am working on scripts that will create tables and users, grant
permissions, etc. every night on a clean copy of our db.  Without
dbms_sys_sql, I would have to connect to other users to do the grants.
I
don't want passwords anywhere in my scripts, I want to connect once then
run
everything from this one user.  dbms_sys_sql takes in a userid and sql
text
(plus a couple of other things) and runs the sql as that user.  

Linda

-Original Message-
Sent: Friday, May 18, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


Linda,

you should be using dbms_sql instead, which incidentally is *very*
stable.
What feature of dbms_sys_sql you need but isn't provided by dbms_sql? I
am
just curious ...

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art !
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seley, Linda
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seley, Linda
  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-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).



RE: ....A drop schema script ??

2001-05-19 Thread Christopher Spence

Another thing with DROP USER CASCADE is you can cause lost data in the
SYSTEM tablespace.  This will cause corruption of data and inherently causes
problems with export/import if I remember correctly.

I would recommend dropping all objects first, then drop the user. 
(There is one under objects on my site)
This was partially fixed in 8.1.6 and further refined on 8.1.7

Note:100405.1



Jared Still wrote:

> Luis,
>
> Don't feel bad, this is a valid question.
>
> DROP USER CASCADE is not always the most efficient way to
> drop a user, especially a user with a large number of objects.
>
> I've had that command fail a number of times, and had to rerun
> it until I decided there must be a better way.
>
> DROP USER CASCADE can generate a *lot* of recursive SQL,
> and therefore can take a very long time.  It also eats up system
> resources at a prodigious rate.
>
> I've found that when dropping a schema owner, it's much easier
> to drop their objects individually, then drop the user.
>
> e.g.
>
> spool '_dropscott.sql'
>
> select 'drop ' || object_type || ' scott.' || object_name ||
> decode(object_type, 'TABLE', ' cascade constraints;',';')
> from dba_objects
> where object_type in ('TABLE','PACKAGE','PROCEDURE','FUNCTION')
> and owner = 'SCOTT';
>
> spool off
> @_dropscott.sql
> drop user scott cascade;
>
> I still include the 'cascade' on drop user to pick up any objects not
> included in the above list.
>
> Works for me, YMMV.
>
> Jared
>
> On Thursday 17 May 2001 13:25, Luis DeUrioste wrote:
> > uhhh DUHHH !
> >
> > I could write the algorithm to solve the logarithm .. IF I ONLY
HAD A
> > BRAIN ..
> >
> > Thank you to all of you, and special thanks for not bashing me
> >
> > Luis Octavio
> >
> > Luis DeUrioste wrote:
> > > All mighty and powerful DBA supremes !
> > >
> > > Do any of you have a drop schema script that would be willing to
share
> > > ??
> > > It'll be greatly appreciated
> > >
> > > T I A
>
> 
> Content-Type: text/x-vcard; charset="us-ascii";
name="Luis_deUrioste.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Luis Octavio de Urioste
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   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-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).
 <> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



RE: adding columns to system tables

2001-05-19 Thread Christopher Spence

 I don't think there is many select *, generally most people (as well as
oracle currently) name all the columns.

Even without doing this, unless your doing something wierd, ussually the
columns are not touched, although I would not recommend making this change
and would infact use a joined view.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 1:41 PM

Just think of the internal code that uses

SELECT * from USER_TAB_COLUMNS;

after you add a column. 

|| -Original Message-
|| From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 18, 2001 1:17 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: adding columns to system tables
|| 
|| 
|| Greg,
|| 
|| It is 'safe' in that you won't die or get injured.  However, 
|| your database
|| may and your support from Oracle certainly will.
|| 
|| "Don't even think about it."
|| 
|| Jack
|| 
|| 
|| Jack C. Applewhite
|| Database Administrator/Developer
|| OCP Oracle8 DBA
|| iNetProfit, Inc.
|| Austin, Texas
|| www.iNetProfit.com
|| [EMAIL PROTECTED]
|| (512)327-9068
|| 
|| 
|| -Original Message-
|| Schraiber
|| Sent: Friday, May 18, 2001 11:26 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Does anyone know if it is 'safe' to add additional columns
|| to user_tab_columns? I am running 8.1.5. I would use the new
|| columns to tell the application software which columns on
|| any one table are user editable by a dynamically generated
|| dialog form.
|| 
|| Thanks,
|| Greg
|| 
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Greg Schraiber
||   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-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).
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Jack C. Applewhite
||   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-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).
|| 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



RE: adding columns to system tables

2001-05-19 Thread Christopher Spence

 That can't be as bad as re-writing supplied packages :)

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 1:16 PM

Greg,

It is 'safe' in that you won't die or get injured.  However, your
database
may and your support from Oracle certainly will.

"Don't even think about it."

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Schraiber
Sent: Friday, May 18, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L


Does anyone know if it is 'safe' to add additional columns
to user_tab_columns? I am running 8.1.5. I would use the new
columns to tell the application software which columns on
any one table are user editable by a dynamically generated
dialog form.

Thanks,
Greg

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Schraiber
  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-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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



RE: Hi need some please

2001-05-19 Thread Christopher Spence

Depending if you mean rows or individual columns but this shouldnt' be to
difficult with PL/SQL.  With SQL it will be a little more difficult but
doable.  Unfortunately I don't know a site with this as I never had needed
to.



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 2:41 PM

Hi All,

Does anyone have a script that will compare table_a to table_b
and delete the dups in table_b,  or a site that might have one?

Thanks Very Much for any ideas.

-bill

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Conner
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



RE: dbms_sys_sql

2001-05-19 Thread Christopher Spence

 unless your concerned about the sys admin having access to the passwords,
generally using file level security is suitable to protect scripts with
passwords in them.  But that depends on how comfortable you are with the SA,
and if the shop has a fairly stable security structure.

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 6:11 PM

I am working on scripts that will create tables and users, grant
permissions, etc. every night on a clean copy of our db.  Without
dbms_sys_sql, I would have to connect to other users to do the grants.
I
don't want passwords anywhere in my scripts, I want to connect once then
run
everything from this one user.  dbms_sys_sql takes in a userid and sql
text
(plus a couple of other things) and runs the sql as that user.  

Linda

-Original Message-
Sent: Friday, May 18, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


Linda,

you should be using dbms_sql instead, which incidentally is *very*
stable.
What feature of dbms_sys_sql you need but isn't provided by dbms_sql? I
am
just curious ...

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but having an opinion is an art !
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seley, Linda
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



RE: adding columns to system tables

2001-05-19 Thread Christopher Spence

 It is generally considered bad practice, why not create another table with
the additional columns and just make a view that joins them?

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 12:25 PM

Does anyone know if it is 'safe' to add additional columns
to user_tab_columns? I am running 8.1.5. I would use the new
columns to tell the application software which columns on
any one table are user editable by a dynamically generated
dialog form.

Thanks,
Greg

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Greg Schraiber
  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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



Re: Why I can not create temporary tablespace?

2001-05-19 Thread David A. Barbour

Robert,

Check your syntax.

CREATE TEMPORARY TABLESPACE c2tmp TEMPFILE
'/oracle/oradata/c2datatmp.dat'
SIZE 50M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M;

Regards,

David A. Barbour

Robert Chen wrote:
> 
> hi, I connect as sys/change_on_install and execute this:
> 
> create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat'
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M;
> 
> Error at line 1:
> ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat'
> ORA-27037: unable to obtain file status
> SVR4 Error: 2: No such file or directory
> Additional information: 3
> 
> Please tell me why? I even change the directory to 777(anyone can read and
> write) still gotta this error.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robert Chen
>   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-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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David A. Barbour
  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-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).



Re: Why I can not create temporary tablespace?

2001-05-19 Thread Robert Chen

hi, I connect as sys/change_on_install and execute this:

create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat'
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M;

Error at line 1:
ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Please tell me why? I even change the directory to 777(anyone can read and
write) still gotta this error.

But I try this one:

create tablespace c3temp datafile '/oracle/home/oradata/c3temp.dat' size 1m;

It works fine and tell me tablespace created.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Chen
  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-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).



Why I can not create temporary tablespace?

2001-05-19 Thread Robert Chen

hi, I connect as sys/change_on_install and execute this:

create TEMPORARY TABLESPACE c2tmp TEMPFILE '/oracle/oradata/c2datatmp.dat'
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50M;

Error at line 1:
ORA-01119: Error in creating database file '/oracle/oradata/c2datatmp.dat'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Please tell me why? I even change the directory to 777(anyone can read and
write) still gotta this error.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Chen
  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-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).



iOraBugFinder available

2001-05-19 Thread Danisment Gazi Unal (Unal Bilisim)

Hi Gurus,

I developed a new web based product named iOraBugFinder.

iOraBugFinder scans Oracle's alert log files and ORA-600/ORA-7445 trace
files, extracts relevant information from them and generates URL links
to relevant bugs, notes, forums at Metalink.

It's at
http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html

regards...

--
Use itrprof SQL Analyzer.

itrprof SQL Analyzer is a web based tool which analyzes
SQL_TRACE/Event10046 trace files of Oracle,
finds bottlenecks and offersinformation on how to tune them.

No download, no setup, just click
http://www.unal-bilisim.com/products/itrprof/itrprof.html


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  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-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).



RE: RE: job offer from SAUDI ARABIA

2001-05-19 Thread Christopher Spence

 Interesting topic but I will make a brief comment.
(Still wondering how this became of job offerings but here goes)

1. Guns don't kill people, people do.
2. Goverment is too easy on criminals (at least in US) 
3. Why can't we all just get along?
4. If we all just got along, imagine the reduction in taxes for not needing
an army, navy, air force, special forces, and nucular weapons.  We all be
rich!  Now wouldn't that be nice.

Now considering we are all human, and for some time there will still be
humans on this planet, I will have a hand gun within proximity of my domicle
at all times, although I find no need to talk about it or run around
flashing it around.

Christopher,



-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/18/01 11:55 PM
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).



My Website

2001-05-19 Thread Christopher Spence

Some of you already know me from Lazyda list, some of your don't (prob
glad).  Well I have been working on putting up yet! another dba portal site.
I have articles, scripts, and forums.  I been really busy lately fire
fighting a huge new product of ours, so I haven't got as much content as I
wanted to have by now, but i do have about 45 articles and 30 or so scripts.
Most of the famous and popular (or ones I liked) articles are already up
their as I always had them an arms reach away.  Feel free to contact me
(please use email on site) for any additions one may feel appropriate.  And
unlike OTHER lists, none of the information on the site I claim as my own
unless it is of course, my own.  Everyone who participates gets due credit
and there are no royalties with the site either (go figure heh?).  

Now that everyone is asleep from me running on, here is the URL:

www.vampired.net Aka Vampire D's Oracle Den.

Christopher,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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-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).