Title: Accessing views across a db link
Try
this:
select
--+ DRIVING_SITE(rv)
*
from
view_name@remotedb rv
where
columnA = '...';
-
Regards,
Waleed
-Original Message-From: Martin, Alan
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 5:28
PMTo:
Fellow listers,
After upgrading to the latest greatest Pentium 4 desktop
( 2.3 GHZ, 512 Meg of Ram, 80 Gig disk, Yeehah! )
and dealing with the JIT bugs, I find that Oracle names no
longer works properly.
The folllowing screen dump explains it all. Start names, everything
looks hunky dory, exit
>
> It does not work on Solaris 8.
SunOS (a.k.a. BSD) used vixiecron; they dumped it when
"Solaris" went SVR4. You can still find workable copies
of Paul's original work (pretty ancient by now).
Alternative it to use perl with Schedule::Cron to process
the lines. It understands */X notation a
Alan,
This query should be resolved at the remote end. I forget which
version of Oracle was the first to know enough to do that.
Which version are you on?
Have you traced the SQL?
Jared
"Martin, Alan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2002 02:28 PM
Please respond to OR
Raj,
Thanks for the help, but in this case I need to first wash a little egg off
of my face. The problem here was at least was easily recoverable. What had
happen was we moved a database instance from one machine to another. It's
cheaper to run two instances on one box that pay Oracle for
David,
Based on the ls output it seems you may have 4 groups with 1 member in groups 1,2 & 4
but 3 members in group 3.
Do a "select * from v$log;" and see how the logs are really setup.
I would suggest you want to have the same number of members in each group.
If you want them to switch less of
> He wanted every 4 weeks -
Whoops! I miss-read.
Thanks for the correction!
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
Sigh, There are many answers to this question related
to the environment you will be deploying into. It
sounds like you are actually maintaining many
databases. Are all of them really 24x7 (i.e. less than
a minute of downtime per year) or can you schedule
maintenance in the future that will not af
Title: Accessing views across a db link
Accessing a view across a db link takes a while (fetch phase) when a *local* select statement uses a "where" clause (e.g. select * from view_name@remotedb where columnA = '...';). Does anyone know a way (other than a snapshot or materialized view of the
> > The */4 must be linux. This is not available on HP-UX 11.0.
>
> Introduced by Paul Vixie into vixiecron, subsequently adopted
> by a number of cron implementations. HP's is, unfortunately,
> not one of them. Sun's might, AIX doesn't.
It does not work on Solaris 8.
--
/Nils Höglund, Naqu
> The */4 must be linux. This is not available on HP-UX 11.0.
It works on BSD-systems too.
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav.
I'm on 8.1.6.2, Solaris 2.6.
All the unidentified sessions were active but had no SQL associated with
them.
Jay Miller
-Original Message-
Sent: Tuesday, July 02, 2002 3:43 PM
To: '[EMAIL PROTECTED]'
We just had a problem on our datawarehouse where we hit the maximum number
of processe
Here is the original reply ...
From: "Deshpande, Kirti"
Date: Thu, 20 Jun 2002 14:35:36 -0500
Subject: RE: DBMS_SYSTEM.KSDWRT question
Addition:
DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in
V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views.
- Kirit
I do not kn
Jared,
Point taken. So I guess I like to live on the edge a little... :)
I've been using crontab -e for years without problems though. .
Alan
Jare
I'm trying to recover from an install that bombed. The final step in
the install, and the only step that I still need to perform, was to
execute a configuration assistant for Oracle9i's built-in HTTP
listener. For the life of me, I can't figure out the executable name
to invoke the HTTP configurat
not available on Sun (vers 5.8) - just tried it. nor Digital UNIX.
cool though ;-)
-Original Message-
Sent: Tuesday, July 02, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
-- Ron Thomas <[EMAIL PROTECTED]> on 07/02/02 09:03:26 -0800
>
>> 0 */4 * * * your_command
>
> The *
> Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ...
No luck using this one on 8.1.6/8.1.7/9.0.1... Any gotchas?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5
In other words, it is unbreakable. Can't get in... Can't break in...
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Tuesday, July 02, 20
I would say it is unbreakable. Can't break what's already broke.
-Original Message-
Sent: Tuesday, July 02, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
In other words, it is unbreakable. Can't get in... Can't break in...
Thank You
Stephen P. Karniotis
Product Architect
Com
Your country code, my country code. I guess we're all One Big Happy World
under Oracle, because I can't work on any of my TARs, either. (Don't even
axe why *I* have to work on them...)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech In
-- "Hand, Michael T" <[EMAIL PROTECTED]> on 07/02/02 08:13:32 -0800
> Roland,
> crontab alone will not meet your needs. Hint: check the date command and
> MOD type fuctionality in a shell script.
The at command will normally take "number of days from now"
as the when to run argument. Simply h
DBMS_SYSTEM
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 12:19 PM
> And that package would be... ?
>
> Jared
>
>
>
>
>
>
> K Gopalakrishnan <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/01/2002 01:53 PM
> Please
I recently moved from one server to another and found that many of the
system object where invalid. I reran catalog.sql and catproc.sql and this
corrected the problems for me... give that a try.
Melanie
-Original Message-
Sent: Tuesday, July 02, 2002 1:05 PM
To: Multiple recipients of
Could be a Euro conversion problem. I do remember that Oracle had not
completed much of this work in time.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Mes
Fawzia, What are you querying to get the SCN
information. I would also be curious where you read
about the recovery issues in OPS environment? Oracle
maintains what is called a snapshot SCN and global
SCN. The snapshot SCN is usually maintained in the SGA
and the global SCN is maintained by the DL
Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
Hi,
We are testing our application on 9.2 and getting errors using Microsoft ODBC Driver.
we are having MDAC 2.7 installed on the machine.
Is anyone also encountered some errors using 9.2 with Microsoft odbc driver and how u
reslove the issues??
Thanks
--Harvinder
--
Please see the official
-- Ron Thomas <[EMAIL PROTECTED]> on 07/02/02 09:03:26 -0800
>
>> 0 */4 * * * your_command
>
> The */4 must be linux. This is not available on HP-UX 11.0.
Introduced by Paul Vixie into vixiecron, subsequently adopted
by a number of cron implementations. HP's is, unfortunately,
not one of th
ok, ok...were even.
-Original Message-
Sent: Tuesday, July 02, 2002 1:13 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris
You just can't forget about that dbms_output/trigger thing, can you? ;)
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2002 10:51 AM
Perl is very fast, very flexible, and quite inexpensive. :)
See my post earlier today that includes the TOC from
"Perl for Oracle DBA's"
Jared
"Post, Ethan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients o
My note must have been missing the smiley
but you guys WERE picking on me :) (MOO make him stop!
)
--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> My sincere and humble apologies to Rachel, if my earlier email has
> offended
> her. That was not the intention. I believe myself
SQL> desc dbms_system
PROCEDURE DIST_TXN_SYNC
Argument Name TypeIn/Out Default?
-- --- --
INST_NUM NUMBER IN
PROCEDURE KCFRMS
PROCEDURE KSDDDT
PROCEDURE KSD
And that package would be... ?
Jared
K Gopalakrishnan <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/01/2002 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: system event waits
John:
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and
received following errors. Can someone please help me to fix errors. This
is HIGH priority that I am working to try to find out who messed up our
database per my Manager.
SQL> begin
2 sys.dbms_logmnr.start_logmnr(
Really? I didn't realize you were on the advance copy list. :)
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
> If you can't do things carefully, you probably won't
> make it too long as a DBA anyway.
Not using 'crontab -e' *is* being careful. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
You just can't forget about that dbms_output/trigger thing, can you? ;)
Jared
"Grabowy, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2002 10:51 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subj
Folks,
Since good old MetaSh t is once again having problems, as well as the help
line I need to know if any of you have run into the following before:
PENGUIN:8.1:SYS> alter package utl_tcp compile body;
alter package utl_tcp compile body
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error
Sometimes a full table scan is better than an index lookup. Sometimes not.
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Monday, July 01, 2002 6:27 PM
To: Multiple recipients of list ORACLE-L
My queries are running exceptionally good with a rule based optimizer
I'm pretty sure this has not been done...
NOBODY(!) should be on 9012 in production - unless
you're happy with zero security. As well as the
reading-anything as Ian points out, with a little bit
of playing around its also possible to destroy any
data in the database (since a view is updatable if
They made changes to MetaLink over the weekend, I cannot search for my own
TARs because of the country code.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatic
My sincere and humble apologies to Rachel, if my earlier email has offended
her. That was not the intention. I believe myself and others that tease
and pick on Rachel, do it out of respect and love for her, and would never
intentionally mean to offend her.
I do not know about other locations an
Did Oracle back port the patch to fix the ANSI-style jonn bug to 9.0.1.2? This bug
allows one to read any table in the database despite the permission set.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 02, 2002 8:23 AM
To: Mult
Roland,
I'm assuming that "every 4 weeks" means every 28 days which means same day
of the
week (Every 4th Friday for example)
If this meets your requirements then you can try the suggestion at this
link:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b397b8d1de3d5118ff40090279
cd0f9,00.html
Title: Message
Possible could use at, and have the job re-schedule
itself for 4 weeks when it first starts - just a thought
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002
11:58 AMTo: Multiple recipients of list ORACLE-LSubject
Sigh. There are way too many packages in Oracle. Thanks Jared. I have to
share this with a developer struggling to write some parsing functions.
I'll take back all the bad reviews I posted on bookpool.com about your
book...
-Original Message-
Sent: Tuesday, July 02, 2002 12:57 AM
To:
Aww, come on, crontab -e isn't that bad! The most dangerous thing
about it is accidentally running crontab -r instead of -e. Using crontab
-e is no worse than using a wildcard with the rm command, i.e. 'rm a *'
instead of 'rm a*'. One deletes all files that start with 'a', the other
delet
1. If you have bug 1210242, then using timed_statistics=true will have a
profound impact upon performance. Get a patch, and then go to 3.
2. If you use an HP-UX release older than release 10, then using
timed_statistics=true will have a profound impact upon performance.
Upgrade HP-UX, and then go
I'd agree with Ian, because (at-least) on AIX, pre 9013 versions had smon
leak, clob leak problems.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't r
Title: Message
He
wanted every 4 weeks -
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002
11:58 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Unix - scheduling
Is a strick 14 day rule absolutely necessary, if not.
I found couple redo logs in my Oracle8.0.5 database, as shown they are
switched every 5 minutes. I'd like to have only two or three logs out there
and don't want them to be switched until every 4 hours. Is there a way to
control it that way?
Secondly, if redo log switchs every 5 minutes, does
try desc dba_tables & dba_indexes
"Guerra, Abraham
Title: RE: Unix - scheduling
Hello Gurus,
Does
anybody have a script to locate objects/segments within a file? I have a
tablespace that spreads into several files, but there is one of this files that
is hot. I would like to know which objects reside in this file. The
Oracle version is
>0 */4 * * * your_command
The */4 must be linux. This is not available on HP-UX 11.0.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."
--William Butler
Yeats.
Title: RE: Unix - scheduling
U...think they slipped something into my Mountain
Dew while I wasn't looking so that they could
log
into production directly via SQL*Plus and make some manual changes...I must have
still been
regaining my senses when I sent this...sorry
:)
-Original Mes
He specified that 0 */4 * * * would cause it to run every 4 hours. He provided an
example.
-Original Message-
Sent: Tuesday, July 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
-- Nils Höglund <[EMAIL PROTECTED]> on 07/02/02 03:28:20 -0800
> 0 */4 * * * your_command
$
Cherie,
I agree with Dick. As long as you have time to install 9.2 on your
development machine and assure yourself that it, at least, does not hurt
you, I would go with 9.2 now just to give yourself breathing room for the
next year or so.
If you stick with 9.0, you know that you will begin to f
Oracle version 9i release 2
LINUX RH7.3
===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze in
I have some people who are asking about 3'rd party data extraction tools to
pull data from Oracle into text files for loading a data warehouse. I am
not sure what the size of the project is but I think it is pretty big. The
DW is Terradata. Anyway, they are stating Oracle tools are too slow. T
The choice should be between 9.0.1.3 + patch 2121935 or 9.2. The patch is to fix a
serious, serious security problem with ANSI-style joins.If you feel the need to
go to 9i, I'd choose the latter. I don't think 9.2 has been out long enough.
Ian MacGregor
Stanford Linear Accelerator Center
Hi,
We are currently testing our application on 9.0.1.2 and it looks stable except some
bugs with function based indexes.
Is it advisable to move to 9.0.1.3 (as it is terminal release of 9.0) or 9.2 which is
just released 2 months back (and may have some bugs)
OR 9.0.1.2 is stable enough an
Roland,
crontab alone will not meet your needs. Hint: check the date command and
MOD type fuctionality in a shell script.
Good luck,
Mike
-Original Message-
Sent: Tuesday, July 02, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
>
>Hallo,
>
>anyone who has a good example on how t
Hello Cherie
I think that I saw somewhere that support for 9.0.1 will go away
about June 2003 while support for 9iR2 will be until 2005.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 4:53 PM
>
> Dick,
Title: RE: Unix - scheduling
Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to
simply schedule the cronjob to run on the 1st and 15th of each month, i.e.
# Min Hr Day Mon WkDay Command
0 0 1,15 * *
Hi All,
We are trying to install RAC on LINUX Cluster and have gotten a long way,
however when the DBCA tries to create the database we get ORA-03113
(end-of-file on communication channel).
We are sort of lost for ideas and hope that you guys(m/f) have already
struggled your way through the in
OJNK? Your term Larry? Or do I need to RTFM?
Didn't realize this had a name.
Jared
On Wednesday 26 June 2002 18:48, Larry Elkins wrote:
> Greg,
>
> When the situation is appropriate, and I don't want a correlated approach,
> I will typically use the hash aj as illustrated by your second exam
Fawzia,
Oracle it self will keep an eye on that also. It will kick the other instance
if it falls behind. So that the redo file will be switched.
Anjo.
"Malik, Fawzia" wrote:
> Hi gurus,
>
> I have a query..Basically we have an OPS set up here (8.0.6) and I have
> noticed that the scn on nod
Cherie,
First off, I had no plans to ever use 9.0 anywhere other than test to see
what was new. In your case your already on 9.0.1 and appear happy with that.
Given that you could deploy o 9.0.1 or upgrade to 9.2 now and hope for a longer
time before the next upgrade. Personally I'd make t
Cherie,
Before any upgrade I consider whether or no I really need it. For
mission critical application it would be wise to stick with what you have,
unless you have problems with it.
Now we have 9.0.1.2 in production and 9.1.3 in development and I don't
intend to move to 9.2 in nearest tim
http://www.superscripts.com/tutorial/crontab.html
On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote:
> Hallo,
>
> anyone who has a good example on how to write in the crontab if you want to schedule
>a job to run every four week.
> Is it possible to do that in unix cron job schedule.
>
> Thanks in adv
Hi,
You should not compare tkprof outputs with V$SQL,V$SQLAREA. Because,
recursive/child statistics are included in their parent statements in these
views. But, tkprof substructs recursive statistics. I mean tkprof reports real
values for statements, but dictionary doesn't.
regards...
"Orr, St
-- Nils Höglund <[EMAIL PROTECTED]> on 07/02/02 03:28:20 -0800
> 0 */4 * * * your_command
$ man 5 cronttab;
The time and date fields are:
field allowed values
- --
minute 0-59
hour
-- [EMAIL PROTECTED] on 07/02/02 00:43:19 -0800
> Hallo,
>
> anyone who has a good example on how to write in the crontab if you want to
> schedule a job to run every four week. Is it possible to do that in unix cron
> job schedule.
"Monthly" is doable. "Every 28 days" requires using at,
or a
For those of you in the Oracle Partner program, here's what looks like another
little bug to add to the 'Unbreakable' list...
Log into the Oracle partner network at http://oraclepartnernetwork.oracle.com/
and look for the Product Query Tool under 'Pricing' - It gives the cost of the
various Ora
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund w
Dick,
Thanks for your comments. So, the bottom line is that you are
recommending moving from 9.0.1.2 to 9.2?
Cherie
[EMAIL PROTECTED]
Peter,
I'm not sure what do you mean by the SQL interface
for iFS. Can you elaborate or give some links to resources?
afaik, iFS is created to store non-relational data.
However, this is mapped to relational schema in DB where iFS stores all the
information. There are also some Views created
Cherie,
For the most part I don't like using version X.0 at any point. Now in
version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i
it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i
I won't touch anything before 9.2, which is waiting fo
Guess who did?
MetaLink V2 - Note
An error occured while trying to query the system.
Please try again later
[CODE : -12541 ]
Be careful what you wish for, you just might get it!!
Dick Goulet
--
Please see the official ORACLE-L FAQ: http:
We have a couple of new applications in development that are moving to QA.
These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've
been pretty happy with this version to this point but are at a pivotal spot
in our product development cycle where we have a narrow window in which
Oracle Distributed Systems
by Charles Dye
Published by O'Reilly
ISBN: 1-56592-432-0
Also check the online docs for the replication sections.
Dave
-Original Message-
Sent: Tuesday, July 02, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L
Hi
I would like someone out there to
First
off - thanks to Chris and Alexandre for their helpful input on the subject of
iFS.
Brief
question - does anyone know of the status of SQL as an interface to iFS? I know
this has been promised, but whether delivered yet I just don't
know...
thanks,
peter
edinburgh
.
Hi
I would like someone out there to give me a name of a good book and
websites where I can learn more about Replication. From configuration
(setting up replication) to solving problems (conflict resolutions /
trouble shooting).
Please any website and good book. I am involved in big project and I
Thinking about it logically how can any 2 systems that are used
independently (which in a way is what OPS is)always keep the same SCN
numbers together.
As long as each of the instances has it's own set of redo log files and it's
own set of archived log files (i.e both nodes/instances not writing t
Peter,
Is the cpu a P chip. That stops the java from running. Search the
web for the "solution to JREW error on pentium 4 installations" for the
solution. www.orafaq.com has the messages.
Ron
ROR mª¿ªm
>>> [EMAIL PROTECTED] 07/01/02 05:03PM >>>
One of our developers is having a problem insta
On metastink check out NOTE:131299.1. This has detailed instructions for three
different work arounds.
Dave
-Original Message-
Sent: Monday, July 01, 2002 8:27 PM
To: Multiple recipients of list ORACLE-L
Hi
I am guessing that he has a P4 cpu in the system and you need to do the
foll
Hi gurus,
I have a query..Basically we have an OPS set up here (8.0.6) and I have
noticed that the scn on node A is 500 and the scn on node B is 2000. I am
concerned about this w.r.t recovery- surely this would be an issue ??I
logged a call with oracle and they said it wasnt an issue, but then
> anyone who has a good example on how to write in the crontab if you want to schedule
>a job to run every four week.
> Is it possible to do that in unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) ma
>
>Hallo,
>
>anyone who has a good example on how to write in
>the crontab if you want to schedule a job to run
>every four week.
>Is it possible to do that in unix cron job
>schedule.
>
>Thanks in advance
>
>
>Roland
>
Roland,
Please, just for once, couldn't you try to figure out things by y
Jared's passion to regular expessions is understandable after book "Perl for
Oracle DBAs" :)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 8:03 AM
>
> Yes, but not nearly as flexible as owa_pattern, and infinitely
> more
I had experienced a similar thing too. But I had opened the database with
the compatible parameter database needed to startup..
Try to change the compatible parameter in my opinion to open the database.
,
Bunyamin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL
I had a problem.
Trying to drop a column from a Oracle 8i Table (personal edition on a
w2kPro) i got the following message (or similar) " you can't drop a table
with 8.0.5 compatibility, you need at least 8.1.0. !
Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio)
and all
Hallo,
anyone who has a good example on how to write in the crontab if you want to schedule a
job to run every four week.
Is it possible to do that in unix cron job schedule.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
"Oracle9i New Features" is pretty much concise and descriptive at the same
time. Good Job!
I used "Oracle8i New Features For Administrators Exam Cram" and found it a
helpful resource. Thanks!
Alexandre
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent
94 matches
Mail list logo