Re: sql query read from text file

[Vladimir Begun]

On Jun 19, 2001 at 12:17:32PM, Seema Singh wrote:
> Hi
> If i have one file a.txt and I want to put that content in where clause of 
> sql statement then how can I do it.
> Example :
> a.txt content
> 98989
> 67676
> 898989
> Select x,y,z from abc
> where x in (98989,67676,898989)
> /

create file named modify.ed, put the following commands:

1,$-1s/$/,/
$s/$/);/
w
q

your SQL*Plus script

SET FEEDBACK OFF TERMOUT OFF
SPOOL _launch.sql
PROMPT SELECT x, y, z FROM abc WHERE x IN (
SPOOL OFF
!ed -s a.txt < modify.ed; cat a.txt >> _launch.sql
REM a.txt is modified!!!
SET FEEDBACK ON TERMOUT ON
REM @@_launch.sql

-- 
Vladimir Begun   | If you push the "extra ice" button on the
http://vbegun.net/   | soft drink vending machine, you won't get
http://vbegun.net/wap/   | any ice.  If you push the "no ice" button,
[EMAIL PROTECTED]| you'll get ice, but no cup.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Begun
  INET: [EMAIL PROTECTED]

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

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

Yahoo!

[Viraj Luthra]

Hello every one,

Hey you know what after a long battle, finally installed SCO 7.1.0 and on top of that 
Oracle 8. Thanks to a lot of people, but Kirti Deshpande ( I think ) stands out, you 
helped me with some good things.

Actually the whole problem was with the swap, it was too small, so be careful guys 
when you get "Out of Memory" problems you need to add in swap. Doing a "man swap" will 
pull you out.

Okay now I can practse some more Oracle, I think I will start with building some 
databases.

May the fun begin.

Thanks again

raja


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need help getting started

[Viraj Luthra]

I dont want to sound rude here, and my comments are NOT directed at you personally.

What is the standard of these OCP's, when a person who has not worked with oracle, can 
pass them, for the sake of discussion it does not matter which tests they were? It 
seems doing an OCP is a complete waste of time!


--

On Tue, 19 Jun 2001 19:15:24  
 Sllewnerak wrote:
>This is kind of a different Oracle question. Does anyone have any suggestions 
>how a person can land an entry level job. I do not work in the Technology 
>field but would very much like to. I have been going to school at night for 
>about two and a half years
>and have the first two OCP developers tests behind me and am working on the 
>third now. I have a 3.9 GPA and can't even get an interview. How do you get 
>experience if no one will hire you? I have even offered to work for free in 
>the evenings or on my days off. I live in Minneapolis and would really 
>appreciate any suggestions that anyone might have. Thanks,
>Karen
>


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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[2]: using User defined functions in Check constraint

[Jonathan Gennick]

I agree w/Tom. Use the raise_application_error function when
you want to make the triggering statement fail.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

Tuesday, June 19, 2001, 1:59:34 PM, Tom Mercadente wrote:
MTF> While you can use any Oracle supplied function within a check constraint,
MTF> you cannot use a self-written function.  
MTF> But you can perform the same thing by using a database table trigger on
MTF> the
MTF> table itself.  You can basically validate anything you want from any
MTF> schema
MTF> you wish using a database trigger (with some exceptions).
 
MTF> A pre-insert trigger on the table would work just fine.  Check them out
MTF> in
MTF> the documentation.


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

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

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

Need help getting started

[Sllewnerak]

This is kind of a different Oracle question. Does anyone have any suggestions 
how a person can land an entry level job. I do not work in the Technology 
field but would very much like to. I have been going to school at night for 
about two and a half years
and have the first two OCP developers tests behind me and am working on the 
third now. I have a 3.9 GPA and can't even get an interview. How do you get 
experience if no one will hire you? I have even offered to work for free in 
the evenings or on my days off. I live in Minneapolis and would really 
appreciate any suggestions that anyone might have. Thanks,
Karen

No Subject

[Prashant S. Bhangale]

[EMAIL PROTECTED]

Slightly OFF-TOPIC: Calling OCIPasswordChange using Perl

[Molina, Gerardo]

I've posted this to [EMAIL PROTECTED] but I have not gotten any emails in
the last 3 hours from that list server so I don't know if that list server
has gone belly up or if it's just me, so I'm posting here also...

Has anyone figured out how to call OCIPasswordChange from Perl (with or
without DBI)?  The reason I'm asking is that Oracle is saying that
OCIPasswordChange function should be used instead of 'alter user..' to
accomplish password changes.  I'm hoping someone has figured out how to do
this using Perl.

I saw the following archive item where Tim Bunce talks about a possible
approach to incorporate this functionality into DBI but I don't know if
anyone ever implemented this or came up with an alternate solution.

http://www.perl.jann.com/dbi-users/29/msg00157.html

TIA,
Gerardo




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Disk configuration

[KC]

Kevin,
 
Thanks for your input. I was trying to put certain 
datafiles on contiguous disk space, tell me if I am wrong, I try to avoid the 
situation where you want to create a 2G file, but the file system don't have a 
2G contiguous space, so your flle is broken into multiple pieces, can that 
happen??
 
KC

-Original Message-From: 
Kevin Lange <[EMAIL PROTECTED]>To: Multiple 
recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 
Wednesday, June 20, 2001 1:22 AMSubject: RE: Disk 
configuration
It 
all depends on what kind of os/filesystem/and disks you have.   I 
know that under AIX, using SSA drives we could actually tell where on the 
disk we wanted the filesystem to go.  This way we could position 
certain things in the faster location.  
 
But personally, I would not go thru the trouble.
 
I 
have never had a DB slowdown so far because of placement on the 
drive.   Admittadly, I have had probelms based on putting 
conflicting tables/indexes on the same drive  you want to keep things 
that could be access simultaneously on  different media.  But 
other than that   no other conflicts.

-Original Message-From: KC 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 
9:36 AMTo: Multiple recipients of list 
ORACLE-LSubject: Disk configuration
Dear List,
 
Someone told me when a disk 
receive a write request, it write to the nearest free space on disk 
where the disk read/write head is currently positioning, is this 
information correct?? If this is true, is this a bad thing for database 
application?? That mean we can't really control where the file go, for 
performance purpose we may want to put certain files on the outer tracks 
of a disk, if the write location is depending on where the read/write 
head is, how can we avoid that, can we create subdisks from the outer 
track of a disk and create a logical volume from it??
 
KC

RE: STARTUP ??

[Reardon, Bruce (CALBBAY)]

A SQL 
script or a OS bat / cmd file?
 
If a 
SQL script it might be easiest to use a database startup 
trigger.
 
Depends on what you are trying to do - can you give 
more information?
 
Regards,
Bruce

  -Original Message-From: Bunyamin K. Karadeniz 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 19 June 2001 11:46 
  To: Multiple recipients of list ORACLE-LSubject: STARTUP 
  ??
  os : WINDOWS 
  ADVANCED SERVER 2000
  DB: ORACLE 8.1.6
   
  MY question is how to execute a script on each 
  startup of database on NT ??
   
  Thanks 
  Bunyamin

Re: strange problem after installing Oracle816

[Peter McLarty]

Hi
Just check all of your paths. You might be trying to use files from the 
other version libs or some similar issue.

Peter

At 01:35 PM 19/06/2001 -0800, you wrote:
>Hi all,
>
>I installed Oracle8.1.6 on a SunOS 5.6 box.  That box
>already had 815 and 817 installed.  When I'm in 816
>Oracle_HOME/bin, sqlplus works fine but when I do
>svrmgrl which does exist, I got this:
>
>ld.so.1: svrmgrl: fatal: relocation error: file
>svrmgrl: symbol kghla42_: referenced symbol not found
>Killed
>
>I got the same error when run in 817home/bin, but in
>815/bin, it works just fine.
>
>The PATH only have 815home/bin in it.  Is it the path
>problem??? but I was in 816home/bin when I executed
>svrmgrl.
>
>Thank you!
>
>Andrea
>
>
>__
>Do You Yahoo!?
>Spot the hottest trends in music, movies, and more.
>http://buzz.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Andrea Oracle
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Disk configuration

[KC]

Chris,
 
I agreed with what you said, however sometimes you 
want to put the file in certain location when the file is first created, any 
ideal??
 
KC
 
 

-Original Message-From: 
Christopher Spence <[EMAIL PROTECTED]>To: 
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 
Wednesday, June 20, 2001 1:15 AMSubject: RE: Disk 
configuration
As 
that person if Santa exists.
 
The datafiles allocate their extents upon their creation, so a new 
insert will write within that space, 
 
"Walking on water and developing 
software from a specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

-Original Message-From: KC 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 
10:36 AMTo: Multiple recipients of list 
ORACLE-LSubject: Disk configuration
Dear List,
 
Someone told me when a disk 
receive a write request, it write to the nearest free space on disk 
where the disk read/write head is currently positioning, is this 
information correct?? If this is true, is this a bad thing for database 
application?? That mean we can't really control where the file go, for 
performance purpose we may want to put certain files on the outer tracks 
of a disk, if the write location is depending on where the read/write 
head is, how can we avoid that, can we create subdisks from the outer 
track of a disk and create a logical volume from it??
 
KC

Re: What the difference between qio and direct I/O option in VxFS

[KC]

Connor,

Thanks for the info. Is Direct I/O licensed with the Veritas Volume manager
or the Database edition?? We want to be able to avoid double buffering,
sound like Direct I/O is what we want, however our SysAdmin insisted that we
need to purchase the Database edition, I thought Direct I/O came with the
VxFS file system, maybe the SysAdmin confused Direct I/O to raw ,please
clarify??

KC


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wednesday, June 20, 2001 2:53 AM


>
>Direct IO is the capacity to perform operations
>without the data being passed through the Unix buffer
>cache (it goes straight to/from the disks to the
>Oracle buffer cache)
>
>Quick IO is Veritas's simulation of raw datafiles - it
>presents the file to Oracle as if it were raw.
>
>hth
>connor
>
>--- KC <[EMAIL PROTECTED]> wrote: > Dear List,
>>
>> What the difference between qio and direct I/O
>> option in Veritas file system VxFS??
>>
>> KC
>>
>
>
>=
>Connor McDonald
>http://www.oracledba.co.uk (mirrored at
>http://www.oradba.freeserve.co.uk)
>
>"Some days you're the pigeon, some days you're the statue"
>
>
>Do You Yahoo!?
>Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>or your free @yahoo.ie address at http://mail.yahoo.ie
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: =?iso-8859-1?q?Connor=20McDonald?=
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN Repository vs. Controlfiles

[Orr, Steve]

Thanks Bruce,

So it looks like the only feature that does not have an alternative solution
is the stored scripts. You can backup the controlfile and keep the logs to
cover everything else.



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L


Steve,

>From the 817 documentation on RMAN:
"
Storage of the RMAN Repository Exclusively in the Control File
Because most information in the recovery catalog is also available in the
target database's control file, RMAN supports an operational mode in which
it uses the target database control file instead of a recovery catalog. This
mode is especially appropriate for small databases where installation and
administration of another database for the sole purpose of maintaining the
recovery catalog is burdensome. 

Oracle does not support the following features in this operational mode: 

Stored scripts 

Restore and recovery when the control file is lost or damaged 

Types of Records in the Control File
When you do not use a recovery catalog, the control file is the exclusive
source of information about backups and copies as well as other relevant
information. The control file contains two types of records: circular reuse
records and non-circular reuse records. 

Circular Reuse Records
Circular reuse records contain non-critical information that is eligible to
be overwritten if the need arises. These records contain information that is
continually generated by the database. Some examples of information circular
reuse records include: 

Log history 

Archived redo logs 

Backups 

Offline ranges for datafiles 

Circular re-use records are arranged in a logical ring. When all available
record slots are full, Oracle either expands the control file to make room
for a new records or overwrites the oldest record. The
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter specifies the minimum
age in days of a record before it can be reused. 

See Also: 
"Monitoring the Overwriting of Control File Records" to learn how to manage
Oracle's treatment of circular-reuse records.  
 
 


Non-Circular Reuse Records
Non-circular reuse records contain critical information that does not change
often and cannot be overwritten. Some examples of information in circular
reuse records include: 

Datafiles 

Online redo logs 

Redo threads 

Recovery Without a Catalog
To restore and recover your database without using a recovery catalog,
Oracle recommends that you: 

Use a minimum of two multiplexed or mirrored control files, each on separate
disks. 

Keep excellent records of which files were backed up, the date they were
backed up, and the names of the backup pieces that each file was written to
(see Chapter 4, "Generating Lists and Reports with Recovery Manager"). Keep
all Recovery Manager backup logs. 




WARNING: 
It is difficult to restore and recover if you lose your control files and do
not use a recovery catalog. The only way to restore and recover when you
have lost all control files and need to restore and recover datafiles is to
call Oracle Support Services. Support will need to know: 

The current schema of the database. 

Which files were backed up. 

When the files were backed up. 

The names of the backup pieces containing the files. 

  


 
 


See Also: 
"Understanding Catalog-Only Command Restrictions" for a complete list of
commands that are disabled unless you use a recovery catalog.  
"

Regards,
Bruce


-Original Message-
Sent: Wednesday, 20 June 2001 2:02 
To: Multiple recipients of list ORACLE-L


With Oracle 8.0 there was RMAN functionality that you could only get by
having a repository in a database. But with Oracle 8.1 it seems that you get
all the functionality you need with controlfiles. What functionality do you
lose by using RMAN with controlfiles?


Steve Orr


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


You can just use the controlfile so you don't have to setup a database
repository. Here's a clip from page 2-8 of the User's Guide:

"When you use a control file as the RMAN repository, RMAN still functions
very effectively. If you choose not to use a recovery catalog, follow the
guidelines in "Managing the RMAN Repository Without a Recovery Catalog" on
page 3-45. Specifically, make sure you understand which commands require a
catalog, and develop a strategy for backing up the repository."

You can configure the amount of history kept in you controlfiles with the
following init.ora entry:
# Keep 14 days of history in the control file for the RMAN backups...
CONTROL_FILE_RECORD_KEEP_TIME = 14

Of course, make sure you backup the controlfiles. :-) 


Steve Orr



-Original Message-
Sent: Monday, June 18, 2001 9:17 AM
To: Multiple recipients o

RE: New system, cart blanche, what to buy

[John Kanagaraj]

>I would vote for AIX and RS/6000. From my experience, those are robust
>servers and IBM has got good phone support. However, I do not 

I would fully second that. (And your SAs are going to love its easy Admin
capabilities)

>real bad experience. Other than that, AIX is one of the best OSs I have
>worked on. FWIW .. truss will be available with AIX 5L (this 
>fall, I was
>told). 

That's good news, Kirti. However, there are lots of other utilities out
there from IBM that they have not really advertised or pushed out for AIX -
I wonder why...

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

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

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

RE: Backups on raw devices

[Reardon, Bruce (CALBBAY)]

Steve,

>From the 817 documentation on RMAN:
"
Storage of the RMAN Repository Exclusively in the Control File
Because most information in the recovery catalog is also available in the
target database's control file, RMAN supports an operational mode in which
it uses the target database control file instead of a recovery catalog. This
mode is especially appropriate for small databases where installation and
administration of another database for the sole purpose of maintaining the
recovery catalog is burdensome. 

Oracle does not support the following features in this operational mode: 

Stored scripts 

Restore and recovery when the control file is lost or damaged 

Types of Records in the Control File
When you do not use a recovery catalog, the control file is the exclusive
source of information about backups and copies as well as other relevant
information. The control file contains two types of records: circular reuse
records and non-circular reuse records. 

Circular Reuse Records
Circular reuse records contain non-critical information that is eligible to
be overwritten if the need arises. These records contain information that is
continually generated by the database. Some examples of information circular
reuse records include: 

Log history 

Archived redo logs 

Backups 

Offline ranges for datafiles 

Circular re-use records are arranged in a logical ring. When all available
record slots are full, Oracle either expands the control file to make room
for a new records or overwrites the oldest record. The
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter specifies the minimum
age in days of a record before it can be reused. 

See Also: 
"Monitoring the Overwriting of Control File Records" to learn how to manage
Oracle's treatment of circular-reuse records.  
 
 


Non-Circular Reuse Records
Non-circular reuse records contain critical information that does not change
often and cannot be overwritten. Some examples of information in circular
reuse records include: 

Datafiles 

Online redo logs 

Redo threads 

Recovery Without a Catalog
To restore and recover your database without using a recovery catalog,
Oracle recommends that you: 

Use a minimum of two multiplexed or mirrored control files, each on separate
disks. 

Keep excellent records of which files were backed up, the date they were
backed up, and the names of the backup pieces that each file was written to
(see Chapter 4, "Generating Lists and Reports with Recovery Manager"). Keep
all Recovery Manager backup logs. 




WARNING: 
It is difficult to restore and recover if you lose your control files and do
not use a recovery catalog. The only way to restore and recover when you
have lost all control files and need to restore and recover datafiles is to
call Oracle Support Services. Support will need to know: 

The current schema of the database. 

Which files were backed up. 

When the files were backed up. 

The names of the backup pieces containing the files. 

  


 
 


See Also: 
"Understanding Catalog-Only Command Restrictions" for a complete list of
commands that are disabled unless you use a recovery catalog.  
"

Regards,
Bruce


-Original Message-
Sent: Wednesday, 20 June 2001 2:02 
To: Multiple recipients of list ORACLE-L


With Oracle 8.0 there was RMAN functionality that you could only get by
having a repository in a database. But with Oracle 8.1 it seems that you get
all the functionality you need with controlfiles. What functionality do you
lose by using RMAN with controlfiles?


Steve Orr


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


You can just use the controlfile so you don't have to setup a database
repository. Here's a clip from page 2-8 of the User's Guide:

"When you use a control file as the RMAN repository, RMAN still functions
very effectively. If you choose not to use a recovery catalog, follow the
guidelines in "Managing the RMAN Repository Without a Recovery Catalog" on
page 3-45. Specifically, make sure you understand which commands require a
catalog, and develop a strategy for backing up the repository."

You can configure the amount of history kept in you controlfiles with the
following init.ora entry:
# Keep 14 days of history in the control file for the RMAN backups...
CONTROL_FILE_RECORD_KEEP_TIME = 14

Of course, make sure you backup the controlfiles. :-) 


Steve Orr



-Original Message-
Sent: Monday, June 18, 2001 9:17 AM
To: Multiple recipients of list ORACLE-L


I've logged a TAR on this one with Oracle.  They have verified what I
suspected all along.  The SAs here don't understand how Oracle performs a
hot backup.  There is no difference between raw and cooked file systems as
far as Oracle is concerned when performing a hot backup.  Also, the skipping
of the header

RE: strange problem after installing Oracle816

[Kevin Lange]

Check your path statements and other environment setting on the Sun box.
If you already had the old software installed, you probably are still using
those for the old path.

When you are in the 8.1.6 ORACLE_HOME/bin directory its finding the binary
file for that version of oracle but its fining the Library and modules from
the other version thru the path.

Make sure everything is updated for the  new Oracle Home.

-Original Message-
Sent: Tuesday, June 19, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I installed Oracle8.1.6 on a SunOS 5.6 box.  That box
already had 815 and 817 installed.  When I'm in 816
Oracle_HOME/bin, sqlplus works fine but when I do
svrmgrl which does exist, I got this:

ld.so.1: svrmgrl: fatal: relocation error: file
svrmgrl: symbol kghla42_: referenced symbol not found
Killed

I got the same error when run in 817home/bin, but in
815/bin, it works just fine.

The PATH only have 815home/bin in it.  Is it the path
problem??? but I was in 816home/bin when I executed
svrmgrl.

Thank you!

Andrea


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: How to size db_block_size?

[Glen Mitchell]

 http://www.ixora.com.au/tips/creation/raw_log_files.htm
has some details related to log block sizes.
Christopher Spence wrote:

log
file block size is generally 512, 1024 bytes, dispite the file system block
size.
"Walking on water and developing software
from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot

-Original
Message-
From: hp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
12:11 PM
To: Multiple recipients of
list ORACLE-L
Subject: RE: How to size db_block_size?
ok
I'm confused.if i run df -g 
i get this
(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment
size
and
if i run
select
 
max(l.lebsz)  log_block_size
from
 
sys.x$kccle  l
where
 
l.inst_id = userenv('Instance');
i
get 
LOG_BLOCK_SIZE
__
 
1024
does
this mean my os block size is 1k?
if
so how do i change it to 8k?




-Original
Message-
From: Christopher Spence [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
9:26 AM
To: Multiple recipients of
list ORACLE-L
Subject: RE: How to size db_block_size?
df
-g  "Walking
on water and developing software from a specification are easy if both
are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot

-Original
Message-
From: Herman Susantio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
5:14 AM
To: Multiple recipients of
list ORACLE-L
Subject: Re: How to size db_block_size?
Hi all, just
want to ask,How do we know the OS Block size from our system ?We use Sun
Solaris 2.7any command to show OS Block Size ? Thanks
& Regards Herman

- Original Message -

From:Nirmal
Kumar Muthu Kumaran

To: Multiple
recipients of list ORACLE-L

Sent: Tuesday, June 19, 2001 4:30
PM

Subject: RE: How to size db_block_size?
 Hi Justin,
A larger data
block size provides greater efficiency in disk and memory I/O (access and
storage of data). Such cases include:
a) Oracle is
on a large computer system with a large amount of memory and fast disk
drives. For example, databases controlled by mainframe computers with vast
hardware resources typically use a data block size of 4K or greater.
b) The operating
system that runs Oracle uses a small operating system block size. For example,
if the operating system block size is 1K and the data block size matches
this, Oracle may be performing an excessive amount of disk I/O during normal
operation. For best performance in this case, a database block should consist
of multiple operating system blocks.
Hope that this
would helps you.
Nirmal.
-Original Message-
From:  Justin Coleman
[SMTP:[EMAIL PROTECTED]]
Sent:  Tuesday, June 19,
2001 10:06 AM
To:    Multiple
recipients of list ORACLE-L
Subject:  
How to size db_block_size?
Dear All,
Is there a recommended approach on
how to decide on the db_block_size for
your database?  I am looking
to create a database that during the day will
be used for light OLTP, but during
the day and night will have heavish batch
jobs.  Therefore I was intent
on using 8k or 16k blocks.  Most likely 8k
blocks.  But is there an approach
to actually chosing the correct
db_block_size?
Cheers for any help in advance.
Justin
 
_
Get Your Private, Free E-mail from
MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Justin Coleman
  INET: [EMAIL PROTECTED]
Fat City Network Services   
-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California   
-- Public Internet access / Mailing Lists

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






-- 
Glen Mitchell   NZ Phone: +64 9 3730400
Energy Research Lab URL: http://www.peace.com
Peace Software  Email: [EMAIL PROTECTED]
 

Oracle 9i on Linux (Mandrake 8.0)

[Stephane Faroult]

A bit of info to complete Joe's own tests. Interestingly, I have not met
the same problems but I can confirm that it can be done on a 256M
machine.

System used :
256M, dual-Celeron 466MH system. Swap 400M.
Mandrake 8.0 distribution (kernel 2.4.3-20mdksmp)
Note that 8.1.7 had previously been installed, and therefore all the
upgrades required (to glibc etc.) applied (check the Mandrake site for
the details).

The machine being both short on disk AND memory, here is some
information about the disk space you will need :

Compressed distribution as available from the Oracle site :
Linux9i_Disk1.cpio.gz   412092424  (about 400M)
Linux9i_Disk2.cpio.gz   638547208  (about 620M)
Linux9i_Disk3.cpio.gz82956567  (about 80M)

DO NOT DECOMPRESS AS SPECIFIED ON THE DOWNLOAD PAGE.
gunzip  Linux9i_Disk1.cpio.gz -> OK
cpio -icdvm < Linux9i_Disk1.cpio.gz gives :
cpio: premature end of file

You MUSN'T use the 'c' flag to cpio and it works well. Note that if you
are short on space and if you have copied the .gz files to a CD

  gunzip -c /mnt/cdrom/Linux9i_Diskn.cpio.gz | cpio -idvm

should work well too.

Space required by the uncompressed distribution (K):

$ du -ks Disk1
447168  Disk1
$ du -sk Disk2
626340  Disk2
$ du -sk Disk3
83972   Disk3
 
 As the bulk of the distribs is made of already compressed files (such
as .jar) there is not much of a difference between compressed and
uncompressed.
 
To install you need between 1.6 and 1.8G (additional to the 'staging'
space above). I had to sacrifice the 8.1.7 distrib. Even the 'custom'
installation doesn't allow you to 'forget' much of what I tend to
consider as useless crap (not a great fan of advanced queuing, among
others). I have installed neither the Spatial option nor OEM, but it's
about the leaner I could get to.

Beware that you will also need up to 200M under ~oracle/tmp during the
install (the installer is kind enough to warn you and pause until you
fix, though - solved the problem with a soft link to another partition).

First forgot to shutdown the current 8.1.7
 runInstaller (under Disk1) does nothing - no message

Once the 8.1.7 database was shutdown, the installation run without any
problem, link included.

About INTERNAL :

$ sqlplus

 SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jun 19 22:54:52 2001

 (c) Copyright 2001 Oracle Corporation.  All rights reserved.

 Enter user-name: internal
 Enter password: 
 ERROR:
 ORA-09275: CONNECT INTERNAL is not a valid DBA connection


 Enter user-name: sys as sysdba
 Enter password: 
 Connected to an idle instance.

 If you forget to create a link to your init$ORACLE_SID.ora file under
$ORACLE_HOME/dbs you get this :
 
 SQL> startup nomount
 ORA-03113: end-of-file on communication channel
 SQL> exit

(plus a core file). Worked OK with a link to the 8.1.7 init.ora file
(nothing really exotic in it though).


Will try to upgrade the 8.1.7 database later (11:30 pm here and not in a
mood to spend the night over it).

Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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

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

RE: Externally Identified User - Serious Weirdness

[Jim Newman]

Agreed, _Oracle_ users BSIDBA and OPS$BSIDBA are not the same (spelled and
pronounced differently :>) , even though the _UNIX_ user BSIDBA would run as
OPS$BSIDBA.
Can you select count(*) from BSIDBA.FA_IDNT?
If so, you could try creating a synonym FA_IDNT for BSIDBA.FA_IDNT.

Jim

-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 7:32 AM
To: Multiple recipients of list ORACLE-L




I don't think BSIDBA and OPS$BSIDBA are the same Oracle user.  (Check in
dba_users).  So ops$bsidba probably doesn't own the tables? (Maybe the
install
went wrong because of  the value of the initializaion parameter
os_authent_prefix which I think could be null or could be ops$ or some other
value) I'm not sure how you could run the program and make it log in as
bsidba;
most probably you'll have to supply a username and pwd.
Are there really new apps written in COBOL?  :-)

chaim





"Ron Rogers" <[EMAIL PROTECTED]> on 06/18/2001 04:45:03 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)




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

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

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

RE: strange problem after installing Oracle816

[Khedr, Waleed]

You might need to change LD_LIBRARY_PATH=$ORACLE_HOME/lib

Regards,

Waleed

-Original Message-
Sent: Tuesday, June 19, 2001 5:36 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I installed Oracle8.1.6 on a SunOS 5.6 box.  That box
already had 815 and 817 installed.  When I'm in 816
Oracle_HOME/bin, sqlplus works fine but when I do
svrmgrl which does exist, I got this:

ld.so.1: svrmgrl: fatal: relocation error: file
svrmgrl: symbol kghla42_: referenced symbol not found
Killed

I got the same error when run in 817home/bin, but in
815/bin, it works just fine.

The PATH only have 815home/bin in it.  Is it the path
problem??? but I was in 816home/bin when I executed
svrmgrl.

Thank you!

Andrea


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

[Bala, Prakash]

Check whether FA_IDNT is a public synonym which is pointing to a
non-existing table.

HTH
Prakash

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L



Hope everybody had a good weekend -

Working on HP-UX and Oracle 8.1.7.0.0

I've got a third party app that 's written in COBOL and stores some of the
information it needs to generate screens in the database.  I am trying to
practice restoring this beast, and it turns out I must run a utility to
recompile some of the COBOL.  All users in this database are identified
externally and have OPS$ as the prefix to their username.  The table(s) in
question are owned by Oracle user BSIDBA.  The UNIX user BSIDBA runs the
program and the user in v$session shows up as OPS$BSIDBA.  I get an
ora-00942  on a select count (*) from one of the tables.  Generally, this
means some type of privilege is missing, but this user owns the table!
Just in case, I granted select on the table to OPS$BSIDBA, got a 'grant
succeeded', reran the COBOL piece, and got the same error.

Set up tracing, ran it again, ran tkprof against the output, and sure
enough:

The following statement encountered a error during parse:
select count(*) from FA_IDNT
Error encountered: ORA-00942

I've granted everything I can think of to everyone I can find (this is - or
will be - a development instance) and am still getting the error.  Metalink
hasn't revealed any secrets.

Anybody seen anything like this or have an idea of something else I can try
- the vendor has given up, says it's a DB problem.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
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: Bala, Prakash
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Tablespace recovery - Point in time (TSPITR)

[Nirmal Kumar Muthu Kumaran]

Title: RE: Tablespace recovery - Point in time (TSPITR)





Any Help Please  


-Original Message-
From:   Nirmal Kumar  Muthu Kumaran [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 18, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
Subject:    Tablespace recovery - Point in time (TSPITR)


Dear guru's 


Can any one please help me , how to do the tablespace point in time recovery. 


I reviewed the backup and recovery books, but still am not clear. 


I don't know how to make the 'Clone Database'. 


Hope that i can do TSPITR with three way by using the following 


a) cloning a database
b) transportable tablespace
c) rman. 


Please enlighten me for the above. 


Thanks in advance. 


Regards,
Nirmal 

Transportable tablespace problem in 817

[Kumanan Balasundaram]

I'm trying to a transportable but the export session is hanging.
The v$session says the session is actually active.

Anybody here has any such experience?

Any ideas to resolve this?


Thanks
Kumanan

SQL> set autoprint on serveroutput on
SQL>  exec dbms_tts.transport_set_check ('DATA',TRUE);
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
VIOLATIONS


Index KBALASUN.PK_USERS_USERID in tablespace INDEXTS enforces primary
constriant
s  of table KBALASUN.USERS in tablespace DAT
SQL>  exec dbms_tts.transport_set_check ('DATA,INDEXTS',TRUE);
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
no rows selected

alter tablespace data read only;
alter tablespace data read only;

/tmp  $ env
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=KBDB
ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data
ORACLE_HOME=/export/home/oracle/product/8.1.7


/tmp  $ exp  transport_tablespace=y tablespaces=DATA,INDEXTS
file=testtrans.dmp

Export: Release 8.1.7.0.0 - Production on Tue Jun 19 19:30:37 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Username: sys as sysdba
Password: 

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kumanan Balasundaram
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[Mercadante, Thomas F]

Uh Hal,

You should read the books.  Dual is a table.
And whoever suggested to re-run catalog was not quite correct.
Dual is created in the sql.bsq file.

the actual script says:

===  from sql.bsq   ===

create table dual   /* pl/sql's standard pckg requires dual.
*/
  (dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
  storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option

===  from sql.bsq   ===

there!  I did my research for the day!  :)

Tom Mercadante




-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
>You could always just run catalog.sql as sys.
>
>-Original Message-
>Sent: Tuesday, June 19, 2001 11:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Your email says duel. You created dual, with an a, right?
>
>And did you grant select on dual to public? And create a
>public synonym for it?
>
>HTH,
>
>Yosi
>
>
>Shirish Khapre wrote:
>
> > hi
> > i accidentally  dropped duel table from sys..then recreated it.
> > now when i am using rman during running the catrman.sql for
>recovery_catalog
> > it is flashing error
> >
> > select '08.00.05' from dual
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > u'r help is highly appreciated
> >
> > Shirish Khapre, SE Rolta India Ltd.
> > Off Ph No. (+91) (022) 832,826,8300568
> > Ext'n 2730
> > Minds are like parachutes. They only function when they are open
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shirish Khapre
> >   INET: [EMAIL PROTECTED]
> >
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

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

sql query read from text file

[Seema Singh]

Hi
If i have one file a.txt and I want to put that content in where clause of 
sql statement then how can I do it.
Example :
a.txt content
98989
67676
898989
Select x,y,z from abc
where x in (98989,67676,898989)
/
Actuall I want to do it in unix.I want to know the first 2 or 3 high CPU 
using processes then by putting this pid we can get the oracle user name and 
what sql statement that oracle user are executing.
if some have any similar kind of scripts let me know.
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

RE: * I'm Looking for an Oracle Financials DBA for Miami,

[Mohammad Rafiq]

This advise was applicable to those living outside USA and not living
in NEWYORK/CALIFORNIA as they are already well aware of such sites...


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 19 Jun 2001 10:55:59 -0800

That would be good advice also for people form New York and / or California 
that might be interested in migrating to the USA for work also, with all the 
dot com layoffs.

 > Check
 > www.monster.com
 > www.dice.com
 > www.net-temps.com
 > for jobs positions and put your resume to see response before deciding
 > to migrate to USA.
 >
 > Regards
 > Rafiq
 >
 >
 >
 > Reply-To: [EMAIL PROTECTED]
 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
 > Date: Tue, 19 Jun 2001 05:56:13 -0800
 >
 > Florida has always been a weak market compared to rest of the USA.  I
 > remember in NYC, you could go get another job at a lunchtime
 > interview.  DC
 > area has a good job market.  Pick up the NY Times or
 > Washington Post.  Not
 > sure on the rest of the country.  BTW, the financials job in
 > Miami is at
 > DelMonte and they have been looking for over a year.
 >
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   INET: [EMAIL PROTECTED]

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

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Transportable tablespace problem in 817

[Solomon, Saul M.]

This is a bug. You've probably got an ORA-600 too in your alert log. I had the same 
problem and upgraded to 8.1.7.1 to fix it.

Saul Solomon
Senior Database Administrator
PPG Industries
[EMAIL PROTECTED]
412 434-3504



-Original Message-
Sent: Tuesday, June 19, 2001 4:22 PM
To: Multiple recipients of list ORACLE-L


I'm trying to a transportable but the export session is hanging.
The v$session says the session is actually active.

Anybody here has any such experience?

Any ideas to resolve this?


Thanks
Kumanan

SQL> set autoprint on serveroutput on
SQL>  exec dbms_tts.transport_set_check ('DATA',TRUE);
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
VIOLATIONS


Index KBALASUN.PK_USERS_USERID in tablespace INDEXTS enforces primary
constriant
s  of table KBALASUN.USERS in tablespace DAT
SQL>  exec dbms_tts.transport_set_check ('DATA,INDEXTS',TRUE);
PL/SQL procedure successfully completed.
SQL> select * from sys.transport_set_violations;
no rows selected

alter tablespace data read only;
alter tablespace data read only;

/tmp  $ env
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORACLE_SID=KBDB
ORA_NLS33=/export/home/oracle/product/8.1.7/ocommon/nls/admin/data
ORACLE_HOME=/export/home/oracle/product/8.1.7


/tmp  $ exp  transport_tablespace=y tablespaces=DATA,INDEXTS
file=testtrans.dmp

Export: Release 8.1.7.0.0 - Production on Tue Jun 19 19:30:37 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Username: sys as sysdba
Password: 

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kumanan Balasundaram
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Solomon, Saul 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).

strange problem after installing Oracle816

[Andrea Oracle]

Hi all,

I installed Oracle8.1.6 on a SunOS 5.6 box.  That box
already had 815 and 817 installed.  When I'm in 816
Oracle_HOME/bin, sqlplus works fine but when I do
svrmgrl which does exist, I got this:

ld.so.1: svrmgrl: fatal: relocation error: file
svrmgrl: symbol kghla42_: referenced symbol not found
Killed

I got the same error when run in 817home/bin, but in
815/bin, it works just fine.

The PATH only have 815home/bin in it.  Is it the path
problem??? but I was in 816home/bin when I executed
svrmgrl.

Thank you!

Andrea


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  INET: [EMAIL PROTECTED]

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

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

RE: MOVE PARTITION

[Tortorelli, Mary Jo]

alter table  move partition  tablespace 
 

-Original Message-
Sent: Monday, June 18, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L



Helo all, 

How can i move one or more paritions from one tablespace to another. 

I checked the objects for TSPITR, in that some of objects are in SYSTEM tablespace. 

Any help pls. 

Nirmal. 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: New system, cart blanche, what to buy

[Post, Ethan]

My feelings are that the list strongly likes AIX as far as getting more bang
for your buck. - E

-Original Message-
Sent: Tuesday, June 19, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L


All,

For a position that would (possibly) like me to set up an
Oracle infrastructure from scratch, on Unix. Given the
opportunity to choose from any system, what hardware
would you pick?

>From the small bit of information I've been able to glean,
it'll be fairly large, and need failover.

I obviosuly can't guess the size of the system, but one part
of the question is vendor. I'm familiar with Solaris, but HP
seems to be platform of choice these days. And each vendor
has their own storage methodologies, and their own HA
clustering mechanisms. And there's always OPS.

Any opinions, pointers, caveats? (Is this a broad enough
question? :-)

Yosi


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

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

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

--
This e-mail is intended for the use of the addressee(s) only and may contain 
privileged, confidential, or proprietary information that is exempt from disclosure 
under law.  If you have received this message in error, please inform us promptly by 
reply e-mail, then delete the e-mail and destroy any printed copy.   Thank you.

==
-- 
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: duel error

[lhoska]

I think Dual is a table.

  1  SELECT TABLE_NAME FROM SYS.DBA_TABLES
  2* WHERE TABLE_NAME='DUAL'
SQL> /

TABLE_NAME
--
DUAL

SQL> DESC DUAL
 NameNull?Type
 ---  
 DUMMYVARCHAR2(1)


-Original Message-
Sent: Tuesday, June 19, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L


Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
>You could always just run catalog.sql as sys.
>
>-Original Message-
>Sent: Tuesday, June 19, 2001 11:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Your email says duel. You created dual, with an a, right?
>
>And did you grant select on dual to public? And create a
>public synonym for it?
>
>HTH,
>
>Yosi
>
>
>Shirish Khapre wrote:
>
> > hi
> > i accidentally  dropped duel table from sys..then recreated it.
> > now when i am using rman during running the catrman.sql for
>recovery_catalog
> > it is flashing error
> >
> > select '08.00.05' from dual
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > u'r help is highly appreciated
> >
> > Shirish Khapre, SE Rolta India Ltd.
> > Off Ph No. (+91) (022) 832,826,8300568
> > Ext'n 2730
> > Minds are like parachutes. They only function when they are open
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shirish Khapre
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Thanks,
>
>Yosi
>
>
>-
>Yosi Greenfield
>Oracle Certified DBA
>[EMAIL PROTECTED]
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Hal Wigoda
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[William Beilstein]

Wrong, DUAL is a table owner by the SYS user that contains one row. Check your 
DBA_TABLES and DBA_OBJECTS views.

>>> [EMAIL PROTECTED] 06/19/01 03:56PM >>>
Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
>You could always just run catalog.sql as sys.
>
>-Original Message-
>Sent: Tuesday, June 19, 2001 11:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Your email says duel. You created dual, with an a, right?
>
>And did you grant select on dual to public? And create a
>public synonym for it?
>
>HTH,
>
>Yosi
>
>
>Shirish Khapre wrote:
>
> > hi
> > i accidentally  dropped duel table from sys..then recreated it.
> > now when i am using rman during running the catrman.sql for
>recovery_catalog
> > it is flashing error
> >
> > select '08.00.05' from dual
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > u'r help is highly appreciated
> >
> > Shirish Khapre, SE Rolta India Ltd.
> > Off Ph No. (+91) (022) 832,826,8300568
> > Ext'n 2730
> > Minds are like parachutes. They only function when they are open
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > --
> > Author: Shirish Khapre
> >   INET: [EMAIL PROTECTED] 
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Thanks,
>
>Yosi
>
>
>-
>Yosi Greenfield
>Oracle Certified DBA
>[EMAIL PROTECTED] 
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>--
>Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Kimberly Smith
>   INET: [EMAIL PROTECTED] 
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Hal Wigoda
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: William Beilstein
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[Hal Wigoda]

Dual is not a table.

It just a placeholder.

At 11:04 AM 6/19/01 -0800, you wrote:
>You could always just run catalog.sql as sys.
>
>-Original Message-
>Sent: Tuesday, June 19, 2001 11:32 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Your email says duel. You created dual, with an a, right?
>
>And did you grant select on dual to public? And create a
>public synonym for it?
>
>HTH,
>
>Yosi
>
>
>Shirish Khapre wrote:
>
> > hi
> > i accidentally  dropped duel table from sys..then recreated it.
> > now when i am using rman during running the catrman.sql for
>recovery_catalog
> > it is flashing error
> >
> > select '08.00.05' from dual
> > *
> > ERROR at line 2:
> > ORA-00942: table or view does not exist
> >
> > u'r help is highly appreciated
> >
> > Shirish Khapre, SE Rolta India Ltd.
> > Off Ph No. (+91) (022) 832,826,8300568
> > Ext'n 2730
> > Minds are like parachutes. They only function when they are open
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shirish Khapre
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
>
>--
>Thanks,
>
>Yosi
>
>
>-
>Yosi Greenfield
>Oracle Certified DBA
>[EMAIL PROTECTED]
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yosi Greenfield
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Kimberly Smith
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Hal Wigoda
  INET: [EMAIL PROTECTED]

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

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

Re: How to find the table size?

[Greg Moore]

> I need to calculate the size of the table assuming one of the rows is
having
> all the columns maxsize possible.

I don't understand your question.  Do you want to plan in advance to make an
estimate of how large a table will be, or are you looking at an existing
database and wanting to find out how large the tables are right now?

- Greg

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

Re: [RE: ps -ef | grep sqlplus]

[Yigal Ran]

Look at OPS$ user accounts in the DOC's.

Yigal


Kimberly Smith <[EMAIL PROTECTED]> wrote:
> We use an externally identified account here to sign on to the database
from
> cron for DBA related tasks.  Since only the dba team knows the oracle Unix
> password it works for us well.
> 
> -Original Message-
> Sent: Tuesday, June 19, 2001 11:38 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> 
> 
> hi,
> 
> do you know how to hide oracle passwords from ps -ef? we pass in our pw in
> cron, and it shows up when you run ps -ef (to check unix processes). i
> recognize that is this NOT a smart thing to do...
> 
> can anyone recommend a better way of supplying oracle passwords when
> scripts are connecting to oracle? do you use config files that store
> pws? just curious what everyone else is doing to plug this security hole.
> 
> thanks,
> kris
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).



Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yigal Ran
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ps -ef | grep sqlplus]

[Yigal Ran]

Look at OPS$ user accounts in the DOC's.

Yigal


Kimberly Smith <[EMAIL PROTECTED]> wrote:
> We use an externally identified account here to sign on to the database
from
> cron for DBA related tasks.  Since only the dba team knows the oracle Unix
> password it works for us well.
> 
> -Original Message-
> Sent: Tuesday, June 19, 2001 11:38 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> 
> 
> 
> hi,
> 
> do you know how to hide oracle passwords from ps -ef? we pass in our pw in
> cron, and it shows up when you run ps -ef (to check unix processes). i
> recognize that is this NOT a smart thing to do...
> 
> can anyone recommend a better way of supplying oracle passwords when
> scripts are connecting to oracle? do you use config files that store
> pws? just curious what everyone else is doing to plug this security hole.
> 
> thanks,
> kris
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).



Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yigal Ran
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ps -ef | grep sqlplus

[Kevin Lange]

Here is our method:

1. We save the passwords in a file using the OS level command CRYPT.
2. To run something we call a script file from Cron that first goes and gets
the encrypted password from config file.
3. Then we decrypt the password using CRYPT.
4. Then we start the sql process with the /nolog option.
5. Then we connect to the database using the connect
userid/password@database command.

This has a few advantages:
1. The passwords are not visible on the command line.
2. The passwords are not in every script file.  They are only kept in one
config file.
3. The config file only keeps encrypted passwords.



-Original Message-
Sent: Tuesday, June 19, 2001 1:38 PM
To: Multiple recipients of list ORACLE-L






hi,

do you know how to hide oracle passwords from ps -ef? we pass in our pw in
cron, and it shows up when you run ps -ef (to check unix processes). i
recognize that is this NOT a smart thing to do...

can anyone recommend a better way of supplying oracle passwords when
scripts are connecting to oracle? do you use config files that store
pws? just curious what everyone else is doing to plug this security hole.

thanks,
kris

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

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

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

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

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

RE: ps -ef | grep sqlplus

[Jenkins, Michael]

I can't get this page to come up but I suspect it is an old piece of code
that pads a bunch of spaces so that the password is hidden when a user does
a "ps -ef" command.  Beware, this is not foolproof.  There are X-Windows
utilities in almost all incarnations of UNIX that show the complete line, no
matter how long it is.  Also, I think in Solaris that you could probably
find it in /proc which is readable by the world.

There are a lot of arguments against this, but I have always found
externally identified accounts the easiest and least difficult to manage
solution to this problem.  The main caveat is maintaining two separate
schemas when performing grants.  If you do it from the start then it is
quite easy.

So, make yourself an "ops$oracle" account and grant it DBA.  Then run the
jobs from the oracle crontab and start sqlplus like this:  sqlplus /

Easy enough!  I'm sure there will be security comments against this.  If
someone has compromised your oracle UNIX account, then logging into the
database without a password as a dba is probably the least of your worries.

Hope this helps.

--Michael

-Original Message-
Sent: Tuesday, June 19, 2001 3:04 PM
To: Multiple recipients of list ORACLE-L


We recognized the same problem and found this program as an answer:

http://www.orafaq.org/scripts/c_src/hide.txt

Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline

> -Original Message-
> From: Kris Austin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 2:38 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ps -ef | grep sqlplus
> 
> 
> 
> 
> 
> hi,
> 
> do you know how to hide oracle passwords from ps -ef? we pass in our pw in
> cron, and it shows up when you run ps -ef (to check unix processes). i
> recognize that is this NOT a smart thing to do...
> 
> can anyone recommend a better way of supplying oracle passwords when
> scripts are connecting to oracle? do you use config files that store
> pws? just curious what everyone else is doing to plug this security hole.
> 
> thanks,
> kris
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Armstead, Michael 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  INET: [EMAIL PROTECTED]

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

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

RE: transfer of large datafile Oracle7.3.4.4 databases to 8.1.7. 1.3

[Boivin, Patrice J]

More info on this, the error occurs during the export.

The bug was fixed in 8.0.5, says Oracle Support, but because I am using an
Oracle 7.3. export file we get the oversized file errors during the import,
even if we are using the 8.1.7 import utility..

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 18, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: transfer of large datafile Oracle7.3.4.4
databases to 8.1.7. 1.3

FYI,

Oracle Support confirmed that I hit a 2G file size limit for Oracle
databases on NT.  This "probably" led to data dictionary corruption.

I don't know if this is an NTFS limitation or Oracle on NT problem,
but at
this point I don't care, I can fix this by creating multiple smaller
datafiles per tablespace.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED] 



-Original Message-
From:   Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, June 18, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Subject:transfer of large datafile Oracle7.3.4.4
databases
to 8.1.7.1.3

Has anyone successfully transferred large datafile Oracle
databases
from
Oracle7.3. to 8.1.7?  By large datafile database I mean a
database
that has
files over 2G in size.  This may not apply to all, it may
apply only
to
those who extended the files beyond 2G.  Just curious, since
many of
you
appear to have made thet move from Oracle 7.3.4. to 8.1.6.
or
8.1.7..

Here we did a full export of the db (Tru64 UNIX), ftp'ed it
to
another
server (NT 4), then ran the 8.1.7 import to re-create the
users and
other
global information.  I aborted the import when the import
started to
create
tables.  Then I deleted user accounts I didn't need on the
development
database, and did a user import for the schemas that I
needed.
Using SQL I
then re-created all the public synonyms, since the import
utility
did not
re-create those.  

However the Change Manager tells me that the SYSTEM
tablespace
doesn't exist
in the new database.  Meanwhile the new database is open,
and we can
query
from it.  All the accounts appear to be accessible.  Some
objects
(packages,
procedures, views) are invalid, but not many.  The
developers are
now going
through twelve packages and one procedure that did not
compile
successfully,
probably due to tightening of the code standards.

Anyway when I run the import utility in show=y mode, I see
in the
import SQL
code something that I saw last year:  create tablespace
statements
with
datafile sizes that are 1.7 billion Gigabytes.  We
don't have
enough
disk to hold that much data, and besides I don't think that
NT can
support
files that size.  I know that UNIX can't.

e.g. "CREATE TABLESPACE "USERS" DATAFILE
'/oracle2/oradata/xx/users01.dbf' SI"
 "ZE 1844674407360320   DEFAULT STORAGE (INITIAL
40960 NEXT
40960
MIN"
 "EXTENTS 1 MAXEXTENTS 505 PCTINCREASE 0) ONLINE PERMANENT"

Last year Oracle Support told me to pre-create the
tablespaces, do
the full
import, and ignore the error reports during the import.
They said
that
because the tablespaces do exist, import will produce an
error but
it will
move on and do its thing.  Given that I am creating new
databases
and we
wish to migrate our major production databases, I would much
prefer
it if
there were no errors anywhere.  Another issue with this bug
is that
 

RE: duel error

[Kevin Lange]

Did you remember the Grants and the Insert ??

create table dual   /* pl/sql's standard pckg requires dual.
*/
  (dummy varchar2(1))/* note, the optimizer knows sys.dual is single row
*/
  storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option



-Original Message-
Sent: Tuesday, June 19, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L


hi
i accidentally  dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for recovery_catalog
it is flashing error

select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist

u'r help is highly appreciated

Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open

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

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

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

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

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

RE: Latchs. THANX

[murosa]

 Ok, thank you very to all who reply to me.

 Best regards.

 Miguel




19/06/2001 12.55
[EMAIL PROTECTED]@fatcity.com

19/06/2001 12.41



 Por favor, responda a [EMAIL PROTECTED] 



Remitente [EMAIL PROTECTED]




 Hi folks.

 I'd  like  to  know  about  different  latchs,  wait events and locks.
Meaning  of  willing to wait and immediate ratio and all anothers things in
relation with that.

 Anybody  knows  about  documents,  books, notes in Metalink, etc about
that?.

 Thank you very much in advence.

 Regards.

 Miguel.

   
"Este  mensaje  y  los  documentos  que,  en  su caso, lleve anexos, pueden
contener  información  confidencial. Por ello, se informa a quien lo reciba
por error que la información contenida en el mismo es reservada y su uso no
autorizado  está prohibido  legalmente, por lo que en tal caso  le  rogamos
que  nos  lo  comunique  por la misma vía o por teléfono (901 113 113) , se
abstenga  de realizar copias del mensaje  o  remitirlo o entregarlo  a otra
persona y proceda a borrarlo de inmediato."


--
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).
|--|
| Destinatario Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> |
| Copia|
|--|





   
"Este  mensaje  y  los  documentos  que,  en  su caso, lleve anexos, pueden
contener  información  confidencial. Por ello, se informa a quien lo reciba
por error que la información contenida en el mismo es reservada y su uso no
autorizado  está prohibido  legalmente, por lo que en tal caso  le  rogamos
que  nos  lo  comunique  por la misma vía o por teléfono (901 113 113) , se
abstenga  de realizar copias del mensaje  o  remitirlo o entregarlo  a otra
persona y proceda a borrarlo de inmediato."


--
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: ps -ef | grep sqlplus

[Kimberly Smith]

We use an externally identified account here to sign on to the database from
cron for DBA related tasks.  Since only the dba team knows the oracle Unix
password it works for us well.

-Original Message-
Sent: Tuesday, June 19, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L






hi,

do you know how to hide oracle passwords from ps -ef? we pass in our pw in
cron, and it shows up when you run ps -ef (to check unix processes). i
recognize that is this NOT a smart thing to do...

can anyone recommend a better way of supplying oracle passwords when
scripts are connecting to oracle? do you use config files that store
pws? just curious what everyone else is doing to plug this security hole.

thanks,
kris

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ps -ef | grep sqlplus

[Armstead, Michael A]

We recognized the same problem and found this program as an answer:

http://www.orafaq.org/scripts/c_src/hide.txt

Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline

> -Original Message-
> From: Kris Austin [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 2:38 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  ps -ef | grep sqlplus
> 
> 
> 
> 
> 
> hi,
> 
> do you know how to hide oracle passwords from ps -ef? we pass in our pw in
> cron, and it shows up when you run ps -ef (to check unix processes). i
> recognize that is this NOT a smart thing to do...
> 
> can anyone recommend a better way of supplying oracle passwords when
> scripts are connecting to oracle? do you use config files that store
> pws? just curious what everyone else is doing to plug this security hole.
> 
> thanks,
> kris
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kris Austin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Armstead, Michael 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: duel error

[Kimberly Smith]

You could always just run catalog.sql as sys.

-Original Message-
Sent: Tuesday, June 19, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L


Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

> hi
> i accidentally  dropped duel table from sys..then recreated it.
> now when i am using rman during running the catrman.sql for
recovery_catalog
> it is flashing error
>
> select '08.00.05' from dual
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> u'r help is highly appreciated
>
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 832,826,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when they are open
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shirish Khapre
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: * I'm Looking for an Oracle Financials DBA for Miami,

[Page, Bruce]

That would be good advice also for people form New York and / or California that might 
be interested in migrating to the USA for work also, with all the dot com layoffs.

> Check
> www.monster.com
> www.dice.com
> www.net-temps.com
> for jobs positions and put your resume to see response before deciding
> to migrate to USA.
> 
> Regards
> Rafiq
> 
> 
> 
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Tue, 19 Jun 2001 05:56:13 -0800
> 
> Florida has always been a weak market compared to rest of the USA.  I 
> remember in NYC, you could go get another job at a lunchtime 
> interview.  DC 
> area has a good job market.  Pick up the NY Times or 
> Washington Post.  Not 
> sure on the rest of the country.  BTW, the financials job in 
> Miami is at 
> DelMonte and they have been looking for over a year.
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[William Beilstein]

And one more thing. The table dual has one column called dummy with is defined as 
varchar2(1). and contains ONE row with the value of 'X'.

>>> [EMAIL PROTECTED] 06/19/01 02:13PM >>>
Who were you logged on as when you recreated it? Did you create a public
synonym for .dual?  You should create the table as sys.dual and create
the public synonym for it. That should fix your problem

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 1:51 PM


> hi
> i accidentally  dropped duel table from sys..then recreated it.
> now when i am using rman during running the catrman.sql for
recovery_catalog
> it is flashing error
>
> select '08.00.05' from dual
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> u'r help is highly appreciated
>
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 832,826,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when they are open
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> --
> Author: Shirish Khapre
>   INET: [EMAIL PROTECTED] 
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: William Beilstein
  INET: [EMAIL PROTECTED]

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

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

ps -ef | grep sqlplus

[Kris Austin]

hi,

do you know how to hide oracle passwords from ps -ef? we pass in our pw in
cron, and it shows up when you run ps -ef (to check unix processes). i
recognize that is this NOT a smart thing to do...

can anyone recommend a better way of supplying oracle passwords when
scripts are connecting to oracle? do you use config files that store
pws? just curious what everyone else is doing to plug this security hole.

thanks,
kris

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

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

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

New system, cart blanche, what to buy

[Yosi Greenfield]

All,

For a position that would (possibly) like me to set up an
Oracle infrastructure from scratch, on Unix. Given the
opportunity to choose from any system, what hardware
would you pick?

>From the small bit of information I've been able to glean,
it'll be fairly large, and need failover.

I obviosuly can't guess the size of the system, but one part
of the question is vendor. I'm familiar with Solaris, but HP
seems to be platform of choice these days. And each vendor
has their own storage methodologies, and their own HA
clustering mechanisms. And there's always OPS.

Any opinions, pointers, caveats? (Is this a broad enough
question? :-)

Yosi


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[Yosi Greenfield]

Your email says duel. You created dual, with an a, right?

And did you grant select on dual to public? And create a
public synonym for it?

HTH,

Yosi


Shirish Khapre wrote:

> hi
> i accidentally  dropped duel table from sys..then recreated it.
> now when i am using rman during running the catrman.sql for recovery_catalog
> it is flashing error
>
> select '08.00.05' from dual
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> u'r help is highly appreciated
>
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 832,826,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when they are open
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shirish Khapre
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


-
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[Ruth Gramolini]

Who were you logged on as when you recreated it? Did you create a public
synonym for .dual?  You should create the table as sys.dual and create
the public synonym for it. That should fix your problem

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 1:51 PM


> hi
> i accidentally  dropped duel table from sys..then recreated it.
> now when i am using rman during running the catrman.sql for
recovery_catalog
> it is flashing error
>
> select '08.00.05' from dual
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
>
> u'r help is highly appreciated
>
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 832,826,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when they are open
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Shirish Khapre
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: duel error

[JOE TESTA]

 
my guess is the public synonym is still there, grant select on dual to 
public.
 
if the synonym isnot there recreate it also.
 
joe
>>> [EMAIL PROTECTED] 06/19/01 01:51PM 
>>>hii accidentally  dropped duel table from sys..then 
recreated it.now when i am using rman during running the catrman.sql for 
recovery_catalogit is flashing errorselect '08.00.05' from 
dual*ERROR at line 2:ORA-00942: table or view does not 
existu'r help is highly appreciatedShirish Khapre, SE Rolta 
India Ltd.Off Ph No. (+91) (022) 832,826,8300568Ext'n 
2730Minds are like parachutes. They only function when they are 
open-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Shirish 
Khapre  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

Re: duel error

[Rocky Welch]

Make sure you grant select from dual to public.

HTH,
-Rocky

--- Shirish Khapre <[EMAIL PROTECTED]> wrote:
> hi
> i accidentally  dropped duel table from sys..then recreated it.
> now when i am using rman during running the catrman.sql for
> recovery_catalog
> it is flashing error
> 
> select '08.00.05' from dual
> *
> ERROR at line 2:
> ORA-00942: table or view does not exist
> 
> u'r help is highly appreciated
> 
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 832,826,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when they are open
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Shirish Khapre
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  INET: [EMAIL PROTECTED]

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

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

r25des/r25desm

[Ken Komoto]

I've bumped into a problem with Reports 25 designer:

When I try to load an rdf or rex into the database, the application dies.

On my NT box, if I use r25mov32.exe or r25con32.exe, I get:

REP-26540: Abnormal condition: Internal error while reading 
SQL*Reportwriter V1.1's Rexfile

If I use r25des32.exe and go to File>Admin>Convert, the application just blinks
and goes away.

On the Sun box, if I use r25desm, I get Bus Error (coredump)
 if I use r25mrepm, I get the same REP-26540
 if I use r25convm, I get Bus error

What do I do to get the report saved in the database?

Kenneth Komoto  mailto:[EMAIL PROTECTED]
Office of the Registrar Phone: (530)752-7197
University of CaliforniaFax  : (530)752-0329
Davis, Ca 95616

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

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

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

Re: how to find highest process useing more CPU

[ARUN K C]

use the following command it will tell who is using the cpu
/usr/ucb/ps auxw|head


>From: "Seema Singh" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: how to find highest process useing more CPU
>Date: Tue, 19 Jun 2001 08:46:04 -0800
>
>Hi
>Is there any way to find which process is taking much cpu except top 
>command
>on Solaris Unix.
>If some one have any script let me know.
>With regards
>-Seema
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Seema 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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

RE: using User defined functions in Check constraint

[Mercadante, Thomas F]

Title: using User defined functions in Check constraint



Hussain
While 
you can use any Oracle supplied function within a check constraint, you cannot 
use a self-written function.  
But 
you can perform the same thing by using a database table trigger on the table 
itself.  You can basically validate anything you want 
from any schema you wish using a database trigger (with some 
exceptions).
 
A 
pre-insert trigger on the table would work just fine.  Check them out in 
the documentation.
 
hope 
this helps
Tom 
Mercadante Oracle Certified 
Professional 

  -Original Message-From: Arslan Dar 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 1:14 
  PMTo: Multiple recipients of list ORACLE-LSubject: using 
  User defined functions in Check constraint
  Hello All 
  Can we use user made functions in the check 
  constraints?. Like In the check constraitns, we can use oracle functions, like 
  LENGTH(NAME)=9. What we want to do is to check a value, which before being 
  saved in the database(when we press save, registration no. of a patient, gets 
  prefixed with the area code where the patient is being registrered), checks 
  whether the values prefixed with the data are present in a table in another 
  schema, for this purpose we want to use a function(selfmade). This we do to 
  get a unique value irrespective of the area. 
  If not, is there a work around, to check such a 
  value from a different schema&table in a check constraint.Oracle 8.1.7 on 
  winnt 4 TIAHussainDBA SKMCH & 
  RC 

duel error

[Shirish Khapre]

hi
i accidentally  dropped duel table from sys..then recreated it.
now when i am using rman during running the catrman.sql for recovery_catalog
it is flashing error

select '08.00.05' from dual
*
ERROR at line 2:
ORA-00942: table or view does not exist

u'r help is highly appreciated

Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when they are open

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

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

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

Re: how to find highest process useing more CPU

[Sam Roberts]

/usr/ucb/ps -uax


This will give u the /son of a b***'s'  taking the most CPU

Sam





- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 19, 2001 9:13 PM


> On Tue, Jun 19, 2001 at 08:46:04AM -0800, Seema Singh wrote:
> > Hi
> > Is there any way to find which process is taking much cpu except top
command
> > on Solaris Unix.
> > If some one have any script let me know.
> > With regards
> > -Seema
>
> Try looking up the documentation for ps
>
> for example...
> ps -e -o pcpu,pid,user,args | sort -nr | head
>
>
> --
> Tommy Wareing
> Software Engineer
> Oxford English Dictionary
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tommy Wareing
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Sam Roberts
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: What the difference between qio and direct I/O option in VxFS

[Connor McDonald]

Direct IO is the capacity to perform operations
without the data being passed through the Unix buffer
cache (it goes straight to/from the disks to the
Oracle buffer cache)

Quick IO is Veritas's simulation of raw datafiles - it
presents the file to Oracle as if it were raw.

hth
connor

--- KC <[EMAIL PROTECTED]> wrote: > Dear List,
> 
> What the difference between qio and direct I/O
> option in Veritas file system VxFS??
> 
> KC
> 


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

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


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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

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

RE: * I'm Looking for an Oracle Financials DBA for Miami,

[Mercadante, Thomas F]

Title: RE: * I'm Looking for an Oracle Financials DBA for Miami,



I also 
think that, if you are willing to move, Oracle DBA's can ALWAYS find 
jobs.
 
Move 
to either large population areas where either Federal or State Govt's are, and 
there always consultant opportunities.
 
I 
can't imagine that a DBA would have problems finding work in either DC, NYC or 
Boston (sorry, I'm from the east coast - not too familiar with the rest of the 
country).
 
Even 
in my small neck of the woods (Albany, NY) there are DBA positions available 
with state govt.
Tom 
Mercadante Oracle Certified 
Professional 

  -Original Message-From: Bowes, Chris 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 12:59 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: * 
  I'm Looking for an Oracle Financials DBA for Miami,
  I really think it matters where in the job field you're 
  talking.  I know of at least 3 people who in the last 6 months changed 
  jobs and their picks of jobs from multiple opportunities.  One in 
  Florida, one in Atlanta and one in San Francisco.  In 2 of the 3 cases 
  (FL and ATL), when the candidate chose which offer s/he wanted, the ones that 
  were told 'no' didn't want to take no for an answer and kept bugging the 
  candidate.  The Florida and San Francisco candidates were Oracle DBA's 
  the other (Atlanta) was a web programmer who could interface with 
  Oracle.
  If you used to work at 
  www.wowlookatthisgreatsitewehopetomakeaprofitsoonuntilthenletsbuysomemorecoolexpensivestuff.com 
  then, yes, you could in trouble if that's all you know.  We in the Oracle 
  community and the Sqlserver community have had our opportunities cut down 
  some, but they're still out there.
  --Chris [EMAIL PROTECTED] 
  

Re: * I'm Looking for an Oracle Financials DBA for Miami,

[Mohammad Rafiq]

Check
www.monster.com
www.dice.com
www.net-temps.com
for jobs positions and put your resume to see response before deciding
to migrate to USA.

Regards
Rafiq



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 19 Jun 2001 05:56:13 -0800

Florida has always been a weak market compared to rest of the USA.  I 
remember in NYC, you could go get another job at a lunchtime interview.  DC 
area has a good job market.  Pick up the NY Times or Washington Post.  Not 
sure on the rest of the country.  BTW, the financials job in Miami is at 
DelMonte and they have been looking for over a year.

 >>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
"DBA" jobs listings on ComputerJobs.com for the Florida area have gone from 
1572 to 846 over the past 6 months. The job ads you see are repeated each 
week and are posted by more than one recruiter for the same job. Contact 
with the recruiter results in the " job is filled" or some other lame 
excuse. It appears that they are building a resume database incase the 
market opens up again. In the past weeks we have been contacted 2 or 3 times 
a week by recruiters inquiring "if we have any opening that they can fill?"
  I think the market is tight right now and "downsizing" will continue for a 
while until the economy picks up. Weekly the papers report another company 
in the Atlanta, GA area going through the "size" adjustment.
ROR mª¿ªm

 >>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
Gregory Conron schrieb:
 >
 > On June 16, 2001 04:35 am, Jared Still wrote:
 > >Many of
 > > us consider this a service, especially the way that jobs are
 > > at the moment.
 >
 > Amazing the difference a year can make, eh?
 >

Hi

Just curious: How bad is the job situation in the US right now ?
I'm wondering since we consider moving there (my wife is american).

  
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FIBM  |
  
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ron Rogers
   INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gene Sais
   INET: [EMAIL PROTECTED]

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

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

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

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

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

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

RE: How to size db_block_size?

[Christopher Spence]

Title: RE: How to size db_block_size?



log 
file block size is generally 512, 1024 bytes, dispite the file system block 
size.
 
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: hp 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 12:11 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  How to size db_block_size?
  ok 
  I'm confused.
  if i 
  run df -g  i get this
  
  (/dev/vg00/lvol3 ) :
  8192 file system block size 1024 fragment size
  and if i 
  run
  select  max(l.lebsz)  
  log_block_sizefrom  sys.x$kccle  lwhere  
  l.inst_id = userenv('Instance');
  i 
  get 
  LOG_BLOCK_SIZE__  
  1024
  does this mean my os block size is 
  1k?
  if so how do i change it to 
  8k? 
  
 
 -Original 
Message-From: Christopher Spence 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:26 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
How to size db_block_size?
df 
-g 
 
"Walking on water and developing software 
from a specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: Herman Susantio 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 5:14 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: How to size db_block_size?
  Hi all,
   
  just want to ask,
  How do we know the OS Block size from our 
  system ?
  We use Sun Solaris 2.7
  any command to show OS Block Size 
  ?
   
  Thanks & Regards
   
  Herman
   
  
- Original Message - 
From: 
Nirmal 
Kumar Muthu Kumaran 
To: Multiple recipients of list 
ORACLE-L 
Sent: Tuesday, June 19, 2001 4:30 
PM
Subject: RE: How to size 
db_block_size?

Hi Justin, 
A larger data block size 
provides greater efficiency in disk and memory I/O (access and storage 
of data). Such cases include: 
a) Oracle is on a large 
computer system with a large amount of memory and fast disk drives. For 
example, databases controlled by mainframe computers with vast hardware 
resources typically use a data block size of 4K or greater. 
b) The operating system that 
runs Oracle uses a small operating system block size. For example, if 
the operating system block size is 1K and the data block size matches 
this, Oracle may be performing an excessive amount of disk I/O during 
normal operation. For best performance in this case, a database block 
should consist of multiple operating system blocks.
Hope that this would helps 
you. 
Nirmal. 

  -Original Message- 
  From:   Justin Coleman 
  [SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, 
  June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject:    
  How to size db_block_size? 
  Dear All, 
  Is there a recommended approach on how to 
  decide on the db_block_size for your database?  I am looking to create a database that 
  during the day will be used for 
  light OLTP, but during the day and night will have heavish batch 
  jobs.  Therefore I was intent 
  on using 8k or 16k blocks.  Most likely 8k blocks.  But is there an approach to actually 
  chosing the correct db_block_size? 
  Cheers for any help in advance. 
  Justin 
  _ 
  Get Your Private, Free E-mail from MSN 
  Hotmail at http://www.hotmail.com. 
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 
  -- Author: Justin Coleman   INET: [EMAIL PROTECTED] 
  Fat City Network Services    
  -- (858) 538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public 
  Internet access / Mailing Lists  
  To REMOVE yourself from this mailing list, 
  send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the 
  name of mailing list you want to be removed from).  You 
  may also send the HELP command for 
  other information (like subscribing). 

Re: how to find highest process useing more CPU

[Tommy Wareing]

On Tue, Jun 19, 2001 at 08:46:04AM -0800, Seema Singh wrote:
> Hi
> Is there any way to find which process is taking much cpu except top command 
> on Solaris Unix.
> If some one have any script let me know.
> With regards
> -Seema

Try looking up the documentation for ps

for example...
ps -e -o pcpu,pid,user,args | sort -nr | head


-- 
Tommy Wareing
Software Engineer
Oxford English Dictionary

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

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

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

using User defined functions in Check constraint

[Arslan Dar]

Title: using User defined functions in Check constraint





Hello All 
Can we use user made functions in the check constraints?. Like In the check constraitns, we can use oracle functions, like LENGTH(NAME)=9. What we want to do is to check a value, which before being saved in the database(when we press save, registration no. of a patient, gets prefixed with the area code where the patient is being registrered), checks whether the values prefixed with the data are present in a table in another schema, for this purpose we want to use a function(selfmade). This we do to get a unique value irrespective of the area. 

If not, is there a work around, to check such a value from a different schema&table in a check constraint.
Oracle 8.1.7 on winnt 4 
TIA
Hussain
DBA SKMCH & RC 

RE: * I'm Looking for an Oracle Financials DBA for Miami,

[Bowes, Chris]

Title: RE: * I'm Looking for an Oracle Financials DBA for Miami,





I really think it matters where in the job field you're talking.  I know of at least 3 people who in the last 6 months changed jobs and their picks of jobs from multiple opportunities.  One in Florida, one in Atlanta and one in San Francisco.  In 2 of the 3 cases (FL and ATL), when the candidate chose which offer s/he wanted, the ones that were told 'no' didn't want to take no for an answer and kept bugging the candidate.  The Florida and San Francisco candidates were Oracle DBA's the other (Atlanta) was a web programmer who could interface with Oracle.

If you used to work at www.wowlookatthisgreatsitewehopetomakeaprofitsoonuntilthenletsbuysomemorecoolexpensivestuff.com then, yes, you could in trouble if that's all you know.  We in the Oracle community and the Sqlserver community have had our opportunities cut down some, but they're still out there.

--Chris
[EMAIL PROTECTED]

Compaq servers and 9i

[Boivin, Patrice J]

http://www.theregister.co.uk/content/2/19805.html
 

 Compaq Alpha box steals 9i benchmark laurels
By Andrew Orlowski in San Francisco
Posted: 19/06/2001 at 11:49 GMT

Compaq is first out of the blocks with a barnstorming
midrange benchmark for
a system running Oracle 9i. 

If you've got $13 million to spare - which is a lot for
a midrange system, quite
frankly - you can get a 32-way AlphaServer GS320 to run
230,533
Benchmark C transactions per minute using Oracle 9i.
That works out as
$56.62 per transaction. The system clocked 188,000
users, and ran
Compaq's Tru64 Unix. (Which was Digital Unix, and OSF/1
before that). 

Compaq's configuration also includes 16 PIIIs. The $13
million figure is for the
cost of the system over three years. The AlphaServer
itself is billed at under
half a million dollars, that's a quarter of the cost of
licensing Oracle 9i
software. As usual in these systems, storage accounts
for most of the rest. 

By comparison, the Unix systems to beat in the TPC-C Top
Ten include a
32way Solaris SPARC Fujitsu system, the PrimePower 2000,
which clocks
222,772 TPC-C at $51.40, making it the highest
non-clustered performer; an
IBM RS/6000 S85 'pServer' clocking 220,807 at $43.30,
and an HP 9000
Superdome clocking 197,024 at $53.77 per transaction. 

The full, 234 page PDF for the AlphaServer can be found
here. 

Not everyone likes to measure their hardware against the
synthetic TPC-C
benchmarks. TPC-C scores have been criticised for mixing
clustered and
non-clustered results in the same league table, and more
importantly, failing to
replicate real word application conditions. 

But it's an itch no vendor seems to be able to resist
scratching. ®
 
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).

how to find highest process useing more CPU

[Seema Singh]

Hi
Is there any way to find which process is taking much cpu except top command 
on Solaris Unix.
If some one have any script let me know.
With regards
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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

RE: Java

[Guy Hammond]

It means that the Java system classes aren't installed. Try logging in
as SYSTEM and running "CREATE OR REPLACE JAVA SYSTEM". This will take a
while, but it should fix your problem.
 
g.
 

-Original Message-
Sent: Tuesday, June 19, 2001 4:56 PM
To: Multiple recipients of list ORACLE-L


Hi 

Do you know what is mean:

ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler

Thanks

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN - Veritas NETBackup

[Johnson Poovathummoottil]

They will not have even that operator job if you have
the tape drive with a robotic arm like the one we
have.
It is cool once everything is set up right. Apart from
initial teething troubles . 

--- Sam Roberts <[EMAIL PROTECTED]> wrote:
>  We are going to use RMAN AND Veritas netbackup with
> Oracle 8.1.6 unix
> solaris 8 and a 60 tape dlt drive.
> 
> looks a cool combination with very little for the
> dba to do and even
> better - no need for sys admin people once its all
> set up. In fact the  the
> sysadm's for this job will just add and remove
> tapes, sounds like a computer
> operator to me.
> 
> Sam
> 
> Any one have exeriences using these tools or any
> gotcha's that the sun rep's
> didn't share with us.
> Also the Sun rep's really pushed RMAN which i was
> surprised about
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Sam Roberts
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Johnson Poovathummoottil
  INET: [EMAIL PROTECTED]

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

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

Re: Java

[DBarbour]

Alon,

Sounds to me like you're missing the classesXX.zip file in
$ORACLE_HOME/


David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
Alon Ben-Zvi   
   
  
antra.com>   cc:   
   
Sent by: Subject: Java 
   
[EMAIL PROTECTED]   
   
   
   
   
   
06/19/2001 10:15   
   
AM 
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Hi

Do you know what is meen:

ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler

Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alon Ben-Zvi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: How to size db_block_size?

[hp]

Title: RE: How to size db_block_size?



ok I'm 
confused.
if i 
run df -g  i get this

(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment size
and if i 
run
select  max(l.lebsz)  
log_block_sizefrom  sys.x$kccle  lwhere  
l.inst_id = userenv('Instance');
i 
get 
LOG_BLOCK_SIZE__  
1024
does this mean my os block size is 
1k?
if so how do i change it to 
8k? 

   
   -Original 
  Message-From: Christopher Spence 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:26 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  How to size db_block_size?
  df 
  -g 
   
  "Walking on water and developing software from 
  a specification are easy if both are frozen." 
  Christopher R. Spence Oracle DBA Fuelspot 
  
-Original Message-From: Herman Susantio 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 5:14 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
How to size db_block_size?
Hi all,
 
just want to ask,
How do we know the OS Block size from our 
system ?
We use Sun Solaris 2.7
any command to show OS Block Size 
?
 
Thanks & Regards
 
Herman
 

  - Original Message - 
  From: 
  Nirmal 
  Kumar Muthu Kumaran 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Tuesday, June 19, 2001 4:30 
  PM
  Subject: RE: How to size 
  db_block_size?
  
  Hi Justin, 
  A larger data block size provides 
  greater efficiency in disk and memory I/O (access and storage of data). 
  Such cases include: 
  a) Oracle is on a large computer 
  system with a large amount of memory and fast disk drives. For example, 
  databases controlled by mainframe computers with vast hardware resources 
  typically use a data block size of 4K or greater. 
  b) The operating system that runs 
  Oracle uses a small operating system block size. For example, if the 
  operating system block size is 1K and the data block size matches this, 
  Oracle may be performing an excessive amount of disk I/O during normal 
  operation. For best performance in this case, a database block should 
  consist of multiple operating system blocks.
  Hope that this would helps 
  you. 
  Nirmal. 
  
-Original Message- 
From:   Justin Coleman 
[SMTP:[EMAIL PROTECTED]] Sent:   Tuesday, 
June 19, 2001 10:06 AM To: Multiple recipients of list ORACLE-L Subject:    
How to size db_block_size? 
Dear All, 
Is there a recommended approach on how to 
decide on the db_block_size for your 
database?  I am looking to create a database that during the day 
will be used for light OLTP, but 
during the day and night will have heavish batch jobs.  Therefore I was intent on using 8k or 16k 
blocks.  Most likely 8k blocks.  But is there an approach to actually chosing the 
correct db_block_size? 
Cheers for any help in advance. 
Justin 
_ 
Get Your Private, Free E-mail from MSN 
Hotmail at http://www.hotmail.com. 
-- Please 
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin 
Coleman   INET: 
[EMAIL PROTECTED] 
Fat City Network Services    
-- (858) 538-5051  FAX: (858) 538-5051 San Diego, California    
-- Public Internet access / Mailing Lists  
To REMOVE yourself from this mailing list, 
send an E-Mail message to: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: 
UNSUB ORACLE-L (or the name of 
mailing list you want to be removed from).  You may 
also send the HELP command for other 
information (like subscribing). 

OCP Testing Software

[kjanusz]

I have used SelfTest Software in the past to prepare for 
the OCP tests.  Is there another similar company that is 
as good or better?

Thanks,
Ken Janusz, CPIM
-- 
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: Backups on raw devices

[Orr, Steve]

With Oracle 8.0 there was RMAN functionality that you could only get by
having a repository in a database. But with Oracle 8.1 it seems that you get
all the functionality you need with controlfiles. What functionality do you
lose by using RMAN with controlfiles?


Steve Orr


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


You can just use the controlfile so you don't have to setup a database
repository. Here's a clip from page 2-8 of the User's Guide:

"When you use a control file as the RMAN repository, RMAN still functions
very effectively. If you choose not to use a recovery catalog, follow the
guidelines in "Managing the RMAN Repository Without a Recovery Catalog" on
page 3-45. Specifically, make sure you understand which commands require a
catalog, and develop a strategy for backing up the repository."

You can configure the amount of history kept in you controlfiles with the
following init.ora entry:
# Keep 14 days of history in the control file for the RMAN backups...
CONTROL_FILE_RECORD_KEEP_TIME = 14

Of course, make sure you backup the controlfiles. :-) 


Steve Orr



-Original Message-
Sent: Monday, June 18, 2001 9:17 AM
To: Multiple recipients of list ORACLE-L


I've logged a TAR on this one with Oracle.  They have verified what I
suspected all along.  The SAs here don't understand how Oracle performs a
hot backup.  There is no difference between raw and cooked file systems as
far as Oracle is concerned when performing a hot backup.  Also, the skipping
of the header is only applicable to certain variants of UNIX.

One other question here.  Does anyone have recommendations on the repository
database required for RMAN?  Do we need to keep a separate instance on
another production box?  Or the same production box?  Does everybody have
all of there repository information for all of their database in one
instance?  It seems like you would want a separate instance for each
repository and have them staggered across different machines so that the
odds of losing your database and it's repository at the same time would be
low.  Any suggestions?

Thanks for all the replies so far!

--Michael

-Original Message-
Sent: Friday, June 15, 2001 9:55 PM
To: Multiple recipients of list ORACLE-L


Michael,
 We use RMAN on RAW with EDM (EMC) backups, without any problem. When using
RMAN, it will take care of all blocks that are being changed while the
backup is
going on. Also as EDM interfaces with the Tape library, RMAN will write
directly
to the Tape . Have this set up on about 15 databases and all of them are
working
fine. But occasionally our backups fail on 8.1.6 databases due to lack of
resources on the Server (and some bugs!).

Rama

"Jenkins, Michael" wrote:

> We have parallel server running on on a Sun Cluster 2.2 and we are looking
> for the easiest way to perform hot backups.  Now, I know that you have to
> use the "dd" command and skip the header at the beginning.  Everything I
> read on metalink indicates that you can use basically the same paradigm as
a
> hot backup on cooked file systems.  But, the sysadmins here tell me that
the
> raw device can't be backed up if there is any write activity on the data
> file that is currently being backed up.  Now we all know that contrary to
> popular belief there is write activity on a data file even when the
> tablespace is in backup mode.  Is "rman" or some other block-level backup
> utility the only way to get a reliable hot backup on raw devices?  Does
> anybody have any experience with hot backups that are made while the
> database still has active users logged in?
>
> I look forward to everyone's thought on this.
>
> Thanks.
>
> Michael L. Jenkins
> Oracle Certified DBA
> Nextel Communications
> Norcross, GA
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jenkins, Michael
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenkins, Michael
  INET: [EMAIL PROTECTED]

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

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

Java

[Alon Ben-Zvi]

Hi 
Do you know what is mean:
ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler
Thanks

RE: Java

[Cale, Rick T (Richard)]

>From MetaLink

Do the following 

 Set the CLASSPATH to ORACLE_HOME/javavm/lib/aurora.zip 
 Then run the initjvm.sql script from 
 ORACLE_HOME/javavm/install. 

Rick

-Original Message-
Sent: Tuesday, June 19, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


Hi 

Do you know what is meen:

ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler

Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alon Ben-Zvi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

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

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

RE: Disk configuration

[Kevin Lange]

It all 
depends on what kind of os/filesystem/and disks you have.   I know 
that under AIX, using SSA drives we could actually tell where on the disk we 
wanted the filesystem to go.  This way we could position certain things in 
the faster location.  
 
But 
personally, I would not go thru the trouble.
 
I have 
never had a DB slowdown so far because of placement on the drive.   
Admittadly, I have had probelms based on putting conflicting tables/indexes on 
the same drive  you want to keep things that could be access simultaneously 
on  different media.  But other than that   no other 
conflicts.

  -Original Message-From: KC 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:36 
  AMTo: Multiple recipients of list ORACLE-LSubject: Disk 
  configuration
  Dear List,
   
  Someone told me when a disk receive 
  a write request, it write to the nearest free space on disk where the disk 
  read/write head is currently positioning, is this information correct?? If 
  this is true, is this a bad thing for database application?? That mean we 
  can't really control where the file go, for performance purpose we may want to 
  put certain files on the outer tracks of a disk, if the write location is 
  depending on where the read/write head is, how can we avoid that, can we 
  create subdisks from the outer track of a disk and create a logical volume 
  from it??
   
  KC

RE: Disk configuration

[Christopher Spence]

As 
that person if Santa exists.
 
The 
datafiles allocate their extents upon their creation, so a new insert will write 
within that space, 
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: KC 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 10:36 
  AMTo: Multiple recipients of list ORACLE-LSubject: Disk 
  configuration
  Dear List,
   
  Someone told me when a disk receive 
  a write request, it write to the nearest free space on disk where the disk 
  read/write head is currently positioning, is this information correct?? If 
  this is true, is this a bad thing for database application?? That mean we 
  can't really control where the file go, for performance purpose we may want to 
  put certain files on the outer tracks of a disk, if the write location is 
  depending on where the read/write head is, how can we avoid that, can we 
  create subdisks from the outer track of a disk and create a logical volume 
  from it??
   
  KC

RE: STARTUP ??

[Guidry, Chris]

Hello,
If you have the NT Resource Kit check out AUTOEXNT

The AutoExNT service allows you to start a batch file, AUTOEXNT.BAT, at boot
time without having
to log onto the computer on which it will run.

AutoExNT includes an /interactive option (analogous to the /interactive
option of the AT command)
that allows you to see the processes started. To use AutoExNT, you must be
running Windows NT 3.5
or later.

--
Chris J. Guidry  P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 07:46 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  STARTUP ??
> 
> os : WINDOWS ADVANCED SERVER 2000
> DB: ORACLE 8.1.6
>  
> MY question is how to execute a script on each startup of database on NT
> ??
>  
> Thanks 
> Bunyamin
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guidry, 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: FW: 9i On Linux

[JOE TESTA]

yea got it installed on 256M of ram last night, 
 
there is another msg on the listserv about my findings, if you 
dont see it let me know and I'll resend it from home tonite.
 
basically, i got the binaries installed(but none of them would 
relink), 
 
hacked the $ORACLE_HOME/bin/genclntsh based on installing 
8.1.7 on rh 7.1 and
regenerated the share libs, relinked everything manually after 
getting out of installer.
 
built scripts to build db, will run them this 
evening.
 
rh 7.1, 256M of ram
 
will also be attempting it on my laptop tonite as i've just 
loaded up rh 7.1 on it about 10 mins ago.
 
joe
 
>>> "Armstead, Michael A" 
<[EMAIL PROTECTED]> 06/19/01 10:14AM 
>>>Joe,Did you get time to do your RH Linux tests this 
weekend? If you're inDresden, you probably didn't have much else to do. If 
you did test, how'd itgo?Michael Armstead    
Application Database Administrator, OCP-CertifiedUS Pharmaceuticals 
ITGlaxo SmithKline> -Original Message-> 
From:    JOE TESTA [SMTP:[EMAIL PROTECTED]]> 
Sent:    Friday, June 15, 2001 4:31 PM> 
To:    Multiple recipients of list ORACLE-L> 
Subject:    Re: 9i On Linux> > i've got 256M, dont 
run SUSE but will attempt it on rh 7.1 this weekend.>  > 
joe>  > > > >>> [EMAIL PROTECTED] 
06/15/01 04:20PM  Can any of you just confirm that Oracle 9i 
requires 500M of memory on> Linux?> > Thank,> 
> Waleed> -- > Please see the official ORACLE-L FAQ: > -- > 
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: * I'm Looking for an Oracle Financials DBA for Miami,

[Streeter, Lerone A LBX]

opportunities are scarce in all facets of computing across the US, yes it is
amazing the difference a year can make.  a friend sent this link the other
day:

http://www.salon.com/tech/wire/2001/06/15/new_homeless/index.html

I've got friends in Atlanta, Detroit, san Francisco, new york, and a few
other places; they all had some dismal stories.  the industry is suffering a
bit of late.  the overall unemployment rate is up in comparison to the last
couple of years.

http://stats.bls.gov/wh/cpsbref3.htm



===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===

-Original Message-
Sent: Tuesday, June 19, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L


Florida has always been a weak market compared to rest of the USA.  I
remember in NYC, you could go get another job at a lunchtime interview.  DC
area has a good job market.  Pick up the NY Times or Washington Post.  Not
sure on the rest of the country.  BTW, the financials job in Miami is at
DelMonte and they have been looking for over a year.

>>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
"DBA" jobs listings on ComputerJobs.com for the Florida area have gone from
1572 to 846 over the past 6 months. The job ads you see are repeated each
week and are posted by more than one recruiter for the same job. Contact
with the recruiter results in the " job is filled" or some other lame
excuse. It appears that they are building a resume database incase the
market opens up again. In the past weeks we have been contacted 2 or 3 times
a week by recruiters inquiring "if we have any opening that they can fill?"
 I think the market is tight right now and "downsizing" will continue for a
while until the economy picks up. Weekly the papers report another company
in the Atlanta, GA area going through the "size" adjustment.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
Gregory Conron schrieb:
> 
> On June 16, 2001 04:35 am, Jared Still wrote:
> >Many of
> > us consider this a service, especially the way that jobs are
> > at the moment.
> 
> Amazing the difference a year can make, eh?
> 

Hi

Just curious: How bad is the job situation in the US right now ? 
I'm wondering since we consider moving there (my wife is american).

 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FIBM  |
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ron Rogers
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gene Sais
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Streeter, Lerone  A LBX
  INET: [EMAIL PROTECTED]

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

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

Java

[Alon Ben-Zvi]

Hi 

Do you know what is meen:

ORA-29547 Java system class not available: oracle/aurora/rdbms/Compiler

Thanks
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alon Ben-Zvi
  INET: [EMAIL PROTECTED]

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

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

FW: 9i On Linux

[Armstead, Michael A]

Joe,

Did you get time to do your RH Linux tests this weekend? If you're in
Dresden, you probably didn't have much else to do. If you did test, how'd it
go?

Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline

> -Original Message-
> From: JOE TESTA [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 15, 2001 4:31 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: 9i On Linux
> 
> i've got 256M, dont run SUSE but will attempt it on rh 7.1 this weekend.
>  
> joe
>  
> 
> 
> >>> [EMAIL PROTECTED] 06/15/01 04:20PM >>>
> Can any of you just confirm that Oracle 9i requires 500M of memory on
> Linux?
> 
> Thank,
> 
> Waleed
> -- 
> Please see the official ORACLE-L FAQ: 
> -- 
> 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: Armstead, Michael 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: Latchs

[Scott . Shafer]

Also look for Anjo Kolk's (sp?) paper "Oracle7 Wait Events and Enqueues" on
http://www.evdbt.com

Scott Shafer
San Antonio, TX
210-581-6217

"I hate the country, all those animals walking around un-cooked."

> -Original Message-
> From: Rahul [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 6:05 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Latchs
> 
> the best resource ..
> 
> http://www.amazon.com/exec/obidos/ASIN/156592598X/ixora/102-4862016-620016
> 8
> 
> 
> > --
> > From:   [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> > Reply To:   [EMAIL PROTECTED]
> > Sent:   Tuesday, June 19, 2001 5:55 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Latchs
> > 
> > 
> >  Hi folks.
> > 
> >  I'd  like  to  know  about  different  latchs,  wait events and
> > locks.
> > Meaning  of  willing to wait and immediate ratio and all anothers things
> > in
> > relation with that.
> > 
> >  Anybody  knows  about  documents,  books, notes in Metalink, etc
> > about
> > that?.
> > 
> >  Thank you very much in advence.
> > 
> >  Regards.
> > 
> >  Miguel.
> > 
> >
> > "Este  mensaje  y  los  documentos  que,  en  su caso, lleve anexos,
> > pueden
> > contener  información  confidencial. Por ello, se informa a quien lo
> > reciba
> > por error que la información contenida en el mismo es reservada y su uso
> > no
> > autorizado  está prohibido  legalmente, por lo que en tal caso  le
> > rogamos
> > que  nos  lo  comunique  por la misma vía o por teléfono (901 113 113) ,
> > se
> > abstenga  de realizar copias del mensaje  o  remitirlo o entregarlo  a
> > otra
> > persona y proceda a borrarlo de inmediato."
> > 
> > 
> > -- 
> > 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: Rahul
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Installing oracle remotely

[jon baker]

http://www.uk.research.att.com/vnc/

is up and running for me.


Jon Baker   
Database Engineer (1/5)
<[EMAIL PROTECTED]>
www.netsec.net


[EMAIL PROTECTED] wrote:
> 
> Does anyine have a current link to the VNC binaries for AIX 4.3? The
> link documented on the VNC home page at ATT Cambridge Labs is a dead
> URL.
> 
> Regards,
> 
> Gary
> _
> Good judgement comes from experience.
> Experience comes from bad judgement.
> 
> __
> 
> We do it using an X based system such as VNC.  Out machines are at
> co-locations around the US.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: jon baker
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Intermedia Questions, Any Gurus on This Subject?

[Mike J Kurth]

You need to create preferences to specify storage parameters like:

begin
ctx_ddl.create_preference('storage_small','BASIC_STORAGE');
ctx_ddl.set_attribute('storage_small','I_TABLE_CLAUSE','tablespace 
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','K_TABLE_CLAUSE','tablespace 
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','R_TABLE_CLAUSE','tablespace 
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','N_TABLE_CLAUSE','tablespace 
LOBADM_01_SMALL_DATA');
ctx_ddl.set_attribute('storage_small','I_INDEX_CLAUSE','tablespace 
LOBADM_01_SMALL_INDX');
ctx_ddl.set_attribute('storage_small','P_TABLE_CLAUSE','tablespace 
LOBADM_01_SMALL_DATA');
end;
/

Then create index like:

create index lobadm.client_full_nm_indx on lobadm.client(full_nm)
indextype is ctxsys.context
parameters('storage lobadm.storage_small')
/

Hope this helps


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: JDeveloper Connection to Oracle DB

[Kevin Kostyszyn]

Sorry, this might be a stupid question but, is the db ON the same machine as
JDeveloper.  If it is, are you sure the db is running, is the machine on a
network?  If it isn't, were there any errors encountered during
installation?

-Original Message-
Mouchantaf
Sent: Tuesday, June 19, 2001 4:40 AM
To: Multiple recipients of list ORACLE-L


Hi again,

I would like to clarify the problem once again since it
seems that I might have left some details out. I have
installed JDeveloper 3.0 and I am running Oracle
8i personal edition on a Windows 98 platform. I am
trying to create a connection to the DB from
JDeveloper. I specify the "Oracle JDBC Thin" as driver
since I need to use applets, and I select "Existing TNS
Names" as the connection method and I choose the
service running. When I click on the "Test Connection"
button I get an error message that reads: "Io
exception: The Network adapter could not establish the
connection".

I tried to resolve the problem but was unable to. I had
the listener started using the command: lsnrctl start.
I am able to ping the server. There are no firewalls
invovled. According to the documentation, the Thin
driver uses the sqlnet. I tried using the IP address
instead of the TNSNames and I still got the same error
message.

I would appreciate any help.

Thank you,

Elias S. Mouchantaf
Tel. (+961) 3 740319
[EMAIL PROTECTED]
www.moshnet.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Elias Mouchantaf
  INET: [EMAIL PROTECTED]

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

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

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

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

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

Disk configuration

[KC]

Dear List,
 
Someone told me when a disk receive a 
write request, it write to the nearest free space on disk where the disk 
read/write head is currently positioning, is this information correct?? If this 
is true, is this a bad thing for database application?? That mean we can't 
really control where the file go, for performance purpose we may want to put 
certain files on the outer tracks of a disk, if the write location is depending 
on where the read/write head is, how can we avoid that, can we create subdisks 
from the outer track of a disk and create a logical volume from 
it??
 
KC

Jdeveloper Compatibility

[Kevin Kostyszyn]

Hi all,
I have a question wondering if someone could help me out.  Has anyone heard
of compatibility issues with Jdeveloper 3.2.3 on Winnt and versions of
Oracle DB's.  I have someone here telling me that it won't work with Oracle
8.1.6 SE, and it is causing me MAJOR issues.  So if anyone know's anything
it would be greatly appreciated.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

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

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

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

OT RE: * I'm Looking for an Oracle Financials DBA for Miami,

[Boivin, Patrice J]

This is interesting, at home I received an e-mail from a recruiter from
Florida, who said that he had hundreds of positions to fill, etc. etc.

I just answered:  "if this is not spam, let me know."

He replied:  "It's not spam!!"

But I strongly suspect that he is in fact just building a database of
résumés, sometimes I wonder if there isn't a market for these things,
"résumé banks" on the Web are popping up here and there.

I doubt that employers actually rely on these, they are much more likely in
my opinion to go to local IT recruiting firms.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Gene Sais [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, June 19, 2001 10:56 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: * I'm Looking for an Oracle Financials DBA for
Miami,

Florida has always been a weak market compared to rest of the USA.
I remember in NYC, you could go get another job at a lunchtime interview.
DC area has a good job market.  Pick up the NY Times or Washington Post.
Not sure on the rest of the country.  BTW, the financials job in Miami is at
DelMonte and they have been looking for over a year.

>>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
"DBA" jobs listings on ComputerJobs.com for the Florida area have
gone from 1572 to 846 over the past 6 months. The job ads you see are
repeated each week and are posted by more than one recruiter for the same
job. Contact with the recruiter results in the " job is filled" or some
other lame excuse. It appears that they are building a resume database
incase the market opens up again. In the past weeks we have been contacted 2
or 3 times a week by recruiters inquiring "if we have any opening that they
can fill?"
 I think the market is tight right now and "downsizing" will
continue for a while until the economy picks up. Weekly the papers report
another company in the Atlanta, GA area going through the "size" adjustment.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
Gregory Conron schrieb:
> 
> On June 16, 2001 04:35 am, Jared Still wrote:
> >Many of
> > us consider this a service, especially the way that jobs are
> > at the moment.
> 
> Amazing the difference a year can make, eh?
> 

Hi

Just curious: How bad is the job situation in the US right now ? 
I'm wondering since we consider moving there (my wife is american).

 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FIBM  |
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ron Rogers
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gene Sais
  INET: [EMAIL PROTECTED]

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

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

Re: Externally Identified User - Serious Weirdness

[Chaim . Katz]

I don't think BSIDBA and OPS$BSIDBA are the same Oracle user.  (Check in
dba_users).  So ops$bsidba probably doesn't own the tables? (Maybe the install
went wrong because of  the value of the initializaion parameter
os_authent_prefix which I think could be null or could be ops$ or some other
value) I'm not sure how you could run the program and make it log in as bsidba;
most probably you'll have to supply a username and pwd.
Are there really new apps written in COBOL?  :-)

chaim





"Ron Rogers" <[EMAIL PROTECTED]> on 06/18/2001 04:45:03 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)







David,
 Is FA_IDNT a view that you didn't know about that the package uses?
Just a thought.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/18/01 03:16PM >>>

Hope everybody had a good weekend -

Working on HP-UX and Oracle 8.1.7.0.0

I've got a third party app that 's written in COBOL and stores some of the
information it needs to generate screens in the database.  I am trying to
practice restoring this beast, and it turns out I must run a utility to
recompile some of the COBOL.  All users in this database are identified
externally and have OPS$ as the prefix to their username.  The table(s) in
question are owned by Oracle user BSIDBA.  The UNIX user BSIDBA runs the
program and the user in v$session shows up as OPS$BSIDBA.  I get an
ora-00942  on a select count (*) from one of the tables.  Generally, this
means some type of privilege is missing, but this user owns the table!
Just in case, I granted select on the table to OPS$BSIDBA, got a 'grant
succeeded', reran the COBOL piece, and got the same error.

Set up tracing, ran it again, ran tkprof against the output, and sure
enough:

The following statement encountered a error during parse:
select count(*) from FA_IDNT
Error encountered: ORA-00942

I've granted everything I can think of to everyone I can find (this is - or
will be - a development instance) and am still getting the error.  Metalink
hasn't revealed any secrets.

Anybody seen anything like this or have an idea of something else I can try
- the vendor has given up, says it's a DB problem.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

--
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: Ron Rogers
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Latchs

[Raghu Kota]

Oracle8i Internal Sevices
by
steve Adams.


>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Latchs
>Date: Tue, 19 Jun 2001 02:55:21 -0800
>
>
>  Hi folks.
>
>  I'd  like  to  know  about  different  latchs,  wait events and 
>locks.
>Meaning  of  willing to wait and immediate ratio and all anothers things in
>relation with that.
>
>  Anybody  knows  about  documents,  books, notes in Metalink, etc 
>about
>that?.
>
>  Thank you very much in advence.
>
>  Regards.
>
>  Miguel.
>
>
>"Este  mensaje  y  los  documentos  que,  en  su caso, lleve anexos, pueden
>contener  información  confidencial. Por ello, se informa a quien lo reciba
>por error que la información contenida en el mismo es reservada y su uso no
>autorizado  está prohibido  legalmente, por lo que en tal caso  le  rogamos
>que  nos  lo  comunique  por la misma vía o por teléfono (901 113 113) , se
>abstenga  de realizar copias del mensaje  o  remitirlo o entregarlo  a otra
>persona y proceda a borrarlo de inmediato."
>
>
>--
>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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

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

RE: Installing oracle remotely

[gnorwell]

Does anyine have a current link to the VNC binaries for AIX 4.3? The link documented on the VNC home page at ATT Cambridge Labs is a dead URL.


Regards,

Gary
_
Good judgement comes from experience.
Experience comes from bad judgement.




__


We do it using an X based system such as VNC.  Out machines are at
co-locations around the US.

RE: how to insert quote in a column

[Kevin Lange]

'''joy'''

-Original Message-
Sent: Monday, June 18, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.

Thanks
Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder 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: Kevin Lange
  INET: [EMAIL PROTECTED]

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

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

Re: * I'm Looking for an Oracle Financials DBA for Miami,

[kjanusz]

The Minneapolis / St. Paul area is not very active for 
Oracle people now.  We have about 175 Oracle shops in 
the area.

Ken Janusz, CPIM
> Florida has always been a weak market compared to rest of the USA.  I remember 
> in NYC, you could go get another job at a lunchtime interview.  DC area has a 
> good job market.  Pick up the NY Times or Washington Post.  Not sure on the rest 
> of the country.  BTW, the financials job in Miami is at DelMonte and they have 
> been looking for over a year.
> 
> >>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
> "DBA" jobs listings on ComputerJobs.com for the Florida area have gone from 1572 
> to 846 over the past 6 months. The job ads you see are repeated each week and 
> are posted by more than one recruiter for the same job. Contact with the 
> recruiter results in the " job is filled" or some other lame excuse. It appears 
> that they are building a resume database incase the market opens up again. In 
> the past weeks we have been contacted 2 or 3 times a week by recruiters 
> inquiring "if we have any opening that they can fill?"
>  I think the market is tight right now and "downsizing" will continue for a > while 
>until the economy picks up. Weekly the papers report another company in 
> the Atlanta, GA area going through the "size" adjustment.
> ROR mª¿ªm
> 
> >>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
> Gregory Conron schrieb:
> > 
> > On June 16, 2001 04:35 am, Jared Still wrote:
> > >Many of
> > > us consider this a service, especially the way that jobs are
> > > at the moment.
> > 
> > Amazing the difference a year can make, eh?
> > 
> 
> Hi
> 
> Just curious: How bad is the job situation in the US right now ? 
> I'm wondering since we consider moving there (my wife is american).
> 
>  
> | Regards,   |
> | Stefan Jahnke  |
> | BOV AG |
> | @:D2 Vodafone, Abt.: FIBM  |
>  
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Stefan Jahnke
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ron Rogers
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Gene Sais
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Intermedia Questions, Any Gurus on This Subject?

[Koivu, Lisa]

Title: RE: Intermedia Questions, Any Gurus on This Subject?





Hi Vicky, 


You need to create a preference to define the storage clause with CTX_DDL.  I did this at a former employer and I don't have the scripts handy, sorry to say.  The documentation does go over this in detail.  You can specify just about everything for storage of your imt index in the preference.  You can even put the separate pieces of the index in separate ts's.  Buffer pool though, I'm not sure. See below a cutout from the doco.

 Specifying Storage Attributes


The following examples specify that the index tables are to be created in the foo tablespace with an initial extent of 1K:

begin
ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)'); 
ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)'); 
ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)'); 
ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',
'tablespace foo storage (initial 1K)'); 
ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',
'tablespace foo storage (initial 1K)'); 
end;


HTH
Lisa Koivu
Oracle Database Administrator
954-935-4117


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

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



-Original Message-
From:   Oracle DBA [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, June 19, 2001 9:11 AM
To: Multiple recipients of list ORACLE-L
Subject:    Intermedia Questions, Any Gurus on This Subject?


Help anybody, version 8.1.6.3 on UNIX


1.  Storage clause of an intermedia index build.  How
to specify the buffer pool to KEEP or CACHE the index?


2.  How to specify the tablespace for such a DOMAIN
index. When put in tablespace clause, says its invalid
option for domain index.



Thanx



=
Vicky D. Foster, 
Oracle DBA
email:  [EMAIL PROTECTED]


__
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oracle DBA
  INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Intermedia Questions, Any Gurus on This Subject?

[Hatzistavrou Giannis]

There is a wealth of docs regarding this issue in OTN
also check

http://www.oracle.com/products/intermedia

> -Original Message-
> From: Oracle DBA [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 19, 2001 15:11
> To:   Multiple recipients of list ORACLE-L
> Subject:  Intermedia Questions, Any Gurus on This Subject?
> 
> Help anybody, version 8.1.6.3 on UNIX
> 
> 1.  Storage clause of an intermedia index build.  How
> to specify the buffer pool to KEEP or CACHE the index?
> 
> 2.  How to specify the tablespace for such a DOMAIN
> index. When put in tablespace clause, says its invalid
> option for domain index.
> 
> 
> Thanx
> 
> 
> =
> Vicky D. Foster, 
> Oracle DBA
> email:  [EMAIL PROTECTED]
> 
> __
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Oracle DBA
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Hatzistavrou Giannis
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: * I'm Looking for an Oracle Financials DBA for Miami,

[Gene Sais]

Florida has always been a weak market compared to rest of the USA.  I remember in NYC, 
you could go get another job at a lunchtime interview.  DC area has a good job market. 
 Pick up the NY Times or Washington Post.  Not sure on the rest of the country.  BTW, 
the financials job in Miami is at DelMonte and they have been looking for over a year.

>>> [EMAIL PROTECTED] 06/19/01 09:06AM >>>
"DBA" jobs listings on ComputerJobs.com for the Florida area have gone from 1572 to 
846 over the past 6 months. The job ads you see are repeated each week and are posted 
by more than one recruiter for the same job. Contact with the recruiter results in the 
" job is filled" or some other lame excuse. It appears that they are building a resume 
database incase the market opens up again. In the past weeks we have been contacted 2 
or 3 times a week by recruiters inquiring "if we have any opening that they can fill?"
 I think the market is tight right now and "downsizing" will continue for a while 
until the economy picks up. Weekly the papers report another company in the Atlanta, 
GA area going through the "size" adjustment.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 06/19/01 03:15AM >>>
Gregory Conron schrieb:
> 
> On June 16, 2001 04:35 am, Jared Still wrote:
> >Many of
> > us consider this a service, especially the way that jobs are
> > at the moment.
> 
> Amazing the difference a year can make, eh?
> 

Hi

Just curious: How bad is the job situation in the US right now ? 
I'm wondering since we consider moving there (my wife is american).

 
| Regards,   |
| Stefan Jahnke  |
| BOV AG |
| @:D2 Vodafone, Abt.: FIBM  |
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Stefan Jahnke
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ron Rogers
  INET: [EMAIL PROTECTED] 

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Gene Sais
  INET: [EMAIL PROTECTED]

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

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

What the difference between qio and direct I/O option in VxFS

[KC]

Dear List,
 
What the difference between qio and direct I/O 
option in Veritas file system VxFS??
 
KC

RE: ftp

[Lord David]

Thanks all, I'll remember to bookmark it this time.

David Lord

-Original Message-
Sent: 19 June 2001 13:05
To: Multiple recipients of list ORACLE-L


ftp://oracle-ftp.oracle.com  

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

E-Mail: [EMAIL PROTECTED]  



-Original Message-
From:   Lord David [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, June 19, 2001 6:47 AM
To: Multiple recipients of list ORACLE-L
Subject:ftp

Hi

Someone posted the address of the oracle ftp site a while back.  As
I've
forgotten it, could they repost it.

TIA
David Lord
Senior DBA, Hays Commercial Services, IT Solutions
 

**
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they

are addressed. If you have received this email in error please
notify 
the system manager.

This footnote also confirms that this email message has been swept
by 
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lord David
  INET: [EMAIL PROTECTED]

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

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

STARTUP ??

[Bunyamin K. Karadeniz]

os : WINDOWS 
ADVANCED SERVER 2000
DB: ORACLE 8.1.6
 
MY question is how to execute a script on each 
startup of database on NT ??
 
Thanks 
Bunyamin

Re: How to find the size of all the tables under a particular

[JOE TESTA]

why not analyze the table and look at avg_row_len column on 
user_tables?
 
joe
 
>>> [EMAIL PROTECTED] 06/19/01 04:30AM 
>>>Dear DBA Gurus,    I need to find the 
size of one row of all the tables under a particularschema using vsize 
clause.  How do I do this?  Please help.TIA and 
Regards,Ranganath-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Ranganath K  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).