date:20020717


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a batch file 
that is called by the NT 'AT' scheduler.  I recently changed some lines of commands in 
the batch file and since then when the batch file is executed by 'AT' only the lines 
that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I deleted the job 
from 'AT' and then entered it back in but still getting this odd behavior of only 
executing the commands that I did not edit.  Our SA's know nothing about 'AT' so they 
are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I know you 
find it hard to believe that something can be weird in Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the 8i Backup 
and Recovery Handbook for my reading pleasure.  I see the app that is being used going 
to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).

AW: How to change VB code to use bind variables?

2002-07-17 Thread Stefan Jahnke


Hi 

I did a search on MSDN for sql bind variable. Here is the result page:

http://search.microsoft.com/default.asp?qu=sql+bind+variableboolean=ALLnq=
NEWso=RECCNTp=1ig=01ig=02ig=03ig=04ig=05ig=06i=00i=01i=02i=03i=
04i=05i=06i=07i=08i=09i=10i=11i=12i=13i=14i=15i=16i=17i=18i=1
9i=20i=21i=22i=23i=24i=25i=26i=27i=28i=29i=30i=31i=32i=33i=34
i=35i=36i=37i=38i=39i=40i=41i=42i=43i=44i=45i=46i=47i=48i=49
i=50i=51siteid=us/dev

Looks like some articles might help.

Try also these ones

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdobjparameter.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmscadoobjmod.asp


Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer
Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar?
Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns
an unter 0 18 03 / 73 64 62 73!

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Miller, Jay [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 17. Juli 2002 00:08
An: Multiple recipients of list ORACLE-L
Betreff: RE: How to change VB code to use bind variables?


Hi Jared,

Thanks for the suggestion.  But I went to www.microsoft.com, clicked on
support and searched on the words
bind variables oracle visual basic

After a dozen Internet Explorer Script errors I got a bunch of links with
names like 26jbkjakjbmon

That one led to a blank page.  Others led to articles that didn't even
mention bind variables.  And I thought Metalink was bad.

Does anyone have a link that goes directly to an article?

Thanks,
Jay Miller

-Original Message-
Sent: Tuesday, July 16, 2002 4:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Check on the MS support site.  There are several
articles detailing how to do this.

Jared





Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/16/2002 02:08 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:How to change VB code to use bind variables?


Hi,

In checking my v$SQLArea I recently discovered that there was an often
executed SQL statement that was not using bind variables.  I tracked it 
down
to a VB front end and asked the development group to modify the code. They
asked me how to do it.

Not being a VB programmer I said I had no idea but would try to find out.
Here's an abbreviated version of the code.  It's the sAcctId that seems to
be causing the multiple executions.  Anyone know how this can be rewritten
to use bind variables?  Can it be done from VB or do we need to transfer 
the
code to PL/SQL on the back end?

Private Function GetSQL(ByVal sKey As String, _
ByVal sAcctId As String, _
Optional ByVal sAcctNum As String, _
Optional ByVal sWhereAnd As String)
Dim sConnect As String
Dim sSql As String
Dim oWsiLibData As WSILib.CDisplayData
Dim rsCustomer As ADODB.Recordset
Dim lCustId As Long
Dim sCustId As String

Select Case sKey
...
...
Case accountinfo:
 sSql = SELECT a.id, a.account_no, a.type, a.title1, 
a.title2,
a.title3,   _
a.inventory_date date_opened, a.last_modified_date
last_change,   _
rc.description rebatecmsn,   _
sSql = sSql   account_info.fetch_email(  sAcctId  ) 
email

sSql = sSql  FROM account a, status s, usa_wh_tax u, fund f, 

 _
stock_commission_codes sc, cmsn_rebate_codes rc,
account_kind ak 
sSql = sSql  , dual  
sSql = sSql  WHERE a.status_id=s.id and
a.usa_tax_code=u.code(+)   _
and a.fund_id=f.id and   _
a.s_stk_cmsn_code=sc.code(+) and
a.cmsn_reb_code=rc.code(+) and a.kind_id=ak.id   _
and a.id =  sAcctId

sConnect = sConnectWSI

GetSQL = Array(sConnect, sSql)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California

Re: Size of Oracle server processes

2002-07-17 Thread Jos Someone


Tim,
I think your observation is correct, every Apps logon
does create two sessions. How is that affecting the
size of the server process? Do you mean the size is
the sum of the two sessions? In glance, most of the
memory size came out of the data segment of the
process.
Jos
 
--- Tim Gorman [EMAIL PROTECTED] wrote:  This is a
pure guess, and I don't have my own
 OraApps system to check it upon first, so this might
 be embarrassing, but here goes...
 
 Often I see 2 sessions started for every dedicated
 server process when Oracle Forms is in use with
 Oracle Apps, from R10.7 on up.  I think the
 Jinitiator applet is creating the second session
 associated with the process.  To verify this, you
 could try running the following query and see if it
 returns two rows instead of one:
   selectsid, serial#, username, osuser, process
   from   v$session
   where paddr in (select addr from v$process
  where spid =
 oracleSID-processID)
 Plug in the PID for the server process into
 oracleSID-processID where you are seeing the
 large RSS.  If you do get two rows back from the
 query, then this might be an explanation for the
 increased size?
 
 Hope this helps...
 
 -Tim
   - Original Message - 
   From: Jos Someone 
   To: Multiple recipients of list ORACLE-L 
   Sent: Monday, July 15, 2002 1:18 PM
   Subject: Size of Oracle server processes
 
 
   I have a question to ask regarding Oracle server
 process (oracleSID) size. We have just installed
 Oracle Apps 11i, while monitoring the system using
 glance, I notice something strange, the oracle
 server processes - process which has a name
 oracleSID has a very big RSS size in glance, these
 processes were associated with the f60webmx
 processes. I was curious about the size of it,
 normally these processes are about 2-3M big. I did a
 quick test by logging on to the database using
 sqlplus and observe the size of the oracle server
 process, it showed  a size of 2M. So why the
 oracleSID processes size is so big where they are
 assoicated with f60webmx, is it something special
 about them? Or the RSS size shown in glance is
 doubling up on something?
 
   Jos
 
 
 
 
 
 
 

--
   SOLD.com.au - Find yourself a bargain!
  

http://www.sold.com.au - SOLD.com.au
- Find yourself a bargain!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Jos=20Someone?=
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Muqthar Ahmed


Dave,

Did you stop and start SCHEDULER.if not do it, it will fix the problem.

Muqthar Ahmed
DBA

-Original Message-
Sent: Wednesday, July 17, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a batch file 
that is called by the NT 'AT' scheduler.  I recently changed some lines of commands in 
the batch file and since then when the batch file is executed by 'AT' only the lines 
that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I deleted the job 
from 'AT' and then entered it back in but still getting this odd behavior of only 
executing the commands that I did not edit.  Our SA's know nothing about 'AT' so they 
are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I know you 
find it hard to believe that something can be weird in Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the 8i Backup 
and Recovery Handbook for my reading pleasure.  I see the app that is being used going 
to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

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: Muqthar Ahmed
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Alan Davey


Dave,

I've found AT to be flakey at best.  I haven't had your specific problem, but I have 
had problems where AT would only occasionally run when it was supposed to.

I don't remember if it was a specific NT patch or a version of IE explorer, but one of 
these will install a Scheduler utility, which I've found to be pretty reliable.  If 
you open My Computer (or explorer) you should see a folder called Scheduled Tasks.  
Double-click and then use the wizard to set up a call to your batch file.

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
I have Oracle 8.1.7 running on NT.  I do cold backups nightly and 
have a batch file that is called by the NT 'AT' scheduler.  I recently 
changed some lines of commands in the batch file and since then when 
the batch file is executed by 'AT' only the lines that I did not 
edit are executed.
If I execute the batch file from the command prompt it works fine. 
 I deleted the job from 'AT' and then entered it back in but still 
getting this odd behavior of only executing the commands that I did 
not edit.  Our SA's know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze? 
 I know you find it hard to believe that something can be weird in 
Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups. 
 I have the 8i Backup and Recovery Handbook for my reading pleasure. 
 I see the app that is being used going to a 24X7 schedule.  Now 
it is only used during the day.

Thanks,

Dave
-- 
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

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: Alan Davey
  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).

ORA-00904 revisited, found something

2002-07-17 Thread Vladimir Barac


After doing some tracing

alter system set events '904 trace name errorstack forever';

on database which is being exported (8.1.7.0) with exp8.1.7.2, trace file
said to me that there is problem with SYS.EXU8JBQ...

Then, I have compared catexp.sql from both versions and found... gues
what?

Views EXU8BJQ are pretty different on 8.1.7.0 and 8.1.7.2 !!! Isn't that
weird? After database versions difference is at fourth digit!!!

So, is it safe to run catexp from 8.1.7.2 on 8.1.7.0?

Here is part of catexp 8.1.7.2

REM
REM Job Queues
REM
CREATE OR REPLACE VIEW exu8jbq
(job, ownerid, owner, lowner, cowner, next_date, flag,
 interval#, what, nlsenv, env, instance) AS
SELECT j$.job, u$.user#, j$.powner, j$.lowner, j$.cowner,
   to_char(j$.next_date, '-MM-DD:HH24:MI:SS'),
   decode(j$.flag,1,'TRUE',0,'FALSE'),
   replace(j$.interval#,,''),
   replace(j$.what,,''),
   replace(j$.nlsenv,,''),
   j$.env, j$.field1
FROM sys.job$ j$, sys.user$ u$
WHERE j$.powner = u$.name

Here is catexp from 8.1.7.0

REM
REM Job Queues
REM
CREATE OR REPLACE view exu8jbq
 (job, ownerid, owner) as
  SELECT j$.job, u$.user#, j$.powner
  FROM sys.job$ j$, sys.user$ u$
  WHERE j$.powner = u$.name

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Barac
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Adrian Roe


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

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).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Boivin, Patrice J


Which editor did you use to edit your batch file?

WordPad and Notepad don't behave the same way.

Open the file in wordpad and in notepad, to see if it looks the same in
both.

Beware of tabs, unicode, and the two different EOL characters.  Wordpad
sometimes uses a different end-of-line character than notepad.  Notepad
sometimes saves things in unicode.

Also make sure you change the explorer settings to show file name
extensions, show all files, etc.  sometimes one of the editors (not sure if
it's wordpad or notepad) saves files with .txt at the end, even though you
specify an extension in the Save As filename box.  e.g. you can end up with
files named job.txt.txt.

Save things in plain text, avoid word format, but you probably know that
already.

HTH

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Wednesday, July 17, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Subject:Weird Windoze 'AT'  Behavior

I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Win2000/8.1.7.3/Temp Space Question

2002-07-17 Thread Vergara, Michael (TEM)


No, I created it as you suggested.  Here is the SQL from my script...

CREATE TEMPORARY TABLESPACE TEMP
   TEMPFILE 'E:\OraNT\oradata\SID\temp01.dbf' SIZE 250M REUSE
   AUTOEXTEND ON NEXT 50M MAXSIZE 2000M
   EXTENT MANAGEMENT local
   UNIFORM SIZE 2M;

Does that help?

Thanks,
Mike


-Original Message-
Sent: Tuesday, July 16, 2002 8:08 PM
To: Multiple recipients of list ORACLE-L


Vergara, Michael (TEM)£¬
Hi , i think you created the tablespace like:
Create tablespace temp datafile 'xxx' extent management local , right?
Drop it and recreate it like:
Create temporary tablespace temp tempfile 'xxx' ...


Good luck!

chaos
[EMAIL PROTECTED]

zhu chao
DBA of Eachnet.com
86-021-32174588-667

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  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: Weird Windoze 'AT' Behavior


Yep, it has the full path and name.  It still only executes some of the lines of code. 
 I would expect that it execute the whole file or non of the file.  I bounced the 
server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

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).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

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

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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Hayes, Scott


One problem that I have had with the 'AT' command is the you cannot use UNC
namimg when doing a copy, you have to use a mapped drive. This is a
documented 'feature' of the 'AT' command.

Example:
copy stuff to \\server\backup_dir  -- does not work
net use f: \\server\backup_dir
copy stuff to f:  -- Works

Good luck,

Scott



I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  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: Hayes, Scott
  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: Win2000/8.1.7.3/Temp Space Question

2002-07-17 Thread Fink, Dan


Michael,
I have seen the same behavior. Even stopping and starting the
database did not seem to clear up the temp segments as described in the
documentation. I did some research on it, but could not find anything on
metalink nor could I find any patterns with testing. Adding more space to
the tablespace only delayed the onset of the problem (we had a temp
tablespace of  20G with 3 users on the system). The only solution was to
shutdown the database, start it up, drop the temp tablespace and recreate
it. I think it is a bug, but we never took the time to put in a TAR.

Dan

-Original Message-
Sent: Wednesday, July 17, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


No, I created it as you suggested.  Here is the SQL from my script...

CREATE TEMPORARY TABLESPACE TEMP
   TEMPFILE 'E:\OraNT\oradata\SID\temp01.dbf' SIZE 250M REUSE
   AUTOEXTEND ON NEXT 50M MAXSIZE 2000M
   EXTENT MANAGEMENT local
   UNIFORM SIZE 2M;

Does that help?

Thanks,
Mike


-Original Message-
Sent: Tuesday, July 16, 2002 8:08 PM
To: Multiple recipients of list ORACLE-L


Vergara, Michael (TEM)£¬
Hi , i think you created the tablespace like:
Create tablespace temp datafile 'xxx' extent management local ,
right?
Drop it and recreate it like:
Create temporary tablespace temp tempfile 'xxx' ...


Good luck!

chaos
[EMAIL PROTECTED]

zhu chao
DBA of Eachnet.com
86-021-32174588-667

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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: Fink, Dan
  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).

A DBA looks at OAS


Folks,
 
I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that now
makes 
my head swim to look at. (I think to myself, what the devil was I doing??)
 
Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards 
to:
 
1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own getting started experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.
 
Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!
 
RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Bishop Lewis


The Scheduler is installed with IE5.5 - definitively worth the install.

As far as executing some lines but not others - it sounds like a environment
variable problem to me - put a set command (to list variables and a pause
command in your script (or output a log file) and check that your
environmental settings are okay.

Lewis Bishop
---
Oracle Database Consultant - Barclays Enable/ISS/OpenPlan 
Email:  [EMAIL PROTECTED]



-Original Message-
Sent: 17 July 2002 16:14
To: Multiple recipients of list ORACLE-L


This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Dave,

I've found AT to be flakey at best.  I haven't had your specific problem,
but I have had problems where AT would only occasionally run when it was
supposed to.

I don't remember if it was a specific NT patch or a version of IE explorer,
but one of these will install a Scheduler utility, which I've found to be
pretty reliable.  If you open My Computer (or explorer) you should see a
folder called Scheduled Tasks.  Double-click and then use the wizard to set
up a call to your batch file.

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
I have Oracle 8.1.7 running on NT.  I do cold backups nightly and 
have a batch file that is called by the NT 'AT' scheduler.  I recently 
changed some lines of commands in the batch file and since then when 
the batch file is executed by 'AT' only the lines that I did not 
edit are executed.
If I execute the batch file from the command prompt it works fine. 
 I deleted the job from 'AT' and then entered it back in but still 
getting this odd behavior of only executing the commands that I did 
not edit.  Our SA's know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze? 
 I know you find it hard to believe that something can be weird in 
Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups. 
 I have the 8i Backup and Recovery Handbook for my reading pleasure. 
 I see the app that is being used going to a 24X7 schedule.  Now 
it is only used during the day.

Thanks,

Dave
-- 
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

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: Alan Davey
  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, attachments and opinions contained in this message are those of its 
author only and do not necessarily represent those of The Woolwich and or any other 
members of the Barclays Group and are intended solely for the use of the individual or 
entity to whom they are addressed. The sender may not be authorised to give financial 
advice, and nothing in this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may not copy, 
distribute or take any action in reliance on it. If you have received this email in 
error please notify the Information Security Manager at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bishop Lewis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed

Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread Igor Neyman


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

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:

Re: Size of Oracle server processes

2002-07-17 Thread Tim Gorman


Exactly.  Each process is carrying two separate UGAs and PGAs in the server
process's heap area, which is a data segment.  Does HPUX have a pmap
utility, as can be found in Solaris and Linux?  It does a great job of
breaking down a process into the distinct code and data segments.  I don't
know glance very well, so I can visualize what your seeing...

If you're inclined to test this effect, you can implement multiple
connections using OCI or PRO*C in a test program.  On Oracle8i software
installs, there is an OCI demo program named cdemoses.c in the directory
$ORACLE_HOME/rdbms/demo which creates two connections from the same
program.  I don't know exactly what it does, but it could be something to
compile/link quick and see if the effect is duplicated...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 7:28 AM


 Tim,
 I think your observation is correct, every Apps logon
 does create two sessions. How is that affecting the
 size of the server process? Do you mean the size is
 the sum of the two sessions? In glance, most of the
 memory size came out of the data segment of the
 process.
 Jos

 --- Tim Gorman [EMAIL PROTECTED] wrote:  This is a
 pure guess, and I don't have my own
  OraApps system to check it upon first, so this might
  be embarrassing, but here goes...
 
  Often I see 2 sessions started for every dedicated
  server process when Oracle Forms is in use with
  Oracle Apps, from R10.7 on up.  I think the
  Jinitiator applet is creating the second session
  associated with the process.  To verify this, you
  could try running the following query and see if it
  returns two rows instead of one:
selectsid, serial#, username, osuser, process
from   v$session
where paddr in (select addr from v$process
   where spid =
  oracleSID-processID)
  Plug in the PID for the server process into
  oracleSID-processID where you are seeing the
  large RSS.  If you do get two rows back from the
  query, then this might be an explanation for the
  increased size?
 
  Hope this helps...
 
  -Tim
- Original Message -
From: Jos Someone
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 15, 2002 1:18 PM
Subject: Size of Oracle server processes
 
 
I have a question to ask regarding Oracle server
  process (oracleSID) size. We have just installed
  Oracle Apps 11i, while monitoring the system using
  glance, I notice something strange, the oracle
  server processes - process which has a name
  oracleSID has a very big RSS size in glance, these
  processes were associated with the f60webmx
  processes. I was curious about the size of it,
  normally these processes are about 2-3M big. I did a
  quick test by logging on to the database using
  sqlplus and observe the size of the oracle server
  process, it showed  a size of 2M. So why the
  oracleSID processes size is so big where they are
  assoicated with f60webmx, is it something special
  about them? Or the RSS size shown in glance is
  doubling up on something?
 
Jos
 
 
 
 
 
 
 
 
 --

SOLD.com.au - Find yourself a bargain!
 

 http://www.sold.com.au - SOLD.com.au
 - Find yourself a bargain!
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: =?iso-8859-1?q?Jos=20Someone?=
   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: Tim Gorman
  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).

Import Error

2002-07-17 Thread Hamid Alavi


Hi List,

This morning I try to import a dump file from another database(oracle 8.1.6)
to my database(oracle 8.17.4 sun solaris )but I got the following error,
after I check the error message it said it is an internal error, What do you
think:

import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
IMP-00069: Could not convert to environment national character set's handle

Is there any solution.

Thanks.

Hamid Alavi
Office 818 737-0526
Cell818 402-1987






=== Confidentiality Statement === 
The information contained in this message and any attachments is 
intended only for the use of the individual or entity to which it is 
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
and exempt from disclosure under applicable law.  If you have received 
this message in error, you are prohibited from copying, distributing, or 
using the information.  Please contact the sender immediately by return 
e-mail and delete the original message from your system. 
= End Confidentiality Statement =  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Khedr, Waleed


Did you check the event viewer Application log  System log for any
unanticipated errors?

Waleed

-Original Message-
Sent: Wednesday, July 17, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

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: Khedr, Waleed
  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

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Jeff Herrick



In the same veinif it's a system level environment variable
that has been added since reboot, then you need a reboot of the server.
Simply starting and stopping the Scheduler service is not enough since
the scheduler service inherits its environment from the Service Control
manager (Services.exe) which only reads its environment at system
boottime.

Cheers

Jeff Herrick

On Wed, 17 Jul 2002, Bishop Lewis wrote:

 The Scheduler is installed with IE5.5 - definitively worth the install.

 As far as executing some lines but not others - it sounds like a environment
 variable problem to me - put a set command (to list variables and a pause
 command in your script (or output a log file) and check that your
 environmental settings are okay.

 Lewis Bishop
 ---
 Oracle Database Consultant - Barclays Enable/ISS/OpenPlan
 Email:[EMAIL PROTECTED]



 -Original Message-
 Sent: 17 July 2002 16:14
 To: Multiple recipients of list ORACLE-L


 This header confirms that this email message has been swept for the
 presence of computer viruses.

 Corporate IT
 THE WOOLWICH
 --

 Dave,

 I've found AT to be flakey at best.  I haven't had your specific problem,
 but I have had problems where AT would only occasionally run when it was
 supposed to.

 I don't remember if it was a specific NT patch or a version of IE explorer,
 but one of these will install a Scheduler utility, which I've found to be
 pretty reliable.  If you open My Computer (or explorer) you should see a
 folder called Scheduled Tasks.  Double-click and then use the wizard to set
 up a call to your batch file.

 HTH,
 --

 Alan Davey
 [EMAIL PROTECTED]
 212-604-0200  x106


 On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
 I have Oracle 8.1.7 running on NT.  I do cold backups nightly and
 have a batch file that is called by the NT 'AT' scheduler.  I recently
 changed some lines of commands in the batch file and since then when
 the batch file is executed by 'AT' only the lines that I did not
 edit are executed.
 If I execute the batch file from the command prompt it works fine.
  I deleted the job from 'AT' and then entered it back in but still
 getting this odd behavior of only executing the commands that I did
 not edit.  Our SA's know nothing about 'AT' so they are of no help.
 Has anyone else seen this odd behavior in the 'AT' function in Windoze?
  I know you find it hard to believe that something can be weird in
 Windoze.  ;o)
 And yes, I am soon planning on learning RMAN and do hot backups.
  I have the 8i Backup and Recovery Handbook for my reading pleasure.
  I see the app that is being used going to a 24X7 schedule.  Now
 it is only used during the day.
 
 Thanks,
 
 Dave
 --
 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
 
 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: Alan Davey
   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, attachments and opinions contained in this message are those of its 
author only and do not necessarily represent those of The Woolwich and or any other 
members of the Barclays Group and are intended solely for the use of the individual 
or entity to whom they are addressed. The sender may not be authorised to give 
financial advice, and nothing in this message should be construed as offering such 
advice.

 The message may contain privileged and confidential information and you may not 
copy, distribute or take any action in reliance on it. If you have received this 
email in error please notify the Information Security Manager at 
[EMAIL PROTECTED]

 Replies to this email may be monitored for operational or business reasons.

 Woolwich plc. Registered in England Number : 3295699.

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

RE: Weird Windoze 'AT' Behavior


That is it exactly!!  I have a few lines that do a XCOPY command to copy my database 
files to another server.  Previously I had the backup going to a local drive.  Now I 
have a server that I am getting all my database backups going to.  Will it work if the 
drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

problem with rollback segment

2002-07-17 Thread Alexander Ordonez


Hi gurus, 

i have problem with 1 rollbadck seg, but this show active. I check the
transaction and this is not used for any process!!!
who make offline?? force??? and need free the space!!!


@lex

  Lic. Alexander Ordóñez Arroyo 
 Soporte Compaq Tru64Unix  BD  Oracle  
  Caja Costarricense del Seguro Social 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]  Celular 397-0532


The true is out there in WWW

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexander Ordonez
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: RE: dblink problem ( ORA-02019)

2002-07-17 Thread Ramon E. Estevez


Check the parameter GLOBAL_NAMES, the best if have them FALSE in both
instances.

Ramon

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 5:28 AM


 Hi

 thanks for your mail.
 Dick , I checked out , both db's are 8.1.7.2 and have same db_domain as
 world.
 i also tried out Suzy Vordos' suggestion :
 selected name,value,ismodified from v$paramater for both databases ,
 but the result for both is same . So change in init.ora or alter system
 after db startup does not seem likely.

 regards
 Ratnesh


 -Original Message-
 Sent: Tuesday, July 16, 2002 6:57 PM
 To: Ratnesh Kumar Singh; Multiple recipients of list ORACLE-L


 Folks,

 Since I recently slammed into this unexpected wall I'll pass along the
 experience.  A couple of weeks ago I upgraded an 8.0.5.2.1 instance to
8.1.7
 and
 subsequently at OTS's request to 8.1.7.4.  To make a long story short most
 things with database links worked OK, but a describe across one did not
 (ORA-02019).  The problem ended up being a small error in Oracle's INIT
 parameter documentation.  Back in 8.0.5.2.1, due to a bug introduced, you
 needed
 to have DB_DOMAIN=.WORLD or DB_DOMAIN=.VICR.COM.  Note the '.' before the
 domain.  Well in 8.1.7, or sometime before that, they fixed the bug, but
 forgot
 about those of us who don't always follow the 'yellow brick road'.  So if
 your
 having problems with ORA-02019's take a second and check this parameter in
 your
 init.ora.  I changed mine  the problems went away.

 Dick Goulet

   - Original Message -
   From: Ratnesh Kumar Singh
   To: Multiple recipients of list ORACLE-L
   Sent: Wednesday, July 10, 2002 6:23 PM
   Subject: dblink problem ( ORA-02019 )


   hi

   i have 3 databases(A,B,X) on 3 diff boxes.
   i have created 1 dblink each from A to X  from B to X.
   The syntax for dblink creation is exactly same for both dblinks.

   I am able to query from dblink A-X  as select * from
 user.table@dblinkAX
   but when i try to query from dblink B-X as select * from
   user.table@dblinkBX
   i get the foll error
   Error: ORA-02019: connection description for remote database not
found

   When i modify my query by suffixing '.world' as
   select * from [EMAIL PROTECTED] , the query works fine.

   I have compared the entries in init,sqlnet,tnsnmames,listener files
on
 both
   A  B
   databases and they are absolutely similar .
   i was thinking that the domain or globalnames parameters might be
diff
 on A
B ,
   but they are absolutely same .

   any suggestions are most welcome ...

   thanks in advance
   ratnesh



   ---
   Ratnesh Kumar Singh
   Sr. Software Engineer
   Patni Computer Systems Ltd
   TTC Mahape , Navi Mumbai
   Work : (91 22) 7611090/110/128/350 Ext. 2107
   Home : (91 22) 8662162
   http://www.patni.com
   World-Wide Partnerships. World-Class Solutions.
   ---

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Ratnesh Kumar Singh
   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: Ramon E. Estevez
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Mark Leith


Dave, try WinCron.. Pretty cheap and apparently more reliable..

http://www.wincron.co.uk

M.

-Original Message-
Dave
Sent: 17 July 2002 16:59
To: Multiple recipients of list ORACLE-L


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

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: Mark Leith
  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

a couple of questions


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Igor Neyman


Not sure about mapped drives, just try it.
If it wouldn't work, try to change Task Scheduler service startup
options (through ControlPanel/Services) to run under some account, which has
privileges to access network drives, instead of running under local SYSTEM
account.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 12:47 PM


That is it exactly!!  I have a few lines that do a XCOPY command to copy my
database files to another server.  Previously I had the backup going to a
local drive.  Now I have a server that I am getting all my database backups
going to.  Will it work if the drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread James J. Morrow


You may want to check a couple of things:

1.  Be careful which editor you use.  (Consider locating an old copy of the
MS-DOS QEdit
shareware program.  It's small, and very clean).  Or, use the DOS EDIT
utility.  (If you
feel the need for a windows editor, notepad is probably your cleanest
choice.)

2.  DOS sometimes needs an end-of-file marker (Ctrl-Z).  Some things won't
recognize the last
line without it.

3.  Or, if you're a *nix bigot like me, install cygwin (http://www.cygwin.com). 
You'll get a 
unix-like cron utility as well as some decent scripting tools...

Farnsworth, Dave wrote:
 
 I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a batch file 
that is called by the NT 'AT' scheduler.  I recently changed some lines of commands 
in the batch file and since then when the batch file is executed by 'AT' only the 
lines that I did not edit are executed.
 If I execute the batch file from the command prompt it works fine.  I deleted the 
job from 'AT' and then entered it back in but still getting this odd behavior of only 
executing the commands that I did not edit.  Our SA's know nothing about 'AT' so they 
are of no help.
 Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I know you 
find it hard to believe that something can be weird in Windoze.  ;o)
 And yes, I am soon planning on learning RMAN and do hot backups.  I have the 8i 
Backup and Recovery Handbook for my reading pleasure.  I see the app that is being 
used going to a 24X7 schedule.  Now it is only used during the day.
 
 Thanks,
 
 Dave
-- James

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
McKinney, TX, USA

The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man.  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  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: Weird Windoze 'AT' Behavior

2002-07-17 Thread Hayes, Scott


Yes :)

Scott

-Original Message-
Sent: Wednesday, July 17, 2002 12:47 PM
To: Multiple recipients of list ORACLE-L


That is it exactly!!  I have a few lines that do a XCOPY command to copy my
database files to another server.  Previously I had the backup going to a
local drive.  Now I have a server that I am getting all my database backups
going to.  Will it work if the drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
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

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).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

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

Re: Import Error

2002-07-17 Thread Ramon E. Estevez


Hamid,

try setting NLS_CHAR=WE8ISO8859P1
in the session doing the import.

HTH

Ramon


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:38 AM


 Hi List,

 This morning I try to import a dump file from another database(oracle
8.1.6)
 to my database(oracle 8.17.4 sun solaris )but I got the following error,
 after I check the error message it said it is an internal error, What do
you
 think:

 import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
 import server uses US7ASCII character set (possible charset conversion)
 IMP-00069: Could not convert to environment national character set's
handle

 Is there any solution.

 Thanks.

 Hamid Alavi
 Office 818 737-0526
 Cell818 402-1987






 === Confidentiality Statement ===
 The information contained in this message and any attachments is
 intended only for the use of the individual or entity to which it is
 addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
 and exempt from disclosure under applicable law.  If you have received
 this message in error, you are prohibited from copying, distributing, or
 using the information.  Please contact the sender immediately by return
 e-mail and delete the original message from your system.
 = End Confidentiality Statement =


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Hamid Alavi
   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: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-17 Thread MacGregor, Ian A.


It really OAS and not iAS?  If it is, you need to upgrade your software.  There is  a 
published exploit against  the version of Apache used by Oracle's latest iAS release.  
Oracle has released a patch which stops the exploit

I have built Oracle web servers for years, but I am now of the mind that these things 
should not be built by DBA's but by webmasters. 

I am undecided whether to one should go with iAS or construct your own with  Apache.  
The mod_plsql module for instance was not created by Oracle.  It and things  such as 
forms server and reports server will run against such a construction. 

However, we were advised last week that the  Windows NT machines will be converted to 
XP  this year.  As a result, I  started to look at  the 9i Internet Developer Suite.  
About every third line is a statement to the effect that the 9i database, 9 iAS, and 9 
iDS are made to work together.  I haven't figured out what one is giving up if one 
builds their own web server and also installs components for the 9 iAS distribution.  
Is it just convenience?

One reason for giving up the convenience is security.  An exploit is discovered and 
possibly published.  Apache fixes the problem.  If I have built my own I can get the 
patch from Apache and  rebuild the web server.  If I'm wedded to iAS I need to wait 
for Oracle to  incorporate the patch into its offering.  This could be a matter days 
to over a week.  However weighing-in on the 9 iAS side is the ease of installing a 
fix.  The Apache fix  for the aforementioned problem required  a rebuild; you need 
someone wise in the ways of make files and such.   The 9 iAS fix was a simple file 
replacement.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Folks,
 
I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that now
makes 
my head swim to look at. (I think to myself, what the devil was I doing??)
 
Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards 
to:
 
1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own getting started experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.
 
Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!
 
RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: a couple of questions


Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.

Oracle does have user-defined data types if that helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
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).

Oracle DBA with AIX and Web experience Needed in Arizona..

2002-07-17 Thread OraStaff


Position: Oracle DBA with AIX and Web experience
  
Location: Phoenix, Arizona (** Candidates must currently reside in Arizona)

Salary Range: 80-90K range..Depends on experience.

PLEASE Do not send your resume for this position UNLESS you have the skills 
outlined below for this position.

DO NOT send your resume unless you have a stable work history.
Candidates whose work history includes frequent job changes connot be
considered.
If you are employed by a consulting company you must have a long term
project history.

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

Responsibilities:
To provide physical database support for Oracle on multiple platforms. 
Perform physical database design. 
Participate in application and system architecture design. 
Manage database configuration in all environments. 
Identify, analyze, predict and correct database and application problems. 
Ensure database integrity.
Plan and practice disaster recovery procedure. 
Balance database across processors and nodes. 
Manage table/file allocations. 
Provide on-call support.

Requirements:
-9 years of I.T. experience.
-Minimum 5 years Oracle DBA experience.
-AIX experience.
-Familarity with Oracle 8 or higher, parallel server and Net8
-PL/SQL..triggers, stored procedures.
-Understanding of use of Oracle in Web applications.
-Advanced shell script writing experience.
-Excellent written and verbal skills.
-Must be a U.S. citizen or Permanent resident.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
Please use job code: One/Phoenix/DBA/Todd
ph: 1-800 -549-8502

All Submissions are handled in confidence.

*We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the position 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: a couple of questions


Rachel,

First question - Not a Clue.  I'm on windoze.  ;o)

Second Question - SQL_Variant datatype -I'll find out more about this.  I have never 
used it.

A data type that stores values of various SQL Server-supported data types, except 
text, ntext, image, timestamp, and sql_variant. 
sql_variant may be used in columns, parameters, variables, and return values of 
user-defined functions. sql_variant allows these database objects to support values of 
other data types.
A column of type sql_variant may contain rows of different data types. For example, a 
column defined as sql_variant can store int, binary, and char values. The only types 
of values that cannot be stored using sql_variant are text, ntext, image, timestamp, 
and sql_variant.
sql_variant can have a maximum length of 8016 bytes.
An sql_variant data type must first be cast to its base data type value Before 
participating in operations such as addition and subtraction.
sql_variant may be assigned a default value. This data type also may have NULL as its 
underlying value, but the NULL values will not have an associated base type. In 
addition, sql_variant may not have another sql_variant as its base type.
A UNIQUE, primary, or foreign key may include columns of type sql_variant, but the 
total length of the data values comprising the key of a given row should not be 
greater than the maximum length of an index (currently 900 bytes).
A table may have any number of sql_variant columns.
sql_variant cannot be used in CONTAINSTABLE and FREETEXTTABLE.
ODBC does not fully support sql_variant. Hence, queries of sql_variant columns are 
returned as binary data when using Microsoft OLE DB Provider for ODBC (MSDASQL). For 
example, an sql_variant column containing the character string data 'PS2091' is 
returned as 0x505332303931.

Dave




-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
--
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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: a couple of questions

2002-07-17 Thread Jamadagni, Rajendra


Rachel,

1. Don't know

2.
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/
a88876/adfnstyp.htm#434671 may not be the exact thing but you just might be
closer ...

Also, Oracle *automatically* does implicit conversion ... but I think your
developers are asking for more. For implicit conversion
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89856/03
_types.htm#3435

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

Re: A DBA looks at OAS

2002-07-17 Thread mkb


No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password pwd.

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- Freeman, Robert [EMAIL PROTECTED] wrote:
 Folks,
  
 I'm a DBA who is really an old developer at heart. I
 know a little Java, a
 little Asp
 (enough, as they say, to be really dangerous!), I
 used to do C code that now
 makes 
 my head swim to look at. (I think to myself, what
 the devil was I doing??)
  
 Anyway, I've finally found some time and a machine
 here at work to start
 playing with
 OAS just to see what it's all about. Anyone have any
 good suggestions with
 regards 
 to:
  
 1. Sites, books, white papers and the like with good
 install tips, hints,
 warnings and the like.
 2. Sites, books, white papers and the like Quick
 getting started tips.
 3. Your own getting started experiences of things
 to do or not to do.
 5. Anything I should do before I mess with OAS.
  
 Optimistically hopeful that this will all just go
 really smooth and I'll
 have a cool
 web page that I

RE: a couple of questions

2002-07-17 Thread Brian McGraw


Rachel -

We were running 64-bit Oracle here for a while, but I decided against
it.  I knew that we weren't going to need the features that the 64bit
version would buy us.  That, coupled with the fact that the 64 bit
versions of the software are usually the *last* to be patched, kept me
on the 32-bit version.

HTH -

Brian

--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

-Original Message-
Carmichael
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L

Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: a couple of questions


Dennis,

it's a dev box so we don't really need mileage it won't be hit as hard
as production (and I'll make sure production is created properly)...

as for the datatypes, I know about user-defined, they don't want that.
These are people who know SQL Server but not Oracle and are designing
the system as if it were SQL Server. My boss has input to this process,
I don't, so I'll work through him to get the mindset changed.

Thanks!

Rachel

--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
 Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so
 far,
 but not much mileage on either. The one thing that came up is that
 you must
 be careful because you seem to get 32-bit Oracle by default. Someone
 on this
 list suggested running file oracle.
 
 Oracle does have user-defined data types if that helps.
 
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]
 
 
 -Original Message-
 From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 12:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: a couple of questions
 
 
 Okay, I'm working on what feels like 30 new projects all at once and
 I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but
 
 
 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?
 
 second (and this one confuses me a bit)... I've been asked if
 Oracle9i
 supports a variant datatype -- they are not familiar with oracle
 but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They
 referred
 me to C++ and Java, neither of which I know.
 
 Can anyone point in the right direction to start researching this?
 
 Thanks!
 
 Rachel
 
 
 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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: a couple of questions

2002-07-17 Thread MacGregor, Ian A.


A variant  data type column in the database?  What would be the domain of such a 
column?  Does such a column not beg for data which should be placed in other columns 
to be stored in it?  Oh what fun when someone stores 1234 or worse 1.2E4 both as a 
number and string.

Perhaps I'm to staid in my ways to grasp the benefits of its use in the database.  
It's use runs counter to the data modeling principles I was taught. 

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  

-Original Message-
Sent: Wednesday, July 17, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: a couple of questions


Dennis,

I'm not sure your referring to the message I posted a couple of weeks ago,
but the labeling on the CD's from Oracle can be deceiving.  Each CD pack ships
with both the 32 and 64 bit versions of Oracle, one of which is labeled with the
bit value).  Make sure you've got the right one.

If memory is serving correctly 'variant' in MicroSlop maps somewhat to raw
in Oracle.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date:   7/17/2002 9:33 AM

Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.

Oracle does have user-defined data types if that helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
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: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: a couple of questions

2002-07-17 Thread Toepke, Kevin M


Rachel

Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type. 

Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm

Kevin

The Any types provide highly flexible modeling of procedure parameters and
table columns where the actual type is not known. These datatypes let you
dynamically encapsulate and access type descriptions, data instances, and
sets of data instances of any other SQL type. These types have OCI and
PL/SQL interfaces for construction and access.


SYS.AnyData
This type contains an instance of a given type, with data, plus a
description of the type. AnyData can be used as a table column datatype and
lets you store heterogeneous values in a single column. The values can be of
SQL built-in types as well as user-defined types.


-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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 (?) -- UNC, NetBIOS, mapped drives and Apache / iAS forms serv er

2002-07-17 Thread Boivin, Patrice J


This is OT I suppose, but I would like to see if there are any comments re.
this.

For Apache I believe the account used to map the drive must be the same used
to create the share at the other end.  This is important if you have aliases
that point to remote locations.

For iAS forms server, I never managed to make it recognize mapped drive on
our NT machines here regardless of which account the NT Forms Server service
is configured to run as.  In the end I had to use a process launched from a
batch file.  Even that doesn't work when launched as a job, it has to be
launched interactively from the desktop.  We are gradually moving to
servlets to get rid of the Forms server altogether...

Mapped drives, UNC names, NetBIOS must be an old part of the win32 platform.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: a couple of questions


Kevin,

Looks messy to me, and damned confusing to boot.

Dick Goulet

The more you overtake the pluming the easier it is to stop up the drain.

Scotty of Star Trek, Search for Spock.

Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date:   7/17/2002 9:58 AM

Rachel

Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type. 

Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm

Kevin

The Any types provide highly flexible modeling of procedure parameters and
table columns where the actual type is not known. These datatypes let you
dynamically encapsulate and access type descriptions, data instances, and
sets of data instances of any other SQL type. These types have OCI and
PL/SQL interfaces for construction and access.


SYS.AnyData
This type contains an instance of a given type, with data, plus a
description of the type. AnyData can be used as a table column datatype and
lets you store heterogeneous values in a single column. The values can be of
SQL built-in types as well as user-defined types.


-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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).

RE: a couple of questions

2002-07-17 Thread Deshpande, Kirti


Rachel:
 For a quick scoop on this sys.ANYDATA datatype, check current issue of
Oracle Magazine (Jul/Aug).  Tom Kyte's column has neat information on the
AnyDATA. But using it in SQL queries ain't the prettiest thing. 

HTH,

- Kirti 

 -Original Message-
 From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 12:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: a couple of questions
 
 Rachel
 
 Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
 thinks its what SQL server would call a variant data type. 
 
 Follow this link for more info
 http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/
 toc.htm
 
 Kevin
 
 The Any types provide highly flexible modeling of procedure parameters
 and
 table columns where the actual type is not known. These datatypes let you
 dynamically encapsulate and access type descriptions, data instances, and
 sets of data instances of any other SQL type. These types have OCI and
 PL/SQL interfaces for construction and access.
 
 
 SYS.AnyData
 This type contains an instance of a given type, with data, plus a
 description of the type. AnyData can be used as a table column datatype
 and
 lets you store heterogeneous values in a single column. The values can be
 of
 SQL built-in types as well as user-defined types.
 
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 1:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Okay, I'm working on what feels like 30 new projects all at once and I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but
 
 
 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?
 
 second (and this one confuses me a bit)... I've been asked if Oracle9i
 supports a variant datatype -- they are not familiar with oracle but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They referred
 me to C++ and Java, neither of which I know.
 
 Can anyone point in the right direction to start researching this?
 
 Thanks!
 
 Rachel
 
 
 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Toepke, Kevin M
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS

2002-07-17 Thread MacGregor, Ian A.


The httpd daemons need to be started as root?  Since when?  Is it because you're using 
the standard HTTP PORT OF 80?  Starting these daemons under the nobody account is much 
safer.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password pwd.

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- Freeman, Robert [EMAIL PROTECTED] wrote:
 Folks,
  
 I'm a DBA who is really an old developer at heart. I
 know a little Java, a
 little Asp
 (enough, as they say, to be really dangerous!), I
 used to do C code that now
 makes 
 my head swim to look at. (I think to myself, what
 the devil was I doing??)
  
 Anyway, I've finally found some time and a machine
 here at work to start
 playing with
 OAS just to see what it's all about. Anyone have any
 good suggestions with
 regards 
 to:
  
 1. Sites, books, white papers and the

RE: RE: a couple of questions

2002-07-17 Thread Toepke, Kevin M


I agree, it looks messy and confusing... However, I found an example that
makes it a little easier to understand.

http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:3099475696866,%7Banydata%7D

My guess it was implemented for 2 reasons
1)  to say they have every feature as M$
2)  to support 3rd party vendors porting stuff from M$

Kevin

-Original Message-
Sent: Wednesday, July 17, 2002 1:35 PM
To: Toepke, Kevin M; Multiple recipients of list ORACLE-L


Kevin,

Looks messy to me, and damned confusing to boot.

Dick Goulet

The more you overtake the pluming the easier it is to stop up the drain.

Scotty of Star Trek, Search for Spock.

Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date:   7/17/2002 9:58 AM

Rachel

Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type. 

Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm

Kevin

The Any types provide highly flexible modeling of procedure parameters and
table columns where the actual type is not known. These datatypes let you
dynamically encapsulate and access type descriptions, data instances, and
sets of data instances of any other SQL type. These types have OCI and
PL/SQL interfaces for construction and access.


SYS.AnyData
This type contains an instance of a given type, with data, plus a
description of the type. AnyData can be used as a table column datatype and
lets you store heterogeneous values in a single column. The values can be of
SQL built-in types as well as user-defined types.


-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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: Toepke, Kevin M
  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: (Fwd/2)

2002-07-17 Thread Johnson, Michael


There are those that argue Apple provided competition
to Microsoft.   Not very good competition, but competition
nonetheless and so the monopoly argument goes out
the window.I agree Microsoft is substandard product,
especially with regard to the server based class.
However, the market place has spoken very clearly
and it is up to someone else to come and take away
some of Microsofts Pie !

In 1998, at Oracle OpenWorld, McNally and Ellision
completely trashed Microsoft and Bill Gates in one of
those open morning sessions.My thought at the time
was , instead of bitchin about them , why dont you
just go compete against them and put them out of 
business.

Well, its 2002 and Sun / Oracle now have 
major business problems and Microsoft just
seems to keep on truckin. I havent heard
much lately from Scott and Larry regarding
this issue.   Perhaps they are putting together
a good technical presentation for Openworld 
this year and that will give me a good
reason to go.

maybe I will hear good technical presentations 
instead of thoughtless meanderings and tirades about folks
they are obviously jeoulous of.

FWIW.

Mike

-Original Message-
Sent: Tuesday, July 16, 2002 3:19 PM
To: '[EMAIL PROTECTED]'


Hi Mike,

I just got a bit of a chuckle when you mentioned free market system and
Microsoft in the same breath.  Microsoft didn't get to be the biggest by
having the best product.  They got it from the best marketing and
unscrupulous and illegal business practices (tried to say that without using
the over-used Monopoly!).

Oracle can make claims that they are the best because they can actually
prove some or most those claims.  MS can't.  Sorry for sounding like a
whiner, but it's been a Microsoft day at it's best.  Multiple reboots for
everyone!  Yay!

OK, enough whining.  It's no fun when you can't whine/complain to someone
without having some brewskis!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

 -Original Message-
 From: Johnson, Michael [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, July 16, 2002 6:03 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: (Fwd/2)
 
 
 I would add to this ..
 
 In a free market system nobody should 
 look at the negative side when people make
 money off of their hard work or investments.
 This is the way it is set up.  
 
 Why not say  damn, how did he do
 it and where do I get in line to get
 some of that action ?
 
 I always find it interesting the envy and/or
 disgust that some folks have toward people
 who make alot of money. 
 
 Think of all the middle class people
 Larry Ellison and crew put to work who
 bought homes and cars to drive our economy.
 
 I didnt care for any of Larry and Scotts 
 bitchin and moanin about Microsoft and
 Bill Gates, but I say to Larry ..  More power
 to you to make more money, keep gettin richer 
 and help build our economy.  Keep on truckin !
 
 FWIW.
 
 Mike
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

HP-UX 11i/8.1.6.3/Excel

2002-07-17 Thread Vergara, Michael (TEM)


I am trying to create a SQL query in Excel that will take a
parameter value and return a value from the database.  I cannot
make it work.

Can anybody point me towards a tutorial, or maybe even show me a
MS Query file that has worked in the past?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

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

Returing a COMPLETE recordset from a stored procedure

2002-07-17 Thread johanna . doran




Ok,

 
Maybe its just been a rough day, but looking at the docs (PLSQL Devleopers 
Guide), I only see that I can return only a record at a 
time.

But say I want to 
return a complete recordset from a stored procedure toa C program, what 
would be my retrun type? Can I use a collection?

The docs aren't 
clear on this and only show examples of retrunung a single 
rowtype.

Any links (except to 
metalink - I dont have access) would be helpful,

Thanks,

 
Hannah

external authentication

2002-07-17 Thread Lyuda Hoska









Does anyone here have experience working with database that supports
external authentication application users?

My question is how would application know which database to connect to
if there are multiple databases on the server?

Does it have to be hard-coded in application?

Thank you.

RE: a couple of questions


How do u get 32 bit by default?  The 32bit and 64bit Oracle came as
separate CDs.  Am I missing something?

Richard

-Original Message-
Sent: Wednesday, July 17, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.

Oracle does have user-defined data types if that helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
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: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:RE: RE: a couple of questions


Much better explanation especially with the examples.  BUT, do I smell a
potential manure pile here?

Dick Goulet

Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date:   7/17/2002 1:53 PM

I agree, it looks messy and confusing... However, I found an example that
makes it a little easier to understand.

http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:3099475696866,%7Banydata%7D

My guess it was implemented for 2 reasons
1)  to say they have every feature as M$
2)  to support 3rd party vendors porting stuff from M$

Kevin

-Original Message-
Sent: Wednesday, July 17, 2002 1:35 PM
To: Toepke, Kevin M; Multiple recipients of list ORACLE-L


Kevin,

Looks messy to me, and damned confusing to boot.

Dick Goulet

The more you overtake the pluming the easier it is to stop up the drain.

Scotty of Star Trek, Search for Spock.

Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date:   7/17/2002 9:58 AM

Rachel

Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type. 

Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm

Kevin

The Any types provide highly flexible modeling of procedure parameters and
table columns where the actual type is not known. These datatypes let you
dynamically encapsulate and access type descriptions, data instances, and
sets of data instances of any other SQL type. These types have OCI and
PL/SQL interfaces for construction and access.


SYS.AnyData
This type contains an instance of a given type, with data, plus a
description of the type. AnyData can be used as a table column datatype and
lets you store heterogeneous values in a single column. The values can be of
SQL built-in types as well as user-defined types.


-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  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).

GZip/WinZip...hot backups...

2002-07-17 Thread Grabowy, Chris


A fellow DBA had mentioned that during his disaster recovery test, gzip had
unzipped his Solaris files but did not restore the .dbf extension.  Thus
leaving him to manually rename his files to include a .dbf extension.  He
examined the gzip man pages but could not find any flags to set or anything
to help.  Has anyone else encountered this?  Ideas?

During a hot backup, on W2K platform, he uses WinZip to backup/compress all
the datafiles into one large backup file.  Has anyone encountered any
problems with using this approach?  Versus using the ocopy or copy command?
He mentioned that on occasion he gets an error message from WinZip that the
file was open, but everything seems to work.

Many thanks in advance!!!

Chris



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RE: a couple of questions


Some times I get a thin CD pack which only has 32bit.
I will have to ask Oracle to ship me the 64bit version.

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


Dennis,

I'm not sure your referring to the message I posted a couple of weeks
ago,
but the labeling on the CD's from Oracle can be deceiving.  Each CD pack
ships
with both the 32 and 64 bit versions of Oracle, one of which is labeled with
the
bit value).  Make sure you've got the right one.

If memory is serving correctly 'variant' in MicroSlop maps somewhat to
raw
in Oracle.

Dick Goulet

Reply Separator
Author: DENNIS WILLIAMS [EMAIL PROTECTED]
Date:   7/17/2002 9:33 AM

Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.

Oracle does have user-defined data types if that helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
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: 
  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: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: (Fwd/2)


There are those that argue Apple provided competition
to Microsoft.   Not very good competition, but competition
nonetheless and so the monopoly argument goes out
the window.

Only because years ago, MS put money in it (100 mill?) and
promised to port MS Office and IE to Mac to keep it alive,
so there appears to be competition.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: a couple of questions

2002-07-17 Thread Tim Gorman


Rachel,

This variant datatype sounds a lot like the union data structure from
C language, which closely resembled a struct (i.e. record) but all of
the fields overlap the same memory address.  In other words, it was a
mechanism for type re-casting.  In the grand tradition of robust programming
languages, there are about a dozen and a half ways to do this in C, and
the union structure is one of the less popular.  Luckily, it is difficult
to use for any other purpose...

Not so with what you're describing.  Sounds like a feature which is ripe for
all kinds of abuse.  I can just imagine entire tables populated with columns
of type VARIANT by some designer touting flexibility as a mantra.
Fortunately, Oracle developers can use the RAW datatype in the same fashion,
and it is interesting to note (but perhaps not coincidental) that most C
programmers tend to favor a similar mechanism (i.e. void pointers) for
type re-casting too.  In other words, be assured that VARIANT is not the
only way to get the job done, and might prove unpopular anyway...

Just my $0.02...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:08 AM


 Okay, I'm working on what feels like 30 new projects all at once and I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but


 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?

 second (and this one confuses me a bit)... I've been asked if Oracle9i
 supports a variant datatype -- they are not familiar with oracle but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They referred
 me to C++ and Java, neither of which I know.

 Can anyone point in the right direction to start researching this?

 Thanks!

 Rachel


 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  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: external authentication

2002-07-17 Thread Karniotis, Stephen









If you have multiple databases and you are using
external user authentication, the connect string would need to identify the SID
or TNSNames entry that they must connect to. We wrote a front-end application that the user invoked via a
menu or API. They passed in the
English name of the app and we passed the entry back to them.



Thank
You



Stephen
P. Karniotis

Product Architect

Compuware Corporation

Direct: (248)
865-4350

Mobile: (248)
408-2918

Email: [EMAIL PROTECTED]

Web: www.compuware.com



-Original
Message-
From: Lyuda Hoska
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002
3:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: external authentication



Does anyone
here have experience working with database that supports external
authentication application users?

My question
is how would application know which database to connect to if there are
multiple databases on the server?

Does it have
to be hard-coded in application?

Thank you.










The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

RE: a couple of questions


No problem running 64bit Oracle on 64bit Solaris so far.
But 64 bit has it's own set of bugs from 32 bit.  I am
sure you will test it before deployment. :)

Richard Ji

-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Returning a COMPLETE record set from a stored procedure

2002-07-17 Thread Jamadagni, Rajendra




You could return a REF cursor and then fetch from that ref cursor in your 
program. This situation is ideal compared to passing (around) 
collections.

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-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 17, 2002 
  3:24 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Returing a COMPLETE recordset from a stored procedure
  Ok,
  
   
  Maybe its just been a rough day, but looking at the docs (PLSQL Devleopers 
  Guide), I only see that I can return only a record at a 
  time.
  
  But say I want to 
  return a complete recordset from a stored procedure toa C program, what 
  would be my retrun type? Can I use a collection?
  
  The docs aren't 
  clear on this and only show examples of retrunung a single 
  rowtype.
  
  Any links (except 
  to metalink - I dont have access) would be helpful,
  
  Thanks,
  
   
  Hannah

*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: GZip/WinZip...hot backups...


If you gzip a .dbf file, you get .dbf.gz extension.
Is that what he was doing?  What's the full filename after gzipped?

Richard

-Original Message-
Sent: Wednesday, July 17, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L


A fellow DBA had mentioned that during his disaster recovery test, gzip had
unzipped his Solaris files but did not restore the .dbf extension.  Thus
leaving him to manually rename his files to include a .dbf extension.  He
examined the gzip man pages but could not find any flags to set or anything
to help.  Has anyone else encountered this?  Ideas?

During a hot backup, on W2K platform, he uses WinZip to backup/compress all
the datafiles into one large backup file.  Has anyone encountered any
problems with using this approach?  Versus using the ocopy or copy command?
He mentioned that on occasion he gets an error message from WinZip that the
file was open, but everything seems to work.

Many thanks in advance!!!

Chris



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re:Returing a COMPLETE recordset from a stored procedure


Hannah,

It can be done.  The following sql statement returns a pile of data from a
procedure at one time.

SELECT * FROM
THE(SELECT CAST(gatekeeper.fail_why('serial','model') AS
atemgr.GATEKEEPER_INFO_TBL) FROM DUAL)
WHERE MODEL_NUMBER IS NOT NULL;

If you want more of the specifics I can provide.

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   7/17/2002 11:23 AM

Ok,
 
Maybe its just been a rough day, but looking at the docs (PLSQL Devleopers
Guide), I only see that I can return only a record at a time.
 
But say I want to return a complete recordset from a stored procedure to a C
program, what would be my retrun type?  Can I use a collection?
 
The docs aren't clear on this and only show examples of retrunung a single
rowtype.
 
Any links (except to metalink - I dont have access) would be helpful,
 
Thanks,
 
Hannah

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1


META content=MSHTML 5.00.2314.1000 name=GENERATOR/HEAD
BODY
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002Ok,/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=551091818-17072002nbsp;nbsp;nbsp; 
Maybe its just been a rough day, but looking at the docs (PLSQL Devleopers 
Guide), I only see that I can return only a record at a 
time./SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=551091818-17072002But say I want to 
return a complete recordset from a stored procedure tonbsp;a C program, what 
would be my retrun type?nbsp; Can I use a collection?/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=551091818-17072002The docs aren't 
clear on this and only show examples of retrunung a single 
rowtype./SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=551091818-17072002Any links (except to

metalink - I dont have access) would be helpful,/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002Thanks,/SPAN/FONT/DIV
DIVFONT face=Arial size=2SPAN 
class=551091818-17072002/SPAN/FONTnbsp;/DIV
DIVFONT face=Arial size=2SPAN class=551091818-17072002nbsp;nbsp;nbsp; 
Hannah/SPAN/FONT/DIV/BODY/HTML

-- 
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: Returning a COMPLETE record set from a stored procedure

2002-07-17 Thread johanna . doran


Ok, then the question is, can I pass a REF CURSOR to a C program?
That's my problem.  I know I can do it with ref cursors lets say within a package but 
what if I want to pass a complete recordset to a C program?

We have a programmer writing a program in C, wants us to write stored procs that 
return record sets to his calling program.

Makes sense.  I can do it in Visual Basic just by executing code into a recordset, but 
straight PL/SQL and C I am unsure about.

  -Original Message-
 From: [EMAIL PROTECTED]@SUNGARD   On Behalf Of Jamadagni, Rajendra 
[EMAIL PROTECTED]
 Sent: Wednesday, July 17, 2002 3:43 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Returning a COMPLETE record set from a stored procedure
 
 
 You could return a REF cursor and then fetch from that ref cursor in your  program. 
This situation is ideal compared to passing (around)  collections.
 
--
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).

OT: Just a laff! Gates gooses geese guano gunners

2002-07-17 Thread John Kanagaraj


Hi all,

Just LOL!

John Kanagaraj

THE MISSING LINK | Gates gooses geese guano gunners

Penguins may be after Bill Gates' Windows, but geese have his windows
in their scopes. And his roof. And his yard. Gaggles of waterfowl
think Mr. Microsoft's mansion is the perfect place to leave their
calling cards. Evidently these goose droppings are giving Gates
goosebumps. He asked wildlife officials in Washington state to do
something about the problem. Now the chief park ranger has the green
light to go on a massive bird hunt. Some 4,000 geese could get their
gooses cooked thanks to their scatological sorties. If you're a Linux
lover, go ahead and yell it: Go geese, go geese!

Source: vnunet
http://www.vnunet.com/News/1133586

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

UNDO

2002-07-17 Thread John Weatherman


All,

When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?  

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: Returning a COMPLETE record set from a stored procedure

2002-07-17 Thread Jamadagni, Rajendra


http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/
a76942/pc_04dat.htm#23109

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/
a76975/oci05bnd.htm#422771

HTH some
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: Wednesday, July 17, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L


Ok, then the question is, can I pass a REF CURSOR to a C program?
That's my problem.  I know I can do it with ref cursors lets say within a
package but what if I want to pass a complete recordset to a C program?

We have a programmer writing a program in C, wants us to write stored procs
that return record sets to his calling program.

Makes sense.  I can do it in Visual Basic just by executing code into a
recordset, but straight PL/SQL and C I am unsure about.



*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: external authentication

2002-07-17 Thread Toepke, Kevin M




Don't 
do it unless the application is running locally on the same physical server as 
the database. It is (or at least was) extremely easy to break into a system that 
uses external authentication across a network. (...don't 
ask:)

The 
following example shows how to connect to the PLAY database using external 
authentication
$ORACLE_SID=play 
$export ORACLE_SID
$sqlplus /

Kevin

  -Original Message-From: Lyuda Hoska 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 17, 2002 3:24 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  external authentication
  
  Does anyone here have experience working with database 
  that supports external authentication application 
  users?
  My question is how would application know which 
  database to connect to if there are multiple databases on the 
  server?
  Does it have to be hard-coded in 
  application?
  Thank 
you.

SQL*Net encryption/integrity connection problems ORA-12660

2002-07-17 Thread Martin, Alan

Title: SQL*Net encryption/integrity connection problems ORA-12660

We have turned on encryption and integrity on HP 11.0 64-bit (server params=REQUIRED).
All DBs that use encryption use a 2nd listener on port 1526.
Oracle 7/8/8i clients have NO problem establishing a listener connection AND a DB connection.
However...
Various client sites (site-wide) periodically get an ORA-12660, Encryption or crypto-checksumming parameters incompatible. Nothing has changed in any *.ora files. I see the listener_xxx.log shows an establish for the connect attempt, but sys.aud$ does NOT show a DB connection. Sometimes bouncing the DB and/or listener corrects the problem, and all users at a site can once again connect to the DB (until it happens again - not periodic).

Current situation:
Site-A connects to box HPdev and box HPprod (any DB using port 1526).
Site-B connects to box HPprod, but not box HPdev.
Site-C connects to box HPdev (1 of 3 DBs only), but not box HPprod.

I could bounce everything tonight, and if lucky, EVERYTHING works after that.

In the log file I see:
17-JUL-2002 00:48:49 * service_update * dbxxx * 0
What does service_update mean?

I occasionally see:
TNS-12502: TNS:listener received no CONNECT_DATA from client.

Does anyone know if the 8.1.7.2.1 listener is buggy?
Should I patch it?
Install a 9i listener? (Backwards compatible to 7.3.3?)
Could this be a loaded network timing issue?
Any shared experiences would be appreciated.

Thanx,
Alan Martin
Defense Logistics Information Service
Battle Creek, MI

RE: RE: a couple of questions


and here they want to be database independent


sigh. it's for a content management system

--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
 I agree, it looks messy and confusing... However, I found an example
 that
 makes it a little easier to understand.
 

http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
 F4950_P8_CRITERIA:3099475696866,%7Banydata%7D
 
 My guess it was implemented for 2 reasons
   1)  to say they have every feature as M$
   2)  to support 3rd party vendors porting stuff from M$
 
 Kevin
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 1:35 PM
 To: Toepke, Kevin M; Multiple recipients of list ORACLE-L
 
 
 Kevin,
 
 Looks messy to me, and damned confusing to boot.
 
 Dick Goulet
 
 The more you overtake the pluming the easier it is to stop up the
 drain.
 
 Scotty of Star Trek, Search for Spock.
 
 Reply Separator
 Author: Toepke; Kevin M [EMAIL PROTECTED]
 Date:   7/17/2002 9:58 AM
 
 Rachel
 
 Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference).
 Me
 thinks its what SQL server would call a variant data type. 
 
 Follow this link for more info

http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
 c.htm
 
 Kevin
 
 The Any types provide highly flexible modeling of procedure
 parameters and
 table columns where the actual type is not known. These datatypes let
 you
 dynamically encapsulate and access type descriptions, data instances,
 and
 sets of data instances of any other SQL type. These types have OCI
 and
 PL/SQL interfaces for construction and access.
 
 
 SYS.AnyData
 This type contains an instance of a given type, with data, plus a
 description of the type. AnyData can be used as a table column
 datatype and
 lets you store heterogeneous values in a single column. The values
 can be of
 SQL built-in types as well as user-defined types.
 
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 1:09 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Okay, I'm working on what feels like 30 new projects all at once and
 I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but
 
 
 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?
 
 second (and this one confuses me a bit)... I've been asked if
 Oracle9i
 supports a variant datatype -- they are not familiar with oracle
 but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They
 referred
 me to C++ and Java, neither of which I know.
 
 Can anyone point in the right direction to start researching this?
 
 Thanks!
 
 Rachel
 
 
 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Toepke, Kevin M
   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: Toepke, Kevin M
   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

RE: UNDO


John - I am running a 9iR2 database. I figured that Oracle development might
have fixed undo by now, so I created the database using the automated Oracle
GUI tool. I notice that it left the SYSTEM rollback segment online. HTH.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L


All,

When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?  

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: a couple of questions


Dang. 

that means I might actually have to tell them we can do it :)

Rachel

--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
 Rachel:
  For a quick scoop on this sys.ANYDATA datatype, check current issue
 of
 Oracle Magazine (Jul/Aug).  Tom Kyte's column has neat information on
 the
 AnyDATA. But using it in SQL queries ain't the prettiest thing. 
 
 HTH,
 
 - Kirti 
 
  -Original Message-
  From:   Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, July 17, 2002 12:59 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: a couple of questions
  
  Rachel
  
  Check out the SYS.ANY datatype in Oracle 9i (from the SQL
 reference). Me
  thinks its what SQL server would call a variant data type. 
  
  Follow this link for more info
 

http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/
  toc.htm
  
  Kevin
  
  The Any types provide highly flexible modeling of procedure
 parameters
  and
  table columns where the actual type is not known. These datatypes
 let you
  dynamically encapsulate and access type descriptions, data
 instances, and
  sets of data instances of any other SQL type. These types have OCI
 and
  PL/SQL interfaces for construction and access.
  
  
  SYS.AnyData
  This type contains an instance of a given type, with data, plus a
  description of the type. AnyData can be used as a table column
 datatype
  and
  lets you store heterogeneous values in a single column. The values
 can be
  of
  SQL built-in types as well as user-defined types.
  
  
  -Original Message-
  Sent: Wednesday, July 17, 2002 1:09 PM
  To: Multiple recipients of list ORACLE-L
  
  
  Okay, I'm working on what feels like 30 new projects all at once
 and I
  WILL be RTFM'ing as soon as I can get more than 5 minutes out of
  meetings but
  
  
  first:  has anyone heard of any problems with 64-bit Oracle on a
  Solaris 64-bit OS?
  
  second (and this one confuses me a bit)... I've been asked if
 Oracle9i
  supports a variant datatype -- they are not familiar with oracle
 but
  are familiar with SQL Server and say that there is a datatype
 called
  variant there where you can basically overload the column with
  whatever datatype you want (string, number, date) and the database
  knows what type of data it is storing within the column. They
 referred
  me to C++ and Java, neither of which I know.
  
  Can anyone point in the right direction to start researching this?
  
  Thanks!
  
  Rachel
  
  
  __
  Do You Yahoo!?
  Yahoo! Autos - Get free new car price quotes
  http://autos.yahoo.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).
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Toepke, Kevin M
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!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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: (Fwd/2)


Mike - I think you are right. In fact, an author named Gary Rivlin wrote a
book named The Plot to Get Bill Gates: An Irreverent Investigation of the
World's Richest Man . . . and the People Who Hate Him. This thesis was just
what you describe, that many of Bill Gates competitors get themselves so
angry over Bill Gates that their actions aren't even in their own best
interests.
   Larry Ellison is a pretty suave, sophisticated person of no small ego,
and I've often thought he probably feels it unfair that Bill Gates who is
often characterized in the media as presenting a pretty nerdy image is the
computer industry's wealthiest figure. Naturally, when the media needs a
sound bite they only go to the top individual, which is Bill, rarely others
like Larry.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L


There are those that argue Apple provided competition
to Microsoft.   Not very good competition, but competition
nonetheless and so the monopoly argument goes out
the window.I agree Microsoft is substandard product,
especially with regard to the server based class.
However, the market place has spoken very clearly
and it is up to someone else to come and take away
some of Microsofts Pie !

In 1998, at Oracle OpenWorld, McNally and Ellision
completely trashed Microsoft and Bill Gates in one of
those open morning sessions.My thought at the time
was , instead of bitchin about them , why dont you
just go compete against them and put them out of 
business.

Well, its 2002 and Sun / Oracle now have 
major business problems and Microsoft just
seems to keep on truckin. I havent heard
much lately from Scott and Larry regarding
this issue.   Perhaps they are putting together
a good technical presentation for Openworld 
this year and that will give me a good
reason to go.

maybe I will hear good technical presentations 
instead of thoughtless meanderings and tirades about folks
they are obviously jeoulous of.

FWIW.

Mike

-Original Message-
Sent: Tuesday, July 16, 2002 3:19 PM
To: '[EMAIL PROTECTED]'


Hi Mike,

I just got a bit of a chuckle when you mentioned free market system and
Microsoft in the same breath.  Microsoft didn't get to be the biggest by
having the best product.  They got it from the best marketing and
unscrupulous and illegal business practices (tried to say that without using
the over-used Monopoly!).

Oracle can make claims that they are the best because they can actually
prove some or most those claims.  MS can't.  Sorry for sounding like a
whiner, but it's been a Microsoft day at it's best.  Multiple reboots for
everyone!  Yay!

OK, enough whining.  It's no fun when you can't whine/complain to someone
without having some brewskis!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

 -Original Message-
 From: Johnson, Michael [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, July 16, 2002 6:03 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: (Fwd/2)
 
 
 I would add to this ..
 
 In a free market system nobody should 
 look at the negative side when people make
 money off of their hard work or investments.
 This is the way it is set up.  
 
 Why not say  damn, how did he do
 it and where do I get in line to get
 some of that action ?
 
 I always find it interesting the envy and/or
 disgust that some folks have toward people
 who make alot of money. 
 
 Think of all the middle class people
 Larry Ellison and crew put to work who
 bought homes and cars to drive our economy.
 
 I didnt care for any of Larry and Scotts 
 bitchin and moanin about Microsoft and
 Bill Gates, but I say to Larry ..  More power
 to you to make more money, keep gettin richer 
 and help build our economy.  Keep on truckin !
 
 FWIW.
 
 Mike
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
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:

Re: a couple of questions


I'm going to try very hard to unremember (G) anything about ANY just
so I can tell them they can't get there from here.

Rachel

--- Tim Gorman [EMAIL PROTECTED] wrote:
 Rachel,
 
 This variant datatype sounds a lot like the union data structure
 from
 C language, which closely resembled a struct (i.e. record) but
 all of
 the fields overlap the same memory address.  In other words, it was
 a
 mechanism for type re-casting.  In the grand tradition of robust
 programming
 languages, there are about a dozen and a half ways to do this in C,
 and
 the union structure is one of the less popular.  Luckily, it is
 difficult
 to use for any other purpose...
 
 Not so with what you're describing.  Sounds like a feature which is
 ripe for
 all kinds of abuse.  I can just imagine entire tables populated with
 columns
 of type VARIANT by some designer touting flexibility as a mantra.
 Fortunately, Oracle developers can use the RAW datatype in the same
 fashion,
 and it is interesting to note (but perhaps not coincidental) that
 most C
 programmers tend to favor a similar mechanism (i.e. void pointers)
 for
 type re-casting too.  In other words, be assured that VARIANT is not
 the
 only way to get the job done, and might prove unpopular anyway...
 
 Just my $0.02...
 
 -Tim
 
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, July 17, 2002 11:08 AM
 
 
  Okay, I'm working on what feels like 30 new projects all at once
 and I
  WILL be RTFM'ing as soon as I can get more than 5 minutes out of
  meetings but
 
 
  first:  has anyone heard of any problems with 64-bit Oracle on a
  Solaris 64-bit OS?
 
  second (and this one confuses me a bit)... I've been asked if
 Oracle9i
  supports a variant datatype -- they are not familiar with oracle
 but
  are familiar with SQL Server and say that there is a datatype
 called
  variant there where you can basically overload the column with
  whatever datatype you want (string, number, date) and the database
  knows what type of data it is storing within the column. They
 referred
  me to C++ and Java, neither of which I know.
 
  Can anyone point in the right direction to start researching this?
 
  Thanks!
 
  Rachel
 
 
  __
  Do You Yahoo!?
  Yahoo! Autos - Get free new car price quotes
  http://autos.yahoo.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).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Tim Gorman
   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!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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: Index questions

2002-07-17 Thread Greg Moore




 If we have a column of 'Y','N' values, the index will
 not help with CBT(usually most of the values are 'N').

 My question is : how about bitmap indexes? Should it
 help a lot, or just a little bit?

The issue you are dealing with is skewed data.  Most rows have 'N', a few
have 'Y'.  Your data is not evenly distributed ... it's skewed.

Bitmap indexes are a solution, but not a solution for this issue.  What you
are looking for is histograms.  If they won't work for you (because you're
using bind variables) an alternate solution is to code two SQL's in PL/SQL
using an IF statement ... IF :x = 'N' then ... execute the SQL that's hinted
to not use the index, ELSE execute the SQL that's hinted to use the index.

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

OTN discount for OCP exams

2002-07-17 Thread Djordje Jankovic


Anybody knows the OTN promotion for code for the Prometric OCP exam
discounts.  The discount should be 20%.

Apparently one can get that from OTN - that what a representative from
Oracle University told me - but you send an e-mail and you wait few days,
which  would like to avoid.

Thanks.

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

2002-07-17 Thread Fink, Dan


John,
The system rollback segment must be kept online for use by the
kernel calls (recursive sql). I admit that I have never tried taking it
offline in automatic undo mode, so I'm not sure exactly what would happen.
However, my educated guess is that it would not be pretty!

Dan Fink

-Original Message-
Sent: Wednesday, July 17, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L


All,

When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?  

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: Fink, Dan
  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: UNDO

2002-07-17 Thread John Weatherman


I've noticed the create tool for R1/2 seem to leave the segment on-line.  I
just wondered if it were an oversight and I need to clean it up or if it's
being used by Oracle itself for some strange reason/under some
circumstances.  If the latter, I'd really like to know when before it bites
me. :)

Regards,

John P Weatherman
Database Administrator
Replacements Ltd.



-Original Message-
Sent: Wednesday, July 17, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L


John - I am running a 9iR2 database. I figured that Oracle development might
have fixed undo by now, so I created the database using the automated Oracle
GUI tool. I notice that it left the SYSTEM rollback segment online. HTH.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L


All,

When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?  

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: John Weatherman
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS | IAS vs. Locally-built Apache


This is Oracle9i Application Server Version 1.0.2.2.3a for NT.
So, I'm guessing this is iAS. I have a hard enough time keeping
up with Oracle marketing's changing the names/version of Oracle Net,
parallel server, and MTS every opportunity they get!!

RF



Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, July 17, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L


It really OAS and not iAS?  If it is, you need to upgrade your software.
There is  a published exploit against  the version of Apache used by
Oracle's latest iAS release.  Oracle has released a patch which stops the
exploit

I have built Oracle web servers for years, but I am now of the mind that
these things should not be built by DBA's but by webmasters. 

I am undecided whether to one should go with iAS or construct your own with
Apache.  The mod_plsql module for instance was not created by Oracle.  It
and things  such as forms server and reports server will run against such a
construction. 

However, we were advised last week that the  Windows NT machines will be
converted to XP  this year.  As a result, I  started to look at  the 9i
Internet Developer Suite.  About every third line is a statement to the
effect that the 9i database, 9 iAS, and 9 iDS are made to work together.  I
haven't figured out what one is giving up if one builds their own web server
and also installs components for the 9 iAS distribution.  Is it just
convenience?

One reason for giving up the convenience is security.  An exploit is
discovered and possibly published.  Apache fixes the problem.  If I have
built my own I can get the patch from Apache and  rebuild the web server.
If I'm wedded to iAS I need to wait for Oracle to  incorporate the patch
into its offering.  This could be a matter days to over a week.  However
weighing-in on the 9 iAS side is the ease of installing a fix.  The Apache
fix  for the aforementioned problem required  a rebuild; you need someone
wise in the ways of make files and such.   The 9 iAS fix was a simple file
replacement.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 17, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Folks,
 
I'm a DBA who is really an old developer at heart. I know a little Java, a
little Asp
(enough, as they say, to be really dangerous!), I used to do C code that now
makes 
my head swim to look at. (I think to myself, what the devil was I doing??)
 
Anyway, I've finally found some time and a machine here at work to start
playing with
OAS just to see what it's all about. Anyone have any good suggestions with
regards 
to:
 
1. Sites, books, white papers and the like with good install tips, hints,
warnings and the like.
2. Sites, books, white papers and the like Quick getting started tips.
3. Your own getting started experiences of things to do or not to do.
5. Anything I should do before I mess with OAS.
 
Optimistically hopeful that this will all just go really smooth and I'll
have a cool
web page that I can bring up soon!
 
RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert
  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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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

To

Linux SuSe question?

2002-07-17 Thread Khedr, Waleed


Is the downloadable version of SuSe Linux good to run Oracle or should I buy
it from the store?

This is for my own research.

Thanks

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS


Lot's to consider unfortunately I'm running it on NT ... :-))

Might ought have mentioned that. :-))

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, July 17, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L


No books or tips.  Just my recent experience *trying*
to install 9iAS R2 (I hope that's what you meant when
you wrote OAS).

I downloaded 9iAS J2EE and Web Cache for Solaris and
HP-UX.

Oracle recommends about 1GB ram, 1GB swap and lots of
free disk space.  Anyway, my target Solaris box had
500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
the ideal platform.  On the HP-UX box, I had 3GB ram,
a 2 CPU L class machine, lots of swap and lots of
disk.

In any case, what I learned is that root privs are
vital.  Had them on the Solaris box but not on the
HP-UX machine.  The installs in both cases where
fairly standard.  I had ran through them quite a few
times on both servers.  On Solaris becuase of resource
issues and HP-UX because of root permission issues.

There are two types of installs.  A mid-tier (less
config, easier, fewer components) and an
infrastructure (more config, more components, needs a
database repoistory).  I did the mid-tier install in
both cases.

Make sure you have JDK 1.3 or later installed.

Before the install for mid-tier in particular, export
ORACLE_SID=iasdb even if you do not intend to use a
repository or have a database.

I created a separate ORACLE_HOME for my install.

Also, Oracle recommends that you use hostnames, so
naming methods should reflect hostname.com instead of
123.45.67.8.  

During the install, you will be asked for a password
for the Eterprise Manager website.  NOTE IT DOWN!!! 
You'll need it to start and stop the EM website. 
Oracle recommends that you start and stop services via
the EM website and not the command line and I'll go
along with this since I had trouble shutting down
services via the command line (sometime it worked and
sometime it did'nt).

Also, during the install when prompted to run the
root.sh script, run as root since this script starts
the Apache httpd daemons.  These need to be started as
root.  It does a bunch of other config things aswell. 
See root.sh.  This is vital since after the install is
complete, the installer then configures the components
such web cache, OC4J components, Apache config etc. 
This is the problem I was having on HP-UX, late in the
day, govt client, sysadmin has left the building.

Ok, after the install has completed and started all
the services (hoepfully), you need to apply all
relevant patches.  For the mid tier install, install
the patch in the following order:

9.0.1.3 patch set
RDBMS bundled patch
Oracle Internet Directory path
Oracle HTTP server patch

You'll see this in the install notes for the patch. 
Note that the RDBMS bundled patch is slightly
different on HP-UX versus Solaris.  Just read the
instructions carefully if you are on HP-UX.  Solaris
was a little easier.

After the patch, you can login to the EM website at
http://myhostname.com:1810.  If the website does not
come up, you can start it from the prompt using emctl
start|stop|status.  Stopping requires password which
was entered earlier during install.  Password can also
be changed using emctl set password pwd.

Using the website, you can/start stop other services
such as web cache, BC4J, OC4J containers etc.

The default website can be accessed (hopefully) at
http://myhostname.com:

Also, you can start|stop the httpd daemons from the
command line from $ORACLE_HOME/dcm/bin/dcmctl
start|stop -ct ohs if the EM website is inaccessible
for some reason.  Again, Oracle recommends that you do
all admin through EM the website.

Similarly, web cache can be started/stopped from the
prompt by webcachectl start|stop|status.

Finally, just a couple days ago, we seemed to have
trouble starting 9iAS.  Seems like some log files had
their ownership changed.  Don't know how this
happened.  My guess is some sort of bug.  The way I
tracked this is tailing the logs while trying to start
the server.  Since I could'nt get the EM website up, I
had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.

Useful logs were:
$ORACLE_HOME/opmn/logs/ons.log and ipm.log
$ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
and of cource
$ORACLE_HOME/Apache/Apache/logs/error_log and
access_log

hth

mkb

--- Freeman, Robert [EMAIL PROTECTED] wrote:
 Folks,
  
 I'm a DBA who is really an old developer at heart. I
 know a little Java, a
 little Asp
 (enough, as they say, to be really dangerous!), I

RE: OTN discount for OCP exams

2002-07-17 Thread Sherman, Edward


I took a test last Monday with promotion code OPP and got 30% off (cost
$80.00 USD)

Somebody mentioned it before on this list.

Thank you whoever that was!

-Original Message-
Sent: Wednesday, July 17, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L


Anybody knows the OTN promotion for code for the Prometric OCP exam
discounts.  The discount should be 20%.

Apparently one can get that from OTN - that what a representative from
Oracle University told me - but you send an e-mail and you wait few days,
which  would like to avoid.

Thanks.

Djordje
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  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: Sherman, Edward
  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: UNDO


An attempt to take the system tablespace offline, while in automated undo
mode, will result in a hologram of Larry appearing and then he slaps you
upside the head. This is followed by the more typical ORA-01597: Cannot
alter system rollback segment online or offline. Just one of those nice new
Oracle9i Release 2 features.

RF

Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i  (Sybex)

Clark Griswold: Eddie, has anyone ever told you that you're bad luck?
Cousin Eddie: Those were my mother's dying words. But I
guess if your body's covered in third degree burns, and 
your foot's caught in a bear trap, you tend to start talkin' 
crazy.



-Original Message-
Sent: Wednesday, July 17, 2002 4:52 PM
To: Multiple recipients of list ORACLE-L


John,
The system rollback segment must be kept online for use by the
kernel calls (recursive sql). I admit that I have never tried taking it
offline in automatic undo mode, so I'm not sure exactly what would happen.
However, my educated guess is that it would not be pretty!

Dan Fink

-Original Message-
Sent: Wednesday, July 17, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L


All,

When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?  

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  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: Fink, Dan
  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: Freeman, Robert
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: a couple of questions


Richard - I can't answer how we got 32 bit Oracle on Solaris by default.
Currently my sys admin is handling installs. I think he had only one version
and its' bitness wasn't labeled. 
   One day someone on this list asked how to tell whether the version
installed was 32 or 64 bit. Several other people provided methods. Slow day,
so I tried them. Turned out we were using 32-bit. We have been on Compaq
Tru64 for many years and this isn't an issue there (only 64 bit), so we
probably just hadn't particularly thought the issue through. I just figured
that if one person ran into that, others might also. 
   I also assumed that if there is a 32 bit and 64 bit versions, the obvious
choice would be to go for 64 bit. That has always been the answer for other
applications and platforms I've dealt with, once the better version is
available there is no looking back. But then this morning Brian McGraw said
that he always used the 32 bit version and provided good reasons. So part of
me is asking how long has 64 bit Solaris been available? (a few years for
sure), and do Solaris types just love 32 bit or what ??.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L


How do u get 32 bit by default?  The 32bit and 64bit Oracle came as
separate CDs.  Am I missing something?

Richard

-Original Message-
Sent: Wednesday, July 17, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.

Oracle does have user-defined data types if that helps.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


Okay, I'm working on what feels like 30 new projects all at once and I
WILL be RTFM'ing as soon as I can get more than 5 minutes out of
meetings but


first:  has anyone heard of any problems with 64-bit Oracle on a
Solaris 64-bit OS?

second (and this one confuses me a bit)... I've been asked if Oracle9i
supports a variant datatype -- they are not familiar with oracle but
are familiar with SQL Server and say that there is a datatype called
variant there where you can basically overload the column with
whatever datatype you want (string, number, date) and the database
knows what type of data it is storing within the column. They referred
me to C++ and Java, neither of which I know.

Can anyone point in the right direction to start researching this?

Thanks!

Rachel


__
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.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).
-- 
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: Ji, Richard
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat

Robert Freeman - RMAN Resources

2002-07-17 Thread Post, Ethan


Robert,

Wondering if you would mind posting some of the best resources for RMAN that
you have found besides the documentation.  I have a request from someone who
is a newbie to track down some info, I would recommend your book if it was
out yet :)

Thanks,
Ethan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OT - unix vs linux vs windows - the future

2002-07-17 Thread Rodd Holman





Actually I have done much the same as Joe. I run RedHat 7.3, Oracle9i for Linux, OpenOffice,

and Ximian Evolution (www.ximian.com). I have a Windows box that I sync my Handspring with

to get my Exchange schedule and then use gpilotd to sync with Evolution and run my calendar

off of Linux. I use IMAP to connect Evolution to my Exchange folders. The exchange stuff

is just so I can share with the company. Once the company upgrades to Exchange 2000 I

will investigate using Ximian Connector for Exchange and get rid of my Windows box completely.



Rodd Holman



On Tue, 2002-07-16 at 11:09, Orr, Steve wrote:

Wow Joe, sounds like a religious conviction... 
I'm impressed because I'm of the same persuasion but I'm not quite so
pious/zealous and am still somewhat enslaved to the M$ beast/devil because
of the company usage of Exchange with MS Outlook for Calendar and workflow.
I run Linux on the laptop via VMWare but because of the Outlook dependency,
running Pine, Mozilla or whatever is not a viable email solution for me.
Sigh...

Having run Oracle/Linux servers in production for over a year now I conclude
that the platform is not just viable but is promising. Unix, Linux, and
Windows are part the present with significant installed bases so that also
means they will be part of the future. How long that future will be and how
much future presence there will be is anybody's guess I guess. 

Good and Evil abound.  :-)
Steve Orr



-Original Message-
Sent: Monday, July 15, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L


Thats were you're wrong, i dont use microsoft products, all of my 
development and presentations that i make are non microsoft products.

for IOUG presentations, requirement is to put them in msword and 
powerpoint, i convert from star office to those formatrs and have 
someone proof them so i know the conversion went ok.

so NO I DONT PIRATE software, dont need to since all that i run is free.

And yes feel free to look at the headers of this email, its from mozilla 
on linux. :)

selling my IT manager is easy on linux, since I'm the CTO of Data 
Management Consulting, and selling using linux for development is just 
as easy at client sites.

Outradeious prices absolutely but everywhere i've been they've already 
had oracle in-house so there was no selling to do.

joe


ltiu wrote:

Oracle. It's only free during development/education. Charges will be 
exhorbitant when getting production licenses.

Windows and SQL Server is free too - if you pirate, right? It's what every 
one does : 

Linux is free but trying to sell this to your IT manager is not.

On Sunday 14 July 2002 12:43, Joe Testa wrote:

I dont think the classic unix that you speak of will go away that
fast, too many solaris/aix/hpux machines floating around still.

I do any development/testing of features on linux, it cost me nothing
but the hardware.

RH 7.3 downloaded,  no cost.

technet member 9ir2 oracle downloaded, no cost.

it only makes sense.

joe

Andrey Bronfin wrote:

hi !
i might start another war , but i can't resist a part of me which wants
to
ask :
what do you , seasoned gurus, think of everybody's (as it seems to be)
plans to abandon the classic unix for linux ?
In particular , most database vendors (as well as other enterprise
software vendors) name linux as the future #1 platform for their DBs
(especially given the fact that a DB cluster is not rare any more).
It also looks like many development shops shift their efforts to develop
on windows (or , in some rare cases, linux ) instead of unix .
What do you think about this ?


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Linux SuSe question?

2002-07-17 Thread Grabowy, Chris


The download takes forever because you have to download each and every
single file...unlike RH

You can buy it for 30 bucks.  I think the enterprise version is like 90
dollars.  

-Original Message-
Sent: Wednesday, July 17, 2002 5:09 PM
To: Multiple recipients of list ORACLE-L


Is the downloadable version of SuSe Linux good to run Oracle or should I buy
it from the store?

This is for my own research.

Thanks

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OTN discount for OCP exams

2002-07-17 Thread Djordje Jankovic


Thanks.  

I tried it but they, Prometric, asked me whether my company is the member of
the Oracle Partner Program (which OPP stands for) :-( ?

Djordje

 -Original Message-
 From: Sherman, Edward [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 5:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OTN discount for OCP exams
 
 
 I took a test last Monday with promotion code OPP and got 30% 
 off (cost
 $80.00 USD)
 
 Somebody mentioned it before on this list.
 
 Thank you whoever that was!
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 4:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Anybody knows the OTN promotion for code for the Prometric OCP exam
 discounts.  The discount should be 20%.
 
 Apparently one can get that from OTN - that what a representative from
 Oracle University told me - but you send an e-mail and you 
 wait few days,
 which  would like to avoid.
 
 Thanks.
 
 Djordje
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Djordje Jankovic
   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: Sherman, Edward
   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: Djordje Jankovic
  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: OTN discount for OCP exams

2002-07-17 Thread Erik Williams


Who do you send the email to? I would like to take advantage of the offer
and dont mind waiting a few days. I dont see anything on the home page about
a discount.

Thanks
Erik


 -Original Message-
 From: Djordje Jankovic [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 4:59 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  OTN discount for OCP exams
 
 Anybody knows the OTN promotion for code for the Prometric OCP exam
 discounts.  The discount should be 20%.
 
 Apparently one can get that from OTN - that what a representative from
 Oracle University told me - but you send an e-mail and you wait few days,
 which  would like to avoid.
 
 Thanks.
 
 Djordje
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Djordje Jankovic
   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: Erik 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:OT: Just a laff! Gates gooses geese guano gunners


Yeah for the Geese!!  What did the fool think, building on a lake like that? 
Lakes are full of water, bodies of water attract geese.  Geese, well their
geese.  They got to do it somewhere  where ever they are is good enough for
them.  Bombs Away!!

Dick Goulet

Reply Separator
Author: John Kanagaraj [EMAIL PROTECTED]
Date:   7/17/2002 12:04 PM

Hi all,

Just LOL!

John Kanagaraj

THE MISSING LINK | Gates gooses geese guano gunners

Penguins may be after Bill Gates' Windows, but geese have his windows
in their scopes. And his roof. And his yard. Gaggles of waterfowl
think Mr. Microsoft's mansion is the perfect place to leave their
calling cards. Evidently these goose droppings are giving Gates
goosebumps. He asked wildlife officials in Washington state to do
something about the problem. Now the chief park ranger has the green
light to go on a massive bird hunt. Some 4,000 geese could get their
gooses cooked thanks to their scatological sorties. If you're a Linux
lover, go ahead and yell it: Go geese, go geese!

Source: vnunet
http://www.vnunet.com/News/1133586

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS

2002-07-17 Thread mkb


Just checked my current config again on Solaris.  ps
-ef shows me two httpd processes owned by root and 10
that I assume are spawned via these as oracle.

Also see 2 dwhttpd running under daemon.

I assume it is under port 80 since I have not changed
the httpd.conf file.

Yes, I guess you are right, these should run under
nobody, but these are my first steps into setting this
up and so I installed it as-is.  No tweaks.

mkb

--- MacGregor, Ian A. [EMAIL PROTECTED] wrote:
 The httpd daemons need to be started as root?  Since
 when?  Is it because you're using the standard HTTP
 PORT OF 80?  Starting these daemons under the nobody
 account is much safer.
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 10:49 AM
 To: Multiple recipients of list ORACLE-L
 
 
 No books or tips.  Just my recent experience
 *trying*
 to install 9iAS R2 (I hope that's what you meant
 when
 you wrote OAS).
 
 I downloaded 9iAS J2EE and Web Cache for Solaris and
 HP-UX.
 
 Oracle recommends about 1GB ram, 1GB swap and lots
 of
 free disk space.  Anyway, my target Solaris box had
 500MB swap, 256MB ram and a 400 MhZ SparcII CPU. 
 Not
 the ideal platform.  On the HP-UX box, I had 3GB
 ram,
 a 2 CPU L class machine, lots of swap and lots of
 disk.
 
 In any case, what I learned is that root privs are
 vital.  Had them on the Solaris box but not on the
 HP-UX machine.  The installs in both cases where
 fairly standard.  I had ran through them quite a few
 times on both servers.  On Solaris becuase of
 resource
 issues and HP-UX because of root permission issues.
 
 There are two types of installs.  A mid-tier (less
 config, easier, fewer components) and an
 infrastructure (more config, more components, needs
 a
 database repoistory).  I did the mid-tier install in
 both cases.
 
 Make sure you have JDK 1.3 or later installed.
 
 Before the install for mid-tier in particular,
 export
 ORACLE_SID=iasdb even if you do not intend to use a
 repository or have a database.
 
 I created a separate ORACLE_HOME for my install.
 
 Also, Oracle recommends that you use hostnames, so
 naming methods should reflect hostname.com instead
 of
 123.45.67.8.  
 
 During the install, you will be asked for a password
 for the Eterprise Manager website.  NOTE IT DOWN!!! 
 You'll need it to start and stop the EM website. 
 Oracle recommends that you start and stop services
 via
 the EM website and not the command line and I'll go
 along with this since I had trouble shutting down
 services via the command line (sometime it worked
 and
 sometime it did'nt).
 
 Also, during the install when prompted to run the
 root.sh script, run as root since this script starts
 the Apache httpd daemons.  These need to be started
 as
 root.  It does a bunch of other config things
 aswell. 
 See root.sh.  This is vital since after the install
 is
 complete, the installer then configures the
 components
 such web cache, OC4J components, Apache config etc. 
 This is the problem I was having on HP-UX, late in
 the
 day, govt client, sysadmin has left the building.
 
 Ok, after the install has completed and started all
 the services (hoepfully), you need to apply all
 relevant patches.  For the mid tier install, install
 the patch in the following order:
 
 9.0.1.3 patch set
 RDBMS bundled patch
 Oracle Internet Directory path
 Oracle HTTP server patch
 
 You'll see this in the install notes for the patch. 
 Note that the RDBMS bundled patch is slightly
 different on HP-UX versus Solaris.  Just read the
 instructions carefully if you are on HP-UX.  Solaris
 was a little easier.
 
 After the patch, you can login to the EM website at
 http://myhostname.com:1810.  If the website does not
 come up, you can start it from the prompt using
 emctl
 start|stop|status.  Stopping requires password which
 was entered earlier during install.  Password can
 also
 be changed using emctl set password pwd.
 
 Using the website, you can/start stop other services
 such as web cache, BC4J, OC4J containers etc.
 
 The default website can be accessed (hopefully) at
 http://myhostname.com:
 
 Also, you can start|stop the httpd daemons from the
 command line from $ORACLE_HOME/dcm/bin/dcmctl
 start|stop -ct ohs if the EM website is inaccessible
 for some reason.  Again, Oracle recommends that you
 do
 all admin through EM the website.
 
 Similarly, web cache can be started/stopped from the
 prompt by webcachectl start|stop|status.
 
 Finally, just a couple days ago, we seemed to have
 trouble starting 9iAS.  Seems like some log files
 had
 their ownership changed.  Don't know how this
 happened.  My guess is some sort of bug.  The way I
 tracked this is tailing the logs while trying to
 start
 the server.  Since I could'nt get the EM website up,
 I
 had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct
 ohs.
 
 Useful logs were:
 $ORACLE_HOME/opmn/logs/ons.log and ipm.log
 $ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/

SQL Join or Subquery

2002-07-17 Thread Gary Chambers


All...

I have a question about a query over which I've been racking my brain
for weeks, and I can't find a reference to adequately assist me.

Given a table of temperature sensors, and a table of readings from those
sensors, how might I grab the max (hence latest or current) temperature
reading for each sensor?  The relevant fields in the tables are
timestamp and temp_c (temperature table), and sensorid (both temperature
and sensor tables).

I'm fairly certain that I'm overlooking something very elementary, and I
feel it should be simple and straightforward, but I think I'm being
stymied by the use of aggregate functions in my query.  I can provide
examples of my failed attempts, if you'd like.  Thanks in advance for
any assistance you can provide.

Gary Chambers

//-
// Lucent Technologies GIO/Unix
// 4 Robbins Road, Westford, MA 01886
// 978-399-0481 / 888-480-6924 (Pager)
// Nothing fancy and nothing Microsoft
//-


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

2002-07-17 Thread Danisment Gazi Unal (ubTools)


Hello Fink,

I guess you meant recursive transaction. Because, user SQLs in stored codes
run as recursive SQLs, but they are not recursive transactions.

Recursive transactions don't have to be use SYSTEM rollback segment. If the
RBS of parent statement can not be binded to its recursive transaction, Oracle
assigns SYSTEM rbs to recursive transaction. Otherwise, recursive transaction
use same RBS with its parent. In other words, SYSTEM rbs is the last resort.

regards...

Fink, Dan wrote:

 John,
 The system rollback segment must be kept online for use by the
 kernel calls (recursive sql). I admit that I have never tried taking it
 offline in automatic undo mode, so I'm not sure exactly what would happen.
 However, my educated guess is that it would not be pretty!

 Dan Fink

 -Original Message-
 Sent: Wednesday, July 17, 2002 2:14 PM
 To: Multiple recipients of list ORACLE-L

 All,

 When using automated UNDO in 9iR1, should the system rollback segment
 normally be left offline?

 TIA,

 John P Weatherman
 Database Administrator
 Replacements Ltd.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: John Weatherman
   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: Fink, Dan
   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).

--
Danisment Gazi Unal
http://www.ubTools.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: A DBA looks at OAS

2002-07-17 Thread Scott . Shafer


Thanks, mkb.  I'm installing 9.0.2 now on HPUX.  Good info.

Scott Shafer
San Antonio, TX
210-581-6217


 -Original Message-
 From: mkb [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 12:49 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: A DBA looks at OAS
 
 No books or tips.  Just my recent experience *trying*
 to install 9iAS R2 (I hope that's what you meant when
 you wrote OAS).
 
 I downloaded 9iAS J2EE and Web Cache for Solaris and
 HP-UX.
 
 Oracle recommends about 1GB ram, 1GB swap and lots of
 free disk space.  Anyway, my target Solaris box had
 500MB swap, 256MB ram and a 400 MhZ SparcII CPU.  Not
 the ideal platform.  On the HP-UX box, I had 3GB ram,
 a 2 CPU L class machine, lots of swap and lots of
 disk.
 
 In any case, what I learned is that root privs are
 vital.  Had them on the Solaris box but not on the
 HP-UX machine.  The installs in both cases where
 fairly standard.  I had ran through them quite a few
 times on both servers.  On Solaris becuase of resource
 issues and HP-UX because of root permission issues.
 
 There are two types of installs.  A mid-tier (less
 config, easier, fewer components) and an
 infrastructure (more config, more components, needs a
 database repoistory).  I did the mid-tier install in
 both cases.
 
 Make sure you have JDK 1.3 or later installed.
 
 Before the install for mid-tier in particular, export
 ORACLE_SID=iasdb even if you do not intend to use a
 repository or have a database.
 
 I created a separate ORACLE_HOME for my install.
 
 Also, Oracle recommends that you use hostnames, so
 naming methods should reflect hostname.com instead of
 123.45.67.8.  
 
 During the install, you will be asked for a password
 for the Eterprise Manager website.  NOTE IT DOWN!!! 
 You'll need it to start and stop the EM website. 
 Oracle recommends that you start and stop services via
 the EM website and not the command line and I'll go
 along with this since I had trouble shutting down
 services via the command line (sometime it worked and
 sometime it did'nt).
 
 Also, during the install when prompted to run the
 root.sh script, run as root since this script starts
 the Apache httpd daemons.  These need to be started as
 root.  It does a bunch of other config things aswell. 
 See root.sh.  This is vital since after the install is
 complete, the installer then configures the components
 such web cache, OC4J components, Apache config etc. 
 This is the problem I was having on HP-UX, late in the
 day, govt client, sysadmin has left the building.
 
 Ok, after the install has completed and started all
 the services (hoepfully), you need to apply all
 relevant patches.  For the mid tier install, install
 the patch in the following order:
 
 9.0.1.3 patch set
 RDBMS bundled patch
 Oracle Internet Directory path
 Oracle HTTP server patch
 
 You'll see this in the install notes for the patch. 
 Note that the RDBMS bundled patch is slightly
 different on HP-UX versus Solaris.  Just read the
 instructions carefully if you are on HP-UX.  Solaris
 was a little easier.
 
 After the patch, you can login to the EM website at
 http://myhostname.com:1810.  If the website does not
 come up, you can start it from the prompt using emctl
 start|stop|status.  Stopping requires password which
 was entered earlier during install.  Password can also
 be changed using emctl set password pwd.
 
 Using the website, you can/start stop other services
 such as web cache, BC4J, OC4J containers etc.
 
 The default website can be accessed (hopefully) at
 http://myhostname.com:
 
 Also, you can start|stop the httpd daemons from the
 command line from $ORACLE_HOME/dcm/bin/dcmctl
 start|stop -ct ohs if the EM website is inaccessible
 for some reason.  Again, Oracle recommends that you do
 all admin through EM the website.
 
 Similarly, web cache can be started/stopped from the
 prompt by webcachectl start|stop|status.
 
 Finally, just a couple days ago, we seemed to have
 trouble starting 9iAS.  Seems like some log files had
 their ownership changed.  Don't know how this
 happened.  My guess is some sort of bug.  The way I
 tracked this is tailing the logs while trying to start
 the server.  Since I could'nt get the EM website up, I
 had to use $ORACLE_HOME/dcm/bin/dcmctl start -ct ohs.
 
 Useful logs were:
 $ORACLE_HOME/opmn/logs/ons.log and ipm.log
 $ORACLE_HOME/dcm/logs/emd_logs/ and dcmctl_logs/
 and of cource
 $ORACLE_HOME/Apache/Apache/logs/error_log and
 access_log
 
 hth
 
 mkb
 
 --- Freeman, Robert [EMAIL PROTECTED] wrote:
  Folks,
   
  I'm a DBA who is really an old developer at heart. I
  know a little Java, a
  little Asp
  (enough, as they say, to be really dangerous!), I
  used to do C code that now
  makes 
  my head swim to look at. (I think to myself, what
  the devil was I doing??)
   
  Anyway, I've finally found some time and a machine
  here at work to start
  playing with
  OAS just to see what it's all about. Anyone have any
  good

RE: Robert Freeman - RMAN Resources


Ethan
I'm not Robert, but the newby book he recommended to me is Oracle
Backup  Recovery 101 by Smith and Haisley. About half of it is devoted to
RMAN.  Would have saved me a lot of time when I started, but it hadn't been
published then.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, July 17, 2002 4:35 PM
To: Multiple recipients of list ORACLE-L


Robert,

Wondering if you would mind posting some of the best resources for RMAN that
you have found besides the documentation.  I have a request from someone who
is a newbie to track down some info, I would recommend your book if it was
out yet :)

Thanks,
Ethan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  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: OTN discount for OCP exams

2002-07-17 Thread Sherman, Edward


So _that's_ what OPP stands for!

I registered online at http://www.2test.com
I just put the promotion code in the little text box.

Don't have to talk to anyone that way or answer questions.

If its your first time online you might have to go through an annoying
registration process though.

OPP worked for me. Haven't gotten my credit card bill yet though :-)

Cheers

-Original Message-
Sent: Wednesday, July 17, 2002 5:41 PM
To: Multiple recipients of list ORACLE-L


Thanks.  

I tried it but they, Prometric, asked me whether my company is the member of
the Oracle Partner Program (which OPP stands for) :-( ?

Djordje

 -Original Message-
 From: Sherman, Edward [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 5:09 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OTN discount for OCP exams
 
 
 I took a test last Monday with promotion code OPP and got 30%
 off (cost
 $80.00 USD)
 
 Somebody mentioned it before on this list.
 
 Thank you whoever that was!
 
 -Original Message-
 Sent: Wednesday, July 17, 2002 4:59 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Anybody knows the OTN promotion for code for the Prometric OCP exam 
 discounts.  The discount should be 20%.
 
 Apparently one can get that from OTN - that what a representative from 
 Oracle University told me - but you send an e-mail and you wait few 
 days, which  would like to avoid.
 
 Thanks.
 
 Djordje
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Djordje Jankovic
   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: Sherman, Edward
   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: Djordje Jankovic
  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: Sherman, Edward
  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: GZip/WinZip...hot backups...

2002-07-17 Thread Jared . Still


You may want to investigate 'sparse files' on MetaLink, as some 
compression
utilities could cause problems.

Jared





Grabowy, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/17/2002 12:23 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:GZip/WinZip...hot backups...


A fellow DBA had mentioned that during his disaster recovery test, gzip 
had
unzipped his Solaris files but did not restore the .dbf extension.  Thus
leaving him to manually rename his files to include a .dbf extension.  He
examined the gzip man pages but could not find any flags to set or 
anything
to help.  Has anyone else encountered this?  Ideas?

During a hot backup, on W2K platform, he uses WinZip to backup/compress 
all
the datafiles into one large backup file.  Has anyone encountered any
problems with using this approach?  Versus using the ocopy or copy 
command?
He mentioned that on occasion he gets an error message from WinZip that 
the
file was open, but everything seems to work.

Many thanks in advance!!!

Chris



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: a couple of questions

2002-07-17 Thread Jared . Still


 Not so with what you're describing.  Sounds like a feature which is ripe 
for
 all kinds of abuse.  I can just imagine entire tables populated with 
columns
 of type VARIANT by some designer touting flexibility as a mantra.

I can see it now:

one table in a database
two columns, one for primary key, the other for data
( of type ANY of course )
all on one server
all disk striped a SAME structure as a series of RAID 5 arrays.

No DBA?

Hell, you don't even need a duhveloper, just use the ODBC 
interface in MS Excel.

Jared






Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/17/2002 12:35 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: a couple of questions


Rachel,

This variant datatype sounds a lot like the union data structure from
C language, which closely resembled a struct (i.e. record) but all of
the fields overlap the same memory address.  In other words, it was a
mechanism for type re-casting.  In the grand tradition of robust 
programming
languages, there are about a dozen and a half ways to do this in C, and
the union structure is one of the less popular.  Luckily, it is 
difficult
to use for any other purpose...

Not so with what you're describing.  Sounds like a feature which is ripe 
for
all kinds of abuse.  I can just imagine entire tables populated with 
columns
of type VARIANT by some designer touting flexibility as a mantra.
Fortunately, Oracle developers can use the RAW datatype in the same 
fashion,
and it is interesting to note (but perhaps not coincidental) that most C
programmers tend to favor a similar mechanism (i.e. void pointers) for
type re-casting too.  In other words, be assured that VARIANT is not the
only way to get the job done, and might prove unpopular anyway...

Just my $0.02...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:08 AM


 Okay, I'm working on what feels like 30 new projects all at once and I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but


 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?

 second (and this one confuses me a bit)... I've been asked if Oracle9i
 supports a variant datatype -- they are not familiar with oracle but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They referred
 me to C++ and Java, neither of which I know.

 Can anyone point in the right direction to start researching this?

 Thanks!

 Rachel


 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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).

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

Re: a couple of questions

2002-07-17 Thread Peter . McLarty


Sheesh Has Oracle employed some MS developers, sure sounds like one of 
there brain dead ideas :-)

Cheers


--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

- Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision

=

This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 






[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
17-07-2002 03:14 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Fax to: 
Subject:Re: a couple of questions


 Not so with what you're describing.  Sounds like a feature which is ripe 

for
 all kinds of abuse.  I can just imagine entire tables populated with 
columns
 of type VARIANT by some designer touting flexibility as a mantra.

I can see it now:

one table in a database
two columns, one for primary key, the other for data
( of type ANY of course )
all on one server
all disk striped a SAME structure as a series of RAID 5 arrays.

No DBA?

Hell, you don't even need a duhveloper, just use the ODBC 
interface in MS Excel.

Jared






Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/17/2002 12:35 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
cc: 
Subject:Re: a couple of questions


Rachel,

This variant datatype sounds a lot like the union data structure from
C language, which closely resembled a struct (i.e. record) but all of
the fields overlap the same memory address.  In other words, it was a
mechanism for type re-casting.  In the grand tradition of robust 
programming
languages, there are about a dozen and a half ways to do this in C, and
the union structure is one of the less popular.  Luckily, it is 
difficult
to use for any other purpose...

Not so with what you're describing.  Sounds like a feature which is ripe 
for
all kinds of abuse.  I can just imagine entire tables populated with 
columns
of type VARIANT by some designer touting flexibility as a mantra.
Fortunately, Oracle developers can use the RAW datatype in the same 
fashion,
and it is interesting to note (but perhaps not coincidental) that most C
programmers tend to favor a similar mechanism (i.e. void pointers) for
type re-casting too.  In other words, be assured that VARIANT is not the
only way to get the job done, and might prove unpopular anyway...

Just my $0.02...

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:08 AM


 Okay, I'm working on what feels like 30 new projects all at once and I
 WILL be RTFM'ing as soon as I can get more than 5 minutes out of
 meetings but


 first:  has anyone heard of any problems with 64-bit Oracle on a
 Solaris 64-bit OS?

 second (and this one confuses me a bit)... I've been asked if Oracle9i
 supports a variant datatype -- they are not familiar with oracle but
 are familiar with SQL Server and say that there is a datatype called
 variant there where you can basically overload the column with
 whatever datatype you want (string, number, date) and the database
 knows what type of data it is storing within the column. They referred
 me to C++ and Java, neither of which I know.

 Can anyone point in the right direction to start researching this?

 Thanks!

 Rachel


 __
 Do You Yahoo!?
 Yahoo! Autos - Get free new car price quotes
 http://autos.yahoo.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).

-- 
Please see the official ORACLE-L FAQ:

RE: OT: Just a laff! Gates gooses geese guano gunners

2002-07-17 Thread kkennedy


I heard on the local news that there was a big flap about this g

Kevin Kennedy

-Original Message-
Sent: Wednesday, July 17, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L


Yeah for the Geese!!  What did the fool think, building on a lake like that? 
Lakes are full of water, bodies of water attract geese.  Geese, well their
geese.  They got to do it somewhere  where ever they are is good enough for
them.  Bombs Away!!

Dick Goulet

Reply Separator
Author: John Kanagaraj [EMAIL PROTECTED]
Date:   7/17/2002 12:04 PM

Hi all,

Just LOL!

John Kanagaraj

THE MISSING LINK | Gates gooses geese guano gunners

Penguins may be after Bill Gates' Windows, but geese have his windows
in their scopes. And his roof. And his yard. Gaggles of waterfowl
think Mr. Microsoft's mansion is the perfect place to leave their
calling cards. Evidently these goose droppings are giving Gates
goosebumps. He asked wildlife officials in Washington state to do
something about the problem. Now the chief park ranger has the green
light to go on a massive bird hunt. Some 4,000 geese could get their
gooses cooked thanks to their scatological sorties. If you're a Linux
lover, go ahead and yell it: Go geese, go geese!

Source: vnunet
http://www.vnunet.com/News/1133586

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: kkennedy
  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: OTN discount for OCP exams

2002-07-17 Thread Djordje Jankovic


I got it.

You go to:

http://www.oracle.com/education/certification/faq/index.html?otndisc.html

There are easy instrunctions there (two steps), you have to provide some
info for Oracle University, and you get to the page with the code.

The code is BTW OTN20

Djordje

 -Original Message-
 From: Erik Williams [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, July 17, 2002 5:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OTN discount for OCP exams
 
 
 Who do you send the email to? I would like to take advantage 
 of the offer
 and dont mind waiting a few days. I dont see anything on the 
 home page about
 a discount.
 
 Thanks
 Erik
 
 
  -Original Message-
  From:   Djordje Jankovic [SMTP:[EMAIL PROTECTED]]
  Sent:   Wednesday, July 17, 2002 4:59 PM
  To: Multiple recipients of list ORACLE-L
  Subject:OTN discount for OCP exams
  
  Anybody knows the OTN promotion for code for the Prometric OCP exam
  discounts.  The discount should be 20%.
  
  Apparently one can get that from OTN - that what a 
 representative from
  Oracle University told me - but you send an e-mail and you 
 wait few days,
  which  would like to avoid.
  
  Thanks.
  
  Djordje
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: Djordje Jankovic
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: Erik 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: Djordje Jankovic
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: a couple of questions