date:20010827



Please reread my previous post.

Jared

On Monday 27 August 2001 22:00, Jenkins, Michael wrote:
> Sorry, I was just observing our fine country's "fair use" laws.  If I pay
> for a CD then I should be allowed to back it up just in case the disc
> becomes unusable.  Please don't use the information I've provided if you
> intend to pirate CDs.  After all Thomas Jefferson would be very happy to
> know that we are reverting back to his original concept of copyright law
> which only entitled exclusive ownership of your works for a limited time -
> - after that it went into the public domain!
>
> --Michael
>
> -Original Message-
> Sent: Monday, August 27, 2001 11:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Please, let's not distribute copyright infringement
> schemes via this list.
>
> Opinions on fairness of the law, etc., are really
> not important here either.
>
> Jared
>
> On Monday 27 August 2001 08:46, Kevin Kostyszyn wrote:
> > Actually, I have the crack to AOE, you want it?
> >
> > -Original Message-
> > Tom
> > Sent: Monday, August 27, 2001 10:55 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Off Topic:  I bought a PC this weekend that had my first every CDROM
> > burner. I
> > couldn't wait to use it.  I burned several game CD's (Age of Empires,
> > Return Fire II, Roller coaster Tycoon) and none of them worked.  The
> > games just hung
> > when I ran them.  Bummer.  Is it not possible to make copies of my CD's
> > or am I
> > doing something wrong?
> >
> > Tom
> >
> > Tom Terrian
> > Oracle DBA
> > WPAFB - DAASC
> > [EMAIL PROTECTED]
> > 937-656-3844
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Terrian, Tom
> >   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: 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).

RE: strange problem with v$recover_file ???

2001-08-27 Thread Reardon, Bruce (CALBBAY)


Andrea,

>From Metalink, the column is defined in uppercase:

SQL> select online from v$recover_file;
select online from v$recover_file
   *
ERROR at line 1:
ORA-00936: missing expression


SQL> select "ONLINE" from v$recover_file;

no rows selected

Also, online is a reserved word and that is why you originally get the
ora-00936 error:

SQL> select * from v$reserved_words where keyword ='ONLINE';

KEYWORD  LENGTH
 --
ONLINE6

SQL> 

Regards,
Bruce Reardon.

-Original Message-
Sent: Tuesday, 28 August 2001 8:22 

All, I got a problem with v$recover_file.  Somehow the
query failed if selecting is on ONLINE column.

SQL> desc v$recover_file;

 Name  Null?Type
 - 
---
 FILE#  NUMBER
 ONLINE VARCHAR2(7)
 ERROR  VARCHAR2(18)
 CHANGE#NUMBER
 TIME   DATE



These are OK:
---
select  CHANGE#  from v$recover_file; 
select TIME from  v$recover_file;
select * from v$recover_file;

However these gave me error:

select  ONLINE from v$recover_file;
select online, ERROR from  v$recover_file;
select  FILE# , ONLINE,ERROR , CHANGE#,TIME from 
v$recover_file;
 *
ERROR at line 1:
ORA-00936: missing expression

SQL> select v.name, b.online
  2  from v$datafile v, v$recover_file b
  3  where v.file# = b.file#; 
select v.name, b.online
 *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or
column specification


What's happening?!  Thank you.

Andrea
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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: FROM SRINIVAS -HELP

2001-08-27 Thread Nirmal Kumar Muthu Kumaran


If those records are able to retrieve by a query, then u can use export with
query option too.

Nirmal.

> -Original Message-
> From: Jared Still [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 6:06 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: FROM SRINIVAS -HELP
> 
> 
> 
> Some requirements please:
> 
> is it ok if a row is chosen more than once?
> 
> it will be statistically impossible to pick 10 million
> rows from a set of 44 million without many duplicates.
> 
> if it is ok, just write a pl/sql script to loop through
> the table, skip a random number of rows, grab one, repeat.
> 
> you will likely have to scan the table multiple times.
> 
> not very efficient.  but hey!, I'm just the idea man here.  :)
> 
> if you don't want duplicates, you will need to track those that
> you have already chosen and skip them.  this has the potential
> to be a very long running script.
> 
> why not just go throught the entire table once, pick every 4th
> row, and be done with it?
> 
> Not random, but just how important is randomness to you?  you 
> didn't state the purpose of this exercise.
> 
> Jared
> 
> On Monday 27 August 2001 09:00, [EMAIL PROTECTED] wrote:
> > I have 44 million records in my table.I need to extract the 10 million
> > records randomly,how to retrieve these records randomly. I used the
> > dbms_random.sql ,but I have a doubt that I was correct or not.
> > can U please guide me or just send a piece of code.
> > Thanking U
> > srinivas
> -- 
> 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: Nirmal Kumar  Muthu Kumaran
  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: strange problem with v$recover_file ???

2001-08-27 Thread Rukmini Devi


Hi ,

  ONLINE is a reserved word.  It should not be used as a column name. I
think it is bug.

rukmini
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 3:51 AM


> All, I got a problem with v$recover_file.  Somehow the
> query failed if selecting is on ONLINE column.
>
> SQL> desc v$recover_file;
>
>  Name  Null?Type
>  - 
> ---
>  FILE#  NUMBER
>  ONLINE VARCHAR2(7)
>  ERROR  VARCHAR2(18)
>  CHANGE#NUMBER
>  TIME   DATE
>
>
>
> These are OK:
> ---
> select  CHANGE#  from v$recover_file;
> select TIME from  v$recover_file;
> select * from v$recover_file;
>
> However these gave me error:
> 
> select  ONLINE from v$recover_file;
> select online, ERROR from  v$recover_file;
> select  FILE# , ONLINE,ERROR , CHANGE#,TIME from
> v$recover_file;
>  *
> ERROR at line 1:
> ORA-00936: missing expression
>
> SQL> select v.name, b.online
>   2  from v$datafile v, v$recover_file b
>   3  where v.file# = b.file#;
> select v.name, b.online
>  *
> ERROR at line 1:
> ORA-01747: invalid user.table.column, table.column, or
> column specification
>
>
> What's happening?!  Thank you.
>
> Andrea
>
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrea Oracle
>   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: Rukmini Devi
  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).

DBMS_JOB Help

2001-08-27 Thread Rangachari Sundar


Hi All,

Can Anyone tell me how to stop a background job initiated through a
DBMS_JOB package when it is no longer required?

Thanks in advance.

Regards
Sundar

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rangachari Sundar
  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: Installing 73 and 816 on one NT server?

2001-08-27 Thread Mohan, Ross

 YES

-Original Message-
To: [EMAIL PROTECTED]; Mohan, Ross
Sent: 8/27/2001 10:08 PM

Are you an idiot?

On Monday 27 August 2001 09:16, Mohan, Ross wrote:
> HELP
>
> -Original Message-
> Sent: Friday, August 24, 2001 3:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> nobody would be that dumb, would they? :)
>
> > --
> >
> >  From: "Mohan, Ross" <[EMAIL PROTECTED]>
> >  Date: Thu, 23 Aug 2001 11:13:04 -0400
> >  Subject: RE: Installing 73 and 816 on one NT server?
>
> [via ORACLE-L Digest -- Volume 2001, Number 236]
>
> > ... sw raid?
-- 
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).

RE: Burning game CD's

2001-08-27 Thread Jenkins, Michael

Sorry, I was just observing our fine country's "fair use" laws.  If I pay
for a CD then I should be allowed to back it up just in case the disc
becomes unusable.  Please don't use the information I've provided if you
intend to pirate CDs.  After all Thomas Jefferson would be very happy to
know that we are reverting back to his original concept of copyright law
which only entitled exclusive ownership of your works for a limited time - -
after that it went into the public domain!

--Michael

-Original Message-
Sent: Monday, August 27, 2001 11:00 PM
To: Multiple recipients of list ORACLE-L

Please, let's not distribute copyright infringement
schemes via this list.

Opinions on fairness of the law, etc., are really 
not important here either.

Jared

On Monday 27 August 2001 08:46, Kevin Kostyszyn wrote:
> Actually, I have the crack to AOE, you want it?
>
> -Original Message-
> Tom
> Sent: Monday, August 27, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Off Topic:  I bought a PC this weekend that had my first every CDROM
> burner. I
> couldn't wait to use it.  I burned several game CD's (Age of Empires,
> Return Fire II, Roller coaster Tycoon) and none of them worked.  The games
> just hung
> when I ran them.  Bummer.  Is it not possible to make copies of my CD's or
> am I
> doing something wrong?
>
> Tom
>
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terrian, Tom
>   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: 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: Jenkins, Michael
  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: Burning game CD's

2001-08-27 Thread Kevin Kostyszyn


Wow, someone had a really bad day!  It's ok to post things like this, we'lll
try to keep this in mind the next tiem you post a question!
KK
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 6:16 PM


> You are doing several things wrong:
> a) You are mailing yuor question to the wrong list.
> b) You haven't read the fine manuals.
> Conclusion: RTFM and do that somewhere else.
> Have a nice day.
>
> > -Original Message-
> > From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 27, 2001 10:55 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: OT: Burning game CD's
> >
> >
> > Off Topic:  I bought a PC this weekend that had my first
> > every CDROM burner.  I
> > couldn't wait to use it.  I burned several game CD's (Age of
> > Empires, Return
> > Fire II, Roller coaster Tycoon) and none of them worked.  The
> > games just hung
> > when I ran them.  Bummer.  Is it not possible to make copies
> > of my CD's or am I
> > doing something wrong?
> >
> > Tom
> >
> > Tom Terrian
> > Oracle DBA
> > WPAFB - DAASC
> > [EMAIL PROTECTED]
> > 937-656-3844
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Terrian, Tom
> >   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: Gogala, Mladen
>   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: Kevin Kostyszyn
  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: SQL+ SELECT statement need help solve

2001-08-27 Thread Sinardy


Hi all,

Thank you Kirti, Irfan, Shah



-Original Message-
Sent: Tuesday, 28 August 2001 10:47 AM
To: [EMAIL PROTECTED]; LazyDBA.com Discussion


Sinardy,
Here is one way to do it (using CHR(10) for new line) :

SELECT 'NAME : ' || ename || CHR(10) ||  ' DEPARTMENT : ' || dept || CHR(10)
|| '   SALARY : ' || sal
FROM emp;

HTH,

Regards,

- Kirti Deshpande
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Sinardy [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 9:24 PM
> To:   LazyDBA.com Discussion
> Subject:  SQL+ SELECT statement need help
>
> Hi all,
>
> 1. I have table emp (ename, dept, sal)
> 2. I do
>   SELECT 'NAME : ' || ename || '  DEPARTMENT : ' || dept || '   SALARY
> : ' ||
> sal
>   FROM emp;
>
>   Result:
>
>   NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY : 2000
>   NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000
>
>
> 3. I can I break them to be like
>
>   Name : JAMES
>   DEPARTMENT : LAB ENGINNER
>   SALARY : 2000
>
>   NAME : BOB
>   DEPTARTMENT : DRIVER
>   SALARY : 2000
>
>   something like a new line ('/n') in C++
>
>   SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' || dept || '/n
> SALARY :
> ' || sal
>   FROM emp;
>
>
> Thank you
>
> Sinardy
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: SQL+ SELECT statement need help

2001-08-27 Thread CHAN Chor Ling Catherine (CSC)


Try CHR(10) 

.ie. SELECT 'NAME : ' || ename ||CHR(10)||'DEPARTMENT : ' || dept ||
CHR(10)||'SALARY : ' ||sal FROM emp;

Hope it helps.

Regds,
Chorling
-Original Message-
From:   Sinardy [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, August 28, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Subject:SQL+ SELECT statement need help

Hi all,

1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || '  DEPARTMENT : ' ||
dept || '   SALARY : ' ||
sal
FROM emp;

Result:

NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY :
2000
NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000


3. I can I break them to be like

Name : JAMES
DEPARTMENT : LAB ENGINNER
SALARY : 2000

NAME : BOB
DEPTARTMENT : DRIVER
SALARY : 2000

something like a new line ('/n') in C++

SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' ||
dept || '/n   SALARY :
' || sal
FROM emp;


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: CHAN Chor Ling Catherine (CSC)
  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: SQL+ SELECT statement need help

2001-08-27 Thread Deshpande, Kirti


Sinardy, 
Here is one way to do it (using CHR(10) for new line) : 

SELECT 'NAME : ' || ename || CHR(10) ||  ' DEPARTMENT : ' || dept || CHR(10)
|| '   SALARY : ' || sal
FROM emp;

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Sinardy [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 10:41 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  SQL+ SELECT statement need help
> 
> Hi all,
> 
> 1. I have table emp (ename, dept, sal)
> 2. I do
>   SELECT 'NAME : ' || ename || '  DEPARTMENT : ' || dept || '   SALARY
> : ' ||
> sal
>   FROM emp;
> 
>   Result:
> 
>   NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY : 2000
>   NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000
> 
> 
> 3. I can I break them to be like
> 
>   Name : JAMES
>   DEPARTMENT : LAB ENGINNER
>   SALARY : 2000
> 
>   NAME : BOB
>   DEPTARTMENT : DRIVER
>   SALARY : 2000
> 
>   something like a new line ('/n') in C++
> 
>   SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' || dept || '/n
> SALARY :
> ' || sal
>   FROM emp;
> 
> 
> Thank you
> 
> Sinardy
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Sinardy
>   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: Deshpande, Kirti
  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).

SQL+ SELECT statement need help

2001-08-27 Thread Sinardy


Hi all,

1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || '  DEPARTMENT : ' || dept || '   SALARY : ' ||
sal
FROM emp;

Result:

NAME : JAMES   DEPARTMENT : LAB ENGINEER   SALARY : 2000
NAME : BOB   DEPARTMENT : DRIVER   SALARY : 2000


3. I can I break them to be like

Name : JAMES
DEPARTMENT : LAB ENGINNER
SALARY : 2000

NAME : BOB
DEPTARTMENT : DRIVER
SALARY : 2000

something like a new line ('/n') in C++

SELECT 'NAME : ' || ename || '/n  DEPARTMENT : ' || dept || '/n   SALARY :
' || sal
FROM emp;


Thank you

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  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: OT:Unix Q - Solved

2001-08-27 Thread Ross Collado

Thanks. That's it.

> -Original Message-
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 28 August 2001 12:15
> To: [EMAIL PROTECTED]; Ross Collado
> Subject: Re: OT:Unix Q
> 
> 
> 
> do a 'man ssh-keygen'
> 
> Jared
> 
> On Monday 27 August 2001 19:41, Ross Collado wrote:
> > To all Unix gurus,
> >
> > What's the command to generate an "identity.pub" file for 
> use in ssh ?
> >
> > Rgds,
> > Ross
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  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: OT:Unix Q

do a 'man ssh-keygen'

Jared

On Monday 27 August 2001 19:41, Ross Collado wrote:
> To all Unix gurus,
>
> What's the command to generate an "identity.pub" file for use in ssh ?
>
> Rgds,
> Ross
-- 
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).

Re: FROM SRINIVAS -HELP

Some requirements please:

is it ok if a row is chosen more than once?

it will be statistically impossible to pick 10 million
rows from a set of 44 million without many duplicates.

if it is ok, just write a pl/sql script to loop through
the table, skip a random number of rows, grab one, repeat.

you will likely have to scan the table multiple times.

not very efficient.  but hey!, I'm just the idea man here.  :)

if you don't want duplicates, you will need to track those that
you have already chosen and skip them.  this has the potential
to be a very long running script.

why not just go throught the entire table once, pick every 4th
row, and be done with it?

Not random, but just how important is randomness to you?  you 
didn't state the purpose of this exercise.

Jared

On Monday 27 August 2001 09:00, [EMAIL PROTECTED] wrote:
> I have 44 million records in my table.I need to extract the 10 million
> records randomly,how to retrieve these records randomly. I used the
> dbms_random.sql ,but I have a doubt that I was correct or not.
> can U please guide me or just send a piece of code.
> Thanking U
> srinivas
-- 
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).

Re: Installing 73 and 816 on one NT server?

Are you an idiot?

On Monday 27 August 2001 09:16, Mohan, Ross wrote:
> HELP
>
> -Original Message-
> Sent: Friday, August 24, 2001 3:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> nobody would be that dumb, would they? :)
>
> > --
> >
> >  From: "Mohan, Ross" <[EMAIL PROTECTED]>
> >  Date: Thu, 23 Aug 2001 11:13:04 -0400
> >  Subject: RE: Installing 73 and 816 on one NT server?
>
> [via ORACLE-L Digest -- Volume 2001, Number 236]
>
> > ... sw raid?
-- 
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).

Re: OT:Unix Q

2001-08-27 Thread Joe Testa

man ssh?

joe

Ross Collado wrote:
> 
> To all Unix gurus,
> 
> What's the command to generate an "identity.pub" file for use in ssh ?
> 
> Rgds,
> Ross
> --

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
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

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: Burning game CD's



Please, let's not distribute copyright infringement
schemes via this list.

Opinions on fairness of the law, etc., are really 
not important here either.

Jared


On Monday 27 August 2001 08:46, Kevin Kostyszyn wrote:
> Actually, I have the crack to AOE, you want it?
>
> -Original Message-
> Tom
> Sent: Monday, August 27, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Off Topic:  I bought a PC this weekend that had my first every CDROM
> burner. I
> couldn't wait to use it.  I burned several game CD's (Age of Empires,
> Return Fire II, Roller coaster Tycoon) and none of them worked.  The games
> just hung
> when I ran them.  Bummer.  Is it not possible to make copies of my CD's or
> am I
> doing something wrong?
>
> Tom
>
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Terrian, Tom
>   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: 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).

OT:Unix Q

2001-08-27 Thread Ross Collado


To all Unix gurus,

What's the command to generate an "identity.pub" file for use in ssh ?

Rgds,
Ross
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  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: How fast are your tape backups?

2001-08-27 Thread Reardon, Bruce (CALBBAY)


FYI,

We have NT4, 1Gb RAM.
Fibre Channel Disks
Tape Drive is a Dell (Quantum) DLT7000 connected via SCSI.
Using Backup Exec.

Our total backup and verify is 17.6Gb which takes 126 mins (2.4MB/sec but
includes verify).
If I consider just a 1 drive backup only (ie no verify) we backup approx 5
Gb at 541.3 MB / min = 9 MB/sec.
(This is using Hardware compression).

HTH,
Bruce Reardon

-Original Message-
Sent: Tuesday, 28 August 2001 11:05 

Hello list.  I have a brand new database that is around 200 GB in
size.  Our tape backup solution which was supplied by the hosting
company is only giving me bewteen 6 and 7 MB per second .  A full cold
backup can take 8 to 10 hours at this rate.  

I looked at the specs for the tape library they sold us and it says
15MB/sec or up to 30 MB/sec compressed.  What gives?  The storage is
SCSI 3 and also some Fibre channel so I don't think the drives are the
bottleneck.

What kind of numbers are other people getting?

The system
NT 4 
4GB RAM
400 GB storage (mix of SCSI 3 and fibre)
Oracle 8.1.6.3.0
~ 200 GB in Oracle data files
Tivoli Storage Manager
IBM robotic  tape library (via fibre)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  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: How fast are your tape backups?

2001-08-27 Thread Satar Naghshineh

Title: RE: How fast are your tape backups?





50 gigs in 1.5 hours.


HPUX 10.20
OmniBack 3.5
Oracle 7.3.4
HP DLT8000


Regards,
Satar Naghshineh


-Original Message-
From:   J.C. Stofer [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, August 28, 2001 2:05 AM
To: Multiple recipients of list ORACLE-L
Subject:    How fast are your tape backups?


Hello list.  I have a brand new database that is around 200 GB in
size.  Our tape backup solution which was supplied by the hosting
company is only giving me bewteen 6 and 7 MB per second .  A full cold
backup can take 8 to 10 hours at this rate.  


I looked at the specs for the tape library they sold us and it says
15MB/sec or up to 30 MB/sec compressed.  What gives?  The storage is
SCSI 3 and also some Fibre channel so I don't think the drives are the
bottleneck.


What kind of numbers are other people getting?


The system
NT 4 
4GB RAM
400 GB storage (mix of SCSI 3 and fibre)
Oracle 8.1.6.3.0
~ 200 GB in Oracle data files
Tivoli Storage Manager
IBM robotic  tape library (via fibre)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: J.C. Stofer
  INET: [EMAIL PROTECTED]

Re: one file being relinked in wrong ORACLE_HOME

2001-08-27 Thread Joe Testa


i didnt think you could have 2 oracle homes with that low of a verison
difference, i thought the lowest was x.x.x anything below that couldnt
have different oracle homes, am i wrong here?

joe
Doug C wrote:
> 
> We have 2 Oracle Homes, one of which was upgraded to 8.1.7.1 on Jul 25th. The
> other Oracle Home is just vanilla 8.1.7. We did a "relink all" on the 8.1.7 last
> night which completed successfully. There are no problems being reported by
> anybody. We checked the entire environment before the relink and found all
> settings properly referring to this 8.1.7 home. One file however, libagtsh.a,
> which exists in the 8.1.7.1 home/lib directory, now shows that it is timestamped
> at the time of this relink. Any ideas? Thanks.
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Doug C
>   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)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
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

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: Migrate/Update-which way is better?

2001-08-27 Thread Mario Alberto Ramos Arellano


For those interested..

We migrated by exp/imp from 8.0.6 to 8.1.7. Got some errors on system objects but so 
far everything is going smoothly.

>>> [EMAIL PROTECTED] 08/24/01 17:13 PM >>>
system can get hosed up weird, part  of it depends on ignore= setting.

if you do ignore=y then it will potentially mess up system stuff(someone
qith AQ experience, clarify, doesnt the AQ stuff get loaded into the
system schema?).

I seem to remember that as a problem.

joe
Mario Alberto Ramos Arellano wrote:
> 
> What happens to system?
> During a migration, does SYSTEM get corrupted because of importing older versions of 
>system objects?
> Is it needed to run catalog and catproc again on the new version?
> 
> >>> [EMAIL PROTECTED] 08/23/01 23:27 PM >>>
> 
> nope, not SYS
> 
> >From: Jon Walthour <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Re: Migrate/Update-which way is better?
> >Date: Thu, 23 Aug 2001 10:00:58 -0800
> >
> > > 1. I have a full export dump, I know the objects owned by sys are not
> >exported/imported. What happens to the objects owned by system?
> >
> >Listers, please correct me if I am wrong here, but that's not my
> >understanding. I have recreated a complete database from a full export in
> >the past and the 8i Utilities manual says that a full export "exports the
> >entire database". So, I'm almost certain that includes SYS.
> >
> >Jon Walthour
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mario Alberto Ramos Arellano
>   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)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
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

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: Mario Alberto Ramos Arellano
  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: svrmgrl, sqlplus question ???

2001-08-27 Thread Charlie Mengler



When I'm logged onto the Unix system as user "oracle"
using 9i, Oracle refuses to allow me to log into it by
just using "/". It insists that always include the two
words " / as sysdba"! Since it precludes me from
logging into Oracle just using "/", what is gained by
forcing me to always specify "as sysdba", too


Rachel Carmichael wrote:

> you cannot format in svrmgrl  and you should start learning to use sqlplus
> for this stuff, as svrmgrl goes away in 9i
>
> in sqlplus what I do is:
>
> sqlplus
>
> then at the username prompt I type
>
> / as sysdba
>
> once you do that you can do startup and shutdown
>
> >From: Janet Linsy <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: svrmgrl, sqlplus question ???
> >Date: Mon, 27 Aug 2001 13:21:20 -0800
> >
> >Hi all,
> >
> >In sqlplus, you can use "col ... format ..." to make
> >the output pretty. Can we format columns, make title
> >in svrmgrl?
> >
> >Also I read that sqlplus can be used to mount, open
> >database in 8i, but I don't see how.
> >
> >The db is 815 on Sun 5.6.
> >
> >Thank you!
> >
> >Janet
> >
> >__
> >Do You Yahoo!?
> >Make international calls for as low as $.04/minute with Yahoo! Messenger
> >http://phonecard.yahoo.com/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Janet Linsy
> >   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).
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
>   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: Charlie Mengler
  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).

tnsnames error

2001-08-27 Thread Ravi R


  I am getting an error when I try to connect to the DBA Studio of Or9iAS 
the error is " failed to parse tnsnames.ora file" Error:100 --NLNV-NLNV String
format error. I tried to recreate a new tnsnames,but again shows the same. Do
any body know how to rectify the error.

Thanks
Ravi






Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravi R
  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: svrmgrl, sqlplus question ???

2001-08-27 Thread Rachel Carmichael


you cannot format in svrmgrl  and you should start learning to use sqlplus 
for this stuff, as svrmgrl goes away in 9i

in sqlplus what I do is:

sqlplus

then at the username prompt I type

/ as sysdba

once you do that you can do startup and shutdown



>From: Janet Linsy <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: svrmgrl, sqlplus question ???
>Date: Mon, 27 Aug 2001 13:21:20 -0800
>
>Hi all,
>
>In sqlplus, you can use "col ... format ..." to make
>the output pretty. Can we format columns, make title
>in svrmgrl?
>
>Also I read that sqlplus can be used to mount, open
>database in 8i, but I don't see how.
>
>The db is 815 on Sun 5.6.
>
>Thank you!
>
>Janet
>
>__
>Do You Yahoo!?
>Make international calls for as low as $.04/minute with Yahoo! Messenger
>http://phonecard.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Janet Linsy
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

No Subject

2001-08-27 Thread Satar Naghshineh

Title: 





Hello Ladies and Gentlemen,


I need to present a proposal to management on Upgrading our database from Oracle 7 to 8i (don't laugh, we know we're behind the times!). I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal or presentation. Also, any ideas or thoughts that should be included, will be greatly appreciated.

If any of you are Running BaaN ERP on top of Oracle, I would love to hear from you as well.


Regards,
Satar Naghshineh



mailto:[EMAIL PROTECTED]

How fast are your tape backups?

2001-08-27 Thread J.C. Stofer


Hello list.  I have a brand new database that is around 200 GB in
size.  Our tape backup solution which was supplied by the hosting
company is only giving me bewteen 6 and 7 MB per second .  A full cold
backup can take 8 to 10 hours at this rate.  

I looked at the specs for the tape library they sold us and it says
15MB/sec or up to 30 MB/sec compressed.  What gives?  The storage is
SCSI 3 and also some Fibre channel so I don't think the drives are the
bottleneck.

What kind of numbers are other people getting?

The system
NT 4 
4GB RAM
400 GB storage (mix of SCSI 3 and fibre)
Oracle 8.1.6.3.0
~ 200 GB in Oracle data files
Tivoli Storage Manager
IBM robotic  tape library (via fibre)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: J.C. Stofer
  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: Efficient way to monitor table growth...



In general, you don't need to know the rowcounts
if you know the typical size of a row and the total
space usage for a table/index.  An analyze will
get you these figures as a starting point.

After that, you need only track the object's
high water mark using the dbms_space package
to track growth on a frequent, but low-cost basis.
(there are some samples on my website).



Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 August 2001 23:23


|Hi DBA's
|
|Does an Oracle Stored Procedure or function exist that returns the
row count
|by table in each tablespace?
|I've observed that one of our production tablespaces is has only 8%
free
|space. Perhaps it could be fragmented. I'll have to find a script
that can
|provide these statistics. I know I'll need to add another datafile to
the
|tablespace soon.
|However, I'd like to find out which are the active tables in each
tablespace
|and track the row insert growth on a daily basis.
|


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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-link after new kernel extension loaded for different Oracle Home?

2001-08-27 Thread Doug C


Hello - this is AIX 4.3.3
We did an 8.1.7 install into a separate home which required a new pw-syscall be
loaded.  
An 8.0.5 database then started to act funny.  (couple of core dumps a day that
aren't always repeatable).  
I though that pw-syscall was largely an extension to handle semaphores and
wouldn't be involved in relinking but

What do you all think?  Relink in this situation? Always? Sometimes?

Thanks,
Doug
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Doug C
  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: Efficient way to monitor table growth...

2001-08-27 Thread Michael Netrusov


Analyze tables then look at dba_tables.num_rows. Doing it on a daily will
give you what you want.

HTH,
Michael

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 15:58


> Hi DBA's
>
> Does an Oracle Stored Procedure or function exist that returns the row
count
> by table in each tablespace?
> I've observed that one of our production tablespaces is has only 8% free
> space. Perhaps it could be fragmented. I'll have to find a script that can
> provide these statistics. I know I'll need to add another datafile to the
> tablespace soon.
> However, I'd like to find out which are the active tables in each
tablespace
> and track the row insert growth on a daily basis.
>
> Any ideas?
>
> Thanks for your help.
>
> Denmark Weatherburne
> Belize
> "Knowledge is power, but it is only useful if it is shared!"
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Denmark Weatherburne
>   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: Michael Netrusov
  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: Data Center monitoring

2001-08-27 Thread Raghu Kota


Dear Friends

Thank you somuch for your valueble input for my job. I leared alot from 
these lists!! Thankyou all.

Raghu.



>From: "Deshpande, Kirti" <[EMAIL PROTECTED]>
>To: Raghu Kota <[EMAIL PROTECTED]>,"LazyDBA.com Discussion"  
><[EMAIL PROTECTED]>,[EMAIL PROTECTED]
>Subject: RE: Data Center monitoring
>Date: Mon, 27 Aug 2001 16:25:52 -0500
>
>Raghu,
>We use BMC - PATROL for database monitoring. However, we removed all the
>out-of-box actions by it, and replaced those with our own where ever 
>needed.
>We do not let Patrol change anything in the database (for example,
>allocating space when it detects extent problems). Instead, it e-mails and
>pages the responsible DBA by running our scripts that figure out who is the
>responsible DBA. We also use only about 15 or so parameters for Patrol
>monitoring (I think patrol has about 50 or so). It's an expensive solution
>for the things we currently do with it, but does it solve the problem of
>keeping up with scripts etc for new servers and databases. We have a very
>dynamic environment with 100s of databases on multiple platforms (VAX
>VMS/Alpha, SUN, HP, AIX  etc).. Patrol is a right solution for it.
>
>HTH,
>Regards,
>
>- Kirti Deshpande
>   Verizon Information Services
>http://www.superpages.com
>
> > -Original Message-
> > From:   Raghu Kota [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, August 27, 2001 2:16 PM
> > To: LazyDBA.com Discussion
> > Subject:Data Center monitoring
> >
> >
> >
> > Hi Gurus,
> >
> > I have number of Oracle8i instances  on HP-Ux in a 400 servers Data
> > center!!
> > I want valuble suggestions from Gurus and who maintaining their real 
>Data
> > ceners.. I appreciate your help.
> >
> > Thanks in advance
> > Raghu.
> >
> >
> >
> > _
> > Get your FREE download of MSN Explorer at 
>http://explorer.msn.com/intl.asp
> >
> >
> > 
> > Oracle documentation is here:
> > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to [EMAIL PROTECTED]
> > To subscribe:   send a blank email to [EMAIL PROTECTED]
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Efficient way to monitor table growth...

2001-08-27 Thread Denmark Weatherburne


Hi DBA's

Does an Oracle Stored Procedure or function exist that returns the row count 
by table in each tablespace?
I've observed that one of our production tablespaces is has only 8% free 
space. Perhaps it could be fragmented. I'll have to find a script that can 
provide these statistics. I know I'll need to add another datafile to the 
tablespace soon.
However, I'd like to find out which are the active tables in each tablespace 
and track the row insert growth on a daily basis.

Any ideas?

Thanks for your help.

Denmark Weatherburne
Belize
"Knowledge is power, but it is only useful if it is shared!"

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denmark Weatherburne
  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: Logical Backup for a large database

2001-08-27 Thread Weaver, Walt

Well, to play the Devil's advocate here, the big advantage of export/import
is that it's faster than recovering from RMAN and takes much less disk
space. Here we're contractually obliged to recover customers' data from a
previous night's backup, not earlier. So, an export can work for us. We do
exports every night here, along with RMAN backups.

But, our customer data is nowhere near 150gb.

However as Steve Orr mentioned in a separate post, we recovered from data
loss using RMAN a couple of weeks ago. It really is a much, much better
backup strategy in most cases.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, August 27, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L

I think recommending regular exports for a 150Gb database is a
mistake.

Instead, you should practice using RMAN to restore and recover to a
separate location.  You can limit the size and complexity of a single
table restore by restoring only the table's tablespace, the SYSTEM and
any tablespaces containing rollback segments.

Once you have restored and recovered the one tablespace you need, you
can export the table and import it into the production system.  This
method provides protection that is superior to exports, because it
allows the recovery of a single table to an arbitrary point in time.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 27 Aug 2001, Wong, Bing wrote:

> I would suggest to export schema by schema and schedule the jobs to run
> different time.  In the export job, use pipe file at the unix level to
> compress the export file.  The command is as follows:
>
> To export and compress at the unix level...
>
> mknod export_pipe p
> compress < export_pipe > export.dmp.Z
> exp  ...   file=export_pipe
>
>
> To import and uncompress...
>
> uncompress < export.dmp.Z > export_pipe
> imp ...   file=export_pipe
>
>
> -Original Message-
> Sent: Monday, August 27, 2001 2:11 PM
> To: Multiple recipients of list ORACLE-L
>
> Last week one of my user dropped a table since we don't have any backup
> except for rman backup. It is not allowe me to do any recovery on 7/24
> database.  Anyway we recreate the table(we are lucky, this table hold
> parameters)
>
> This make me think of situation of lossing very important big table. We
have
> about 1000 tables with bigget one of  8GB .
>
> Is there any idea how to perform a logical backup on a database with
150GBs.
> Or take a TSPITR in case of those kind of thing  happen again.  From my
> case, imp/exp looks impossibe from point of view of timing and spacing.
The
> question will be the same for TSOITR on large database. Is there any other
> way to prepre those kind of situation.

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

Do you use Ora8 Perf. Mon. v8.0?

2001-08-27 Thread Denmark Weatherburne


H DBA's


We are running Oracle 8.0.5.0.0 on the NT platform.
I'm currently collecting information about Oracle's Statspack.
I found out that I can run it on Oracle 805 as well even though it was 
released for Oracle version 816.
I was looking at the Oracle8 Performance Monitor v8.0 GUI tool that comes 
with Oracle for Windows NT.
It has to be configured with appropriate counters to display graphs.
Is this a useful tool?
If anyone uses it, I would appreciate some documentaion on configuring it.

Thanks in advance,

Denmark Weatherburne
Belize

"Knowledge is power, but it is only useful if it is shared!"

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

User/Schema ?

2001-08-27 Thread Richard Huntley


The database setup for an application is as follows...schema1 (owns objects)
and schema2 (accesses objects owned by schema1).
I need to copy the DB setup for the application to a test server set up with
a development-like setup, i.e. instead of the tablespaces that are created
in production for the application there is a generic USERS tablespace,
etc...  Can anyone give suggestions on what the quickest way to copy the
schemas would be given the difference with the physical setup (disk layout)
and logical setup (different tablespaces)???  What are my alternatives?

TIA,

Richard Huntley
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard Huntley
  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: Logical Backup for a large database

2001-08-27 Thread Orr, Steve

Yup, just did that 2 weeks ago.

Steve Orr

-Original Message-
Sent: Monday, August 27, 2001 3:55 PM
To: Multiple recipients of list ORACLE-L

I think recommending regular exports for a 150Gb database is a
mistake.

Instead, you should practice using RMAN to restore and recover to a
separate location.  You can limit the size and complexity of a single
table restore by restoring only the table's tablespace, the SYSTEM and
any tablespaces containing rollback segments.

Once you have restored and recovered the one tablespace you need, you
can export the table and import it into the production system.  This
method provides protection that is superior to exports, because it
allows the recovery of a single table to an arbitrary point in time.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 27 Aug 2001, Wong, Bing wrote:

> I would suggest to export schema by schema and schedule the jobs to run
> different time.  In the export job, use pipe file at the unix level to
> compress the export file.  The command is as follows:
>
> To export and compress at the unix level...
>
> mknod export_pipe p
> compress < export_pipe > export.dmp.Z
> exp  ...   file=export_pipe
>
>
> To import and uncompress...
>
> uncompress < export.dmp.Z > export_pipe
> imp ...   file=export_pipe
>
>
> -Original Message-
> Sent: Monday, August 27, 2001 2:11 PM
> To: Multiple recipients of list ORACLE-L
>
> Last week one of my user dropped a table since we don't have any backup
> except for rman backup. It is not allowe me to do any recovery on 7/24
> database.  Anyway we recreate the table(we are lucky, this table hold
> parameters)
>
> This make me think of situation of lossing very important big table. We
have
> about 1000 tables with bigget one of  8GB .
>
> Is there any idea how to perform a logical backup on a database with
150GBs.
> Or take a TSPITR in case of those kind of thing  happen again.  From my
> case, imp/exp looks impossibe from point of view of timing and spacing.
The
> question will be the same for TSOITR on large database. Is there any other
> way to prepre those kind of situation.

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

strange problem with v$recover_file ???

2001-08-27 Thread Andrea Oracle


All, I got a problem with v$recover_file.  Somehow the
query failed if selecting is on ONLINE column.

SQL> desc v$recover_file;

 Name  Null?Type
 - 
---
 FILE#  NUMBER
 ONLINE VARCHAR2(7)
 ERROR  VARCHAR2(18)
 CHANGE#NUMBER
 TIME   DATE



These are OK:
---
select  CHANGE#  from v$recover_file; 
select TIME from  v$recover_file;
select * from v$recover_file;

However these gave me error:

select  ONLINE from v$recover_file;
select online, ERROR from  v$recover_file;
select  FILE# , ONLINE,ERROR , CHANGE#,TIME from 
v$recover_file;
 *
ERROR at line 1:
ORA-00936: missing expression

SQL> select v.name, b.online
  2  from v$datafile v, v$recover_file b
  3  where v.file# = b.file#; 
select v.name, b.online
 *
ERROR at line 1:
ORA-01747: invalid user.table.column, table.column, or
column specification


What's happening?!  Thank you.

Andrea

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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: Data Center monitoring

2001-08-27 Thread Deshpande, Kirti


Raghu,
We use BMC - PATROL for database monitoring. However, we removed all the
out-of-box actions by it, and replaced those with our own where ever needed.
We do not let Patrol change anything in the database (for example,
allocating space when it detects extent problems). Instead, it e-mails and
pages the responsible DBA by running our scripts that figure out who is the
responsible DBA. We also use only about 15 or so parameters for Patrol
monitoring (I think patrol has about 50 or so). It's an expensive solution
for the things we currently do with it, but does it solve the problem of
keeping up with scripts etc for new servers and databases. We have a very
dynamic environment with 100s of databases on multiple platforms (VAX
VMS/Alpha, SUN, HP, AIX  etc).. Patrol is a right solution for it.   

HTH,
Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Raghu Kota [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 2:16 PM
> To:   LazyDBA.com Discussion
> Subject:  Data Center monitoring
> 
> 
> 
> Hi Gurus,
> 
> I have number of Oracle8i instances  on HP-Ux in a 400 servers Data
> center!! 
> I want valuble suggestions from Gurus and who maintaining their real Data 
> ceners.. I appreciate your help.
> 
> Thanks in advance
> Raghu.
> 
> 
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: Burning game CD's

2001-08-27 Thread Gogala, Mladen


You are doing several things wrong:
a) You are mailing yuor question to the wrong list.
b) You haven't read the fine manuals.
Conclusion: RTFM and do that somewhere else.
Have a nice day.

> -Original Message-
> From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: OT: Burning game CD's
> 
> 
> Off Topic:  I bought a PC this weekend that had my first 
> every CDROM burner.  I
> couldn't wait to use it.  I burned several game CD's (Age of 
> Empires, Return
> Fire II, Roller coaster Tycoon) and none of them worked.  The 
> games just hung
> when I ran them.  Bummer.  Is it not possible to make copies 
> of my CD's or am I
> doing something wrong?
> 
> Tom
> 
> Tom Terrian
> Oracle DBA
> WPAFB - DAASC
> [EMAIL PROTECTED]
> 937-656-3844 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Terrian, Tom
>   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: Gogala, Mladen
  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: Logical Backup for a large database

2001-08-27 Thread Stephane Faroult

Mitchell wrote:
> 
> DBAs
> 
> Last week one of my user dropped a table since we don't have any backup
> except for rman backup. It is not allowe me to do any recovery on 7/24
> database.  Anyway we recreate the table(we are lucky, this table hold
> parameters)
> 
> This make me think of situation of lossing very important big table. We have
> about 1000 tables with bigget one of  8GB .
> 
> Is there any idea how to perform a logical backup on a database with 150GBs.
> Or take a TSPITR in case of those kind of thing  happen again.  From my
> case, imp/exp looks impossibe from point of view of timing and spacing. The
> question will be the same for TSOITR on large database. Is there any other
> way to prepre those kind of situation.
> 
> Mitchell
> 

Mitchell,

  As far as 'taking a backup' is concerned, exp is OK, or can be if you
export on a per-table (or per table list) basis and run several exports
in parallel. In direct mode it is very fast. Of course, recovering with
imp is another matter. There are scripts (Korn-shell of death) on the
Oriole site doing this and, possibly more important, discussing (in the
comments) a number of alternative solutions. The other technique (still
on a per-table basis and still in parallel) is dumping to flat files and
using SQL*Loader to reload. We have a product which is not as fast as
exp in direct mode but pretty close, and faster tha exp in conventional
mode, and if you have a sufficiently large maintenance window even a
SQL*Plus spool may be an acceptable solution.
Beware that you lose 'CONSISTENT=Y' though with several parallel exports
or dumps. Of course you musn't shy away from deactivating /reactivating
triggers and constraints when reloading.

HTH,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: Logical Backup for a large database

2001-08-27 Thread Jeremiah Wilton

I think recommending regular exports for a 150Gb database is a
mistake.

Instead, you should practice using RMAN to restore and recover to a
separate location.  You can limit the size and complexity of a single
table restore by restoring only the table's tablespace, the SYSTEM and
any tablespaces containing rollback segments.

Once you have restored and recovered the one tablespace you need, you
can export the table and import it into the production system.  This
method provides protection that is superior to exports, because it
allows the recovery of a single table to an arbitrary point in time.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 27 Aug 2001, Wong, Bing wrote:

> I would suggest to export schema by schema and schedule the jobs to run
> different time.  In the export job, use pipe file at the unix level to
> compress the export file.  The command is as follows:
>
> To export and compress at the unix level...
>
> mknod export_pipe p
> compress < export_pipe > export.dmp.Z
> exp  ...   file=export_pipe
>
>
> To import and uncompress...
>
> uncompress < export.dmp.Z > export_pipe
> imp ...   file=export_pipe
>
>
> -Original Message-
> Sent: Monday, August 27, 2001 2:11 PM
> To: Multiple recipients of list ORACLE-L
>
> Last week one of my user dropped a table since we don't have any backup
> except for rman backup. It is not allowe me to do any recovery on 7/24
> database.  Anyway we recreate the table(we are lucky, this table hold
> parameters)
>
> This make me think of situation of lossing very important big table. We have
> about 1000 tables with bigget one of  8GB .
>
> Is there any idea how to perform a logical backup on a database with 150GBs.
> Or take a TSPITR in case of those kind of thing  happen again.  From my
> case, imp/exp looks impossibe from point of view of timing and spacing. The
> question will be the same for TSOITR on large database. Is there any other
> way to prepre those kind of situation.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  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: Data Center monitoring

Title: RE: Data Center monitoring





I agree.  I have never seen a monitoring tool that worked better than your own tried-and-true trusty scripts.  


-Original Message-
From:   Stephen Andert [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 5:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Data Center monitoring


Raghu,


Well, I/Watch is nice when it works.  While we were attempting to roll it out the first (and second) time, I left most of my "manual" old fashioned scripts running through cron.  Many times, things that were supposed to page or e-mail us from I/Watch didn't.  But sometimes they would.  It was just too unreliable.  My scripts are still in place and I've been spending time polishing them lately.

Also, the quest processes would sometimes spin out of control and crash the box (a mutiple-cpu unix box running Tru64 so no NT jokes).  I think they fixed that in the more recent version.

Stephen 


>>> [EMAIL PROTECTED] 08/27 1:51 PM >>>
I/Watch is nice.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."


Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275


Fuelspot
73 Princeton Street
North, Chelmsford 01863
 




-Original Message-
Sent: Monday, August 27, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L





Hi Gurus,


I have number of Oracle8i instances  on HP-Ux in a 400 servers Data center!!


I want valuble suggestions from Gurus and who maintaining their real Data 
ceners.. I appreciate your help.


Thanks in advance
Raghu.




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: Stephen Andert
  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: svrmgrl, sqlplus question ???

2001-08-27 Thread Thater, William

Janet Linsy wrote:

>Hi all,
>
>In sqlplus, you can use "col ... format ..." to make
>the output pretty. Can we format columns, make title
>in svrmgrl?  
>
AFAIK, you can't.

>
>
>Also I read that sqlplus can be used to mount, open
>database in 8i, but I don't see how.  
>
invoke sqlplus and at the username pompt enter "/ as sysdba".  and if 
you're a part of the dba group [sorry we only run on unix so i don't 
know what is is under windows.] off you go.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
Telergy,Inc.   [EMAIL PROTECTED]

One ping to rule them all,
One ping to find them,
One ping to bring them all,
And in the MUTX bind them.

You don't have to know how the computer works, just how to work the computer.

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

Locking Problem - Solution

2001-08-27 Thread Kevin Lange


Well, I think we have a solution for our mysterious locking problems.


For those of you who do not know, I sent a note out earlier this week with a
mysterious problem of locks happening on an application that was running
find last week  no changes except increased user base.

We looked at everything from resource usage, bad SQL, bad application design
, etc. and was unable to come up with anything.

Then based on a comment in an Oracle Metalink report, we looked to
INITTRANS.

Last Friday we increased the INITRANS on the offending tables from 1 to 2.
At this point in time, no more locking problems are occuring.

Of course, after I tell this, I will look at the database and it will
probably have continuous locks on it


Thanks to all who tried to help.

Kevin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  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: Logical Backup for a large database

2001-08-27 Thread Wong, Bing


I would suggest to export schema by schema and schedule the jobs to run
different time.  In the export job, use pipe file at the unix level to
compress the export file.  The command is as follows:

To export and compress at the unix level...

mknod export_pipe p
compress < export_pipe > export.dmp.Z
exp  ...   file=export_pipe


To import and uncompress...

uncompress < export.dmp.Z > export_pipe
imp ...   file=export_pipe


Bing


-Original Message-
Sent: Monday, August 27, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


DBAs

Last week one of my user dropped a table since we don't have any backup
except for rman backup. It is not allowe me to do any recovery on 7/24
database.  Anyway we recreate the table(we are lucky, this table hold
parameters)

This make me think of situation of lossing very important big table. We have
about 1000 tables with bigget one of  8GB .

Is there any idea how to perform a logical backup on a database with 150GBs.
Or take a TSPITR in case of those kind of thing  happen again.  From my
case, imp/exp looks impossibe from point of view of timing and spacing. The
question will be the same for TSOITR on large database. Is there any other
way to prepre those kind of situation.


Mitchell

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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: Wong, Bing
  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: Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread Rachel Carmichael


yeah, and they said the same thing about the solaris ones... and you didn't 
have to unzip them either


>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Oracle 9i Linux files are erroring during uncompress...
>Date: Mon, 27 Aug 2001 10:53:40 -0800
>
>Well, they end with .gz, and the instructions under the files specify to 
>use
>gunzip to unzip them.
>
>Oh why, oh why does life have to be so difficult...
>
>-Original Message-
>Sent: Monday, August 27, 2001 2:29 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>I think it's simpler than that -- I don't think they really need to be
>unzipped.
>
>
>
> >From: "Grabowy, Chris" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle 9i Linux files are erroring during uncompress...
> >Date: Mon, 27 Aug 2001 09:35:47 -0800
> >
> >Using Windoze, I downloaded the three Oracle 9i Linux files from
> >technet.oracle.com.  I then rebooted into Suse, copied the files over, 
>but
> >gunzip is not recognizing the files.  I switched back to Windoze and 
>using
> >Winzip it doesnt like the files either.  So I redownloaded just the 
>smaller
> >third file and neither will uncompress the file.  Am I missing something
> >here?
> >
> >I would download the files from SuSE but I can't get my DSL modem to 
>work,
> >so I have been downloading the files using Windoze.  Could that be the
> >problem??
> >
> >TIA!!
> >
> >Chris
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Grabowy, Chris
> >   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).
>
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
>   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: Grabowy, Chris
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Data Center monitoring

2001-08-27 Thread Stephen Andert


Raghu,

Well, I/Watch is nice when it works.  While we were attempting to roll it out the 
first (and second) time, I left most of my "manual" old fashioned scripts running 
through cron.  Many times, things that were supposed to page or e-mail us from I/Watch 
didn't.  But sometimes they would.  It was just too unreliable.  My scripts are still 
in place and I've been spending time polishing them lately.

Also, the quest processes would sometimes spin out of control and crash the box (a 
mutiple-cpu unix box running Tru64 so no NT jokes).  I think they fixed that in the 
more recent version.

Stephen 

>>> [EMAIL PROTECTED] 08/27 1:51 PM >>>
I/Watch is nice.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L




Hi Gurus,

I have number of Oracle8i instances  on HP-Ux in a 400 servers Data center!!

I want valuble suggestions from Gurus and who maintaining their real Data 
ceners.. I appreciate your help.

Thanks in advance
Raghu.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

svrmgrl, sqlplus question ???

2001-08-27 Thread Janet Linsy


Hi all,

In sqlplus, you can use "col ... format ..." to make
the output pretty. Can we format columns, make title
in svrmgrl?  

Also I read that sqlplus can be used to mount, open
database in 8i, but I don't see how.  

The db is 815 on Sun 5.6.  

Thank you!

Janet

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  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).

Logical Backup for a large database

2001-08-27 Thread Mitchell


DBAs

Last week one of my user dropped a table since we don't have any backup
except for rman backup. It is not allowe me to do any recovery on 7/24
database.  Anyway we recreate the table(we are lucky, this table hold
parameters)

This make me think of situation of lossing very important big table. We have
about 1000 tables with bigget one of  8GB .

Is there any idea how to perform a logical backup on a database with 150GBs.
Or take a TSPITR in case of those kind of thing  happen again.  From my
case, imp/exp looks impossibe from point of view of timing and spacing. The
question will be the same for TSOITR on large database. Is there any other
way to prepre those kind of situation.


Mitchell

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mitchell
  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: Data Center monitoring

Title: RE: Data Center monitoring





HELP


And get LOTS OF IT


Look at MC Service Guard to enhance availability.  In addition, see if you can use some sort of storage solution that will minimize the occurrence of losing a disk. 

Look at running backups in parallel, and practice recoveries in parallel to minimize any downtime that may occur.


Lisa Koivu
Diehard Viking Fan and DBA
Ft. Lauderdale, FL, USA


-Original Message-
From:   Raghu Kota [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject:    Data Center monitoring




Hi Gurus,


I have number of Oracle8i instances  on HP-Ux in a 400 servers Data center!! 
I want valuble suggestions from Gurus and who maintaining their real Data 
ceners.. I appreciate your help.


Thanks in advance
Raghu.




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: Data Center monitoring


I/Watch is nice.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L




Hi Gurus,

I have number of Oracle8i instances  on HP-Ux in a 400 servers Data center!!

I want valuble suggestions from Gurus and who maintaining their real Data 
ceners.. I appreciate your help.

Thanks in advance
Raghu.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: Data Center monitoring




proactively monitor everything, max extents, datafile percent free, all of 
it,  its always easier to fix something when you have days/weeks of advance 
notice, versus 2AM.
 
joe
>>> [EMAIL PROTECTED] 08/27/01 04:21PM 
>>>Hi Gurus,I have number of Oracle8i 
instances  on HP-Ux in a 400 servers Data center!! I want valuble 
suggestions from Gurus and who maintaining their real Data ceners.. I 
appreciate your help.Thanks in 
advanceRaghu._Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Raghu 
Kota  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: FW: database upgrade policy?




I couldnt get it to work for anyone other than someone in the dba group 
already on linux.  if you're in the dba group you can connect / as sysdba 
anyways, so i guess i'm missing where the security hole is.
 
joe
>>> [EMAIL PROTECTED] 08/23/01 04:41PM 
>>>Okay have a look at bug 1919536, it allows a user to log in as 
sysdba whenusing sqlplus in 9i.Initial testing on our system proves 
that this is true, luckily the db islocked down except for sys admin and dba 
group.Raj__Rajendra 
Jamadagni        MIS, ESPN Inc.Rajendra dot 
Jamadagni at ESPN dot comAny 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 
!*2This 
e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt 
from disclosure under applicable law. If you have received this message in 
error, or are not the named recipient(s), please immediately notify corporate 
MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank 
you.*2-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
Jamadagni, Rajendra  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Data Center monitoring

2001-08-27 Thread Raghu Kota




Hi Gurus,

I have number of Oracle8i instances  on HP-Ux in a 400 servers Data center!! 
I want valuble suggestions from Gurus and who maintaining their real Data 
ceners.. I appreciate your help.

Thanks in advance
Raghu.



_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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



It looks like you have a partitioned table with
a parallel or parallel index definition.



The :Qyyy are the 'table queues' used
by parallel query slaves to pass messages
between the layers of slaves operating the
query.

The SQL with the hints in it is the SQL
generated by the query co-ordinator as
it breaks down your original query for
parallel execution.


I don't think that tkprof makes a very neat
(or complete) job of presenting such query
plans, but it is quite hard to do anything good
when they get complex.  I tend to run my
own 'explain plan' script (see the website
noted below) to split the parallel query SQL
from the rest of the plan as this tends to
make things a little cleaner.



Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 August 2001 19:22


|I am running tkprof and explain plan on the following SQL statement:
|
|SELECT DISTINCT CNFR_NO,
|SPLT_PAY_TYPE, ACH_AMT
|FROM whse_dbo.ACH_TRAN
|WHERE ACCT_NO = '46807' AND
|TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
|STATUS = '2' AND
|CNFR_NO >0 AND
|(SPLT_PAY_TYPE = '810' OR
|SPLT_PAY_TYPE = '820' );
|
|I'm not really looking for advice on tuning this query but rather
just
|wanted to have some general questions answered regarding the
|results i got using tkprof.
|
|This is the first time I've ever run tkprof on a statement and gotten
|an explain plan with :Q in it (followed by numbers).  What does the
|:Q mean?
|
|Also, there is not hint embedded in the select statement I ran but
|the explain plan output shows hints in the explain plan.  Or at least
|the explain plan list the output in hint format.   Why is it doing
that,
|when there were no hints in the original source?
|
|Thanks in advance,
|
|Cherie Machler
|Oracle DBA
|Gelco Information Network


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: ORA-10027 in ps/sql block

2001-08-27 Thread Holman, Rodney


  Thanks for the offer of help.  Developer finally did a
DBMS__OUTPUT.DISABLE 
  followed by the DBMS_OUTPUT.ENABLE.  This cleared the buffer and code 
  worked.  Apparently he had a dirty buffer that didn't clear until the 
  DISABLE was issued.  He has added the DISABLE to his code prior to the 
  ENABLE so that his output is going into an empty buffer. 

  Rodd 

  -Original Message- 
  From: Koivu, Lisa 
  To: Multiple recipients of list ORACLE-L 
  Sent: 8/27/01 1:35 PM 
  Subject: RE: ORA-10027 in ps/sql block 

  Rodd, can you post the code?  

  -Original Message- 
  From:   Holman, Rodney [SMTP:[EMAIL PROTECTED]] 
  Sent:   Monday, August 27, 2001 1:56 PM 
  To: Multiple recipients of list ORACLE-L 
  Subject:ORA-10027 in ps/sql block 

  I have a developer here who is trying to populate a cursor. 
  Every time he 
  runs his code he gets the above error stating that the buffer is too 
  small. 
  We have tried explicitly setting the buffer to 1,000,000 bytes.  This is 
  FAR 
  greater than needed for the amount of data requested.  No matter what 
  buffer 
  size we set he still gets the overflow. 

  We have tried both of the following ideas from metalink 

  Any ideas? 

  Rodd Holman 

  Doc ID:   Note:1005230.6Content 
  Type: 
  TEXT/PLAIN 
  26-AUG-1994 
  Type: PROBLEM   Last Revision 
  Date: 
  13-JAN-1995 
  Status:   PUBLISHED 


  Problem Description: 
   


  Problem Explanation: 
   


  NEW PROBLEM 

  Solution: INCREASE THE SIZE OF THE BUFFER 


  Solution Description: 
  = 
 
  Increase the size of the buffer.  The size of the buffer must be an 
  integer 
  between  
  2,000 and 1,000,000. 
 
  Solution Explanation: 
  = 
 
  Use one of the following two methods to increase the size of the buffer: 

 
  1.  At the SQL*PLUS or SQL*DBA prompt, type 
  SET SERVEROUTPUT ON SIZE n 
  where n is an integer between 2,000 and 1,000,000.  

  Example: To increase the buffer size to 10,000 type 
  SET SERVEROUTPUT ON SIZE 1 

  2. Inside the PL/SQL block type 
 DBMS_OUTPUT.ENABLE(n) 
 where n is an integer between 2,000 and 1,000,000.  
 
 See Appendix A of the Oracle7 Server Application Developer's Guide 
  for 
 an explanation of the ENABLE command. 
. 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com 
    
  -- 
  Author: Holman, Rodney 
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: Holman, Rodney
  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: Oracle 9i Linux files are erroring during uncompress...


Anything over 2oom, is almost impossible to download from technet without
using a download manager, what happens is during the transfer it aborts and
restarts.  Which fouls it up some how, once I started using get right to
downnload the stuff, it worked everytime, not to mention faster.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 2:54 PM
To: Multiple recipients of list ORACLE-L


Well, they end with .gz, and the instructions under the files specify to use
gunzip to unzip them.  

Oh why, oh why does life have to be so difficult...

-Original Message-
Sent: Monday, August 27, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L



I think it's simpler than that -- I don't think they really need to be 
unzipped.



>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i Linux files are erroring during uncompress...
>Date: Mon, 27 Aug 2001 09:35:47 -0800
>
>Using Windoze, I downloaded the three Oracle 9i Linux files from 
>technet.oracle.com.  I then rebooted into Suse, copied the files over, 
>but gunzip is not recognizing the files.  I switched back to Windoze 
>and using Winzip it doesnt like the files either.  So I redownloaded 
>just the smaller third file and neither will uncompress the file.  Am I 
>missing something here?
>
>I would download the files from SuSE but I can't get my DSL modem to 
>work, so I have been downloading the files using Windoze.  Could that 
>be the problem??
>
>TIA!!
>
>Chris
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Grabowy, Chris
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

OT: Who Notices

2001-08-27 Thread dgoulet


No replies needed!!

This is way too ironically funny
> > > >
> > > >
> > > >
> > > >Sometimes ... when you cry ... no one sees your tears ...
> > > >
> > > >
> > > >Sometimes...when you are worriedno one sees your pain...
> > > >
> > > >
> > > >Sometimes ... when you are happy ... no one sees your smile ...
> > > >
> > > >
> > > >But fart just one time...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Oracle Licensing for a Clustered Server Configuration

2001-08-27 Thread Srinagesh Battula

Title: RE: Oracle Licensing for a Clustered Server Configuration






Our failover server neither has a standby database nor oracle binaries.


In our Clustered server configuration, when a fail over happens
the entire diskgroups will be de-ported from the primary and imported on the failover server.


So, at any given point only one node will be running oracle..


> -Original Message-
> From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 12:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Licensing for a Clustered Server Configuration
> 
> 
> for a standby database? yes. If you are USING the binaries on 
> the machine 
> (to apply the archived logs) they want the money.
> 
> However, if you have a backup copy of the binaries loaded, 
> but are not 
> running Oracle, they don't ask for the money.
> 
> 
> >From: Srinagesh Battula <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: Oracle Licensing for a Clustered Server Configuration
> >Date: Mon, 27 Aug 2001 10:07:29 -0800
> >
> >
> >Hi,
> >
> >Does Oracle Corp. require you to buy the RDBMS license for 
> the fail-over
> >server (as well) in a
> >2-node cluster server environment?
> >
> >Thanks
> >
> >Nagesh
> 
> 
> _
> Get your FREE download of MSN Explorer at 
> http://explorer.msn.com/intl.asp
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   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: Oracle Licensing for a Clustered Server Configuration

2001-08-27 Thread Srinagesh Battula

Title: Oracle Licensing for a Clustered Server Configuration



John, are/were you in a similiar 
env..
 
..very curious..coz Oracle is forcing us 
to buy a second license for the passive fail-over server ..
 
Thanks

  -Original Message-From: Shaw, John B 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 12:21 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle Licensing for a Clustered Server Configuration
  Only 
  if it's active on the fail over node - if it's passive you don't need a second 
  license.
  
-Original Message-From: Srinagesh Battula 
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Oracle Licensing for a Clustered Server 
Configuration
Hi, 
Does Oracle Corp. require 
you to buy the RDBMS license for the fail-over server (as well) in a 
2-node cluster server 
environment? 
Thanks 
Nagesh

RE: OT - DB2 for OS/2


I ran it at home for a couple of years (OS/2 2.0, 2.1 and 3.0 "warp"), I
finally gave up on it because IBM never got permission to support Windows95
applications in a shell.

It worked very well, though - never crashed.  DOS and Windows sessions
crashed, but the OS never failed.  And it was so configurable!

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  



-Original Message-
From:   Kevin Lange [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 3:47 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT -  DB2 for OS/2

Until last year my old company was still extensively into OS/2
servers.  We
had DB2 on them as well.

All kidding aside about dead OS's  OS/2 was a excellent OS.  It
was
solid in its last incarnation and IBM software ran great on it.  Our
biggest
trouble was finding outside software to run on it.

If it was not for the fact that no desktop apps were available, we
would
probably never have gotten off of it as a desktop solution for the
company.

-Original Message-
Sent: Monday, August 27, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L


Isn't OS/2 still used extensively by banks to run ATM's? If that's
the case,
then IBM would have a vested interest in keeping DB2 current on
OS/2.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, August 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I can't believe it, they have a beta DB2 v.7.1. for OS/2, same
release
number as for AIX.  

I thought that OS was dead!

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Kevin Lange
  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: Boivin, Patrice J
  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).

No Subject

2001-08-27 Thread Cherie_Machler


I am running tkprof and explain plan on the following SQL statement:

SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
STATUS = '2' AND
CNFR_NO >0 AND
(SPLT_PAY_TYPE = '810' OR
SPLT_PAY_TYPE = '820' );

I'm not really looking for advice on tuning this query but rather just
wanted to have some general questions answered regarding the
results i got using tkprof.

This is the first time I've ever run tkprof on a statement and gotten
an explain plan with :Q in it (followed by numbers).  What does the
:Q mean?

Also, there is not hint embedded in the select statement I ran but
the explain plan output shows hints in the explain plan.  Or at least
the explain plan list the output in hint format.   Why is it doing that,
when there were no hints in the original source?

Thanks in advance,

Cherie Machler
Oracle DBA
Gelco Information Network


Trace file: /orasoft/oracle/admin/DWPRD02/udump/dwprd02_ora_1787.trc
Sort options: fchcpu

count= number of times OCI procedure was executed
cpu  = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query= number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call


SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
STATUS = '2' AND
CNFR_NO >0 AND
(SPLT_PAY_TYPE = '810' OR
SPLT_PAY_TYPE = '820' )

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --
--
Parse1  0.02   0.02  0  0  0
0
Execute  1  0.03   1.10  0  0 42
0
Fetch   30  0.01   1.40  0  0  0
421
--- --   -- -- -- --
--
total   32  0.06   2.52  0  0 42
421

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 1985  (WHSE_DBO)

Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: CHOOSE
  0   SORT (UNIQUE) [:Q5497001]
 SELECT DISTINCT C0,C1,C2 FROM :Q5497000
  0PARTITION (CONCATENATED) [:Q5497001]
  0 INLIST ITERATOR (CONCATENATED) [:Q5497001]
  0  TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF
 'ACH_TRAN' [:Q5497000]
 SELECT /*+ INDEX(A1 "ACH_TRAN_IDX4") */ A1."CNFR_NO" C0,
A1."SPLT_PAY_TYPE" C1,A1."ACH_AMT" C2 FROM
"WHSE_DBO"."ACH_TRAN" PARTITION(:B1)  A1 WHERE
(A1."SPLT_PAY_TYPE"='810' OR A1."SPLT_PAY_TYPE"='820') AND
A1."STATUS"='2' AND A1."ACCT_NO"=46807 AND
TRUNC(A1."TRAN_DT")=TRUNC(TO_DATE('20-JUL-01','DD-MON-YY'))
  AND A1."CNFR_NO">0
  0   INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'ACH_TRAN_IDX4'
  (NON-UNIQUE) [:Q5497000]






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: OT - DB2 for OS/2

2001-08-27 Thread Jan Pruner


One friend of mine working for Siemens is still programming DOS stuff 'cause 
they use MSDOS as OS for chip testing machines (life test for car chips to 
use in VW, BMW ...).

Jan Pruner

Dne po 27. srpen 2001 20:28 jste napsal(a):
> I don't know.
>
> I went to the cinema last week (? A couple of weeks ago?) and one of the
> ticket machines had a C:\ prompt on its screen.
>
> Presumably that thing was running DOS...
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
>   -Original Message-
>   From:   Weaver, Walt [SMTP:[EMAIL PROTECTED]]
>   Sent:   Monday, August 27, 2001 3:01 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject:RE: OT -  DB2 for OS/2
>
>   Isn't OS/2 still used extensively by banks to run ATM's? If that's
> the case,
>   then IBM would have a vested interest in keeping DB2 current on
> OS/2.
>
>   --Walt Weaver
> Bozeman, Montana
>
>   -Original Message-
>   Sent: Monday, August 27, 2001 11:46 AM
>   To: Multiple recipients of list ORACLE-L
>
>
>   I can't believe it, they have a beta DB2 v.7.1. for OS/2, same
> release
>   number as for AIX.
>
>   I thought that OS was dead!
>
>   Patrice Boivin
>   Systems Analyst (Oracle Certified DBA)
>
>   Systems Admin & Operations | Admin. et Exploit. des systèmes
>   Technology Services| Services technologiques
>   Informatics Branch | Direction de l'informatique
>   Maritimes Region, DFO  | Région des Maritimes, MPO
>
>   --
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   --
>   Author: Weaver, Walt
> 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: Jan Pruner
  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).

ach_tran query

Title: ach_tran query





Hi Cherie, 


Looks like parallel query kicked in.  It usually throws some odd looking stuff in the explain plan.


HTH
Lisa


-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 3:11 PM
To: Multiple recipients of list ORACLE-L
Subject:    


I am running tkprof and explain plan on the following SQL statement:


SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
    TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
    STATUS = '2' AND
    CNFR_NO >0 AND
    (SPLT_PAY_TYPE = '810' OR
    SPLT_PAY_TYPE = '820' );


I'm not really looking for advice on tuning this query but rather just
wanted to have some general questions answered regarding the
results i got using tkprof.


This is the first time I've ever run tkprof on a statement and gotten
an explain plan with :Q in it (followed by numbers).  What does the
:Q mean?


Also, there is not hint embedded in the select statement I ran but
the explain plan output shows hints in the explain plan.  Or at least
the explain plan list the output in hint format.   Why is it doing that,
when there were no hints in the original source?


Thanks in advance,


Cherie Machler
Oracle DBA
Gelco Information Network



Trace file: /orasoft/oracle/admin/DWPRD02/udump/dwprd02_ora_1787.trc
Sort options: fchcpu

count    = number of times OCI procedure was executed
cpu  = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call



SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
    TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
    STATUS = '2' AND
    CNFR_NO >0 AND
    (SPLT_PAY_TYPE = '810' OR
    SPLT_PAY_TYPE = '820' )


call count   cpu    elapsed   disk  query    current
rows
--- --   -- -- -- --
--
Parse    1  0.02   0.02  0  0  0
0
Execute  1  0.03   1.10  0  0 42
0
Fetch   30  0.01   1.40  0  0  0
421
--- --   -- -- -- --
--
total   32  0.06   2.52  0  0 42
421


Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 1985  (WHSE_DBO)


Rows Execution Plan
---  ---
  0  SELECT STATEMENT   GOAL: CHOOSE
  0   SORT (UNIQUE) [:Q5497001]
 SELECT DISTINCT C0,C1,C2 FROM :Q5497000
  0    PARTITION (CONCATENATED) [:Q5497001]
  0 INLIST ITERATOR (CONCATENATED) [:Q5497001]
  0  TABLE ACCESS   GOAL: ANALYZED (BY LOCAL INDEX ROWID) OF
 'ACH_TRAN' [:Q5497000]
 SELECT /*+ INDEX(A1 "ACH_TRAN_IDX4") */ A1."CNFR_NO" C0,
    A1."SPLT_PAY_TYPE" C1,A1."ACH_AMT" C2 FROM
    "WHSE_DBO"."ACH_TRAN" PARTITION(:B1)  A1 WHERE
    (A1."SPLT_PAY_TYPE"='810' OR A1."SPLT_PAY_TYPE"='820') AND
    A1."STATUS"='2' AND A1."ACCT_NO"=46807 AND
    TRUNC(A1."TRAN_DT")=TRUNC(TO_DATE('20-JUL-01','DD-MON-YY'))
  AND A1."CNFR_NO">0
  0   INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'ACH_TRAN_IDX4'
  (NON-UNIQUE) [:Q5497000]








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: Oracle 9i Linux files are erroring during uncompress...




do a file on them in linux and see that the magic number comes back to show 
you what it thinks it is.
 
joe
>>> [EMAIL PROTECTED] 08/27/01 02:53PM 
>>>Well, they end with .gz, and the instructions under the files 
specify to usegunzip to unzip them.  Oh why, oh why does life 
have to be so difficult...-Original Message-Sent: Monday, 
August 27, 2001 2:29 PMTo: Multiple recipients of list 
ORACLE-LI think it's simpler than that -- I don't think they 
really need to be unzipped.>From: "Grabowy, Chris" 
<[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: 
Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>>Subject: Oracle 9i Linux files are erroring 
during uncompress...>Date: Mon, 27 Aug 2001 09:35:47 
-0800>>Using Windoze, I downloaded the three Oracle 9i Linux files 
from>technet.oracle.com.  I then rebooted into Suse, copied the 
files over, but>gunzip is not recognizing the files.  I switched 
back to Windoze and using>Winzip it doesnt like the files either.  
So I redownloaded just the smaller>third file and neither will uncompress 
the file.  Am I missing something>here?>>I would 
download the files from SuSE but I can't get my DSL modem to work,>so I 
have been downloading the files using Windoze.  Could that be 
the>problem??>>TIA!!>>Chris>-->Please 
see the official ORACLE-L FAQ: http://www.orafaq.com>-->Author: 
Grabowy, Chris>   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)._Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rachel 
Carmichael  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Grabowy, Chris  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Oracle Licensing for a Clustered Server Configuration

2001-08-27 Thread Shaw, John B

Title: Oracle Licensing for a Clustered Server Configuration



Only 
if it's active on the fail over node - if it's passive you don't need a second 
license.

  -Original Message-From: Srinagesh Battula 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Licensing for a Clustered Server Configuration
  Hi, 
  Does Oracle Corp. require you 
  to buy the RDBMS license for the fail-over server (as well) in a 
  2-node cluster server 
  environment? 
  Thanks 
  Nagesh

Re: PK/Fk question




oh i definitely didnt include all of the problems associated with 
distributed enforcement of FK.  I was denoting the obvious :)
 
joe
>>> [EMAIL PROTECTED] 08/27/01 02:22PM 
>>>There is also the drawback that thetrigger has to do a 
'select for update',with all associated contention problems,otherwise 
the effect of read-consistencywould allow a trigger to determine that 
aparent existed when in fact it had beendeleted by an uncommitted 
transaction.Jonathan LewisHost to The Co-Operative Oracle Users' 
FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.htmlAuthor 
of:Practical Oracle 8i: Building Efficient DatabasesSee http://www.jlcomp.demon.co.uk/book_rev.htmlFor 
latest news of public appearancesSee http://www.jlcomp.demon.co.ukScreen 
saver or Life saver: http://www.ud.comUse 
spare CPU to assist in cancer research.-Original 
Message-To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>Date: 27 August 2001 18:15You can 
only FK to field(s) that are unique or primary keyconstraints.if 
col1 is unique, you can put a unique constraint on it and then FKto it from 
the child.your only other choice is to do FK checkign via triggers(i did 
it fordistributed databases, where parents were on one db and children 
wereon other, efficient NO but it was a 
requirement).joe-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Jonathan Lewis  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: Cobol Copybook format

2001-08-27 Thread Kevin Lange


We often used the FILLER to make the data more presentable in files.   i.e.
used filler between columns.  W
We also defined our output on reports the same way.

-Original Message-
Sent: Monday, August 27, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


Lisa,
 
Thanks for waking up memories of COBOL that I have been trying to run away
from! Anyway a FILLER is just that - a filler or placeholder to pad out
or format a 'record' in the WORKING STORAGE or FILE section (eq. to the
declarative section in PL/SQL). If this is part of a retrieved record from a
file, it is sometime used to pad upto a 4-byte boundary. For a quick newbie
look at COBOL, go to http://www.cob.sjsu.edu/facstaff/lam_m/cobolp.htm
  Let me know offline if
you have additional queries.
 
John Kanagaraj 
Oracle Applications DBA 
DB Soft Inc 
Work : (408) 970 7002 

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com   

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

 

-Original Message-
Sent: Monday, August 27, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L



Good morning everyone, 

I have this messy document that is known as a copybook.  I've been searching
the web to help me understand what the appropriate way to translate this
into a table is.  If anyone has a link they are willing to share, or is
willing to answer questions (like what the heck is FILLER?) please email me
directly. 

Thank you! 

Lisa Koivu 
Oracle Database Administrator 
954-935-4117 

The information in the electronic mail message is Cendant confidential and
may be legally privileged, it is intended solely for the addressee(s) access
to this internet electronic mail message by anyone else is unauthorized. If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in reliance on it is prohibited and
may be unlawful.

The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Cendant Corporation or Affiliates are not liable for any loss
or damage arising in any way from this message or its attachments. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: Kevin Lange
  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: fire the trigger selectively when a column is updated

2001-08-27 Thread Richard Huntley

You
can do something like this:
CREATE OR REPLACE
TRIGGER your_triggerAFTER UPDATE OF ename ON Emp_Tab
FOR EACH ROWBEGINNULL; --do whatever you have to do...call
procedure, etc...
END;
HTH
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Saturday, August 25, 2001 8:55
AMTo: Multiple recipients of list ORACLE-LSubject: fire
the trigger selectively when a column is updated
Hi everyone,
One of my developers wanted to
know if it is possible to write a trigger only if a particular column is
changed, essentially making it a column level trigger.I gathered from the
article below that it is possible in SQL server. Just wanted to know if this is possible in
oracle.
Yes I can think of the :old and :new
but any other way ??
The code that is included inside an
UPDATE trigger runs every time its related table is updated. In most
UPDATE triggers, the code in the trigger affects only certain columns, not all
of them. Because of this, it would be pointless (and a waste of SQL Server
resources) to run all of the code in the trigger if the column or columns you
are interested in have not been updated. In other words, even if a column you
are not interested in is updated, the UPDATE trigger will fire and run its
code.

To help reduce the unnecessary running
of code in an UPDATE trigger, you can take advantage one of two different
functions: UPDATE() (available in SQL Server 2000) or COLUMNS_UPDATED()
(available in SQL Server 7.0 and 2000).
Both functions can be used to test to
see if a particular column you are interested in has changed or not. Because of
this, you can write code in your trigger to only run if the column you are
interested in has changed, otherwise you can prevent the code from running if
the column you are interested in has not changed. This can reduce the amount of
work the trigger needs to do, boosting overall performance of your
database.
The UPDATE() function is used to check
only one column at a time. The COLUMNS_UPDATED() function can be used to check
multiple columns at a time. [ 7.0, 2000] Added 5-29-2001

cozI am anoviceOracle Certifiable
DBBS

RE: ORA-10027 in ps/sql block

Title: RE: ORA-10027 in ps/sql block





Rodd, can you post the code?  


-Original Message-
From:   Holman, Rodney [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject:    ORA-10027 in ps/sql block


I have a developer here who is trying to populate a cursor.  Every time he
runs his code he gets the above error stating that the buffer is too small.
We have tried explicitly setting the buffer to 1,000,000 bytes.  This is FAR
greater than needed for the amount of data requested.  No matter what buffer
size we set he still gets the overflow.


We have tried both of the following ideas from metalink


Any ideas?


Rodd Holman


Doc ID:   Note:1005230.6    Content Type:
TEXT/PLAIN
26-AUG-1994
Type: PROBLEM   Last Revision Date:
13-JAN-1995
Status:   PUBLISHED



Problem Description:




Problem Explanation:




NEW PROBLEM


Solution: INCREASE THE SIZE OF THE BUFFER



Solution Description: 
= 
   
Increase the size of the buffer.  The size of the buffer must be an integer 
between  
2,000 and 1,000,000. 
   
Solution Explanation: 
= 
   
Use one of the following two methods to increase the size of the buffer: 
   
1.  At the SQL*PLUS or SQL*DBA prompt, type 
    SET SERVEROUTPUT ON SIZE n 
    where n is an integer between 2,000 and 1,000,000.  
 
    Example: To increase the buffer size to 10,000 type 
    SET SERVEROUTPUT ON SIZE 1 
 
2. Inside the PL/SQL block type 
   DBMS_OUTPUT.ENABLE(n) 
   where n is an integer between 2,000 and 1,000,000.  
   
   See Appendix A of the Oracle7 Server Application Developer's Guide for 
   an explanation of the ENABLE command.
  .
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  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: Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread Grabowy, Chris


Well, they end with .gz, and the instructions under the files specify to use
gunzip to unzip them.  

Oh why, oh why does life have to be so difficult...

-Original Message-
Sent: Monday, August 27, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L



I think it's simpler than that -- I don't think they really need to be 
unzipped.



>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i Linux files are erroring during uncompress...
>Date: Mon, 27 Aug 2001 09:35:47 -0800
>
>Using Windoze, I downloaded the three Oracle 9i Linux files from
>technet.oracle.com.  I then rebooted into Suse, copied the files over, but
>gunzip is not recognizing the files.  I switched back to Windoze and using
>Winzip it doesnt like the files either.  So I redownloaded just the smaller
>third file and neither will uncompress the file.  Am I missing something
>here?
>
>I would download the files from SuSE but I can't get my DSL modem to work,
>so I have been downloading the files using Windoze.  Could that be the
>problem??
>
>TIA!!
>
>Chris
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Grabowy, Chris
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Grabowy, Chris
  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: Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread John Lewis


Odd thing is that linux/solaris files come down correctly. And I've
down-loaded other zips for NT in the past with no problems. 

This seems like a recent problem. 

-Original Message-
Sent: Monday, August 27, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


If you do not use a download manager like getright, you will almost always
download broken files.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com.  I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files.  I switched back to Windoze and using
Winzip it doesnt like the files either.  So I redownloaded just the smaller
third file and neither will uncompress the file.  Am I missing something
here?

I would download the files from SuSE but I can't get my DSL modem to work,
so I have been downloading the files using Windoze.  Could that be the
problem??

TIA!!

Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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: John Lewis
  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: Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread Rachel Carmichael



I think it's simpler than that -- I don't think they really need to be 
unzipped.



>From: "Grabowy, Chris" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i Linux files are erroring during uncompress...
>Date: Mon, 27 Aug 2001 09:35:47 -0800
>
>Using Windoze, I downloaded the three Oracle 9i Linux files from
>technet.oracle.com.  I then rebooted into Suse, copied the files over, but
>gunzip is not recognizing the files.  I switched back to Windoze and using
>Winzip it doesnt like the files either.  So I redownloaded just the smaller
>third file and neither will uncompress the file.  Am I missing something
>here?
>
>I would download the files from SuSE but I can't get my DSL modem to work,
>so I have been downloading the files using Windoze.  Could that be the
>problem??
>
>TIA!!
>
>Chris
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Grabowy, Chris
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: creating the database from another

2001-08-27 Thread Mercadante, Thomas F




Bunyamin,
 
Let's 
call the database that already exists the SourceDb, and the new one you want to 
create the TargetDB
Do the 
following:
 
On the TargetDB machiine,
create the same directory 
structure that exists on the SourceDB 
machine.  This should include the directories where the database files 
exist(db_data_files), control files (v$controlfile), log files (v$logfile), as 
well as the oracle bdump and udump 
directories.
Shutdown the SourceDB 
database.
Copy all of the files from the SourceDB directories to 
the TargetDB directories.
Copy the init.ora file from SourceDB to 
TargetDB.
 
On the TargetDB machine, create the Oracle services 
using ORADIM:
 
ORADIM -new -pid {sid} -pfile 
c:\oracle\ora816\database\init{sid}.ora
 
This will create the Oracle services, and will attempt 
to open the database.  Check the Alert{sid}.log file for success or 
failure.
 
 
If you wish to change the SID name, you will need to 
re-create the control files.  Look at issuing a 'alter database backup 
controlfile to trace'; command on the SourceDB database to produce the create 
control file command to run on the TargetDB 
machine.
 
hope this helps.
 
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 
  12:40 PMTo: Multiple recipients of list ORACLE-LSubject: 
  creating the database from another
  I have a 8.1.6 database on NT on one machine . 
  And I want to create this database to another machine where oracle is 
  installed but there is no database.  I have the back up of 
  datafiles,control files and redo log files and archieve files.
   
   Can you tell What I will do step by step ? 
  Is there a such a document ? 
   
  Thank you 
  Bunyamin

Re: PK/Fk question


There is also the drawback that the
trigger has to do a 'select for update',
with all associated contention problems,
otherwise the effect of read-consistency
would allow a trigger to determine that a
parent existed when in fact it had been
deleted by an uncommitted transaction.

Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 August 2001 18:15


You can only FK to field(s) that are unique or primary key
constraints.

if col1 is unique, you can put a unique constraint on it and then FK
to it from the child.

your only other choice is to do FK checkign via triggers(i did it for
distributed databases, where parents were on one db and children were
on other, efficient NO but it was a requirement).

joe



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: OT - DB2 for OS/2


I don't know.

I went to the cinema last week (? A couple of weeks ago?) and one of the
ticket machines had a C:\ prompt on its screen.

Presumably that thing was running DOS...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Weaver, Walt [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, August 27, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: OT -  DB2 for OS/2

Isn't OS/2 still used extensively by banks to run ATM's? If that's
the case,
then IBM would have a vested interest in keeping DB2 current on
OS/2.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, August 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I can't believe it, they have a beta DB2 v.7.1. for OS/2, same
release
number as for AIX.  

I thought that OS was dead!

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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: Boivin, Patrice J
  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: PK/Fk question



The opposite end of a 'foreign key' has to be
a 'unique key' or 'primary key'.  You have only
two 'nominally correct' options -
a) declare a unique key on table1.col1
or
b) Create a table where the unique values
of table1.col1 are held, and declare a
primary key on it - them make table1
and table2 reference it.

Your question does, of course, suggest that
there may be a flaw in your physical database
structure.


Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 August 2001 17:42


|Hi DBAs,
|
|Table1 PK is on columns col1,col2,col3
|I want to create a FK on table2 to table1 for col1.
|
|What is the alternative to
|ALTER TABLE table2
|ADD CONSTRAINT fk_table2
|FOREIGN KEY (col1) REFERENCES table1(col1);
|
|I always get ORA-2270: No matching unique or primary key for this
|column-list.
|Every value for table2.col1 is in the table table1.col1. I want to
enforce
|this at the database server level.
|
|Thanks
|Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: Oracle 9i Linux files are erroring during uncompress...




windoze shouldnt be the problem(did i really say that), i used that at 
work to do the downloads copies them to RH machine(binary ftp), and installed 
with no problem.
 
joe
>>> [EMAIL PROTECTED] 08/27/01 01:35PM 
>>>Using Windoze, I downloaded the three Oracle 9i Linux files 
fromtechnet.oracle.com.  I then rebooted into Suse, copied the files 
over, butgunzip is not recognizing the files.  I switched back to 
Windoze and usingWinzip it doesnt like the files either.  So I 
redownloaded just the smallerthird file and neither will uncompress the 
file.  Am I missing somethinghere?I would download the files 
from SuSE but I can't get my DSL modem to work,so I have been downloading 
the files using Windoze.  Could that be 
theproblem??TIA!!Chris-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Grabowy, Chris  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: PK/Fk question




You can only FK to field(s) that are unique or primary key 
constraints.
 
if col1 is unique, you can put a unique constraint on it and then FK to it 
from the child.
 
your only other choice is to do FK checkign via triggers(i did it for 
distributed databases, where parents were on one db and children were on other, 
efficient NO but it was a requirement).
 
joe
>>> [EMAIL PROTECTED] 08/27/01 12:17PM 
>>>Hi DBAs,Table1 PK is on columns col1,col2,col3I want 
to create a FK on table2 to table1 for col1.What is the alternative 
toALTER TABLE table2ADD CONSTRAINT fk_table2FOREIGN KEY (col1) 
REFERENCES table1(col1);I always get ORA-2270: No matching unique or 
primary key for thiscolumn-list. Every value for table2.col1 is in the 
table table1.col1. I want to enforcethis at the database server 
level.ThanksRick-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com-- Author: 
Cale, Rick T (Richard)  INET: [EMAIL PROTECTED]Fat City 
Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

ORA-10027 in ps/sql block

2001-08-27 Thread Holman, Rodney


I have a developer here who is trying to populate a cursor.  Every time he
runs his code he gets the above error stating that the buffer is too small.
We have tried explicitly setting the buffer to 1,000,000 bytes.  This is FAR
greater than needed for the amount of data requested.  No matter what buffer
size we set he still gets the overflow.

We have tried both of the following ideas from metalink

Any ideas?

Rodd Holman

Doc ID:   Note:1005230.6Content Type:
TEXT/PLAIN
26-AUG-1994
Type: PROBLEM   Last Revision Date:
13-JAN-1995
Status:   PUBLISHED


Problem Description:



Problem Explanation:



NEW PROBLEM

Solution: INCREASE THE SIZE OF THE BUFFER


Solution Description: 
= 
   
Increase the size of the buffer.  The size of the buffer must be an integer 
between  
2,000 and 1,000,000. 
   
Solution Explanation: 
= 
   
Use one of the following two methods to increase the size of the buffer: 
   
1.  At the SQL*PLUS or SQL*DBA prompt, type 
SET SERVEROUTPUT ON SIZE n 
where n is an integer between 2,000 and 1,000,000.  
 
Example: To increase the buffer size to 10,000 type 
SET SERVEROUTPUT ON SIZE 1 
 
2. Inside the PL/SQL block type 
   DBMS_OUTPUT.ENABLE(n) 
   where n is an integer between 2,000 and 1,000,000.  
   
   See Appendix A of the Oracle7 Server Application Developer's Guide for 
   an explanation of the ENABLE command.
  .
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Holman, Rodney
  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 quick pl/sql datatypes question



>From a pure performance direction,
pls_integer or binary_integer is probably
the fastest.

If you declare a variable to be of
table_name.column_name%type
there are implicit constraints on the
variable and any pl/sql assignments
(in particular arithmetic operations)
have to check that the result matches
those constraints. At one time I believe
this meant using a temporary variable
to hold a result, then copying the result
if the constraint was matched.

Having said that, you could try a few simple
tests to find out that the differences (in
new releases) are incredibly small.


Jonathan Lewis

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

For latest news of public appearances
See http://www.jlcomp.demon.co.uk

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.




-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 27 August 2001 17:13


|Dear gurus !
|What is better performance-wise - to declare a variable inside a
pl/sql
|block (or a trigger) as integer (number , Pls_integer etc..) or as
|mytable.mycolumn%TYPE .
|Again , i'm concerned ONLY about performance in this question.
|
|Thanks a lot.
|
|DBAndrey
|
|* 03-9254520
|* 053-464562
|* mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  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: Oracle 9i Linux files are erroring during uncompress...


If you do not use a download manager like getright, you will almost always
download broken files.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 1:36 PM
To: Multiple recipients of list ORACLE-L


Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com.  I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files.  I switched back to Windoze and using
Winzip it doesnt like the files either.  So I redownloaded just the smaller
third file and neither will uncompress the file.  Am I missing something
here?

I would download the files from SuSE but I can't get my DSL modem to work,
so I have been downloading the files using Windoze.  Could that be the
problem??

TIA!!

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

Oracle Licensing for a Clustered Server Configuration

2001-08-27 Thread Srinagesh Battula

Title: Oracle Licensing for a Clustered Server Configuration






Hi,


Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a
2-node cluster server environment?


Thanks


Nagesh

RE: Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread John Lewis


I had a similar problem getting 817nt from OTN.

I had to download the file to linux - run gunzip.
then I tar'd it up again and copy to NT - where I used a DOS tar program
to un-tar it. Sheeze! Very painful.

-Original Message-
Sent: Monday, August 27, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com.  I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files.  I switched back to Windoze and using
Winzip it doesnt like the files either.  So I redownloaded just the smaller
third file and neither will uncompress the file.  Am I missing something
here?

I would download the files from SuSE but I can't get my DSL modem to work,
so I have been downloading the files using Windoze.  Could that be the
problem??

TIA!!

Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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: John Lewis
  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: PK/Fk question


That won't work, your primary key is 3 cols, so the foreign key must
reference those same three cols.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Monday, August 27, 2001 12:17 PM
To: Multiple recipients of list ORACLE-L


Hi DBAs,

Table1 PK is on columns col1,col2,col3
I want to create a FK on table2 to table1 for col1.

What is the alternative to
ALTER TABLE table2
ADD CONSTRAINT fk_table2
FOREIGN KEY (col1) REFERENCES table1(col1);

I always get ORA-2270: No matching unique or primary key for this
column-list. 
Every value for table2.col1 is in the table table1.col1. I want to enforce
this at the database server level.

Thanks
Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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: Cobol Copybook format

2001-08-27 Thread John Kanagaraj


Lisa,
 
Thanks for waking up memories of COBOL that I have been trying to run away
from! Anyway a FILLER is just that - a filler or placeholder to pad out
or format a 'record' in the WORKING STORAGE or FILE section (eq. to the
declarative section in PL/SQL). If this is part of a retrieved record from a
file, it is sometime used to pad upto a 4-byte boundary. For a quick newbie
look at COBOL, go to http://www.cob.sjsu.edu/facstaff/lam_m/cobolp.htm
  Let me know offline if
you have additional queries.
 
John Kanagaraj 
Oracle Applications DBA 
DB Soft Inc 
Work : (408) 970 7002 

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com   

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

 

-Original Message-
Sent: Monday, August 27, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L



Good morning everyone, 

I have this messy document that is known as a copybook.  I've been searching
the web to help me understand what the appropriate way to translate this
into a table is.  If anyone has a link they are willing to share, or is
willing to answer questions (like what the heck is FILLER?) please email me
directly. 

Thank you! 

Lisa Koivu 
Oracle Database Administrator 
954-935-4117 

The information in the electronic mail message is Cendant confidential and
may be legally privileged, it is intended solely for the addressee(s) access
to this internet electronic mail message by anyone else is unauthorized. If
you are not the intended recipient, any disclosure, copying, distribution or
any action taken or omitted to be taken in reliance on it is prohibited and
may be unlawful.

The sender believes that this E-mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message and
its attachments could have been infected during transmission. By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action about viruses and
other defects. Cendant Corporation or Affiliates are not liable for any loss
or damage arising in any way from this message or its attachments. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: OT - DB2 for OS/2

2001-08-27 Thread Weaver, Walt


Isn't OS/2 still used extensively by banks to run ATM's? If that's the case,
then IBM would have a vested interest in keeping DB2 current on OS/2.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, August 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


I can't believe it, they have a beta DB2 v.7.1. for OS/2, same release
number as for AIX.  

I thought that OS was dead!

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Weaver, Walt
  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: OT - DB2 for OS/2


I can't believe it, they have a beta DB2 v.7.1. for OS/2, same release
number as for AIX.  

I thought that OS was dead!

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public 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).

Oracle 9i Linux files are erroring during uncompress...

2001-08-27 Thread Grabowy, Chris


Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com.  I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files.  I switched back to Windoze and using
Winzip it doesnt like the files either.  So I redownloaded just the smaller
third file and neither will uncompress the file.  Am I missing something
here?

I would download the files from SuSE but I can't get my DSL modem to work,
so I have been downloading the files using Windoze.  Could that be the
problem??

TIA!!

Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  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 quick pl/sql data types question

2001-08-27 Thread Jamadagni, Rajendra


I think a direct variable declaration (without constraints like not null) is
the fastest. Of course if you are dealing with integers, use pls_integer
instead of number, it is faster. 
Because for typecasting, I think it has to (somehow) access the dictionary
to get the column or table information.

If you want to write code for flexibility, maintainability use the anchored
data types %type and %rowtype.

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 !

*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: Burning game CD's

2001-08-27 Thread Jamadagni, Rajendra


Thanks I didn't knew ... and I am not a big fan of PC games anyway, so I
only read about music CD copyright related stuff.
..hmmm I have to catch up on my reading  

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 !

-Original Message-
Sent: Monday, August 27, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L


I just did a quick search on google, here is a good article in reguards:

http://www.pcmech.com/showdoc/34/

*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: Burning game CD's

2001-08-27 Thread Bill Conner


Find a riper (burner)  that does a binary rip and they will work.

At 07:46 AM 8/27/2001 -0800, you wrote:
>Some games, especially microsoft games have some sort of code or something
>on them that prevents burned cd's from operating correctly.  I know that
>it's definatley on Age of Empires.  However, if you look around on the
>Internet you can find cracks for them, I know there is one for Age of
>Empires.
>KK
>
>-Original Message-
>Tom
>Sent: Monday, August 27, 2001 10:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Off Topic:  I bought a PC this weekend that had my first every CDROM burner.
>I
>couldn't wait to use it.  I burned several game CD's (Age of Empires, Return
>Fire II, Roller coaster Tycoon) and none of them worked.  The games just
>hung
>when I ran them.  Bummer.  Is it not possible to make copies of my CD's or
>am I
>doing something wrong?
>
>Tom
>
>Tom Terrian
>Oracle DBA
>WPAFB - DAASC
>[EMAIL PROTECTED]
>937-656-3844
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Terrian, Tom
>   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: Kevin Kostyszyn
>   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: 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).

Re: OT: Cobol Copybook format

2001-08-27 Thread Connor McDonald


Rather than think of them as a table, think of each
copybook mapping a record in a file (which is what
cobol is basically designed to do)...

The numeric levels are a hierarchical way of grouping
the levels...  For example:

  10   date-created
 20  year-created   pic 99
 20  month-created  pic 99
 20  day-createdpic 99 

would imply that the "date-created" is a 6 digit
number comprising three components (yr/mon/day). 
Within cobol you could refer to either level to
use/create the records.

hth
connor

 --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
> Good morning everyone,
> 
> I have this messy document that is known as a
> copybook.  I've been searching
> the web to help me understand what the appropriate
> way to translate this
> into a table is.  If anyone has a link they are
> willing to share, or is
> willing to answer questions (like what the heck is
> FILLER?) please email me
> directly. 
> 
> Thank you!
> 
> > Lisa Koivu
> > Oracle Database Administrator
> > 954-935-4117
> > 
> > The information in the electronic mail message is
> Cendant confidential and
> > may be legally privileged, it is intended solely
> for the addressee(s)
> > access to this internet electronic mail message by
> anyone else is
> > unauthorized. If you are not the intended
> recipient, any disclosure,
> > copying, distribution or any action taken or
> omitted to be taken in
> > reliance on it is prohibited and may be unlawful.
> > 
> > The sender believes that this E-mail and any
> attachments were free of any
> > virus, worm, Trojan horse, and/or malicious code
> when sent. This message
> > and its attachments could have been infected
> during transmission. By
> > reading the message and opening any attachments,
> the recipient accepts
> > full responsibility for taking protective and
> remedial action about
> > viruses and other defects. Cendant Corporation or
> Affiliates are not
> > liable for any loss or damage arising in any way
> from this message or its
> > attachments. 
> > 
> > 
>  

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: OT: Microsoft XP