Ray,
I had a similar discussion a long time ago. Alter table cache or using
buffer keep is a way for caching or allocating a table in a different
buffer. Pining is a concept relate with shared pool and sql code.
Regards.
-Mensaje original-
De: Raj Gopalan [SMTP:[EMAIL PROTECTED]]
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
Ross,
I was
at the Open World conference session where Jeremy Burton made the comments about
clustering, OPS, data segmentation, etc. The data segmentation part was
about MS SQLServer, and about how it creates significant
Look for buffer keep in the documentation.
-Mensaje original-
De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Enviado el: lunes 5 de febrero de 2001 19:53
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Pinning Tables
Only method (which I am aware of ) to
Hi all,
We need to use timers on a stored procedure, from a compiled
form we've used the included built-ins to this (create_timer, etc), but
how can we use this from the database.
Thanks in advance for all your responses.
--
Please see the official ORACLE-L FAQ:
Hi,
what would you prefer to have a simple way to view and modify
table-data of an oracle-DB by a browser?
Is there a simpler way to go than OAS/iAS?
Any ODBC-plugins?
Has WebDB features that can be used?
Any comments are welcome.
Thanks
Stephan
--
Please see the official ORACLE-L FAQ:
John Dunn£¬ÄúºÃ£¡
u can use a clause in the create table command to specify the details of the
primary key,or alter table to add constraint ,using index clause to specify the detail
about the index.
for example:
sqlcreate table pk
(name char(8),
age number);
sql alter
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 17:36
Hi all,
I have been trying to find some reference on pinning tables in the SGA. I
haven't found anything, all that I am finding is table caching and the
keep
buffer
Ep,
I have 8i running concurrently on a Win2k system with SS7, and have to say
that it still runs like a dream. Like I mentioned earlier Oracle is still my
favourite databeast, but there are a few things that still cough and
splutter - like OEM for example. The Java side of things can be a
Title: RE: OT - WHAT is a FEDERATED DATABASE ???
Ross, glad to see you're starting to come up to speed here. :)
|| Only with the help of the listers, Steve! Thanks..
But for the clustering to work, businesses would have to change software
and segment the data
The CNet authors
Title: RE: OT RE: Async I/O on Windows
Alex,
thanks for your positive comments about your enjoyment
of my sense of humor. Laughing is good medicine in
these serious times.
On the other stuff, if you know of any independent testing
labs you like, I'd be curious about their results, too!
Title: OT: 175 Terabyte Objectivity Database
OOoooh, how COOL!..Objectivity is neither Oracle nor SS
is it ( gasp ) federated in any sense?
Can you tell us more? This is interesting..
-Original Message-
From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
I
understand the argument, Rodd and it raises three
points/questions:
1) I
can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN
does
for the Oracle solution, and at less cost,
and
2) Do
Title: RE: OT RE: Async I/O on Windows
Oh, btw, I have NOT supported a single large MS/SS
database, but.I would be curious to hear more about
them, and am (at least these days) the ULTIMATE AGNOSTIC.
People with religion (Larry is God, Oracle is God, Gates
is Satan, My God is better
Is there anyway to find out if a long running
concurrent program is rolling back its transactions?
Thanks
Casey
Tom,
One of the big advantages of a "standby" database is that it can be opened in the
"read only" mode just for the purpose of a report type database.
Be sure to check all of your options before you make the final decision. The report
database and the OLTP database could/should have different
There's a dynamic view called v$timer or you can get it with the function:
dbms_utility.get_time.
Regards.
-Mensaje original-
De: Sergio Boix Moriano [SMTP:[EMAIL PROTECTED]]
Enviado el: martes 6 de febrero de 2001 10:20
Para: Multiple recipients of list ORACLE-L
Asunto:
"Eric D. Pierce" wrote:
Just got off the phone w/ Oracle tech support, and they said that OEM
*is* definetly supported on Windows 2000, and should work fine.
I stand corrected. It didn't work for me or a client of mine "out of the
box" but I just went and turned on *all* the Oracle-related
AIX 4.3.3 Oracle 8.1.6.2
Is anyone using LMT's in either an OPS environment and/or ad standby
database environment? There is some concern here about using LMT's
because we are discussing these two options. I don't know or nor forsee
any problems, but would like to know if others have any
how can i start and stop cron deamon on solaris 2.6
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arslan Bahar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
It can be done like this:
column ext noprint new_value ext
select to_char(sysdate,'HH24MI') ext
from dual;
spool File.ext
select ...
spool off
The output will be in a file 'File.' where is the formatted time.
-Original Message-
From: Arul kumar [SMTP:[EMAIL PROTECTED]]
Hi
We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6. Have
anybody done this work without database downtime? What was your downtime
window for upgrade? Anybody have any suggestions about the upgrade without
downtime?
Thanks,
Jun
--
Please see the official ORACLE-L FAQ:
Terry,
I've seem LMT's used in standby db's without a problem. As a matter of
fact, if you ever want to use the standby in read-only mode, the temp
tablespace needs to be a LMT, otherwise any query resulting in a sort to
disk will fail.
Gary Kirsh
Next Extent, Inc
-Original Message-
If you add a user to Oracle and don't specify the default tablespace as
'users' it defaults to the system tablespace.
Ana Choto
American University
"Mark
I didn't - but now I have with the following result.
*
ERROR at line 1:
ORA-00900: invalid SQL statement
-Original Message-
Sent: Friday, February 02, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Did you try leaving off the semi colon? Like this, for instance:
copy from
Hi Casey,
Look at the USED_UBLK field in V$TRANSACTION, twice.
If the number is going down, then the transaction is rolling back.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Wednesday, 7 February 2001 0:00
To:
You can use the standby database in read only mode if
you are going to do reporting only.
--- "Terrian, Thomas"
[EMAIL PROTECTED] wrote:
How are you all creating reporting databases? We
currently have an OLTP
database and we wish to create a reporting database
from it. As I see it,
we
If your production database can afford a short downtime. You can copy all
the datafiles and rename the database. We did this way. Refreshed the
database everyday. 15GB database needs 15 min. downtime on the production
database. Depends on your system I guess. Or using hot backup recover to
Hi Guys
Could you suggest any Best book for System Administration and Shell
Scripting for Solaris.
Thanks
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official
Toad by Quest Software. Cheap and works great!
Ron Smith
Database Administration
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, February 06, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
Cold Fusion is one possibility. I used it quite successfully for
vendor/customer
Has anyone tried this. Any problems that you think we
should be aware of. Want to play around on a dev database, but before that
wanted to see if anyone tried it and has some useful
suggestions
Thx
Gautam
In fact there was a recent discussion on /. that if Mac OS X is ported to
x86 platform ... it could challenge Linux ...
so there we go ..
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
Ana,
Congrat. In our case it was some code running through dbms_job and some
contribution from Oracle Discoverer. It was a dataware house application
custom designed by Oracle Consulting.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
The
whole idea behind 9i is CacheFusion which uses a high-speed
interconnect to solve the pinging issues. At least that
is the marketing
line
that will only be proved in time. Any database of any size
should
be
using
A method that has worked very well for us is to re-install the base release
(eg. 8.1.6) in a different ORACLE_HOME (eg. 8.1.6.3) and then apply the
patchset (eg. 8.1.6.3). This allows different release levels to exist on
same server. I remember one of the OFA rules was to use only 3 digits for
Hi Steve,
Thanks, I wasn't aware of that. As I said, they are not busy
machines so I hadn't noticed any paging activity at all.
Two more kernels, 2.2.17 and a 2.4 are in my test area so
I guess I should upgrade once again sigh..
I would like to jump
Title: RE: ora-07445
I run daemons all the time without 7445s.
So, I'd say you found the vehicle, but not the root cause.
For future use, I'd humbly suggest you continue analysis until
you determine root cause, or be prepared to repeat history.
hth
ross
-Original Message-
I'm not sure what your particular needs are without more information but,
one way is not to "stop" it all but to control what it does with a semaphore
file. If it's scheduled in cron, then you probably have it there for a
reason. If you want to "disable" it temporarily, then add some logic to
Title: OT: 175 Terabyte Objectivity Database
The
way Objectivity sets up a federated database is that you have a
master database which records information about the
federation. An individual database can be attached or detached from
the federation. An individual database is comprised of a
Title: RE: OT - WHAT is a FEDERATED DATABASE ???
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 8:46
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
OT - WHAT is a FEDERATED DATABASE ???
Snip
the TPC is
Hi
We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6.
Have anybody done this work without database downtime? What was your
downtime window for upgrade? Anybody have any suggestions about the
upgrade without downtime?
Thanks,
Jun
--
Please see the official
I agree with you, most down time is due to human error, or applying
something (like an upgrade) to existing systems.
I don't understand how management decides whether or not to spend money on
training or on shoring up procedures to reduce down time, I suspect they
only do it when there is a
Name one company who wouldn't try to tweak a benchmark test in an
unrealistic and/or deceptive fashion in order to make a few more sales.
Oracle is guiltier than most and has made an art of it. Aren't benchmarks
supposed to help us make better decisions? Instead they just add to the
confusion.
Hey, I'm waiting for the wearable computer with the wireless link into the
network. Especially if it comes with voice command. That way when a "middle of
the night" problem occurs all I'll have to do is roll over, fix the problem, and
then fall back asleep.
Dick Goulet
Hello Casey
Run this script. It will display rollback commit of all running session
set head on
set echo off
set verify off
set feedback off
set pagesize 1000
set tab off
col "SID" format 999
col "Nb commit"format 99,999,999,999
col "Nb rollback"
Does anyone have an example of how to use transportable tablespaces with
export/import.
I want export a user (8.1.6 database) source and import fromuser
touser(8.1.6 database) target.
I tried to import fromuser/ touser, but many contraints were not created and
lost some data
so I was told to
On 6 Feb 2001, at 7:45, Bill Pribyl wrote:
Date sent: Tue, 06 Feb 2001 07:45:49 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Just got off the phone w/ Oracle tech support, and they said that OEM
*is* definetly supported on Windows 2000,
Hi all,
Thanks for all who responded to my dba/PeopleSoft query. Your insights were
very helpful.
Now I'm looking for any thoughts on Precise SQL and the Precise Enterprise
product line. From their web page, it seems like a job unto itself to run!
Any thought or experiences welcome.
Thanks
Kimberly,
There is a book on C language programming style written by Kerrigan Richie
(the FATHERS of the language) that I really love. Consequently it's at home
where it can't grow legs. Otherwise I simply use the Pro*C manual from Oracle
and follow the standard that all "EXEC SQL"
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
No
problem..
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Tuesday, February 06, 2001 03:51To: Multiple recipients of list
ORACLE-LSubject: RE: (Win2K vs NT4) /
You don't need replication. You can simply create tables on one
machine across a db link fom the first. Depends on the volume and
type of data.
We (only a few Gb) rebuild our reporting environment from transaction.
Reporting doesn't have ALL the tables from OLTP, just the ones we need,
somewhat
Jerry,
When
debugging this type of problem, you need to determine if the umlaut character is
being stored incorrectly in the database, or just displayed incorrectly when you
select it. Use the DUMP function to see the internal representation of the
character:
select
dump(col1) from
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
CacheFusion is already available in 8i. They call it the first phase, or
something along those lines. 8i version handles the redo blocks over the
interconnect, whereas the 9i will also ship the actual data blocks. So, in
There are straightforward examples in the 8.1.7 documentation. I don't know if that
feature is available in 8.1.6. But regardless, you should investigate WHY the
fromuser/touser didn't achieve the desired results or I fear you'll be disappointed
again.
Jim
[EMAIL PROTECTED] 02/06/01
Title: OT: 175 Terabyte Objectivity Database
The
way you use the word "federated" makes me think Stonebraker
or
Codd came up with it...does it transcend MS MarketSpeak?
-Original Message-From: MacGregor, Ian A.
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 1:02
O'Reilly - My bible for basics cross-platformEssential System
Administration
O'Reilly - Great intro to scripting Learning the Korn
Shell
Sun Specific - Sun Performance and Tuning Adrian Cockcroft
All these are available on Amazon.com. I buy a book just about every
well... (platitude insertion:) the good thing about pondering
the dark side of the force every once of while is that it
makes everything else look brighter. :)
On 6 Feb 2001, at 7:01, Mohan, Ross scribbled with alacrity and cogency:
PC Answer: How awful. This denigrates blah blah blah and
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
Amen on the VMWARE and the value of
knowledgeable SysAds!
-Original Message-
From: Jeffery Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:02 AM
To: Multiple recipients of list ORACLE-L
Subject: RE:
Title: RE: RE: OT NT2K vs Unix.
Lisa,
i'd
wager the PQO is a red herring.it's a shared pool allocation problem,
methinks.
I'd up
the size of the shared poolmake 20% of it available as LARGE POOL, and set
some reasonable "min_alloc" sizes.
Happy
Tuning!
-Original
The following script will be helpful as per Steve Adams suggestion...If no
of transcations going down it means there is rollback of process...
set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
,
A large client that I worked with last year had a very high volume OLTP
system and they implemented Quest's SharePlex for a reporting database. It
worked well for them. Oracle's current method of replication could never
have approached the speed they needed and it would have added overhead
It looks like that it is due to something with parallel query process.
Please check your code or degree of tables being used in your code.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 06 Feb 2001 11:00:42 -0800
Hi gurus!
I
In our UNIX environment we use PVCS from Intersolv for all of our ORACLE
relates source control. It's been in use for over 6 years now with no
problems at all.
-Original Message-
From: Paul Drake [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:17 AM
To: Multiple
Title: RE: OT NT2K vs Unix.
Hi
-
I've
installed OAS 4.0.8.1 on Solaris 2.7. When I run the env command against
my oas user (oas40), it tells me that TNS_ADMIN is set to
TNS_ADMIN=/opt/oas40/product/4.0.8.1/network/admin/tnsnames.ora. This
tnsnames contains ONLY host information for our
Third Edition is out now.
-Original Message-
Ferguson
Sent: Tuesday, February 06, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
Unix System administration handbook second edition
by: evi nemeth * garth snyder * scott seebass * trent r. hein
Shell scriping
the new kornshell
Title: RMAN
Hi, Lisa,
You need separate catalogs for rman
8.1.5 and 8.1.6, though you can put then on a single machine in different
schemas.
rman815 scripts could be found in
ORACLE_HOME815/rdbms/admin: catrman, as far as I remember.
Vadim Gorbounov
Oracle DBA
-Original
Title: RE: final frontier / RE: RE: RE: OT NT2K vs Unix.
I love it.
You WILL be assimilated.
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: OT: final frontier / RE: RE:
hi,
os : hp ux 10.2
RDBMS : oracle 7.3.4
ora 600[4146]
if i apply logs and after that am getting media
recovery complete. But if i try to open the db, i am
getting the following errors.
ora 704 - bootstrap failure.
Please help
tia
venki
Title: RE: RE: RE: OT NT2K vs Unix.
NO
WAY You can do stuff to your DB from bed with a
Palm???
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Richard JiSent:
Tuesday, February 06, 2001 2:57 PMTo: Multiple recipients of list
Title: RE: v$waitstat
Mitchell, in order to clear your waits you must bounce your database.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com
Your way selects everytime. The coder's way only deals with it when it
happens. If there are a lot of duplicates, your way is smarter and probably
quicker. If duplicates are rare, coder's way is quicker.
Dan
-Original Message-
Sent: Tuesday, February 06, 2001 4:18 PM
To: Multiple
Title: RE: OT NT2K vs Unix.
Well,
it was actually a Jonestown reference ( for those of
you
following the history of "truly devoted" religious cults),
but I
have to say I like your story better.
-Original Message-From: Mark Leith
[mailto:[EMAIL PROTECTED]]Sent: Tuesday,
Now, now, Mohan! What about those pesky calluses?
-Original Message-
Sent: Tuesday, February 06, 2001 4:28 PM
To: Multiple recipients of list ORACLE-L
You can do ALOT of things in bed with your palm.
( nyuk nyuk nyuk )
-Original Message-
Sent: Tuesday, February 06, 2001
On Tue, 06 Feb 2001, Jeffery Stevenson wrote:
Enough monkeys, enough typewriters and enough time can get you Shakespeare.
8 monkeys, 5 minutes - Win98 source code.
Cheers,
GC
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gregory Conron
INET: [EMAIL PROTECTED]
I think that in order to get correct statistics, you should take time difference
before and after you made modification. The same logic as you collect UTLBSTAT
and UTLESTAT report for database performance analysis. Let me know if I am
wrong.
Eveleen
Please respond to [EMAIL PROTECTED]
Title: RE: RE: final frontier / RE: RE: RE: OT NT2K vs Unix.
I think Larry sent a message to the list about it. ;-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 4:17 PM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
Tim
Can you cut and paste the script into your reply, because your
attachment is not working.
tia
-Original Message-
Sent: Tuesday, February 06, 2001 12:47 PM
To: Multiple recipients of list ORACLE-L
Exporting Tablespaces is not achieved using fromuser/touser. The entire
tablespace
Hi Rafiq,
The problem looks like as what you suggested.
We are working on those lines.
I thank you for your input.
Regards,
Shakeel Qureshi
[EMAIL PROTECTED]
--- Mohammad Rafiq [EMAIL PROTECTED] wrote:
It looks like that it is due to something with
parallel query process.
Please check
hi,list,
i have been learning oracle for 6 months and still have something not quite
clear:
what is the difference between schema and user? and i am not clear about the
usage of create schema,never used it in work.
thanks.
chaos
[EMAIL
Title: RE: RMAN
Lisa,
I believe when you create the catalog you can
specify a compatibility level. Haven't tried it myself so you'd have to check
the BR/RMAN docs for details. We went with an 805 catalog for our 805 sids
and an 816 for our 816 (and hopefully beyond) sids, don't have anything
I have tried this and could not get it to work. I think connect is not a SQL
statement, but a SQLPlus statement, and the dynamic_sql package only works on SQL, not
SQLPlus.
Sarah Satterthwaite
Cambridge, MA
Manasa Rao wrote:
All,
I am trying to open another session using input
Hi everybody,
I'm reading Michael R. Ault's Oracle8 DBA: Performance
Tuning. On p41 the first paragraph mentions something
like: UTLBSTAT creates STAT$BEGIN_... tables and that
UTLESTAT creates STAT$END_... tables.
I checked the scripts in 8.0.5 and 8.1.5, and found
that both STAT$BEGIN_...
I'd do it based on which is more likely to succeed. That will give you the
best performance. Also, I think there's some new DML in Oracle9i that
combines insert/update into one statement.
Marc Perkowitz
MTP Systems Consulting
In a message dated 2/6/2001 3:43:09 PM Central Standard Time,
Hi,
I encountered error when I applied the Patch 1409967 (c1409967.drv) in my
database servers. Note : The copy driver (c1409967.drv) was applied
successfully in my form server.
Has anyone encountered the same problem ?
The error occured when it copied driver file for a Java patch in the
and Ari Kaplan of this list is the CEO :)
From: "Gogala, Mladen" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: RE: OT NT2K vs Unix.
Date: Tue, 06 Feb 2001 13:11:52 -0800
It's called "PocketDBA". That would be cute if
in Transportable tablespace you use export only for the purpose to extract
metadta of the database. Together with the export you have to trasfer the
relative datafiles of the tablespace also. To trasfer data via
trasportablespace there are constraints also like both the databases (
source and
Leslie,
I do not have the book but the STATS$BEGIN... and
STATS$END... tables are created by utlbstat.sql
The utlestat.sql gathers all the stats, creates the
summary tables and formats results into the report.txt
file.
HTH
Suhen
Hi everybody,
I'm reading Michael R. Ault's Oracle8 DBA:
Hi Don,
I am using OEM 2.1.0.1 with an Exchange server as the SMTP gateway (my OMS
and repository are both on Win NT4).
My from address comes through (I can see it in Outlook) but I don't see the
To: address but this doesn't really affect us.
In OEM, my senders address is set to "[EMAIL
We're using Ver 2.1 (or is it 2.2) of OEM. Anyway, the SMTP mail
gateway is an Exchange mail server.
The problem: the "from address" gets dropped somewhere, and never
appears on the received email.
We have tried sending email to all of the following, with the same result -
no "from
test
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: TIL-TEC
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hello All,
I want to run a Job using crontab scheduling.The job is running but
with error like sqlplus and svrmgrl not found.
When I am using the crontab script then it gives some error ,like
sqlplus and svrmgrl not found.
But ths same scripts manually working fine .
So please
Hi Saroj,
crontab runs within its own environment (ie. it doesn't inherit an environment from
any .profile or /etc/profile etc), so you will have to explicitly call them in your
crontab job line (eg. . /etc/profile;script or command ) or even better declare the
variables that the script will
Hi Saroj,
You need to initialize the environment variables first in the cron
file like ORACLE_SID, ORACLE_HOME etc. Also you will have to provide
the Full path of the executables One of the sample cron file is
something like this:
banner BACKUP
echo STARTING DAILY BACKUP ON `date`..
cash it
Rao
--
On Mon, 05 Feb 2001 17:26:19
Allan Nelson wrote:
Use the cache parameter to the alter table command
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Monday, February 05, 2001 12:52 PM
Only method (which I am aware of ) to
93 matches
Mail list logo