OT: RE: assistance

[Mercadante, Thomas F]

Lee,

Well!  I guess you are not eligible because you broke the "Top Secrecy" code
of conduct!

A local tv station saw this scam and contacted this guy - actually recorded
him for on-air viewing (with the mopes permission).  Showed it to be an
absolute scam.

Your email address must be used all over the place!  :)

-Original Message-
Sent: Thursday, August 22, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


HELLO  anyone else get this pile of S**T !!

Lee

-Original Message-
Sent: 22 August 2002 16:44
To: [EMAIL PROTECTED]


STRICTLY CONFIDENTIAL & URGENT.

I ama native of Cape Town in
South Africa and I am an Executive Accountant with
the
South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY 
First and foremost, I apologized using this medium to
reach you for a transaction/business of this
magnitude, but this is due to
Confidentiality and prompt access reposed on this
medium. 

I have decided to seek a confidential
co-operation with you in the execution of the deal
described Hereunder for the benefit of all parties
and
hope you will keep it as a top secret because of the
nature of this transaction.

Within the Department of Mining & Natural Resources
where I work as an Executive Accountant and with the
cooperation of four other top officials, we have in
our possession as overdue payment bills totaling
Twenty - One Million, Five Hundred Thousand U. S.
Dollars ($21,500,000.) which we want to transfer
abroad with the assistance and cooperation of a
foreign company/individual to receive the said fund
on
our behalf or a reliable foreign non-company account
to receive such funds. More so, we are handicapped in
the circumstances, as the South Africa Civil Service
Code of Conduct does not allow us to operate offshore
account hence your importance in the whole
transaction.
This amount $21.5m represents the balance of the
total
contract value executed on behalf of my Department by
a foreign contracting firm, which we the officials
over-invoiced deliberately. Though the actual
contract
cost have been paid to the original contractor,
leaving the balance in the Tune of the said amount
which we have in principles gotten approval to remit
by Key tested Telegraphic Transfer (K.T.T) to any
foreign bank account you will provide by filing in an
application through the Justice Ministry here in
South Africa for the transfer of rights and privileges of
the former contractor to you.

I have the authority of my partners involved to
propose that should you be willing to assist us in
the
transaction, your share of the sum will be 25% of the
$21.5 million, 70% for us and 5% for taxation and
miscellaneous expenses. The business itself is 100%
safe, on your part provided you treat it with utmost
secrecy and confidentiality. Also your area of
specialization is not a hindrance to the successful
execution of this transaction. I have reposed my
confidence in you and hope that you will not
disappoint me. Endeavor to contact me immediately my
e-mail address  whether or not you are
interested in this deal. If you are not, it will enable me scout
for another foreign partner to carry out this deal I want
to assure you that my partners and myself are in a
position to make the payment of this claim possible
provided you can give us a very strong Assurance and
guarantee that our share will be secured and please
remember to treat this matter as very confidential
matter, because we will not comprehend with any form
of exposure as we are still in active Government
Service and remember once again that time is of the
essence in this business.
I wait in anticipation of your fullest co-operation.

Yours faithfully,


JOSEPH EDWARD
NOTE: REPLY TO [EMAIL PROTECTED]


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

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

RE: Pro*C error after install

[Gogala, Mladen]

You favorite Unix vendor should ship you ANSI C compiler, 
preferably for free. Other solution is obtain a binary
for gcc from http://www.gcc.org and change makefile line
CC=/usr/ucb/cc to read CC=/usr/local/bin/gcc. If you chose
the latter, you will have to tweak the makefile a bit so that
it works. Let me warn you in advance: this is not easy. Using
SUN's compiler you'll pay some more but you will lose much less 
time. In the end, the cost for your company will be the same, 
regardless of the option you chose.

> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 22, 2002 10:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Pro*C error after install
> 
> 
> I am getting the following error after installing Pro*C on an 
> existing 8.1.7
> instance.  Can anyone help?
>  
>  
> 
>   oracle@cdwtst:> make -f demo_proc.mk sample1
> /usr/ccs/bin/make -f
> /u001/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk 
> OBJS=sample1.o
> EXE=sample1 build
> cc  -xO2  -Xa  -xstrconst -xF  -mr  -xarch=v8 
> -xcache=16/32/1:1024/64/1
> -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP  -I. -I/u
> 001/app/oracle/product/8.1.7/precomp/public
> -I/u001/app/oracle/product/8.1.7/rdbms/public
> -I/u001/app/oracle/product/8.1.7/r
> dbms/demo -I/u001/app/oracle/product/8.1.7/plsql/public
> -I/u001/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSL
> TS_ENABLE -D_SVID_GETTOD-c sample1.c
> /usr/ucb/cc:  language optional software package not installed
> *** Error code 1
> make: Fatal error: Command failed for target `sample1.o'
> Current working directory 
> /u001/app/oracle/product/8.1.7/precomp/demo/proc
> *** Error code 1
> make: Fatal error: Command failed for target `sample1' 
>  
>  
> R Smith 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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).

Oracle Applications Hanging

[Naveen Nahata]

I'm sorry for posting this again, but I thought maybe it skipped everyone's
eye.

Every once in a while the oracle applications hang, because the listener is
taking too much CPU. Even after waiting for a long time, the Listener process
continues to hog the processor and people cannot connect to Oracle Apps.

Any pointers on why this might be happening. 

Regards
Naveen

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

[Mark Leith]

Just mentioned this to "the boss" Lee, and he said he's had one too? (He's
not a member of the Oracle-L or Oracle-L-OT lists..).

Mark

-Original Message-
Dave
Sent: 22 August 2002 16:19
To: Multiple recipients of list ORACLE-L


Not me.  I must be to much of a financial risk.  ;o)

-Original Message-
Sent: Thursday, August 22, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L


HELLO  anyone else get this pile of S**T !!

Lee

-Original Message-
Sent: 22 August 2002 16:44
To: [EMAIL PROTECTED]


STRICTLY CONFIDENTIAL & URGENT.

I ama native of Cape Town in
South Africa and I am an Executive Accountant with
the
South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY
First and foremost, I apologized using this medium to
reach you for a transaction/business of this
magnitude, but this is due to
Confidentiality and prompt access reposed on this
medium.

I have decided to seek a confidential
co-operation with you in the execution of the deal
described Hereunder for the benefit of all parties
and
hope you will keep it as a top secret because of the
nature of this transaction.

Within the Department of Mining & Natural Resources
where I work as an Executive Accountant and with the
cooperation of four other top officials, we have in
our possession as overdue payment bills totaling
Twenty - One Million, Five Hundred Thousand U. S.
Dollars ($21,500,000.) which we want to transfer
abroad with the assistance and cooperation of a
foreign company/individual to receive the said fund
on
our behalf or a reliable foreign non-company account
to receive such funds. More so, we are handicapped in
the circumstances, as the South Africa Civil Service
Code of Conduct does not allow us to operate offshore
account hence your importance in the whole
transaction.
This amount $21.5m represents the balance of the
total
contract value executed on behalf of my Department by
a foreign contracting firm, which we the officials
over-invoiced deliberately. Though the actual
contract
cost have been paid to the original contractor,
leaving the balance in the Tune of the said amount
which we have in principles gotten approval to remit
by Key tested Telegraphic Transfer (K.T.T) to any
foreign bank account you will provide by filing in an
application through the Justice Ministry here in
South Africa for the transfer of rights and privileges of
the former contractor to you.

I have the authority of my partners involved to
propose that should you be willing to assist us in
the
transaction, your share of the sum will be 25% of the
$21.5 million, 70% for us and 5% for taxation and
miscellaneous expenses. The business itself is 100%
safe, on your part provided you treat it with utmost
secrecy and confidentiality. Also your area of
specialization is not a hindrance to the successful
execution of this transaction. I have reposed my
confidence in you and hope that you will not
disappoint me. Endeavor to contact me immediately my
e-mail address  whether or not you are
interested in this deal. If you are not, it will enable me scout
for another foreign partner to carry out this deal I want
to assure you that my partners and myself are in a
position to make the payment of this claim possible
provided you can give us a very strong Assurance and
guarantee that our share will be secured and please
remember to treat this matter as very confidential
matter, because we will not comprehend with any form
of exposure as we are still in active Government
Service and remember once again that time is of the
essence in this business.
I wait in anticipation of your fullest co-operation.

Yours faithfully,


JOSEPH EDWARD
NOTE: REPLY TO [EMAIL PROTECTED]


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

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

RE: Oracle DBA position- Must already live in WI

[Mercadante, Thomas F]

I *really* don't understand these things.  

Why would an employer say "must be living in Wisconsin".

I can understand saying "relocation fees not available".

Feel like I should be moving so I don't miss the opportunity to apply.


-Original Message-
Sent: Thursday, August 22, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L


Position: Oracle DBA 

Years Exp: 3+ years

Location: Milwaukee, WI 

Industry: Software

Compensation: 45-70K depends on experience plus Exceptional benefits.

*Candidates must already be living in the state of Wisconsin.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Position Description:
Fantastic career opportunity with probably the most high tech company in the
state of Wisconsin.
Small group of dynamic players, team orientated, fun place to work!

*Requirements:
-3-5 years of operational experience with oracle within a Unix environment. 
-Should be very well rehearsed in performing backup and recoverys including
 moving databases from host to host, renaming databases, Imports and
Exports,
 etc. Experience with setting up disaster-recovery scenarios is desirable.
-Performance tuning experience: SQL statements, using Explain Plans and
 TKProf is essential; Evaluating operational performance problems, memory
 tuning, cache tuning, statement tuning, etc. 
-Diagnosing application issues in an Application Server environment is a
must. 
-General oracle dba experience should include establishing dba instances,
building databases,
 adding files to tablespaces, understanding of Rollback Segments, etc. 
-The candidate should also have experience in writing PL/SQL preferably in a
 financial environment; this also includes understanding and building Entity
 Relationship Diagram for an application and using oracle Designer
(preferred), or ERWin. 
-Unix experience should include several years of script writing in KSH, SH,
and/or Perl

-U.S. citizenship or permanent residency is also required.

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/DBA/Milwaukee/Steve

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraStaff
  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: Mercadante, Thomas F
  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: assistance

[johanna . doran]

Title: RE: assistance






Yup.


Its a scam.  Believe it or not, some people have actually fallen for it!


Hannah


 -Original Message-

From:   [EMAIL PROTECTED]@SUNGARD   On Behalf Of Robertson Lee - lerobe <[EMAIL PROTECTED]>

Sent:   Thursday, August 22, 2002 10:49 AM

To: Multiple recipients of list ORACLE-L

Subject:    FW: assistance


HELLO  anyone else get this pile of S**T !!


Lee


-Original Message-

Sent: 22 August 2002 16:44

To: [EMAIL PROTECTED]



STRICTLY CONFIDENTIAL & URGENT.


I am    a native of Cape Town in

South Africa and I am an Executive Accountant with

the

South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY

First and foremost, I apologized using this medium to

reach you for a transaction/business of this

magnitude, but this is due to

Confidentiality and prompt access reposed on this

medium.


I have decided to seek a confidential

co-operation with you in the execution of the deal

described Hereunder for the benefit of all parties

and

hope you will keep it as a top secret because of the

nature of this transaction.


Within the Department of Mining & Natural Resources

where I work as an Executive Accountant and with the

cooperation of four other top officials, we have in

our possession as overdue payment bills totaling

Twenty - One Million, Five Hundred Thousand U. S.

Dollars ($21,500,000.) which we want to transfer

abroad with the assistance and cooperation of a

foreign company/individual to receive the said fund

on

our behalf or a reliable foreign non-company account

to receive such funds. More so, we are handicapped in

the circumstances, as the South Africa Civil Service

Code of Conduct does not allow us to operate offshore

account hence your importance in the whole

transaction.

This amount $21.5m represents the balance of the

total

contract value executed on behalf of my Department by

a foreign contracting firm, which we the officials

over-invoiced deliberately. Though the actual

contract

cost have been paid to the original contractor,

leaving the balance in the Tune of the said amount

which we have in principles gotten approval to remit

by Key tested Telegraphic Transfer (K.T.T) to any

foreign bank account you will provide by filing in an

application through the Justice Ministry here in

South Africa for the transfer of rights and privileges of

the former contractor to you.


I have the authority of my partners involved to

propose that should you be willing to assist us in

the

transaction, your share of the sum will be 25% of the

$21.5 million, 70% for us and 5% for taxation and

miscellaneous expenses. The business itself is 100%

safe, on your part provided you treat it with utmost

secrecy and confidentiality. Also your area of

specialization is not a hindrance to the successful

execution of this transaction. I have reposed my

confidence in you and hope that you will not

disappoint me. Endeavor to contact me immediately my

e-mail address  whether or not you are

interested in this deal. If you are not, it will enable me scout

for another foreign partner to carry out this deal I want

to assure you that my partners and myself are in a

position to make the payment of this claim possible

provided you can give us a very strong Assurance and

guarantee that our share will be secured and please

remember to treat this matter as very confidential

matter, because we will not comprehend with any form

of exposure as we are still in active Government

Service and remember once again that time is of the

essence in this business.

I wait in anticipation of your fullest co-operation.


Yours faithfully,



JOSEPH EDWARD

NOTE: REPLY TO [EMAIL PROTECTED]



*


The information contained in this communication is

confidential, is intended only for the use of the recipient

named above, and may be legally privileged.

If the reader of this message is not the intended

recipient, you are hereby notified that any dissemination,

distribution, or copying of this communication is strictly

prohibited.

If you have received this communication in error,

please re-send this communication to the sender and

delete the original message or any copy of it from your

computer system. Thank You.


--

Please see the official ORACLE-L FAQ: http://www.orafaq.com

--

Author: Robertson Lee - lerobe

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

RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

[DENNIS WILLIAMS]

Kumar - Generally, export/import expects to be going to a higher level of
Oracle. If you are moving the data from 8.1.6 to 9i, then that will present
no problems. Going the other way, moving data from 9i to 8.1.6 can pose
problems. The usual recommendation is to use the 8.1.6 "exp" program against
the 9i database. 
Are the Linux/W2K files binary compatible. I don't know myself, but
somebody does. Learn the techniques for cloning an Oracle database. I
believe http://www.orafaq.com   has a paper on this.
If not, just search using Google.
 
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, August 22, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L



Dennis,
In my case Net8 connection is not feasible because I have both OS Windows
2000/ Linux on the same machine using dual boot. So the only option for me
is to export the required user from Windows database  and then import from
Linux database. But please note that I have source database Windows 2000/9i,
but the source database is Linux/8.1.6. Can this be any problem for
export/import.

Recently I copied a database from a Window machine to another window machine
by copying the database files, redo log file, control files etc to target
machine in the corresponding directory and just created a service on the
target machine by using oradim and it worked fine. Is that possible if you
want to move the database and other files of Windows OS database to a Linux
OS database and then use svrmgrl to do something similar to get windows
database working on Linux. I know for this to work, I need to recreate or
make changes to control file. 

Thanks.


-Original Message-
mailto:[EMAIL PROTECTED]]On Behalf Of DENNIS
WILLIAMS
Sent: Wednesday, August 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
7.


Kumar
   Ummm . . . are you using any 9i features? I'm assuming you have
considered using 9i on Red Hat. Sounds like probably use the 8i export
function to create the export file. I'm assuming the data involved is small
enough to make export/import practical. If you create a Net8 connection, you
can just copy the data.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
8.1.6


I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/
Oracle 8.1.6. Please suggest the options.

Thanks.

--
Please see the official ORACLE-L FAQ:  
http://www.orafaq.com
--
Author: Dharminder Kumar
  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: DENNIS WILLIAMS
  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: DENNIS WILLIAMS
  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: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

[John Weatherman]

Kumar,
 
You 
can't copy the datafiles between OSs unless they are binary compatable, with 
Windows and any
flavor 
of Unix are not.  Also, you will have problems trying to export from 9i and 
import to 8i.  You need
to run 
the export using 8i executables, or at least I could never get it to work any 
other way.  Is there
a 
reason you can't install 9i on the Linux side?  Also, if you are saying 
that both "machines" are the 
same 
hardware ("dual boot"), how do you expect to get the .dmp file from one "side" 
to the "other side"?
Do you 
have some network storage somewhere?
 
Good 
Luck,
John P Weatherman Database Administrator Replacements Ltd. 

  -Original Message-From: Dharminder Kumar 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 
  11:11 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 
  7.
  Dennis,In my case Net8 connection is not feasible because 
  I have both OS Windows 2000/ Linux on the same machine using dual boot. So the 
  only option for me is to export the required user from Windows database  
  and then import from Linux database. But please note that I have source 
  database Windows 2000/9i, but the source database 
  is Linux/8.1.6. Can this be any problem for 
  export/import.Recently I copied a database from a Window machine to 
  another window machine by copying the database files, redo log file, control 
  files etc to target machine in the corresponding directory and just created a 
  service on the target machine by using oradim and it worked fine. Is that 
  possible if you want to move the database and other files of Windows OS 
  database to a Linux OS database and then use svrmgrl to do something similar 
  to get windows database working on Linux. I know for this to work, I need to 
  recreate or make changes to control file. 
  Thanks.-Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
  DENNISWILLIAMSSent: Wednesday, August 21, 2002 4:39 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: Moving Oracle 9i / Windows 2000 
  Database to Red Hat Linux7.Kumar   Ummm . . . 
  are you using any 9i features? I'm assuming you haveconsidered using 9i on 
  Red Hat. Sounds like probably use the 8i exportfunction to create the 
  export file. I'm assuming the data involved is smallenough to make 
  export/import practical. If you create a Net8 connection, youcan just copy 
  the data.Dennis WilliamsDBALifetouch, 
  Inc.[EMAIL PROTECTED]-Original Message-Sent: 
  Wednesday, August 21, 2002 3:24 PMTo: Multiple recipients of list 
  ORACLE-L8.1.6I want to move the Windows 2000/ Oracle 9i 
  database to Linux Red Hat 7.1/Oracle 8.1.6. Please suggest the 
  options.Thanks.--Please see the official ORACLE-L FAQ: 
  http://www.orafaq.com--Author: 
  Dharminder Kumar  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: DENNIS 
  WILLIAMS  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: assistance

[G . Plivna]

Oh, I get such mails usually once a month, although they are from persons
of Nigeria.
If these are from yahoo or so then I send them back to [EMAIL PROTECTED]
else just press del 


Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/



   
 
  Robertson Lee -  
 
  lerobe   To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
  <[EMAIL PROTECTED]cc: 
 
  .uk> Subject:  FW: assistance
 
  Sent by: 
 
  [EMAIL PROTECTED] 
 
   
 
   
 
  2002.08.22 17:48 
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




HELLO  anyone else get this pile of S**T !!

Lee





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

[Hately Mike]

I haven't had this recently.

I can't believe the number of government officials out there who covertly
email people out of the blue with fantastic offers of wealth.
I've been contacted by deposed leaders, heads of government departments and,
on one occasion, a king who needed my money to help him recover the throne
of which he'd been cheated. When he was properly enthroned he was going to
shower me with the kind of riches only seen in pirate movies.
I always feel that was a chance wasted. I could have been a Maharajah by
now.

Yes, I got lots of this kind of old bollocks. 

Cheers,
Mike

-Original Message-
Sent: 22 August 2002 15:49
To: Multiple recipients of list ORACLE-L


HELLO  anyone else get this pile of S**T !!

Lee

-Original Message-
Sent: 22 August 2002 16:44
To: [EMAIL PROTECTED]


STRICTLY CONFIDENTIAL & URGENT.

I ama native of Cape Town in
South Africa and I am an Executive Accountant with
the
South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY 
First and foremost, I apologized using this medium to
reach you for a transaction/business of this
magnitude, but this is due to
Confidentiality and prompt access reposed on this
medium. 




 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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

utl_file_dir versus create directory

[JOE TESTA]

in 9.0.2, you can use utl_file commands against directory objects, quickie 
example:
 
 
create directory tmp as '/tmp';grant write on directory tmp to 
public;grant read on directory tmp to public;
 
declare  ft utl_file.file_type;
 
begin  ft:=utl_file.fopen('TMP','x.gf','w');  
utl_file.put(ft,'X!@#$');  utl_file.fclose(ft);end;/
 
edit /tmp/x.gf
 
 
and no i dont have my utl_file_dir set at all.
 
joe
 
 
 

RE: Strange Data issue.....

[Mercadante, Thomas F]

Title: Strange Data issue.



Waleed,
 
what I 
suggested was that the select and group by were not the same columns, thus the 
results were unpredicitble.
 
He is 
selecting one thing, and grouping by another.
 
If he 
selects and groups by the same items, this will work just 
fine.
 
It 
makes no sense to me why he is concatenating everything 
together.
 
A 
better query would be :
 
   select race, gender, count(*) 
    from pers 
    group by race, gender
 
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Khedr, Waleed 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 11:04 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Strange Data issue.
  This 
  will not fix it.
  Group by race,gender    should return only one row for 
  each unique combination of both columns.
   
  I 
  can not help on this except advising to check the ASCII for both columns or 
  check for special characters in these columns if they are wider that one 
  char.
  Regards,
   
  Waleed
  
-Original Message-From: Mercadante, Thomas F 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 
10:14 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Strange Data issue.
Denham,
 
Your "group by" does not match what you are 
selecting, thus the results are wrong.
 
Change your query as 
follows:
 
   select race||','||gender,count(*) 
    from 
pers     group by race||','||gender
Hope this helps.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Strange Data issue.
  Hello Gurus, 
  I have a problem which I hope someone can help 
  me with. I am trying to clean up some 
  data on a table. This table happens to be a personnel table. 
  In this table there are two columns RACE and 
  GENDER. The select used is : 
     select 
  race||','||gender||','||count(*) 
      from pers     
  group by race, gender; The result is as follows: 
  A,F,62 A,M,613 A,M,35 
  A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 
  I,M,69 I,M,1 W,F,205 
  W,M,972 W,M,28 W,,15 
  The problem is that the result returns double 
  Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in 
  anyway but both Ms return ascii 77. Does anyone have any thoughts on this? 
  TIA Denham 
  Eva Oracle 
  DBA In UNIX Land 
  On a quiet Night, you can hear the Windows 
  machines reboot. 
  

  DISCLAIMER 
  This message is for the named person's use 
  only. It may contain confidential, proprietary or legally privileged 
  information. No confidentiality or privilege is waived or lost by any 
  mistransmission. If you receive this message in error, please immediately 
  delete it and all copies of it from your system, destroy any hard copies 
  of it and notify the sender. You must not, directly or indirectly, use, 
  disclose, distribute, print, or copy any part of this message if you are 
  not the intended recipient. TFMC, its holding company, and any of its 
  subsidiaries each reserve the right to monitor and manage all e-mail 
  communications through its networks. 
  Any views expressed in this message are those 
  of the individual sender, except where the message states otherwise and 
  the sender is authorized to state them to be views of any such 
  entity. 
  
  
  
  
  This e-mail message has been scanned for Viruses and Content and cleared 
  by MailMarshal - For more 
  information please visit www.marshalsoftware.com 
  
  

Re: FW: assistance

[Ray Stell]

They probably don't/can't do anything about international 
garbage, but the federal trade commission has some spam efforts:

http://www.ftc.gov/bcp/conline/edcams/spam/

At this url:  http://www.ftc.gov/opa/1998/9806/uce.htm

The Commission said it closely monitors the development of commerce on
the Internet and is monitoring UCE for deception and fraud. An FTC
e-mail address where consumers can forward fraudulent e-mail (
[EMAIL PROTECTED] ) has collected over 100,000 pieces of UCE and is receiving
up to 1,500 new pieces daily.





On Thu, Aug 22, 2002 at 06:48:30AM -0800, Robertson Lee - lerobe wrote:
> HELLO  anyone else get this pile of S**T !!
> 
> Lee
> 
> -Original Message-
> Sent: 22 August 2002 16:44
> To: [EMAIL PROTECTED]
> 
> 
> STRICTLY CONFIDENTIAL & URGENT.
> 
> I ama native of Cape Town in
> South Africa and I am an Executive Accountant with
> the
> South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY 
> First and foremost, I apologized using this medium to
> reach you for a transaction/business of this
> magnitude, but this is due to
> Confidentiality and prompt access reposed on this
> medium. 
> 
> I have decided to seek a confidential
> co-operation with you in the execution of the deal
> described Hereunder for the benefit of all parties
> and
> hope you will keep it as a top secret because of the
> nature of this transaction.
> 
> Within the Department of Mining & Natural Resources
> where I work as an Executive Accountant and with the
> cooperation of four other top officials, we have in
> our possession as overdue payment bills totaling
> Twenty - One Million, Five Hundred Thousand U. S.
> Dollars ($21,500,000.) which we want to transfer
> abroad with the assistance and cooperation of a
> foreign company/individual to receive the said fund
> on
> our behalf or a reliable foreign non-company account
> to receive such funds. More so, we are handicapped in
> the circumstances, as the South Africa Civil Service
> Code of Conduct does not allow us to operate offshore
> account hence your importance in the whole
> transaction.
> This amount $21.5m represents the balance of the
> total
> contract value executed on behalf of my Department by
> a foreign contracting firm, which we the officials
> over-invoiced deliberately. Though the actual
> contract
> cost have been paid to the original contractor,
> leaving the balance in the Tune of the said amount
> which we have in principles gotten approval to remit
> by Key tested Telegraphic Transfer (K.T.T) to any
> foreign bank account you will provide by filing in an
> application through the Justice Ministry here in
> South Africa for the transfer of rights and privileges of
> the former contractor to you.
> 
> I have the authority of my partners involved to
> propose that should you be willing to assist us in
> the
> transaction, your share of the sum will be 25% of the
> $21.5 million, 70% for us and 5% for taxation and
> miscellaneous expenses. The business itself is 100%
> safe, on your part provided you treat it with utmost
> secrecy and confidentiality. Also your area of
> specialization is not a hindrance to the successful
> execution of this transaction. I have reposed my
> confidence in you and hope that you will not
> disappoint me. Endeavor to contact me immediately my
> e-mail address  whether or not you are
> interested in this deal. If you are not, it will enable me scout
> for another foreign partner to carry out this deal I want
> to assure you that my partners and myself are in a
> position to make the payment of this claim possible
> provided you can give us a very strong Assurance and
> guarantee that our share will be secured and please
> remember to treat this matter as very confidential
> matter, because we will not comprehend with any form
> of exposure as we are still in active Government
> Service and remember once again that time is of the
> essence in this business.
> I wait in anticipation of your fullest co-operation.
> 
> Yours faithfully,
> 
> 
> JOSEPH EDWARD
> NOTE: REPLY TO [EMAIL PROTECTED]
> 
> 
> *
> 
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged.
> If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, 
> distribution, or copying of this communication is strictly
> prohibited.
> If you have received this communication in error,
> please re-send this communication to the sender and
> delete the original message or any copy of it from your
> computer system. Thank You.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Robertson Lee - lerobe
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists

RE: assistance

[Farnsworth, Dave]

Not me.  I must be to much of a financial risk.  ;o)

-Original Message-
Sent: Thursday, August 22, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L


HELLO  anyone else get this pile of S**T !!

Lee

-Original Message-
Sent: 22 August 2002 16:44
To: [EMAIL PROTECTED]


STRICTLY CONFIDENTIAL & URGENT.

I ama native of Cape Town in
South Africa and I am an Executive Accountant with
the
South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY 
First and foremost, I apologized using this medium to
reach you for a transaction/business of this
magnitude, but this is due to
Confidentiality and prompt access reposed on this
medium. 

I have decided to seek a confidential
co-operation with you in the execution of the deal
described Hereunder for the benefit of all parties
and
hope you will keep it as a top secret because of the
nature of this transaction.

Within the Department of Mining & Natural Resources
where I work as an Executive Accountant and with the
cooperation of four other top officials, we have in
our possession as overdue payment bills totaling
Twenty - One Million, Five Hundred Thousand U. S.
Dollars ($21,500,000.) which we want to transfer
abroad with the assistance and cooperation of a
foreign company/individual to receive the said fund
on
our behalf or a reliable foreign non-company account
to receive such funds. More so, we are handicapped in
the circumstances, as the South Africa Civil Service
Code of Conduct does not allow us to operate offshore
account hence your importance in the whole
transaction.
This amount $21.5m represents the balance of the
total
contract value executed on behalf of my Department by
a foreign contracting firm, which we the officials
over-invoiced deliberately. Though the actual
contract
cost have been paid to the original contractor,
leaving the balance in the Tune of the said amount
which we have in principles gotten approval to remit
by Key tested Telegraphic Transfer (K.T.T) to any
foreign bank account you will provide by filing in an
application through the Justice Ministry here in
South Africa for the transfer of rights and privileges of
the former contractor to you.

I have the authority of my partners involved to
propose that should you be willing to assist us in
the
transaction, your share of the sum will be 25% of the
$21.5 million, 70% for us and 5% for taxation and
miscellaneous expenses. The business itself is 100%
safe, on your part provided you treat it with utmost
secrecy and confidentiality. Also your area of
specialization is not a hindrance to the successful
execution of this transaction. I have reposed my
confidence in you and hope that you will not
disappoint me. Endeavor to contact me immediately my
e-mail address  whether or not you are
interested in this deal. If you are not, it will enable me scout
for another foreign partner to carry out this deal I want
to assure you that my partners and myself are in a
position to make the payment of this claim possible
provided you can give us a very strong Assurance and
guarantee that our share will be secured and please
remember to treat this matter as very confidential
matter, because we will not comprehend with any form
of exposure as we are still in active Government
Service and remember once again that time is of the
essence in this business.
I wait in anticipation of your fullest co-operation.

Yours faithfully,


JOSEPH EDWARD
NOTE: REPLY TO [EMAIL PROTECTED]


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--

Oracle DBA position- Must already live in WI

[OraStaff]

Position: Oracle DBA 

Years Exp: 3+ years

Location: Milwaukee, WI 

Industry: Software

Compensation: 45-70K depends on experience plus Exceptional benefits.

*Candidates must already be living in the state of Wisconsin.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.

*Position Description:
Fantastic career opportunity with probably the most high tech company in the
state of Wisconsin.
Small group of dynamic players, team orientated, fun place to work!

*Requirements:
-3-5 years of operational experience with oracle within a Unix environment. 
-Should be very well rehearsed in performing backup and recoverys including
 moving databases from host to host, renaming databases, Imports and Exports,
 etc. Experience with setting up disaster-recovery scenarios is desirable.
-Performance tuning experience: SQL statements, using Explain Plans and
 TKProf is essential; Evaluating operational performance problems, memory
 tuning, cache tuning, statement tuning, etc. 
-Diagnosing application issues in an Application Server environment is a must. 
-General oracle dba experience should include establishing dba instances,
building databases,
 adding files to tablespaces, understanding of Rollback Segments, etc. 
-The candidate should also have experience in writing PL/SQL preferably in a
 financial environment; this also includes understanding and building Entity
 Relationship Diagram for an application and using oracle Designer
(preferred), or ERWin. 
-Unix experience should include several years of script writing in KSH, SH,
and/or Perl

-U.S. citizenship or permanent residency is also required.

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/DBA/Milwaukee/Steve

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraStaff
  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: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

[Dharminder Kumar]

Dennis,In my case Net8 connection is not feasible because I 
have both OS Windows 2000/ Linux on the same machine using dual boot. So the 
only option for me is to export the required user from Windows database  
and then import from Linux database. But please note that I have source database 
Windows 2000/9i, but the source database is Linux/8.1.6. Can this be any problem for 
export/import.Recently I copied a database from a Window machine to 
another window machine by copying the database files, redo log file, control 
files etc to target machine in the corresponding directory and just created a 
service on the target machine by using oradim and it worked fine. Is that 
possible if you want to move the database and other files of Windows OS database 
to a Linux OS database and then use svrmgrl to do something similar to get 
windows database working on Linux. I know for this to work, I need to recreate 
or make changes to control file. Thanks.-Original 
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
DENNISWILLIAMSSent: Wednesday, August 21, 2002 4:39 PMTo: Multiple 
recipients of list ORACLE-LSubject: RE: Moving Oracle 9i / Windows 2000 
Database to Red Hat Linux7.Kumar   Ummm . . . are 
you using any 9i features? I'm assuming you haveconsidered using 9i on Red 
Hat. Sounds like probably use the 8i exportfunction to create the export 
file. I'm assuming the data involved is smallenough to make export/import 
practical. If you create a Net8 connection, youcan just copy the 
data.Dennis WilliamsDBALifetouch, 
Inc.[EMAIL PROTECTED]-Original Message-Sent: 
Wednesday, August 21, 2002 3:24 PMTo: Multiple recipients of list 
ORACLE-L8.1.6I want to move the Windows 2000/ Oracle 9i database 
to Linux Red Hat 7.1/Oracle 8.1.6. Please suggest the 
options.Thanks.--Please see the official ORACLE-L FAQ: 
http://www.orafaq.com--Author: Dharminder 
Kumar  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: DENNIS 
WILLIAMS  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: query help.

[cw]

Hey list Guru,   Can anyone help me with this query?Many thanks,

SELECT 
 A.COUNTY_CODE,
 C.COUNTY_NAME,
 lpad(B.PRECINCT,4,' '),
 count(*),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(18*12))/(1*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(19*12))/(11*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(30*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(40*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(50*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(60*12))/(5*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
A.DOB)-(65*12))/(10*99)),1,0)),
 sum(decode(A.DOB, NULL, 1, 0))
  FROM ONLINE_VOTERS A, ADDRESS_INDEX B, COUNTIES C
 WHERE A.COUNTY_CODE = B.COUNTY_CODE
   AND A.ADDRESS_ID = B.ADDRESS_ID
   AND A.COUNTY_CODE = C.COUNTY_CODE
   AND A.STATUS IN ('V','S')
 GROUP BY A.COUNTY_CODE, C.COUNTY_NAME, lpad(B.PRECINCT,4,' ')
UNION ALL
SELECT 
 D.COUNTY_CODE,
 C2.COUNTY_NAME,
 lpad(D.PRECINCT,4,' '),
 count(*),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(18*12))/(1*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(19*12))/(11*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(30*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(40*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(50*12))/(10*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(60*12))/(5*12)),1,0)),
 sum(DECODE(0,floor((months_between(sysdate,
D.DOB)-(65*12))/(10*99)),1,0)),
 sum(decode(D.DOB, NULL, 1, 0))
  FROM OFFLINE_VOTERS D, COUNTIES C2
 WHERE D.COUNTY_CODE = C2.COUNTY_CODE
   AND D.STATUS IN ('V','S')
 GROUP BY D.COUNTY_CODE, C2.COUNTY_NAME, lpad(D.PRECINCT,4,' ');




_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: cw
  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: utl_file_dir vs create directory

[Rachel Carmichael]

Connor,

So create directory can be used instead of the utl_file_dir
initialization parameter and can still be used with the utl_file
package? That's my only worry, as the docs lead me to believe that I
need to replace the use of utl_file with BFILEs

Once I have "created a directory", it remains available across database
shutdown and startup?


Rachel


--- Connor McDonald <[EMAIL PROTECTED]> wrote:
> a) its dynamic (so bounce needed)
> b) its more granular - you can grant read/readwrite
> etc
> 
> hth
> connor
> 
>  --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > Okay, I'll admit I know nothing about the create
> > directory command and
> > am off to read the fine manuals as soon as I hit
> > send on this
> > 
> > my developer sent me an email saying "do you know of
> > this new feature
> > create_directory? it is recommended to use
> > create_directory instead of
> > utl_file_dir"
> > 
> > First, she's not in, I can't ask her WHO recommended
> > it. But I will.
> > Second, I think she meant create directory, without
> > the underscore.
> > 
> > Basically what we are doing is reading an orders
> > table and generating a
> > flat file to be shipped to the fulfillment center.
> > This will be done
> > via a PL/SQL procedure which will be called at
> > regularly scheduled
> > times.
> > 
> > Why would I want/need to use create directory
> > instead of utl_file?  The
> > database will go live in 9.2.0.1
> > 
> > Any advice is welcome!
> > 
> > Rachel
> > 
> > 
> > __
> > Do You Yahoo!?
> > HotJobs - Search Thousands of New Jobs
> > http://www.hotjobs.com
> > -- 
> > 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). 
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "Remember amateurs built the ark - Professionals built the Titanic"
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> -- 
> 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).


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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: SunFire v100

[Paul Baumgartel]

"headless" server?  What's that?

--- Maria Aurora VT de la Vega <[EMAIL PROTECTED]> wrote:
> Hello everyone.
> 
> Just want to ask if anybody tried to use a SunFire v100 as a database
> server.
> I was told this is a headless server, but otherwise, very similar to
> any
> other sun servers. Looks like an oracle database on this baby can
> work
> enough as a development server. Would like to get anybody's opinion.
> Will oracle work on this or not?
> 
> Thanks.
> 
> =)
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Maria Aurora VT de la Vega
>   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 Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: utl_file_dir vs create directory

[Rachel Carmichael]

that's what I thought, but the docs would lead you to believe it is the
preferred substitute in all cases...

I was always under the impression that BFILEs are read-only. If this is
wrong, then we can and should probably use the 'create directory' and
BFILE. If this is right, then a BFILE is useless to me in this
circumstance

Rachel
--- "Adams, Matthew (GEA, MABG, 088130)" <[EMAIL PROTECTED]>
wrote:
> I believe that the 'create directory' command is only 
> appropriate when dealing with BFILEs.  
> 
> It's not exactly a substitute for the UTL_FILE package
> and UTL_FILE_DIR parameter.
> 
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> My computer beat me at chess, but I won
> when it came to kick boxing.
> 
> -Original Message-
> Sent: Thursday, August 22, 2002 8:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, I'll admit I know nothing about the create directory command
> and
> am off to read the fine manuals as soon as I hit send on this
> 
> my developer sent me an email saying "do you know of this new feature
> create_directory? it is recommended to use create_directory instead
> of
> utl_file_dir"
> 
> First, she's not in, I can't ask her WHO recommended it. But I will.
> Second, I think she meant create directory, without the underscore.
> 
> Basically what we are doing is reading an orders table and generating
> a
> flat file to be shipped to the fulfillment center. This will be done
> via a PL/SQL procedure which will be called at regularly scheduled
> times.
> 
> Why would I want/need to use create directory instead of utl_file? 
> The
> database will go live in 9.2.0.1
> 
> Any advice is welcome!
> 
> Rachel
> 
> 
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> -- 
> 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).
> 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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: utl_file_dir vs create directory

[Rachel Carmichael]

yes I saw the docs. but that doesn't tell me that I can CREATE A
FILE which is what we want to do. Since this is a new application and
database, I can bounce the instance all I want, no one is using it
except me and the programmers yet


--- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> it is recommended that you use "create directory" rather than
> utl_file_dir. 
>
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920
> /a96590/whatsnew.htm#970251 just scroll down a bit. I think create
> directory
> will let you perform the function of utl_file_dir but dynamically.
> For
> changing utl_file_dir you required to bounce the instance, but not in
> this
> case. I think this is why ...
> 
> Raj
> __
> Rajendra JamadagniMIS, 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: Thursday, August 22, 2002 8:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, I'll admit I know nothing about the create directory command
> and
> am off to read the fine manuals as soon as I hit send on this
> 
> my developer sent me an email saying "do you know of this new feature
> create_directory? it is recommended to use create_directory instead
> of
> utl_file_dir"
> 
> First, she's not in, I can't ask her WHO recommended it. But I will.
> Second, I think she meant create directory, without the underscore.
> 
> Basically what we are doing is reading an orders table and generating
> a
> flat file to be shipped to the fulfillment center. This will be done
> via a PL/SQL procedure which will be called at regularly scheduled
> times.
> 
> Why would I want/need to use create directory instead of utl_file? 
> The
> database will go live in 9.2.0.1
> 
> Any advice is welcome!
> 
> Rachel
> >
*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.*2
> 


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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: Strange Data issue.....

[Khedr, Waleed]

Title: Strange Data issue.



This 
will not fix it.
Group 
by race,gender    should return only one row for each unique 
combination of both columns.
 
I can 
not help on this except advising to check the ASCII for both columns or check 
for special characters in these columns if they are wider that one 
char.
Regards,
 
Waleed

  -Original Message-From: Mercadante, Thomas F 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 
  10:14 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Strange Data issue.
  Denham,
   
  Your 
  "group by" does not match what you are selecting, thus the results are 
  wrong.
   
  Change your query as follows:
   
     select race||','||gender,count(*) 
      from 
  pers     group by race||','||gender
  Hope 
  this helps.
   
  Tom Mercadante Oracle Certified Professional 
  
-Original Message-From: Denham Eva 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 
AMTo: Multiple recipients of list ORACLE-LSubject: 
Strange Data issue.
Hello Gurus, 
I have a problem which I hope someone can help me 
with. I am trying to clean up some data 
on a table. This table happens to be a personnel table. In this table there are two columns RACE and 
GENDER. The select used is : 
   select 
race||','||gender||','||count(*) 
    from 
pers     group by race, gender; The result 
is as follows: 
A,F,62 A,M,613 A,M,35 A,,15 C,F,34 
C,M,198 C,M,4 C,,2 
I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 
The problem is that the result returns double Ms, 
M indicating Male. As highligthed above I 
have tried converting to ascii to see if they are different in anyway but 
both Ms return ascii 77. Does anyone have 
any thoughts on this? 
TIA Denham 
Eva Oracle 
DBA In UNIX Land 
On a quiet Night, you can hear the Windows 
machines reboot. 


DISCLAIMER 

This message is for the named person's use only. 
It may contain confidential, proprietary or legally privileged information. 
No confidentiality or privilege is waived or lost by any mistransmission. If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender. You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. TFMC, its holding company, and any of its subsidiaries each 
reserve the right to monitor and manage all e-mail communications through 
its networks. 
Any views expressed in this message are those of 
the individual sender, except where the message states otherwise and the 
sender is authorized to state them to be views of any such entity. 





This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - For more 
information please visit www.marshalsoftware.com 


  

FW: assistance

[Robertson Lee - lerobe]

HELLO  anyone else get this pile of S**T !!

Lee

-Original Message-
Sent: 22 August 2002 16:44
To: [EMAIL PROTECTED]


STRICTLY CONFIDENTIAL & URGENT.

I ama native of Cape Town in
South Africa and I am an Executive Accountant with
the
South Africa  DEPARTMENT OF MINERAL RESOURCES AND ENERGY 
First and foremost, I apologized using this medium to
reach you for a transaction/business of this
magnitude, but this is due to
Confidentiality and prompt access reposed on this
medium. 

I have decided to seek a confidential
co-operation with you in the execution of the deal
described Hereunder for the benefit of all parties
and
hope you will keep it as a top secret because of the
nature of this transaction.

Within the Department of Mining & Natural Resources
where I work as an Executive Accountant and with the
cooperation of four other top officials, we have in
our possession as overdue payment bills totaling
Twenty - One Million, Five Hundred Thousand U. S.
Dollars ($21,500,000.) which we want to transfer
abroad with the assistance and cooperation of a
foreign company/individual to receive the said fund
on
our behalf or a reliable foreign non-company account
to receive such funds. More so, we are handicapped in
the circumstances, as the South Africa Civil Service
Code of Conduct does not allow us to operate offshore
account hence your importance in the whole
transaction.
This amount $21.5m represents the balance of the
total
contract value executed on behalf of my Department by
a foreign contracting firm, which we the officials
over-invoiced deliberately. Though the actual
contract
cost have been paid to the original contractor,
leaving the balance in the Tune of the said amount
which we have in principles gotten approval to remit
by Key tested Telegraphic Transfer (K.T.T) to any
foreign bank account you will provide by filing in an
application through the Justice Ministry here in
South Africa for the transfer of rights and privileges of
the former contractor to you.

I have the authority of my partners involved to
propose that should you be willing to assist us in
the
transaction, your share of the sum will be 25% of the
$21.5 million, 70% for us and 5% for taxation and
miscellaneous expenses. The business itself is 100%
safe, on your part provided you treat it with utmost
secrecy and confidentiality. Also your area of
specialization is not a hindrance to the successful
execution of this transaction. I have reposed my
confidence in you and hope that you will not
disappoint me. Endeavor to contact me immediately my
e-mail address  whether or not you are
interested in this deal. If you are not, it will enable me scout
for another foreign partner to carry out this deal I want
to assure you that my partners and myself are in a
position to make the payment of this claim possible
provided you can give us a very strong Assurance and
guarantee that our share will be secured and please
remember to treat this matter as very confidential
matter, because we will not comprehend with any form
of exposure as we are still in active Government
Service and remember once again that time is of the
essence in this business.
I wait in anticipation of your fullest co-operation.

Yours faithfully,


JOSEPH EDWARD
NOTE: REPLY TO [EMAIL PROTECTED]


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: utl_file_dir vs create directory

[Robertson Lee - lerobe]

Damn, 

it isn't "CREATE_DIRECTORY" at all, it is without the underscore

-Original Message-
Sent: 22 August 2002 14:04
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


This is VERY limited but from what I remember she is correct and it is
"CREATE_DIRECTORY". Is the file you are writing out a BFILE or an external
table. I think that is when you use this option.

Oh hell, I'm going to RTFM to find this out as well.

Lee



> Lee Robertson 
> Oracle DBA
> __   __

> ACXIOM
>   
> Direct Dial:  +44 (0)191 525 7344 Acxiom Limited  
> Telephone: +44 (0)191 525 7000Camberwell Way  
> Facsimile:   +44 (0)191 525 7100  Doxford Tech. Park

>   Sunderland

> E-mail: [EMAIL PROTECTED]  SR9 9XZ 


-Original Message-
Sent: 22 August 2002 13:59
To: Multiple recipients of list ORACLE-L


Okay, I'll admit I know nothing about the create directory command and
am off to read the fine manuals as soon as I hit send on this

my developer sent me an email saying "do you know of this new feature
create_directory? it is recommended to use create_directory instead of
utl_file_dir"

First, she's not in, I can't ask her WHO recommended it. But I will.
Second, I think she meant create directory, without the underscore.

Basically what we are doing is reading an orders table and generating a
flat file to be shipped to the fulfillment center. This will be done
via a PL/SQL procedure which will be called at regularly scheduled
times.

Why would I want/need to use create directory instead of utl_file?  The
database will go live in 9.2.0.1

Any advice is welcome!

Rachel


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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).


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

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

Pro*C error after install

[Smith, Ron L.]

I am getting the following error after installing Pro*C on an existing 8.1.7
instance.  Can anyone help?
 
 

  oracle@cdwtst:> make -f demo_proc.mk sample1
/usr/ccs/bin/make -f
/u001/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk OBJS=sample1.o
EXE=sample1 build
cc  -xO2  -Xa  -xstrconst -xF  -mr  -xarch=v8 -xcache=16/32/1:1024/64/1
-xchip=ultra -D_REENTRANT -K PIC -DPRECOMP  -I. -I/u
001/app/oracle/product/8.1.7/precomp/public
-I/u001/app/oracle/product/8.1.7/rdbms/public
-I/u001/app/oracle/product/8.1.7/r
dbms/demo -I/u001/app/oracle/product/8.1.7/plsql/public
-I/u001/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSL
TS_ENABLE -D_SVID_GETTOD-c sample1.c
/usr/ucb/cc:  language optional software package not installed
*** Error code 1
make: Fatal error: Command failed for target `sample1.o'
Current working directory /u001/app/oracle/product/8.1.7/precomp/demo/proc
*** Error code 1
make: Fatal error: Command failed for target `sample1' 
 
 
R Smith 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: utl_file_dir vs create directory

[Jamadagni, Rajendra]

Rachel,

it is recommended that you use "create directory" rather than utl_file_dir. 
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920
/a96590/whatsnew.htm#970251 just scroll down a bit. I think create directory
will let you perform the function of utl_file_dir but dynamically. For
changing utl_file_dir you required to bounce the instance, but not in this
case. I think this is why ...

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: Thursday, August 22, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L


Okay, I'll admit I know nothing about the create directory command and
am off to read the fine manuals as soon as I hit send on this

my developer sent me an email saying "do you know of this new feature
create_directory? it is recommended to use create_directory instead of
utl_file_dir"

First, she's not in, I can't ask her WHO recommended it. But I will.
Second, I think she meant create directory, without the underscore.

Basically what we are doing is reading an orders table and generating a
flat file to be shipped to the fulfillment center. This will be done
via a PL/SQL procedure which will be called at regularly scheduled
times.

Why would I want/need to use create directory instead of utl_file?  The
database will go live in 9.2.0.1

Any advice is welcome!

Rachel


*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.*2

RE: PL/Sql question

[DENNIS WILLIAMS]

Tom - Thanks to you and everyone else for the great suggestions. He and I
are sitting down tomorrow to straighten this out. I was concerned that there
might be some PL/SQL oddity that I wasn't aware of (he is a pretty good
PL/SQL programmer). I appreciate your ruling that out. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, August 22, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L


Dennis,

I'd guess that the developer did not try it correctly.  Ask to see the code.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L



Tom - The developer reports that he tried this but it didn't work. The third
position is still a space value. Thanks to everyone for the good replies.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 3:13 PM
To: '[EMAIL PROTECTED]'
Cc: DENNIS WILLIAMS


Dennis,

Try changing your insert statement to:

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
 MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
 PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) 
   VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,'
'),
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.

PL/SQL snippets


<...snip...>

   marketingcodeVARCHAR2(3);

<...snip...>

FILELOCATION := '/usr/users/madmload/text_files';
OPEN_MODE:= 'r';
FILENAME := 'prodload.txt';

FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE );

<...snip...>

   UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
   marketingcode := substr(outputstring, 21, 3);
 

<...snip...>

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;





Sql*Loader script

LOAD DATA
INFILE '/usr/users/madmload/joblid.txt'
BADFILE '/usr/users/madmload/jobload.bad'
APPEND
INTO TABLE JOBFACT
(
JOBNBR  POSITION(1:10)  CHAR, 
LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
MDRPRIMARYIDPOSITION(21:28) CHAR,
MARKETINGCODE   POSITION(29:31) CHAR,
SUBPROGRAMCODE  POSITION(32:32) CHAR,
TERRITORYCODE   POSITION(33:34) CHAR,
SUBTERRITORYCODEPOSITION(33:36) CHAR,
SELLINGMETHODCODE   POSITION(37:37) CHAR,
BIDIND  POSITION(38:38) CHAR,
PDKIND  POSITION(39:39) CHAR,
PDKPARTNBR  POSITION(40:44) CHAR,
RETAKEIND   POSITION(45:45) CHAR,
PLANTCODE   POSITION(46:46) CHAR,
PLANTRECEIPTDATEPOSITION(47:56) DATE "/MM/DD" NULLIF
PLANTRECEIPTDA,
PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL,
PLANTRECEIPTMONTH   POSITION(52:53) INTEGER EXTERNAL,
PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD" NULLIF
PHOTOGRAPHYDATE=BLANKS,
SHIPDATEPOSITION(67:76) DATE "/MM/DD" NULLIF SHIPDATE=BLANKS,
SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER EXTERNAL,
PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL,
XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL,
CASHRETAINEDAMT POSITION(106:114)   DECIMAL EXTERNAL,
ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL EXTERNAL,
ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL EXTERNAL,
CHARGEBACKAMT   POSITION(133:141)   DECIMAL EXTERNAL,
SALESTAXAMT POSITION(142:150)   DECIMAL EXTERNAL,
TERRITORYCMSNAMTPOSITION(1

RE: utl_file_dir vs create directory

[Robertson Lee - lerobe]

This is VERY limited but from what I remember she is correct and it is
"CREATE_DIRECTORY". Is the file you are writing out a BFILE or an external
table. I think that is when you use this option.

Oh hell, I'm going to RTFM to find this out as well.

Lee



> Lee Robertson 
> Oracle DBA
> __   __

> ACXIOM
>   
> Direct Dial:  +44 (0)191 525 7344 Acxiom Limited  
> Telephone: +44 (0)191 525 7000Camberwell Way  
> Facsimile:   +44 (0)191 525 7100  Doxford Tech. Park

>   Sunderland

> E-mail: [EMAIL PROTECTED]  SR9 9XZ 


-Original Message-
Sent: 22 August 2002 13:59
To: Multiple recipients of list ORACLE-L


Okay, I'll admit I know nothing about the create directory command and
am off to read the fine manuals as soon as I hit send on this

my developer sent me an email saying "do you know of this new feature
create_directory? it is recommended to use create_directory instead of
utl_file_dir"

First, she's not in, I can't ask her WHO recommended it. But I will.
Second, I think she meant create directory, without the underscore.

Basically what we are doing is reading an orders table and generating a
flat file to be shipped to the fulfillment center. This will be done
via a PL/SQL procedure which will be called at regularly scheduled
times.

Why would I want/need to use create directory instead of utl_file?  The
database will go live in 9.2.0.1

Any advice is welcome!

Rachel


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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).


*

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, 
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: utl_file_dir vs create directory

[Connor McDonald]

a) its dynamic (so bounce needed)
b) its more granular - you can grant read/readwrite
etc

hth
connor

 --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> Okay, I'll admit I know nothing about the create
> directory command and
> am off to read the fine manuals as soon as I hit
> send on this
> 
> my developer sent me an email saying "do you know of
> this new feature
> create_directory? it is recommended to use
> create_directory instead of
> utl_file_dir"
> 
> First, she's not in, I can't ask her WHO recommended
> it. But I will.
> Second, I think she meant create directory, without
> the underscore.
> 
> Basically what we are doing is reading an orders
> table and generating a
> flat file to be shipped to the fulfillment center.
> This will be done
> via a PL/SQL procedure which will be called at
> regularly scheduled
> times.
> 
> Why would I want/need to use create directory
> instead of utl_file?  The
> database will go live in 9.2.0.1
> 
> Any advice is welcome!
> 
> Rachel
> 
> 
> __
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> -- 
> 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
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: utl_file_dir vs create directory

[Adams, Matthew (GEA, MABG, 088130)]

Title: RE: utl_file_dir vs create directory





I believe that the 'create directory' command is only 
appropriate when dealing with BFILEs.  


It's not exactly a substitute for the UTL_FILE package
and UTL_FILE_DIR parameter.



Matt Adams - GE Appliances - [EMAIL PROTECTED]
My computer beat me at chess, but I won
when it came to kick boxing.


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 22, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: utl_file_dir vs create directory



Okay, I'll admit I know nothing about the create directory command and
am off to read the fine manuals as soon as I hit send on this


my developer sent me an email saying "do you know of this new feature
create_directory? it is recommended to use create_directory instead of
utl_file_dir"


First, she's not in, I can't ask her WHO recommended it. But I will.
Second, I think she meant create directory, without the underscore.


Basically what we are doing is reading an orders table and generating a
flat file to be shipped to the fulfillment center. This will be done
via a PL/SQL procedure which will be called at regularly scheduled
times.


Why would I want/need to use create directory instead of utl_file?  The
database will go live in 9.2.0.1


Any advice is welcome!


Rachel



__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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: Problem with Outer Join

[Mercadante, Thomas F]

Rick,

That's not how I read it.  

He wants all dates returned showing whether an employee was present or not.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 22, 2002 9:39 AM
To: Multiple recipients of list ORACLE-L



Tom,

I think by the post he wants to limit result set by employee_id for ex.
employee_id=123

Rick


 

"Mercadante,

Thomas F"  To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>   
<[EMAIL PROTECTED]   cc:

ate.ny.us> Subject: RE: Problem with
Outer Join  
Sent by:

[EMAIL PROTECTED]

 

 

08/22/2002 08:58

AM

Please respond

to ORACLE-L

 

 





Aleem,

Your query should be:

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-')
 = to_char(attend_date,'dd-mm-') (+)


The above says to return all records from the year_date table and , oh, by
the way, return any records in the employee table where dates match.

A better way to do this would be:

 WHERE trunc(year_date) = trunc(attend_date) (+)

The Trunc command simply strips all time from date columns.


Hope this helps


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 22, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L


Hi,

In our employee's attendance application the attendance data is stored in
table 'A' including employee ID and attendance date & time. Another table
'B' has one column with dates of current year (365 records). For the sake
of
simplicity, other fields are ignored.

Table: A
Employee_ID
Attend_date (date with time)

Table: B
year_date (one record each for a day of current year i.e., 365 records)

In a report (single employee at a time) showing all dates of the year and
in
front of it whether the employee was present or not we are running the
following query. Assume that table A has 15 records of employee ID 123, the
query should return 365 records with 15 records telling the time but it
returns 15 records only.

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+),
'dd-mm-') and employee_id = 123;

To my understanding this is perhaps because of the filter employee_ID=123.
What would be the query to get the required result?

TIA!

Aleem
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abdul Aleem
  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: Mercadante, Thomas F
  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: 
  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: Mercadante, Thomas F
  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]

RE: Strange Data issue.....

[Mercadante, Thomas F]

Title: Strange Data issue.



Denham,
 
Your 
"group by" does not match what you are selecting, thus the results are 
wrong.
 
Change your query as follows:
 
   select race||','||gender,count(*) 
    from 
pers     group by race||','||gender
Hope 
this helps.
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Strange Data issue.
  Hello Gurus, 
  I have a problem which I hope someone can help me 
  with. I am trying to clean up some data on 
  a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. 
  The select used is :    select race||','||gender||','||count(*) 
      from 
  pers     group by race, gender; The result is 
  as follows: 
  A,F,62 A,M,613 A,M,35 A,,15 C,F,34 
  C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 
  The problem is that the result returns double Ms, M 
  indicating Male. As highligthed above I 
  have tried converting to ascii to see if they are different in anyway but both 
  Ms return ascii 77. Does anyone have any 
  thoughts on this? 
  TIA Denham 
  Eva Oracle DBA 
  In UNIX Land On a quiet Night, you can hear the Windows machines reboot. 
  
  

  DISCLAIMER 
  
  This message is for the named person's use only. It 
  may contain confidential, proprietary or legally privileged information. No 
  confidentiality or privilege is waived or lost by any mistransmission. If you 
  receive this message in error, please immediately delete it and all copies of 
  it from your system, destroy any hard copies of it and notify the sender. You 
  must not, directly or indirectly, use, disclose, distribute, print, or copy 
  any part of this message if you are not the intended recipient. TFMC, its 
  holding company, and any of its subsidiaries each reserve the right to monitor 
  and manage all e-mail communications through its networks. 
  Any views expressed in this message are those of 
  the individual sender, except where the message states otherwise and the 
  sender is authorized to state them to be views of any such entity. 
  
  
  
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  

RE: Shutdown Immediate Hanging

[Muqthar Ahmed]

Title: Message



Steve,
 
Recently I got same problem and I have resolved it.  This will 
happen if you setup INITIAL and NEXT extent size very small for TEMPORARY 
tablespace.  Look at the following information:
 http://metalink.oracle.com and look for 
the following DOC ID:
 DOC ID: 61997.1
 DOC ID: 1076161.6
 
I 
created new LOCALLY MANAGED TEMPORARY tablespace which handles better than 
DICTIONARY tablespace:
 
 CREATE TEMPORARY TABLESPACE 
temp
 TEMPFILE 
'/d05/oradata/prod/temp01.dbf' SIZE 2048M 
 EXTENT MANAGEMENT LOCAL 
UNIFORM SIZE 1M;
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE 
temp;
 
Muthar 
Ahmed
DBA

  -Original Message-From: Steve Perry 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:13 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Shutdown Immediate Hanging
  I hope somebody can help me with 
  this  shutdown problem. There's 2 questions unless: how to 
  troubleshoot a stalled shutdown and the best way to deal with 
  it.
   
  #1 - Database hangs during 
  shutdown
  We have several instances running 
  8.1.7.3 on Win2k and continue to have intermittent shutdown 
  problems.
  The shutdown never 
  completes.
  Here's are the steps used to stop 
  the database
  1.) Stop the application 
  servers
  1.) run a kill session script to 
  kill all remaining sessions except the one running the script 
  2.) issue shutdown immediate and 
  hope it shuts down.
   
  At this point, the database closes 
  but it never dismounts.
  We never receive the "Completed: 
  ALTER DATABASE DISMOUNT"
   
  Is there anything I can do to 
  diagnose the problem at this point? 
   
  After 15 minutes, 
  Arcserve backs up the files to tape (delay field in arcserve 
  job).
  After the backup is complete, the 
  database startup script is run.
  The alert log says the startup is 
  normal, but no connections are allowed into the database.
   
  I either have to do a shutdown 
  abort or stop the service and then I can start the database.
  I wrote a script to detect the 
  shutdown hangs that will page me, do a shutdown abort, startup and 
  then shutdown immediate (before the backup job starts)
  There's not much I can do when it 
  stalls and I don't mind running the script if it won't corrupt my 
  database.
  
  Is there a better way to handle 
  this? 
   
  I checked metalink and opened a 
  tar. 
  Oracle said it was a security dll 
  issue with MS and that I should change the scripts to shutdown the service 
  instead of using svrmgrl or sqlplus. That was fine until I realized that 
  stopping the service will do a shutdown immediate. If the database 
  doesn't complete before the ora__shutdown_timeout value, it does a 
  shutdown abort (or equivalent).
   
  Thanks,
  Steve

nt password change and OEM

[Jeffrey Beckstrom]

On NTs that are not a Primary or Backup Domain controller, OEM install 
instructions were to create a local user id. This works with no problems. 
However, we have just implemented a policy wherein all NT account passwords 
now change every 90 days.
Therefore, looking for suggestions on how to change the NT password and 
OEM passwords on a regular basis.
 
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
781-4204

RE: Strange Data issue.....

[Bernard, Gilbert]

group by race||','||gender||','||count(*) 
 
might be better.



-Message d'origine-
De: Denham Eva [mailto:[EMAIL PROTECTED]]
Date: jeudi 22 août 2002 14:59
À: Multiple recipients of list ORACLE-L
Objet: Strange Data issue.



Hello Gurus, 

I have a problem which I hope someone can help me with. 
I am trying to clean up some data on a table. This table happens to be a
personnel table. 
In this table there are two columns RACE and GENDER. 
The select used is : 
   select race||','||gender||','||count(*) 
from pers 
group by race, gender; 
The result is as follows: 

A,F,62 
A,M,613 
A,M,35 
A,,15 
C,F,34 
C,M,198 
C,M,4 
C,,2 
I,F,13 
I,M,69 
I,M,1 
W,F,205 
W,M,972 
W,M,28 
W,,15 

The problem is that the result returns double Ms, M indicating Male. As
highligthed above 
I have tried converting to ascii to see if they are different in anyway but
both Ms return ascii 77. 
Does anyone have any thoughts on this? 

TIA 
Denham Eva 
Oracle DBA 
In UNIX Land 
On a quiet Night, you can hear the Windows machines reboot. 


  _  


DISCLAIMER 

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks. 

Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 

  _  

  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bernard, Gilbert
  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: Problem with Outer Join

[Rick_Cale]

Tom,

I think by the post he wants to limit result set by employee_id for ex.
employee_id=123

Rick


   
  
"Mercadante,   
  
Thomas F"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
<[EMAIL PROTECTED]   cc: 
  
ate.ny.us> Subject: RE: Problem with Outer Join
  
Sent by:   
  
[EMAIL PROTECTED]   
  
   
  
   
  
08/22/2002 08:58   
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Aleem,

Your query should be:

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-')
 = to_char(attend_date,'dd-mm-') (+)


The above says to return all records from the year_date table and , oh, by
the way, return any records in the employee table where dates match.

A better way to do this would be:

 WHERE trunc(year_date) = trunc(attend_date) (+)

The Trunc command simply strips all time from date columns.


Hope this helps


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 22, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L


Hi,

In our employee's attendance application the attendance data is stored in
table 'A' including employee ID and attendance date & time. Another table
'B' has one column with dates of current year (365 records). For the sake
of
simplicity, other fields are ignored.

Table: A
Employee_ID
Attend_date (date with time)

Table: B
year_date (one record each for a day of current year i.e., 365 records)

In a report (single employee at a time) showing all dates of the year and
in
front of it whether the employee was present or not we are running the
following query. Assume that table A has 15 records of employee ID 123, the
query should return 365 records with 15 records telling the time but it
returns 15 records only.

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+),
'dd-mm-') and employee_id = 123;

To my understanding this is perhaps because of the filter employee_ID=123.
What would be the query to get the required result?

TIA!

Aleem
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abdul Aleem
  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: Mercadante, Thomas F
  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: 

One potential problem in 9.2 ... was RE: Oracle 9.2 Stability Fee

[Jamadagni, Rajendra]

So far we haven't found our problem in a testing environment it is 9201 on a
RAC cluster. We are having difficulty getting 6i reports server to run, but
no major problems.

Okay here is something I will be investigating ... something for you all to
think about. The query is something like this ...

select col_1, col_2, nvl(col_3,'X') col_3
  from table_a
union
select col_1, col_2, 'X' col_3
  from table_b
/

This is of course not the complete query but just to give you all an idea.
What happens is col_3 is actually defined as varchar2(2) in the database.
Sometimes the value for this column be null, single character or two
characters. 

This is working fine in our 8161 database, oracle forms passes parameter to
a database packaged procedure which has this code. When we moved this to
9.2, the query started giving ORA-6502 errors. When removed col_3 from the
query, things were just fine.

Here is the catch, after playing with it for about 15 minutes, I changed the
nvl clause to "NVL(col_3, 'XX') col_3" thing worked as before, no errors.

What gives?? I will try to test this again, but has any of you encountered
this before? BTW yesterday I searched on Metalink for all bugs reported in
9.2.0.1 and fixed in 10.0.0.0, there were 7 bugs reported to be fixed in
10i. Some of them may be back ported, but isn't is good to know?

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!



*2

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.

*2

Strange Data issue.....

[Denham Eva]

Title: Strange Data issue.





Hello Gurus,


I have a problem which I hope someone can help me with.
I am trying to clean up some data on a table. This table happens to be a personnel table.
In this table there are two columns RACE and GENDER.
The select used is :
   select race||','||gender||','||count(*)
    from pers
    group by race, gender;
The result is as follows:


A,F,62
A,M,613
A,M,35
A,,15
C,F,34
C,M,198
C,M,4
C,,2
I,F,13
I,M,69
I,M,1
W,F,205
W,M,972
W,M,28
W,,15


The problem is that the result returns double Ms, M indicating Male. As highligthed above
I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77.
Does anyone have any thoughts on this?


TIA
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.






 DISCLAIMER 

  
 

  This message is for the named person's use only. It may contain 
confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by 
any mistransmission. If you receive this message in error, please immediately delete 
it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, 
disclose, distribute, print, or copy any part of this message if 
you are not the intended recipient. TFMC, its holding company, and any of 
its subsidiaries each reserve the right to monitor and manage all e-mail communications through its 
networks. 
Any views expressed in this message are those of the 
individual sender, except where the message states otherwise and the sender is 
authorized to state them to be views of any such entity.  







This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com 

utl_file_dir vs create directory

[Rachel Carmichael]

Okay, I'll admit I know nothing about the create directory command and
am off to read the fine manuals as soon as I hit send on this

my developer sent me an email saying "do you know of this new feature
create_directory? it is recommended to use create_directory instead of
utl_file_dir"

First, she's not in, I can't ask her WHO recommended it. But I will.
Second, I think she meant create directory, without the underscore.

Basically what we are doing is reading an orders table and generating a
flat file to be shipped to the fulfillment center. This will be done
via a PL/SQL procedure which will be called at regularly scheduled
times.

Why would I want/need to use create directory instead of utl_file?  The
database will go live in 9.2.0.1

Any advice is welcome!

Rachel


__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
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: Problem with Outer Join

[Mercadante, Thomas F]

Aleem,

Your query should be:

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-') 
 = to_char(attend_date,'dd-mm-') (+)


The above says to return all records from the year_date table and , oh, by
the way, return any records in the employee table where dates match.

A better way to do this would be:

 WHERE trunc(year_date) = trunc(attend_date) (+)

The Trunc command simply strips all time from date columns.


Hope this helps


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Thursday, August 22, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L


Hi,

In our employee's attendance application the attendance data is stored in
table 'A' including employee ID and attendance date & time. Another table
'B' has one column with dates of current year (365 records). For the sake of
simplicity, other fields are ignored.

Table: A
Employee_ID
Attend_date (date with time)

Table: B
year_date (one record each for a day of current year i.e., 365 records)

In a report (single employee at a time) showing all dates of the year and in
front of it whether the employee was present or not we are running the
following query. Assume that table A has 15 records of employee ID 123, the
query should return 365 records with 15 records telling the time but it
returns 15 records only. 

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+),
'dd-mm-') and employee_id = 123;

To my understanding this is perhaps because of the filter employee_ID=123.
What would be the query to get the required result?

TIA!

Aleem
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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: Mercadante, Thomas F
  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).

Problem with Outer Join

[Abdul Aleem]

Hi,

In our employee's attendance application the attendance data is stored in
table 'A' including employee ID and attendance date & time. Another table
'B' has one column with dates of current year (365 records). For the sake of
simplicity, other fields are ignored.

Table: A
Employee_ID
Attend_date (date with time)

Table: B
year_date (one record each for a day of current year i.e., 365 records)

In a report (single employee at a time) showing all dates of the year and in
front of it whether the employee was present or not we are running the
following query. Assume that table A has 15 records of employee ID 123, the
query should return 365 records with 15 records telling the time but it
returns 15 records only. 

SELECT year_date, to_char(attend_date, 'hh:mi:ss' )
 FROM A, B
 WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+),
'dd-mm-') and employee_id = 123;

To my understanding this is perhaps because of the filter employee_ID=123.
What would be the query to get the required result?

TIA!

Aleem
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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: Statement to check the last actions done.Urgent!

[Simplicio Noronha, Savio]

Hi tia,

You can see it through the V_$SQL table.

For this you need to get the Last_SQL_Address and Last_SQL_HASH value from
the 
v_SEssion table.

Once you have these just query v_$SQL table with the 2 params.

Regards
Savio

-Original Message-
Sent: Donnerstag, 22. August 2002 13:33
To: Multiple recipients of list ORACLE-L



Hello, is there any SQL statement to see what SQL have been performed
over a database???
Inserts, deletes, etc.
TIA

--


Beatriz Martínez Jiménez   Ingeniera Informática
Tfno: 983 546646 [EMAIL PROTECTED]
Fundación CIDAUT
Centro de Investigación y desarrollo en Automoción
Parque Tecnológico de Boecillo, p.209. 47151
Boecillo, Valladolid.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
  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: Simplicio Noronha, Savio
  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 FW: Intersting

[Abdul Aleem]

-Original Message-
Sent:   Thursday, August 22, 2002 2:59 PM
Subject:Intersting

Interesting conversation between Camels
A mother and a baby camels were lazing around, and suddenly the baby camel
ask...
Baby : Mother, mother, can I ask you some question?
Mother: Sure! why son, is there something bothering you?
Baby : Why do camel have humps?
Mother: Well son, we are desert animals, we need the humps to store water
and we are known to survive without water.
Baby : Okay, then why are our legs long and our feet rounded?  Mother: Son,
obviously they are meant for walking in the desert. You know with these legs
I can move around the desert better than anyone...! Said the mother proudly.
Baby : Okay, then why are our eye lashes long? Sometimes it is bothering my
sight.
Mother: My son, those long thick eye lashes are your protective cover. They
help to protect your eyes from the desert sand and wind. Said mother camel
with eyes brimming with pride.
Baby : I see. So the hump is to store water when we are in the desert, the
legs are for walking through the desert and these eye lashes protects my
eyes from the desert. Then what the hell are we doing here in the zoo???

MORAL OF THE STORY:
"SKILLS, KNOWLEDGE, ABILITIES AND EXPERIENCES ARE ONLY USEFUL IF YOU ARE AT
THE RIGHT PLACE"
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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: PL/Sql question

[Mercadante, Thomas F]

Dennis,

I'd guess that the developer did not try it correctly.  Ask to see the code.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 5:29 PM
To: Multiple recipients of list ORACLE-L



Tom - The developer reports that he tried this but it didn't work. The third
position is still a space value. Thanks to everyone for the good replies.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 3:13 PM
To: '[EMAIL PROTECTED]'
Cc: DENNIS WILLIAMS


Dennis,

Try changing your insert statement to:

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
 MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
 PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) 
   VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,'
'),
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.

PL/SQL snippets


<...snip...>

   marketingcodeVARCHAR2(3);

<...snip...>

FILELOCATION := '/usr/users/madmload/text_files';
OPEN_MODE:= 'r';
FILENAME := 'prodload.txt';

FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE );

<...snip...>

   UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
   marketingcode := substr(outputstring, 21, 3);
 

<...snip...>

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;





Sql*Loader script

LOAD DATA
INFILE '/usr/users/madmload/joblid.txt'
BADFILE '/usr/users/madmload/jobload.bad'
APPEND
INTO TABLE JOBFACT
(
JOBNBR  POSITION(1:10)  CHAR, 
LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
MDRPRIMARYIDPOSITION(21:28) CHAR,
MARKETINGCODE   POSITION(29:31) CHAR,
SUBPROGRAMCODE  POSITION(32:32) CHAR,
TERRITORYCODE   POSITION(33:34) CHAR,
SUBTERRITORYCODEPOSITION(33:36) CHAR,
SELLINGMETHODCODE   POSITION(37:37) CHAR,
BIDIND  POSITION(38:38) CHAR,
PDKIND  POSITION(39:39) CHAR,
PDKPARTNBR  POSITION(40:44) CHAR,
RETAKEIND   POSITION(45:45) CHAR,
PLANTCODE   POSITION(46:46) CHAR,
PLANTRECEIPTDATEPOSITION(47:56) DATE "/MM/DD" NULLIF
PLANTRECEIPTDA,
PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL,
PLANTRECEIPTMONTH   POSITION(52:53) INTEGER EXTERNAL,
PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD" NULLIF
PHOTOGRAPHYDATE=BLANKS,
SHIPDATEPOSITION(67:76) DATE "/MM/DD" NULLIF SHIPDATE=BLANKS,
SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER EXTERNAL,
PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL,
XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL,
CASHRETAINEDAMT POSITION(106:114)   DECIMAL EXTERNAL,
ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL EXTERNAL,
ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL EXTERNAL,
CHARGEBACKAMT   POSITION(133:141)   DECIMAL EXTERNAL,
SALESTAXAMT POSITION(142:150)   DECIMAL EXTERNAL,
TERRITORYCMSNAMTPOSITION(151:159)   DECIMAL EXTERNAL,
TERRITORYEARNINGSAMTPOSITION(160:168)   DECIMAL EXTERNAL,
EXPECTEDCASHAMT POSITION(169:177)   DECIMAL EXTERNAL,
SOURCEFISCALYEARCONSTANT '2003',
PROOFPOSE   POSITION(178:178)   DECIMAL EXTERNAL,
PROOFCOUNT  POSITION(179:182)DECIMAL EXTERNAL,
SEASONDESC  POSITION(183:183)DECIMAL EXTERNAL,
EXTRACTDATE POSITION(184:193) DATE "/MM/DD" NULLIF
EXTRACTDATE=BLANKS,
FU

Re: Statement to check the last actions done.Urgent!

[dizzy74]

V$SQL


Beatriz Martínez Jiménez wrote:

>Hello, is there any SQL statement to see what SQL have been performed
>over a database???
>Inserts, deletes, etc.
>TIA
>  
>


-- 
Date: Wednesday, Aug 21,2002

!!
!!
!  For people who like peace and quiet:  !
!a phoneless cord.   !
!!



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dizzy74
  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 to startup in restricted mode ?

[Jan Pruner]

Don't startup listener process.

JP

On Thursday 22 August 2002 11:03, you wrote:
> Guys,
>
> i am on 8.1.6 / win2k .
> how do i startup my DB in restricted mode for maintenance purpose
> ?
> i dont want my users to connect during this time.
>
> Is it STARTUP RESTRICT ?  i did it . but  still users are able to
> connect . can DBAs connect , when DB is started in this mode  ?
>
> plz correct me if i am wrong .
>
> TIA.

-- 
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-
Only Robinson Crusoe had all his work done by Friday
--
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).

RE: how to startup in restricted mode ?

[Gesler, Rich]

The RESTRICTED SESSION privilege allows users to logon when the database
is opened in restricted mode.  You should revoke this privilege.  The
DBA role contains this privilege.

-Rich

-Original Message-
Sent: Thursday, August 22, 2002 5:03 AM
To: Multiple recipients of list ORACLE-L


Guys,

i am on 8.1.6 / win2k .
how do i startup my DB in restricted mode for maintenance purpose 
?
i dont want my users to connect during this time.

Is it STARTUP RESTRICT ?  i did it . but  still users are able to 
connect . can DBAs connect , when DB is started in this mode  ?

plz correct me if i am wrong .

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

Statement to check the last actions done.Urgent!

[Beatriz Martínez Jiménez]

Hello, is there any SQL statement to see what SQL have been performed
over a database???
Inserts, deletes, etc.
TIA

--


Beatriz Martínez Jiménez   Ingeniera Informática
Tfno: 983 546646 [EMAIL PROTECTED]
Fundación CIDAUT
Centro de Investigación y desarrollo en Automoción
Parque Tecnológico de Boecillo, p.209. 47151
Boecillo, Valladolid.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
  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: java.sql.SQLException: Io exception: Connection reset by peer: so

[Naveen Nahata]

It comes because of the network problems. 

-Original Message-
Sent: Thursday, August 22, 2002 12:24 AM
To: Multiple recipients of list ORACLE-L
so


Hello List,

Does anybody there know the following error message and how to resolve it?

java.sql.SQLException: Io exception: Connection reset by peer: socket write
error


Environment

classes12.zip
Oracle 8.1.6.3
Solaris 2.8

Thanks,

Mike 


**
This e-mail contains privileged attorney-client communications and/or
confidential information, and is only for the use by the intended recipient.
Receipt by an unintended recipient does not constitute a waiver of any
applicable privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of
this information by anyone other than the intended recipient or his or her
employees or agents is strictly prohibited.  If you have received this
communication in error, please immediately notify us and delete the original
material from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or
SoCalGas, the utilities owned by SET's parent company.  SET is not regulated
by the California Public Utilities Commission and you do not have to buy
SET's products and services to continue to receive quality regulated service
from the utilities.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Wu
  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: Naveen Nahata
  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 to startup in restricted mode ?

[Naveen Nahata]

>Is it STARTUP RESTRICT ?  

Ya

>i did it . but  still users are able to connect . 

Check the users who can connect. They will have RESTRICTED SESSION system
privilege

>can DBAs connect , when DB is started in this mode  ?

Ya. DBA role has all the system privileges granted with admin option. So
RESTRICTED SESION comes automatically


Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  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: move table to differnt datafile

[M B Shibu]

Thanks a lot  Irfan …… 

 

how to startup in restricted mode ?

[oraora oraora]

Guys,

i am on 8.1.6 / win2k .
how do i startup my DB in restricted mode for maintenance purpose 
?
i dont want my users to connect during this time.

Is it STARTUP RESTRICT ?  i did it . but  still users are able to 
connect . can DBAs connect , when DB is started in this mode  ?

plz correct me if i am wrong .

TIA.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: oraora  oraora
  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: Shutdown Immediate Hanging

[Connor McDonald]

My recommendation #1 would be not to shutdown at all. 
Oracle spent all that time and money devising
wonderfully complex memory management (which they pass
on to us as license dollars) so shutting down is like
throwing money in the toilet..

My recommendation #2 is (for those rare times when you
need to shutdown) to not use shutdown immediate -
because they got the name wrong :-)  If you need to
shutdown, I'd just do:

alter system checkpoint;
shutdown abort

hth
connor

 --- Steve Perry <[EMAIL PROTECTED]> wrote: >
MessageI hope somebody can help me with this 
> shutdown problem. There's 2 questions unless: how to
> troubleshoot a stalled shutdown and the best way to
> deal with it.
> 
> #1 - Database hangs during shutdown
> We have several instances running 8.1.7.3 on Win2k
> and continue to have intermittent shutdown problems.
> The shutdown never completes.
> Here's are the steps used to stop the database
> 1.) Stop the application servers
> 1.) run a kill session script to kill all remaining
> sessions except the one running the script 
> 2.) issue shutdown immediate and hope it shuts down.
> 
> At this point, the database closes but it never
> dismounts.
> We never receive the "Completed: ALTER DATABASE
> DISMOUNT"
> 
> Is there anything I can do to diagnose the problem
> at this point? 
> 
> After 15 minutes, Arcserve backs up the files to
> tape (delay field in arcserve job).
> After the backup is complete, the database startup
> script is run.
> The alert log says the startup is normal, but no
> connections are allowed into the database.
> 
> I either have to do a shutdown abort or stop the
> service and then I can start the database.
> I wrote a script to detect the shutdown hangs that
> will page me, do a shutdown abort, startup and then
> shutdown immediate (before the backup job starts)
> There's not much I can do when it stalls and I don't
> mind running the script if it won't corrupt my
> database.
> Is there a better way to handle this? 
> 
> I checked metalink and opened a tar. 
> Oracle said it was a security dll issue with MS and
> that I should change the scripts to shutdown the
> service instead of using svrmgrl or sqlplus. That
> was fine until I realized that stopping the service
> will do a shutdown immediate. If the database
> doesn't complete before the
> ora__shutdown_timeout value, it does a shutdown
> abort (or equivalent).
> 
> Thanks,
> Steve
>  

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
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).