C# ?
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
Denham Eva [EMAIL PROTECTED] 22/02/2002 03:13 PM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
I haven't actually tested this, but how about something like: -
select count(distinct(b.num))
from range a, numbers b
where b.num = a.begin
and b.num = a.end
/
--
David Lord
-Original Message-
From: oracle dba [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 04:03
To: Multiple
Title: RE: password question
Tough crowd. I never said it would be easy. Original question was just decrypting with the assumption that access to dba_users was given. Perhaps I should setup a test environment and sniff traffic going to port 1521 to see if usernames and hashes just happen to
Title: RE: Oracle8i - Oracle9i issue??
Yeah they refer to it as C Sharp as in the music # symbol.
It is Microsoft's C.Net - I think.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 10:08 AM
To: Multiple recipients of list
SET ORACLE-L MAIL
*
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete
Hi Ladies and Gents,
I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an
un-named monitoring tool against it this morning, the instance crashed with
a bunch of ORA-600's in the alert log. Below are the two that appeared,
though the first turned up about 10 times
Jared,
I've also been looking at this - installed 9i yesterday.. Here you go:
USERNAME PASSWORD
-- --
WKSYS 69ED49EE1851900D
SH 9793B3777CD3BD1A
SCOTT
Title: RE: Woopeee and TWO ORA-600's!
Mark
The ora600 lookup tool on Metalink states that there is no description for this code
John
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2002 09:34
To: Multiple recipients of list ORACLE-L
Subject: Woopeee
- Original Message -
I am using java only
The code as follows:
Please give me some suggestions in solving this problem
which problem?
what is the exception?
Marin
...what you brought from your past, is of no use in your present. When
you must choose a new path, do
Corvu, Cognos, Crystal reports(oops did I say that),
Oracle Discoverer,
Depends on the budget and what you really need to do. The first to are to very
powerful tools but do cost a bit but they will use native links annd you can generate
much smater queries with them
Access and ODBC may well
Ahh well!
I have another question following this:
I am also getting the following error on startup:
Fri Feb 22 09:33:04 2002
Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC:
ORA-04031: unable to allocate 4032 bytes of shared memory (shared
pool,unknown object,joxs heap
I am getting some conflicting answers to what I deem to be a fairly simple
question. Does Oracle Spatial support storage of raster data?
We are looking at this in particular to reference to GIS systems. I have
contacted MapInfo Support and have been told that Oracle Spatial does not
store
Hi,
I think you might have read my java code.
My problem is
I am not at all getting connected to the database.
Anything wrong in my code.i don't understand whether the problem is with
some settings on the server[Solaris] or Java code
Please check my code give me your suggestions
Title: RE: Woopeee and TWO ORA-600's!
Mark,
Here are a couple of notes I saved on the subject
John
rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following.
If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql
You can tell RMAN to delete the archive files. We tell RMAN to keep the last 12 hours
on disk.
run
{
allocate channel ch1 type disk format '/bkup1/oracle/%d/full_s%s_p%p_%t';
allocate channel ch2 type disk format '/bkup5/oracle/%d/full_s%s_p%p_%t';
set limit channel ch1 kbytes=100; #
Title: Problem with Rollback segment getting locked
Hi All,
I have about 12 Rollback segmennts in my database 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks
- Original Message -
I am not at all getting connected to the database.
what is the exception?
if u don't get connection for some reason then an exception is thrown with
the proper error code
can u access the instance [EMAIL PROTECTED]:1521:edb with any tool?
also next time don't
It might be the case, that the dictionary cache cannot store any information
of type LONG (which the view text is), but that requires more investigation.
If somebody knows, please inform the rest of us.
But you can just turn on sql_trace and see the query against view$ for each
parse.
You should consider doing a create newtable as select with the oposite
conditions as your delete, followed by a truncate/drop, exchange partition or
whatever. Delete is really hard against the undo segments.
/Bjørn.
On Thursday 21 February 2002 23:13, you wrote:
Hello All,
I have a
Title: RE: Woopeee and TWO ORA-600's!
Thanks
John, worked likea charm! Thanks for the pointer too Tom, but thanks to
John it's all sorted..
Cheers!
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent: 22
February 2002
Mark,
I've had success running removing Java by running the following package:
exec sys.rmjvm(true);
The package sould have been installed when Java was installed.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, February 22, 2002 6:08
Title: Problem with Rollback segment getting locked
I
might not be right but why dont u try reducing the number of transaction per
rollback segment and see
-Original Message-From: Viral Amin
[mailto:[EMAIL PROTECTED]]Sent: Friday, February 22, 2002
7:29 AMTo: Multiple
9i starts to use some of the java stuff all by itself
which possibly explains the error. For example, there
is now a trigger on every create-table to handle the
cdc publish/subscribe features. This of course means
you typically to allocate something to the java pool
(if you have installed java)
Title: Problem with Rollback segment getting locked
Hi, Viral,
Are these RB segments public?
Regards,
Sergey
-Original Message-
From: Viral Amin [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002
7:29 AM
To: Multiple recipients of list
ORACLE-L
Subject: Problem with
Couple of days ago I have a ORA-600 [26599], it was being signaled during
our periodic recompilation cron job. It turned out to be that a clever
duheveloper had a hard new line character in an object name. Once we took it
out, the error went away. This happened in 9012.
Raj
Jamadagni, Rajendra would like to recall the message, Woopeee and TWO
ORA-600's!.
*2
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged,
What lock ? And did you specify optimal ?
Viral Amin wrote:
Hi All,
I have about 12 Rollback
segmennts in my database 25 concurrent users logged in. I am continuously
facing problems of oracle just keep locking couple of Rollback segments.
other people have to wait till Oracle releses the
sorry ... I am trying too fast ... the error parameter was different it
wasn't 26599 ... I am heading for a coffee.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Our management has started asking questions about how Oracle's licensing costs
compare to other database vendors. Specifically, DB2 and Sql Server. I think I am
pretty well armed with the features arguments, at least for Oracle vs. Sql Server,
but I really have no clue about licensing and
The following command will backup you archivelogs and then delete them if
the backup is successful.
(archivelog all
delete input);
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 4:58 PM
Ashoke
If I
I tried to setup SQl*NET (ORACLE 8/8i)trace on client side and put
trace_level_server=10
on sqlnet.ora. I did NOT see log file
($ORACLE_HOME/network/log) generate.
Does anyone know why?
Thanks.
_
Send and receive
Is anyone using this combination? We're having problems getting backups to work with
8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control
panel says the backup has started, but it doesn't finish and usually has a dead rman
process on the db.
We've working with
Hi Chuan,
The views dba_jobs, user_jobs show information about the jobs.
It will be removed after the next execution.
Once happen to me and the job had to broke it before remove it.
The experts of the list can show more light about the subject.
Luck,
-Original Message-
Sent: Friday,
Hi from the Swow storm from Sweden,
We wants to try to run Oracle on a Linux Cluster.
Is someone using Oracle on a Linux Cluster ?
Who is your configuration ?
1- (DELL,HP,Compaq,..)
2- Which Linux version ?
3- Which Oracle version ?
4- Is is fun ?
Best Regards,
HEnrik
--
I am thinking of implementing replication for remote sites. What I have not
been able to gather from documentation to date is
what are the pre steps required to setup a replicated site(master
destination)
what are the steps to bring the replicated site online after the
master
Anjo,
I usually advise in the strongest possible words against setting
"optimal". May logic is that if rollback segment
extends occasionally then
we
should leave the space allocated to a) prevent the dynamic disk
space
management and b) to make room for large queries. The
space will be
Title: RE: 8i and Veritas NetBackup
The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John
Hi,
In order for RMAN to work with a third party backup product the third party
vendor writes an interface to an Oracle supplied API and
You are right that the range aren't necessarily contigous.
I'd probably have to write it in PL/SQL, I just want to see
if one can do this with SQL.
Thanks.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: sql question
Title: Dropping users from Oracle 9i seed database.
You
can drop the following users:
scott (demo)
ctxsys (context)
wksys (workflow)
mdsys (Oracle*Media)
Hopefully, this font is big enough. Yours was a wee bit
too small.
-Original Message-From: Yuval Arnon
[mailto:[EMAIL
Rich,
how about :
SELECT col1 FROM TEST
WHERE EXISTS(SELECT 1 FROM RANGE
WHERE col1 BETWEEN BEGIN AND END)
The above is where the TEST table contains the list of numbers.
I assume that, even though your RANGE table has begin/end entries of 1,9
that 1 and 9 are valid. If
On Friday 22 February 2002 16:03, Henrik Ekenberg wrote:
Who is your configuration ?
Two nodes running in VMWare on an HP laptop
2- Which Linux version ?
RH 7.1 + logical volume manager
3- Which Oracle version ?
9.0.1.2.0
4- Is is fun ?
That depends.
--
Bjørn Engsig, Miracle A/S
I have received the following from one of my co-workers at a client site.
Any links, docs, thoughts, gripes, complaints, help would be appreciated.
Thanks.
--
I am looking for any documentation out there on Oracle support -
How about :
select num
from NUMBERS,
( select begin, end from RANGE)
where num between begin and end;
Paul
-Original Message-
Sent: Friday, February 22, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
You are right that the range aren't necessarily contigous.
I'd
Thanks to all of you, who provided your input on this issue. I will test it
and I will get in touch with you if I have any problem.
Ashoke
-Original Message-
Sent: Friday, February 22, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L
The following command will backup you
Wow, what an open question
How many instances?
How big of a database?
How many users?
Development or production?
What type of application?
Amount of change management required?
Unix or Windows?
I could go on and on.
-Joe
On Fri, 22 Feb 2002 07:38:31 -0800
Grabowy, Chris [EMAIL PROTECTED]
Is is possible to store PDF files in oracle database to allow user accesses
the files, open it and read it? If so, please advise how. I am using
oracle8i with DBI running on Solaris8.
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
Rick,
This is what our corporation uses as a standard. We are not having any of the
problems you describe, however, we are on HP, AIX, Tru64, and NT, not Solaris.
Jim
[EMAIL PROTECTED] wrote:
Is anyone using this combination? We're having problems getting backups to work with
8i. It works
Re the 22% annual support cost. This is apparently not unusually high.
We were quote a 22% for an application last week. This probably
pales when compared to mainframe maintenance fees.
Jared
On Friday 22 February 2002 06:03, Jay Hostetter wrote:
Our management has started asking
I'd say if the client can give me the expected code errors, user errors,
number of time someone will delete/drop/truncate a table, expected number of
ora 600/7445 errors, I can pretty much give a estimate of db support time.
Oh ... and did I mention failed backups, space shortage, SA
-This probably pales when compared to mainframe maintenance fees.
And don't forget that mainframes also rent the OS for a hefty fee!!
Dave
-Original Message-
Sent: Friday, February 22, 2002 10:25 AM
To: Multiple recipients of list ORACLE-L
Re the 22% annual support cost. This is
I'm also running it on two Vmware machines running Linux on my laptop.
I'm currently working on a 'real' cluster, using a mixture of SMP linux
boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big
problem. I believe it still to be electrical on the SCSI bus, so watch
this space.
Check out DBMS_LOB.LOADFROMFILE to load them into
lob's in the db. Similarly, you can use dbms_lob.read
and htp.prn to spit it out to a web page.
hth
connor
--- Nguyen, David M [EMAIL PROTECTED] wrote:
Is is possible to store PDF files in oracle database
to allow user accesses
the files,
Chris - Are you guaranteeing that you can support their system for 6 hours
of work/week? Are you merely providing an estimate of what you guess it will
be and plan to bill based on actual time taken? If it is the former, woe be
unto you. If it is the latter, I would think that you could provide a
Jay - Try this URL:
http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp
naturally it is entirely biased in Microsoft's favor and I don't see where
it mentions that under Oracle's pricing model, upgrades are included, but
not with Microsoft. Oracle and IBM probably have equivalent
James - Given the breadth of your questions, you may want to purchase
Oracle Distributed Systems by Charles Dye, an O'Reilly book. It is the
only book I have found on Oracle replication.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, February 22,
There are several papers on Oracle's web site which
may help. I am working my way through the contents
now so I cannot give you any hands on experience yet.
Look for Notes: 117343.1, 50593.1, 1015725.6 plus
others.
--- James Ambursley [EMAIL PROTECTED] wrote:
I am thinking of implementing
I wish that I had some of that 10 year ago OPS experience ;-)
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 5:53 PM
I'm also running it on two Vmware machines running Linux on my laptop.
I'm currently working
We are in the process of installing a GIS package (Arc/info) which has an
oracle component (SDE)
I have to setup tablespaces to handle various types of data, one of the
tablespaces will be holding
Tiff images. These images range are on average 25 Megs and there will be
upto 200 images.
It is
Yeah, pretty much what I was thinking. I just wanted to ping the list and
see what others would say.
Thanks everyone.
Chris
-Original Message-
Sent: Friday, February 22, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
some
Chris - Are you guaranteeing that you can support
You must be logged in as the owner of the job to remove it.
Jared
Chuan Zhang [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/21/02 10:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:data
-Original Message-
Sent: Friday, February 22, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
We are in the process of installing a GIS package (Arc/info) which has an
oracle component (SDE)
I have to setup tablespaces to handle various types of data, one of the
Darren
a 1 :
===
I would use both thprof to make sure that the SQL is efficient and
statpack to monitor the full database
a 2 :
===
I would never recommend to make the data files bigger than 2 Gb on unix,
so anything up to 2 GB will be fine.
How small you what to make the files depends on the
Do you use commit after removing the job?
-Original Message-
Sent: Friday, February 22, 2002 1:03 AM
To: Multiple recipients of list ORACLE-L
Hi, All,
Is there any Oracle data dict view to see whether the dbms jobs is on the
job queue or not. Why I ask this is that I use
Thanks Paul,
That worked.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: sql question
Date: Fri, 22 Feb 2002 07:53:39 -0800
How about :
select num
from NUMBERS,
( select begin, end from RANGE)
where num between
Hi all,
In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's
schema. One of these triggers tried to write an audit record to a table in
a tablespace different from the table that was being updated, but the audit
table's tablespace filled up.
Since we had an exception clause
Are you logging in as the owner of the DBMS job? Stupid
securty-by-obscurity, IMHO.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Friday, February 22, 2002 12:15 PM
To:
if you can (and I assume you can) change the trigger code and if you are on
8i, make use of autonomous transactions. so you can capture all required
information and insert it into a table.
You may want to write this as a separate procedure and call that with
appropriate information from the
Hi DBAs,
I am researching for solution for a new project. We have a few tables in
Oracle8i db, similar tables with more columns and more data in MS Access.
The data is very static.
Our plan is to synchronize the two dbs, from then on we will always put
change(adding more columns, or insert new
How about monitoring the audit tablespace to ensure it doesn't fill up?
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/22/02 10:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Are you serious?
Replication between Oracle and MS Access, why?
-Original Message-
Sent: Friday, February 22, 2002 2:09 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs,
I am researching for solution for a new project. We have a few tables in
Oracle8i db, similar tables with more
Send an email to whomever in the EXCEPTION clause? Actually, the whomever
should be some email account that the DBAs can subscribe to (and unsubscribe
when they get that six figure job somewhere else).
Also, is there any interest in coding for those this full type error
messages and then
I agree since it's better than auditing the audit!
-Original Message-
Sent: Friday, February 22, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
How about monitoring the audit tablespace to ensure it doesn't fill up?
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL
James - Have you considered just maintaining the Oracle tables and then
attaching (or whatever the Access word is) the Oracle table in Access? That
way you have a single table, single source, etc. Simple is good.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
James can you tell us more about the requirements of your
environment/software that would cause such a solution to arise. I can see
the possibility of writing a MS Access client that perhaps your sales staff
uses that replicates with the database. Hopefully, you don't have too many
tables. You
The Oracle server is on our internal network, the MS Access is on a server
from ISP, which is outside of our network. The cost to eliminate the MS
Access, merge all application to our Oracle is too high, so we decide to
stay the way it is.
It's not real replication, just copy(move) the data
You will need to use VBA and DAO to.
1. Connect to the Oracle database.
2. Delete or drop the tables in the Access database.
3. Insert or create the tables from the Oracle database.
Anyone proficient with VBA and DAO and Access should be able to do this very
easily.
- Ethan
-Original
Hi Listers,
I got the following statement in the tkprof output file :
update EMP set ENAME=:V001,EMPNO=:V002
where rowid = :V003
I'm just wondering how to get the value of that variables (instead of :V001,
:V002 and :V003).
Is there a way to do that ?
Thanks.
Aldi
I am wondering what the license issues with this would be. - E
-Original Message-
Sent: Friday, February 22, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
James - Have you considered just maintaining the Oracle tables and then
attaching (or whatever the Access word is) the
Hello,
How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ??
Also is there a way to issue set serveroutput on from within a stored
procedure so that when someone run the stored procedure, the stored
procedure output will be seen even if the person forgot to set
Can you not substitute say, Oracle Lite for Access on the 'downstream' sites
use Oracle's native replication? (Or keep Access as a front-end, but use
OL for the actual storage the replication.) I would guess you'd be in for
less work/trouble that way (tho I know zip about Oracle's replication
Thanks Dennis, link to Oracle in Access through ODBC is one option, actually
good idea.., if I can get through the network. the Access and Oracle are
on different network.
-Original Message-
From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 2:49 PM
Set you 10046 trace at level 4 or 12, and then check the trace file.
Paul
-Original Message-
Sent: Friday, February 22, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
I got the following statement in the tkprof output file :
update EMP set ENAME=:V001,EMPNO=:V002
Switching an Access application from using Access tables to Oracle ODBC
linked tables or ADO tables is extremely easy. Then you can go directly to
your Oracle DB or to a new one outside the network that could be sync using
Oracle Technology.
Waleed
-Original Message-
Sent: Friday,
[Bjørn Engsig]
You should consider doing a create newtable as select with the oposite
conditions as your delete, followed by a truncate/drop, exchange partition or
whatever. Delete is really hard against the undo segments.
Anyway to lessen that? like nologging on the delete itself,
Hello,
I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ??
Also is there a way to issue set serveroutput on from within a stored
procedure so that when someone run the stored procedure, the stored
procedure output will be seen even if the person forgot to set serveroutput
Mmm. Max sequence number.
I'll go on the assumption that you are selecting the max for a column populated
by a sequence.Here's one option.1) CREATE TABLE
temp_table AS SELECT ROWID myrowid FROM the_active_table WHERE
the_active_table.colum max_value_for_first_query2)
DELETE FROM
(20 days later -- occurrences aren't that common)
Jared,
Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book
unbelievably. I've used the event 10046 traces while the blocking
lock event was going on. The curious thing is that I'm not seeing any
buffer busy waits. The
Would you consider this to be an open opportunity for disaster?
Granting each application schema
'dbms_repcat_admin.grant_admin_any_schema' in a replicated
environment. Here's the example:
REPADMIN = replication administrator/propagator/receiver
ACCT_APP = application schema
HR_APP
1. there isn't a host command in PL/SQL. Read up on external
procedures for this. You need to be painfully aware of the
security implications of this. You need to ask yourself if this
is really necessary. If so, you can write external procs in
Java, C, or even Perl ( that last one isn't well
Paul (or anyone) -
Is there a way to set the level within the session as:
alter session set sql_trace = true
Or do I have to start the session, start a SQLPLUS session, find the
session_id and run the procedure to set it on another session?
Dennis Williams
DBA
Dennis:
In the session:
alter session set events '10046 trace name context forever, level
12'
Barb
--
From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 3:08 PM
To: Multiple recipients of list
You can't SET SERVEROUTPUT ON from within a PL/SQL block,
because that's a SQL*Plus command, not a PL/SQL function.
You *can* invoke dbms_output.enable(), but that still
doesn't set the flag within SQL*Plus that tells SQL*Plus to
fetch and display the output.
If you tend to forget a lot, you
FYI to all.
There's no reason both groups shouldn't use this resource, so please join in
and contribute your scripts and documents that would be too large to send as
attachments.
Best regards,
Paul
- Original Message -
To: LazyDBA.com Discussion [EMAIL PROTECTED]
Sent: Friday, February
snip
Somehow this seems like a bad idea. I've always restricted
administration to REPADMIN, but maybe I lack outside-of-the-box
thinking
/snip
I'm kinda an outside-the-box-kind-of-gal. But, yeah, that looks like a
recipe for failure to me too.
Bambi.
--
Please see the official ORACLE-L
See my comments in the text:
Robert Eskridge wrote:
(20 days later -- occurrences aren't that common)
Jared,
Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book
unbelievably. I've used the event 10046 traces while the blocking
lock event was going on. The curious
Hi,
I made some mistake on a RMAN command, and then try to
get out of the command, I tried ;, exit, /, but none
of them works, they just keep showing me the next
line. So I used control+C, it does get out the
command, but I was out of RMAN also. I was back in OS
prompt.
RMAN release channel'
Re the use of PIPE's to execute commands:
There's a page on my website on using DBMS_PIPE and perl
for debugging PL/SQL. A slight change is all that's need to make
it execute a command.
Simple to do, and fraught with security implications.
I do not know a way to enable DBMS from within a procedure either. The
second item Jared mentions does not seem to set the session to recieve
output. I just ran a check to see and the 'enable' portion of DBMS did not
set the toggle the session for output.
I used this simple script
Begin
I used a lot 'ior i' to install our customized databases on new
machines...installed oracle ..created database,,initialised it and imported
customised database with full dump
Those ior commands were wonderful and you may still see it in dbstart and
dbshut file to provide backword support
Begin
dbms_output.enable(1);
dbms_output.put_line('Jared is wrong!');
end;
/
Oh well, ain't the first time. :)
I always put 'set serveroutput on size 100'
in glogin.sql
Jared
Alec Macdonell [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/22/02 04:33 PM
Please respond
1 - 100 of 105 matches
Mail list logo