Its not a rastafarian DBA introducing himself is it :-)
-Original Message-
Sent: 26 February 2001 20:43
To: Multiple recipients of list ORACLE-L
Does anyone know what iDBA is?
--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
Since version 4 and 5, it is constantly claimed by
Oracle that
You could set up a marker file at the end of job A.
ie
if [ 'successful' ] # insert what ever code you would do to check this.
then
touch job_ok
else
'more code if failure'
fi
# End of script.
When job B kicks in just test for existence of file job_ok before backing up
to
hi all...
my database user US7ASCII as a database character set.
with this character set. .. can i insert some germany words corectly ?
or it will be a problem if i insert some germany words ?
regards
abimanyu
"I'll be back!"
Arnold Schwarzenegger
--
Please see the official ORACLE-L FAQ:
if you have same character set on both sides - server and client then you
have no conversion need and you can store special characters without
problems, but whenever you will need conversion (client with other character
set than us7ascii) then you will fall into troubles.
Regards
Ivo Libal
List,
our AIX suddenly stpped responding... and we had to kill some of the
oracle (LOCAL=NO) processes to return the system back to normal...
apparently the paging space filled up..and OS was unable to create any more
proceses
is there any way to know which oracle process is responsible for
If archivelog database perform online dairy backup (all tablespaces datafiles,
controlfile to trace binary), dairy archived redo logs to tape. Only perform full
backup (offline, archivelog on) once a year.
If it happened that all datafiles, controlfiles redologs gone, which copies of
Hi Kangwen,
You should use whichever is the latest set of files from either your annual
offline backup
or the last online daily backups.
Martin
-Original Message-
Sent: 27 February 2001 10:01
To: Multiple recipients of list ORACLE-L
If archivelog database perform online dairy backup
Hi,
I'm currently testing the Oracle 8i new
datawarehousing functionnalities. Are you using
materialised view for aggregate dimension ?
The second question is what do you do with yes/no
flags. They can be put in the fact table or they can
be put in a profile dimension. Is there another way ?
Hi Friends :
Does anyone use command whenever in sql plus.
I have cron working with sqlplus ( as sqlplus file.txt) then
when occurs some errors or not it return messages, because i am setting
serveroutput on.
Well, I would like to control it. and giving message only when unsucessfull
GOOD BUT I DID NOT UNDERSTAND WHAT IT MEANT CAN YOU ELOBORATE THOUGH
IT IS TEST MAIL. CAN YOU?
-Original Message-
Sent: Tuesday, February 27, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
test
PS: Hampir lupa,
IT DOES USE
-Original Message-
Sent: Tuesday, February 27, 2001 11:10 AM
To: Multiple recipients of list ORACLE-L
why need to change the semaphores ??.. isnt AIX uses kernal extensions for
the same ?
--
From: Viraj Luthra[SMTP:[EMAIL PROTECTED]]
Reply To:[EMAIL
Hi,
When you use whenever, you'll have the opportunity to continue the execution
of your script or exiting with a code error at the first one. Hence, you
must be sure whether you want to exit or continue with the transaction. And
in the first case, you will send a message error only through
AIX doesn't use semaphores. You must run the script rootpre.sh to create the
/etc/loadext This is because AIX uses post-wait drivers.
Regards.
-Mensaje original-
De: rammohan [SMTP:[EMAIL PROTECTED]]
Enviado el: martes 27 de febrero de 2001 12:30
Para: Multiple recipients of
The easiest way, from my perspective is to code the 'A' job to create a
file of zero bytes (touch command) upon successful completion. Then code
job 'B' to remove the file as the first step or exit if not there.
-Original Message-
From: David Jones [SMTP:[EMAIL PROTECTED]]
Sent:
Hi all ,
Nowadays , I have to write an XML
application for querying from Oracle dtabase and showing the results in a web
browser . What must I do ? I have read a book of XML but I did not
understand how I will connect to database and load the query results to xml
tags.
Is there any
Raman, this isn't a settable parameter within AIX. The post-wait
kernel extension takes care of this.
Taken from the installation guide..
Oracle Post-Wait Kernel Extension
The Oracle post-wait kernel extension implements an optimized mechanism
of inter-process communications without the
in the cron job write out a file that tells success or not and have job
b read it.
joe
David Jones wrote:
Dear Lister:
I have two cron jobs which run at 10:30 PM 2:00 AM, job A performed a DB
hot backup and job B will put those backup files into tapes. The problem is
job B is based on
http://technet.oracle.com/tech/xml/#techinfois the place to start reading from
For returning data to XML u have several options:
- use the Oracle XML SQL Utility (http://technet.oracle.com/tech/xml/oracle_xsu/)
which will "generate an XML document (string or DOM) given a SQL
query" or
Dear all
First I installed the Oracle 8.0.5 client S/w at the client m/c , when i
try to install Developer 6.0 at the client m/c
Itz giving the Some DLL error ...I am using the ORACLE_HOME="c:\orawin95"
,Client m/c has win 98 OS .
or
If i installed Developer 6.0 first , than Oracle client
hi list !
I'm trying to be a little bit standard and put my system in a setup file that
can be installed from 'Oracle installer',but the tool named project builder
keeps giving me errors and sometimes it crahses when I include much files,so
did anyone use it?
Rahul, I cut this from a MetaLink forum response. The entire
conversation can found at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=41122.999
Your question may be able to be found if you have root access and the
time to search through each procees or
That true, AIX don't have those parameter. My system adm. told me they are
self adjustable. I don't know it is correct or not?
Joan
-Original Message-
Sent: Tuesday, February 27, 2001 12:40 AM
To: Multiple recipients of list ORACLE-L
why need to change the semaphores ??.. isnt AIX
There had been a Y2K problem with some releases of Developer 6.0. Maybe it
should be due to it . The installer on Developer6 CD can't run perfectly
after 01.01.2000.
The installer must be the 3.3.1.1.0.c or greater. Try to check it, maybe !
--
Please see the official ORACLE-L FAQ:
Thank you Marin,
- Original Message -
From:
Marin Dimitrov
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, February 27, 2001 4:20
PM
Subject: Re: anyone interested in XML
http://technet.oracle.com/tech/xml/#techinfois the place to start reading
Hi,
I want to use Oracle Rman utility on NT to backup a 8.0.5 database on normal
tape.
Do you know if I need to use a "Media Manager" and, if so, from where can I
get one? Is there any which comes with Oracle Enterprise Edition?
I don't have any special tape device, but a normal one on a Dell
At 01:26 AM 2/27/01 -0800, Libal, Ivo wrote:
if you have same character set on both sides - server and client then you
have no conversion need and you can store special characters without
problems, but whenever you will need conversion (client with other character
set than us7ascii) then you will
As others have pointed out on this thread, I was wrong, and you
can in fact pin packages in a startup trigger that have not been
loaded into memory. I was confusing this with functions and
procedures (and cursors) which have to be in memory before they
are pinned and will raise an error if
Use the TO_LOB function. For example:
INSERT INTO my_blob_table SELECT id_num, TO_LOB(my_raw_field) FROM
my_raw_table;
TO_LOB must be used in the select list of a subquery in an INSERT statement.
--
Karl Gruel
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
I agree, I did offline and online off the peak time and I did create another
temp to redirect all the user in day time. My apology to the list. The
answer is not complete.
Joan
-Original Message-
Christian
Sent: Monday, February 26, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Hi,
In order to avoid ORA-1555s due to delayed block cleanout during a
particular conversion, we are running full table scans before the
conversion. Someone has asked if bouncing the system prior to the
conversion, which would be much faster, would suffice. I think the rollback
segment
Yes, if you want to backup directly to tape you have to use a Media Manager.
I backup to disk and then put the backups on tape with an OS backup which
avoids the cost of more software.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday,
Hi,
You are right bouncing the database won't do the trick. The next access to
the block will do the cleanout no matter if the database has gone down in
between.
Jack
I have this sentence in a pl/sql block :
w_nseqline := w_seqline;
select lpad(to_char(w_seqline, '9'), '0') into w_nseqline from
dual;
w_nseqline := w_seqline;
w_nseqline is char(6);
w_seqline is number(6).
I want the result '1'
Where
does one find the dbms_xml package?
Ian
MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-From: Marin Dimitrov
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 27, 2001 5:20
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Is this what you're looking for?
w_nseqline := lpad(to_char(w_seqline),6,'0');
Ch
"Eriovaldo do Carmo Andrietta" [EMAIL PROTECTED] on 02/27/2001 10:05:27 AM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Chaim
use:
select ltrim(to_char(w_seqline, '9')) into w_nseqline from dual;
Eriovaldo do Carmo Andrietta pe:
I have this sentence in a pl/sql block :
w_nseqline := w_seqline;
select lpad(to_char(w_seqline, '9'), '0') into w_nseqline from
dual;
Just a note that Automated Standby is not included in the standard version
of Oracle.
Steve Parker
Technical Consultant
LIS
--
Logistics Internet Systems Ltd.
Knaves House, Knaves Beech Business Centre
Loudwater, High Wycombe
Buckinghamshire , HP10 9QR,
I threw this together and it works fine. I had to have the char field
be 7 when the number was set to 6 otherwise I received ORA-06502:
PL/SQL: numeric or value error: character string buffer too small
SQL declare
2 test_int number(6) := 1;
3 test_char char(7);
4
5 begin
6
one thing I do know is that if for some reason the archived logs are not
moved to the standby site automatically (network down, etc) then you will
have to do it yourself.. so you need something to check for gaps and move
them
From: "Kevin Kostyszyn" [EMAIL PROTECTED]
Reply-To: [EMAIL
Perhaps if they converted their PL/SQL to Java, they'd get the claimed 10x
performance?
Or maybe Oracle is still trying to lookup an ORA-12154 error on Metalink...
sigh That's OK, I don't really NEED to get my unIntelligent Agent running
today. Maybe I can just guess at the problem -- it's
If you use "whenever sqlerror exit 9", then you can test the return code
for either "0" or "9" just as you described. ( You can use any number you
choose, 9 is just an example. )
HTH
John Carlson
http://www.cj.com
[EMAIL PROTECTED] 02/27/01 06:46AM
Can you send me shell script you are
Hi Russ,
Yes, a bounce will not achieve anything, and neither will a full table scan if
it is done in parallel or if 'delayed_logging_block_cleanouts' is TRUE (which is
the default at 7.3 and 8.0).
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
They need to open a TAR!
-Original Message-
Sent: Tuesday, February 27, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L
Perhaps if they converted their PL/SQL to Java, they'd get the claimed 10x
performance?
Or maybe Oracle is still trying to lookup an ORA-12154 error on
You will get a similar message if you ask Metalink to give you a list of all
the bugs for a particular version of Oracle.
At least that's what it returned last Fall.
Maybe their TEMP tablespace is too small.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original
Apparently, it's a widely held myth that a large # of extents (let's
say "BETWEEN 5 AND 1000") per table segment is bad for performance. Yet
the same sources who label the belief mistaken persist in pushing for
fitting all of a table in the INITIAL extent.
And that confuses the heck out of me.
If you are doing XML and Oracle, this book is a *must* have.
It will help you tremendously. It explains XML, Oracle's XML
tools, and how to tie it all together.
I'm working through it now, and it's much better than trying
to piece it all together from various sources of Oracle docs.
Hi Matt,
My web site has moved:
www.cybcon.com/~jkstill/util
Jared
PS. you planning to be at IOUG?
On Tue, 27 Feb 2001, Adams, Matthew (GEA, 088130) wrote:
I've misplaced my URL for Jared's Web Site.
Can someone be so kind as to provide it?
thanks
matt
R. Matt Adams - GE
SMITTY is the AIX system administration tool.
type 'smitty' at the shell prompt.
Anyone can run it, though you're likely to be
very limited as to what you can do with it unless
you have an ID zero account.
Jared
On Mon, 26 Feb 2001, rammohan wrote:
hi,
what exactly is smitty utility?
For those interested, right from the horses mouth, or other orifice as you
desire:
News Notes
MetaLink Performance - An Update
We apologize for the slow response times recently on MetaLink. All over the
world our customers are coming to and using
Christian,
Do you know of a good article on the web to explain
the workings of post wait drivers?
Thanks
Jared
On Tue, 27 Feb 2001, Trassens, Christian wrote:
AIX doesn't use semaphores. You must run the script rootpre.sh to create the
/etc/loadext This is because AIX uses post-wait
I'm considering the switch from Oracle Names to Oracle Internet Directory. One feature I liked about names was the dynamic discovery. Does dynamic discovery also work with OID? For example if one of my databases fails over to another machine in it's cluster, the names server is automatically
Hi Rafiq!
Thanks for sending me your PL/SQL code.
You do a lot of aggregations over the dblink, also
remote joins can be slow.
Suggestion:
Reverse the situation, do the selects local and insert remote.
Run the code on the 7.3.4.5 instance without @OLAP_APPS_LINK in selects
and insert
This really depends on the type of access. If it's random using indexes, the extents
don't matter much. If you do a lot of full table scans, and the extents are scattered
all over, there may be a performance degradation. YMMV as always.
[EMAIL PROTECTED] 02/27/01 01:06PM
Apparently, it's
Speaking of dairy:
Jared, your web site features an "Oracle Initialization Parms Comparison".
When I see "parm", I think of Parmesan (or, more properly, Parmigiana)
cheese.
Shouldn't that be "params"? Or "settings"?
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103
"Hagedorn, Linda" posted a message a few weeks ago about enqueue types JI and
TC. Anjo Kolk says the following:
TC is the incremental checkpoint, if I remember correctly the JI for the job
queue processe.
He's working on a new version of the wait events paper but not sure when it'll
come out.
Right, but
in pl/sql it does not work correcty ...
Why ?
I also did it in sql plus. It works correct but in procedure , no.
Eriovaldo do Carmo Andrietta
ICQ #102604225
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001
Thanks Dave, Don, and Patrice.
It's hardware RAID, a Compaq GS140 machine, and Oracle on VMS [not my
choice of OS/hardware]. Limited to one large RAID5 volume.
I'd like to make the most of what's there, because for political
reasons nothing else will change.
Does it make any sense to increase
Hi!
You might want to take a look at my shareware tool TabExp
that allows you to export any table into a XLM file.
Check it out at: http://www.materialdreams.com/products.html
Try to use the 4.0.1 Bata 1 Version and have a look.
Regards
DO
email: [EMAIL PROTECTED]
web:
Title: RE: RE: MetaSlop
You know, for an announcement to a bunch
of serious hardcore tech people, it was
sure SHORT ON DETAILS.
front end web servers...
additional hardware
uh huh
sure
fine
whatever.
The courtesy of a message with some real meat would be
nice, instead of
Man, these guys just invite the wise-ass comment, don't they? Such as:
Well maybe if the product worked better/was less confusing/had better documentation we
wouldn't all be in Metalink!
Oh no! If 4 new servers brought the system to its knees just think how bad it'll be
when the rest of the
LOL..
That was good..Jared !
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Restore Scenario
On Tue, 27 Feb 2001 [EMAIL PROTECTED] wrote:
If
Jesse company,
Might I ask how many of you who've had a problem with MetaStink have taken
the time to file a TAR with customer service on Metalink? I know I've filed 5
in the last week. The squeaky wheel normally gets the grease!
Dick Goulet
Reply
And if you were running a comparable system, what would *you* say?
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Tuesday, February 27, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Man,
Title: export / import 8.1.5 to 8.0 ?
Hi all -
Is it possible to export an 8.1.5 database and import it into an 8.0.x database? Does the compatibility or anything else special need to be set in order to make this happen?
Thanks -
Lisa
RE: RE: MetaSlopI just affraid that now that "customers are coming to and
using this valuable knowledge base in staggering numbers.", Oracle now has
ammo to charge more or charge separately for this service. It gets them $$
and will lower the usage. Dare they?
-Original Message-
Check out http://www.bookpool.com/.x/43g4gev0ii/ss/1?qs=Building+XML+Oracle
for even better prices on "Building XML Apps with Oracle"
--Scott
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:11 PM
To: Multiple recipients of
Hi Andreas,
Thanks for your suggestion for improvement. I shall pass on this to
development team for their evaluation.
Right now we are testing our migration to 8.1.6.2 and observed that
slowness. We are also working with our UNIX/Hardware team to check network
issue and confirm that the
Hello Everyone,
This new term Operational Data Store(ODS) has many definitions, like staging
area to the data warehouse, data mart, A data warehouse or reporting
database, a archive area etc etc. updated almost real time.
From your experience, is this being used in the Oracle world. What
This reminds me of an experience I had recently. I wanted to open a new
checking account. I decided on a particular bank based on the fact that
they waive numerous service charges if you do direct deposit, all ATM
transactions ( 2 teller visits a month), get your checks as images, etc...
Well,
This is the worst I can ever remember. It's an unusable joke.
Try their marketing hype site (www.oracle.com) and see how fast it comes
up...
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 4:21 PM
I would not leave
Title: MetaSlop -- More Screeching and Droning.
Our own esteemed Paul Baumgartel wants to know how our
equally esteemed Kevin would have handled the MetaCrack
announcement.
There are several possibilities, depending on what is ACTUALLY
going on in the Armani Sweatshop on Ellison Lane.
Title: MetaSlop -- More Screeching and Droning.
OH
MAN!!!Once again Ross has gone on before the rest of us and I just
can't say anything after that!! Apache running on linux based Palm
Pilotsoh...oh the pain in my stomach:)
-Original Message-From: [EMAIL PROTECTED]
Hey Dana,
Are you kidding? A GS140 running OVMS would be my choice of OS/Hardware!
OK, OS bigotry aside... ;)
The RAID5 *WILL* give you performance problems! RAID5 is the worst
performer for write operations. The LGWR,and associated slave processes
(and to a somewhat lesser extent, the
Title: RE: RE: MetaSlop - Another Response Scenario for Paul.
Scenario Two:
## For Immediate Release ###
Ap/UPI/AFP/Reuters --- Redwood Shores, 27 Feb 00
Oracle Denial of Service Attack
Oracle Corporation announced today, in a
Instantly
-Original Message-
Sent: Tuesday, February 27, 2001 1:37 PM
To: Multiple recipients of list ORACLE-L
This is the worst I can ever remember. It's an unusable joke.
Try their marketing hype site (www.oracle.com) and see how fast it comes
up...
- Original Message -
Title: MetaSlop -- More Screeching and Droning.
Hey Ross! Another classic - I may frame
this one and put it on my (virtual) office wall.
Check this out:
http://uptime.netcraft.com/up/graph/?host=metalink.oracle.com
- Original Message -
From:
Mohan,
Ross
To: Multiple
The ins_oemagent.mk keeps blowing up trying to find SUNW_1.4 in
libthread.so. Now, I know that oemagent and odg aren't necessary, but I'm
just trying to get them running anyway. Additionally, Net8 config assistant
blows up complaining that Metalink is down, oh, wait that's another topic.
Title: RE: RE: MetaSlop - Another Response Scenario for Paul.
I have
to leave before I get fired for laughing too loud!!! Ross is officially
the site comedian and witmaster!!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Hello all,
I am running oracle 8i on aix 4.3.3; I need to create a storm or some good activity in
a database. Is there some one who has some ready made scripts or suggestions as to
create this kind of activity. I want to measure my performance metrics under such
conditions.
Thanks in
Hi,
i'm getting a strange error while retrieving blobs using the
standard getBLOB(1) construct... it looks like the length of the
resulting BLOB appears to be 0 in some cases - but the EXACT query issued
2 seconds later retrieves the BLOB properly... I have a polling daemon that
is constantly
Hello all,
I am running oracle 8i on aix 4.3.3; I need to create a storm or some good activity in
a database. Is there some one who has some ready made scripts or suggestions as to
create this kind of activity. I want to measure my performance metrics under such
conditions.
Thanks in
Hi again List... hope everyone is having a pleasant
afternoon/evening/morning:
I'm looking for a list of common questions about Oracle errors that
end-users might encounter. For example, basic stuff like "no listener",
"Archiver error", "Oracle not available", "max # of extents reached", etc,
Title: RE: Creating activity in a database
I need to create a storm or some good activity in a database.
Rename your company's host name to metalink.oracle.com and
wait for the storm to begin.
(Don't worry, you won't have to provide any actual content, just
put up a few pages like Come
Title: MetaSlop -- More Screeching and Droning.
Thank
you Sir!
(we
almost used Sunguard to cover our Sequent servers, but they never
really
went
down enough to merit the cost, but...Sunguard appeared to have the
most
"adult" setup)
-Original Message-From: Rao, Maheswara
Title: RE: RE: MetaSlop - Another Response Scenario for Paul.
Ross,
I think a certain ex-president ( last name
something like clinton) needs a spin doctor like you. Thanks for the great
laughs!
Jim
-Original Message-From:
Mohan, Ross [EMAIL PROTECTED]To:
Multiple
Hi,
I have a table which has a structure similar to the
following.
MID
NOT NULL
VARCHAR2(24)NAME
VARCHAR2(512)PRIORITY
NUMBER(38)PERSISTENT
CHAR(1)EXP_DATE
DATEBODY
LONG RAW
I estimated the table storage for this table using
the formula given in the Oracle documentation. It
Can you illustrate pt. 3 please; some one told me that I must run the database in
ARCHIVELOG mode in order to get a good activity in there. Is that true? How does it
matter?
Rgds,
raja
--
On Tue, 27 Feb 2001 15:06:51
Mohan, Ross wrote:
in all seriousity,
1) Rational does Performance
I just got the following -
SYS: DBW.WORLDALTER TABLESPACE DAILY_SALES_TBL
2 ADD DATAFILE '/db19/oracle/DBW/daily_sales_tbl.dbf' SIZE
1802272768
3 /
ALTER TABLESPACE DAILY_SALES_TBL
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded
I fixed a similar problem
Hi all,
could you pls. show examples how to call os commands from pl/sql (both unix
and nt).
Thanx in advance,
Hessu
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official
just change the db_files param in init.ora..and bounce..
--
From: Charlie Mengler[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-00059: maximum number
Hi Charlie... the parameter DB_FILES is set in the init file... you have to
bounce the instance after you increase it.
The parameter you are thinking of is MAXDATAFILES which is in the control
file. And you are correct; you would need to ALTER DATABASE BACKUP
CONTROLFILE TO TRACE, edit that
All the datafiles of oracle shall have 640. That is -rw-r-.
Owner of the files will be oracle and the group shall be dba.
The users access and updation of all the oracle files
are controlled by oracle only as per the
profile of the individual oracle user.
Manoharan
[EMAIL PROTECTED]
--
Seems like sort of cow disease spread in the list. Strong techies like Jared shouldn't
he spend effort to the benefit of our list ?
Get Your Free Email From CARI - http://mail.cari.net.my
CARI - The First Malaysian Search Engine
93 matches
Mail list logo
