Nice job of investigating the problem.
Glad you got it working.
Installing Perl is much easier after the first
3 or 4 times. :)
Jared
On Monday 18 June 2001 01:45, Nguyen, Long (ITS, Limestone Ave) wrote:
Hi Jared,
Thank you for your advice. Without setting LD_LIBRARY_PATH before the
Hi,
We have an application that connects to our DB via ODBC runs a query and
disconnects.
This query could do any type of DML and is triggered off from external
interfaces (eg radio and scales).
I would like to capture the wait event information and wonder if anyone has
written a DB after
Unless I disremember, that is from Fred Brooks 'The Mythical
Man Month' and referred to writing an IBM OS ( forget which one ),
and was assembly code.
This was for fully documented and unit tested code.
And it was 6 lines, not 10. :)
Jared
On Monday 18 June 2001 05:00, Boivin, Patrice J
I have fond memories of writing 1300 lines of code in
one 12 hour day a few years back. This was a front
end to a DOS version of RCS ( or something like RCS )
and it was for versioning an entire set of application code.
Written in a compiled language called 'Force'. It even
worked when I was
http://www.sun.com/950523/yahoostory.html
This is an interview with the founders of Yahoo from back in '95. It's a
fascinating read, if only to reflect on how much things have changed
over the last few years.
g
-Original Message-
Sent: Wednesday, June 20, 2001 9:21 PM
To: Multiple
Oh my, iPlanet has about...oh...TWELVE THOUSAND products,
most of them compete with something of Oracle's..
The guys i have met from there are fairly sharp...
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/20/2001 6:56 PM
That's interesting, and something I
It's pronounced as Yah'-who as in the wild shout of excitement.. There are
ads on the telly over here for Yahoo..
-Original Message-
Sent: Wednesday, June 20, 2001 08:18
To: Multiple recipients of list ORACLE-L
So the website would be pronounced as ...?
:)
-Original Message-
I disagree ! The dollar is very strong these days. Maybe a few years back
the cost of living was cheaper in Europe, but now things are different. I
was on holiday in the States last year ... my bank account still suffers :).
And now the dollar is even stronger than it was back then.
i think u can use triggers such kind of auditing.
create aud$ table with one more column, and try updating the column as soon
user fires some sql.
this is just a thought. could find another opinion.
saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
iPlanet are what's left of Netscape Corporation's server products group,
after they were eaten by the unholy alliance of Sun and AOL. They had an
application server (Netscape App Server, nee Kiva plus LiveWire) which
used a mysterious combination of C++ and JavaScript to create
AppLogic(tm). It
Hello
we have a problem with a database:
The database cannot start up and we get:
ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace
'INDEX'
Is there any chance to create new rollback segment when the database is
mounted
Working for the govt., you're trading ca$h money for job security.
Business is risky, but you get rewarded for taking that risk - if the
company goes bankrupt or has to make you redundant, then your nice
paycheck isn't getting cut that month. I can't see the govt. going
bankrupt anytime soon
I disagree with your disagreement :)
I would still say - like Lee - that the cost of LIVING over in the states is
far less than over here - maybe not in the Netherlands (But I'd be shocked
if it wasn't).
House prices, taxes, food bills, clothes, petrol, car prices.. The list
could go on and
Your point Taken . Will Check with Higher Stripe Size Whenever possible
.
NOT Using Parallel Query Option (PQO) in the Application
Thanks again
-Original Message-
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 4:41 AM
To: VIVEK_SHARMA
Subject:
Thank you Greg,
We can discuss itrprof results in this great list.
Greg Moore wrote:
all the quries which used the larger sort_area_size
actually ran slower
Why don't you simply run a trace for the small sort_area_size, do the same
with the larger sort_area_size, and then submit the
This will not work as you can't create triggers on sys objects.
So tell me the way how i should create triggers on aud$.
-Original Message-
Sharma
Sent: Thursday, June 21, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
i think u can use triggers such kind of auditing.
create
AND: select bitand(23,45)+0 from dual;
OR: select 23+45-(bitand(23,45)+0) from dual;
XOR: select 23+45-2*(bitand(23,45)+0) from dual;
hth
connor
--- Orr, Steve [EMAIL PROTECTED] wrote: OK, for
the alpha geek award of the day...
Who can tell me how to do a bitwise or from
SQLPlus -- NOT
Where can I find out more about this? Who cares about the launch - I'm up
for the BBQ :) As long as it doesn't RAIN!!
Is it at the Oracle UK HQ?
-Original Message-
Lee - lerobe
Sent: Wednesday, June 20, 2001 03:31
To: Multiple recipients of list ORACLE-L
Any other UK based listers
Do you require the OCP certification?
What are your qualifiactions?
How many bytes are there, exactly, in a kilobyte?
What are hexadecimal numbers?
Do you have test servers to try things before implementing them on
production systems? Are these test systems the same size as the production
SHOCK
Is this the recipe GOD I see before me? G
/SHOCK
Come on Guy, where is our Friday Recipe? Good to see you back on the list!
Mark
-Original Message-
Sent: Thursday, June 21, 2001 10:18
To: Multiple recipients of list ORACLE-L
Working for the govt., you're trading ca$h money
Contract rates are lower as well as permanent salaries and there is none of
the 'extra job security' applied to contractors.
However I work close to home and the out of hours requirements are minimal,
so I'm happy.
- Mike.
-Original Message-
Sent: 20 June 2001 17:37
To: Multiple
Give her a job :)
-Original Message-
Gennick
Sent: Thursday, June 21, 2001 12:41
To: Multiple recipients of list ORACLE-L
Wednesday, June 20, 2001, 5:56:12 PM, Karen wrote:
Sac I believe the reason that I passed the tests is
Sac because I
Sac have personal Oracle on my home computer
On Jun 20, 2001 at 01:50:48PM, Orr, Steve wrote:
OK, for the alpha geek award of the day...
Who can tell me how to do a bitwise or from SQLPlus -- NOT PL/SQL?
Isn't there an internal undocumented bitand function and how could you use
that to implement a bitor function from SQL?
Mark,
You are correct cost of living in states is less than UK. However
the first on your list of examples is House prices. Generalisations can be
made in all arguments but house prices differ hugely depending on location.
ie, In UK north/south/London house price difference. I lived in NJ
This is bizarre, I thought this was a 70s fad. I heard this on CBC radio
last night.
Natives yesterday reported big foot tracks found in northern Ontario. 14
inches long, 5 inches wide, 6 feet apart.
The band chief said that they were definitely not bear tracks, and that the
person who
Go to the following link
For more information and to register go to
http://www.oracle.com/uk/start/9iopenday or call 01252 771499
Might see you there !!
-Original Message-
Sent: 21 June 2001 11:36
To: Multiple recipients of list ORACLE-L
Where can I find out more about this? Who
How about: Are you ISO9000 certified?
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO
Hi fans,
I 've got problem during installation of DB 8.1.6 on AIX platform
(version 4.3.3).
It ran succesfully with 32 bit version.
Here is the error message :
Linking Oracle 8I Enterprise Edition
Error in invoking target install or makefile
Actually, if you sent a simple e-mail with three letters in it: OCP, you
would start a new thread.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch
Hi folks,
as the subject indicates, I feel really stupid asking this question, but
here goes...
If I have several Oracle 8i instances running on an NT Server with, say,
256Mb of memory available, then does this mean that the sum of the SGA sizes
for all the instances, taken together, can't
Hehehe! My record is 125 PL/SQL procedures
in a day. Lost count of the lines of code.
But I had VIM to help me...
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
I have fond memories of writing 1300 lines of code in
one 12 hour day a
I was having a similar conversation with a friend of mine a couple of
months ago. We were both London (England) based consultants, but we'd
been staffed on engagements in Amsterdam (Holland). The cost-of-living
is indeed a lot less, if you look at things like grocery shopping, the
cost of riding
There are also a lot of cases where you can get rid of a subquery. Consider
the following
SELECT DISTINCT emplid
FROMemp_history eh1
WHERE salary 10;
SELECT emplid
FROM emp_history eh1
WHERE rowid = (SELECT MAX(rowid)
FROM emp_history eh2
WHERE eh1.emplid = eh2.emplid
FYI for all AIXer's - there is a 64gb filesize limit on AIX 4.3, soon to be fixed in
AIX 5L jfs2. Time to use Oracle's new exp (817) features like file and filesize.
[EMAIL PROTECTED] 06/20/01 04:46PM
AIX 4.3.3, attached to ESS Shark
Oracle EE 8.1.7
When doing a full db export I get a
but, why do you need to do a bitwise or within sqlplus?
just curious.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 20, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
OK, for the alpha geek award of the day...
Who can tell me how to do
Everybody,
1. The initial Looking for ... is not Spam. But that mail generated a lot
of spam.
2. I am just adding to the spam :- (pardon me - I could'nt resist) - Does
anyone know of any leads or pointers to websites regarding working in UK?
3. Also, this is for the active participants - If
I tried this same thing (procedure below) and received the error messages
below when I was trying to truncate a schema.tablename, which was not the
schema I was logged in as. What is interesting is that the schema to which I
was logged into, does have select, insert, delete and update privs on
Hi!
Where can I get an answer to the question How many places out there are
using Oracle 8 objects and to what extent?
Thanks,
Steve Visokay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen N. Visokay, VA Inc.
INET: [EMAIL PROTECTED]
Fat City Network
Cheers Lee,
Me and Gerry are now registered for both the Grand Opening, and the
celebration dinner afterwards..
Hope to see you, and any one else from the list there.. Let the BBQ begin :)
Mark
-Original Message-
Sent: Thursday, June 21, 2001 12:17
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL
Not 100% sure but I think only the table owner can use TRUNCATE
Witold
Raymond Lee Meng Hong [EMAIL PROTECTED] on 06/21/2001 01:10:52
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Witold Iwaniec/ATL_BLUECROSS_CA)
Got
hi dba's i want to see the underscore parameters such as
_db_block_max_dirty_target etc which view should i use for it
S.Lakshmi Narasimhan
Technology Infrastructure Services
WIPRO TECHNOLOGIES
044-4500200 extn 2059
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Sounds like I'm working in one of the more relaxed countries of the world,
with a low cost-of-living :). You've just made my day. I'll go home
whistling and in a very good mood, today !
-Oorspronkelijk bericht-
Van: Guy Hammond [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 21 juni 2001
You can exceed the 256Mb, if you don't mind the
continual swapping to disk, and the thrashing that
comes with that.;-)
Usually not a good thing to do.
It's usually a good idea to allow some room for
the Operating System as well.
just remember, Virtual Memory = disk swapping (usually)..
anyone who has delete any table can truncate.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: TRUNCATE IN PL/SQL
Date: Thu, 21 Jun 2001 04:46:31 -0800
Not 100% sure but I think only the table owner can use TRUNCATE
Paul,
This depends on the performance impact you are ready to endure on the
instances. You can in fact extend your memory to larger than the total of
256Mb, but swapping memory from physical to virtual can cause some
pretty poor performance.
There are other things you also need to take in to
Actually ... you can truncate someone elses table if you have the authority.
I find that I need to put the users Schema on the front even if there is a
synonym.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L
Anyone else get the attached message? It's been thru the virus wringer, so
I'm not too worried about it (with fingers crossed).
After checking out the headers, it looked genuine and having me fill out a
survey at Oracle for 9iFS is a distinct possibility, but the reply message I
sent bounced.
You are right on this to a certain extent, you either have to be the schema
owner, or you need to have been granted the DROP ANY TABLE system privilege.
Have you satisfied both or either of these Raymond? If not, try it out..
HTH
Mark
-Original Message-
[EMAIL PROTECTED]
Sent:
This guy may be very good to work for if the pay is hourly. Immediately cut
all bs. And even if there is a lot of stupid things one has to do - at least
one is paid.
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L
no, the
Oracle 7 docs state you need delete any table, Oracle 8 docs state you
need drop any table privilege to truncate another owner's table.
Dennis
[EMAIL PROTECTED] wrote:
Not 100% sure but I think only the table owner can use TRUNCATE
Witold
Raymond Lee Meng Hong [EMAIL PROTECTED] on
money isnt everything :)
Right... Like itz not SUFFICIENT.. :)
Ravi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra P Channe
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California--
Or just - are you certified? :)
-Original Message-
Patrice J
Sent: Thursday, June 21, 2001 12:36
To: Multiple recipients of list ORACLE-L
How about: Are you ISO9000 certified?
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit.
There was something on the news the other day about this. It seems that the
dollar is so strong, that some groups are petitioning to get it weakened.
Terry
Daemen, Remco wrote:
I disagree ! The dollar is very strong these days. Maybe a few years back
the cost of living was cheaper in
Title: RE: TRUNCATE IN PL/SQL
Didn't someone already say you have to have drop any table privilege to truncate another user's table? That's at least part of the problem.
Or have you looked at compiling the procedure with another user's privs? I haven't used that myself but I know it's
Also need an entry in the /etc/oratab file for the new SID.
Original Message
On 6/20/01, 8:10:19 PM, Kevin Lange [EMAIL PROTECTED] wrote regarding RE:
new instances on Linux different from NT?:
There is no task related to ORADIM80. You simply reset your ORACLE_SID
and
then create the
You can by using the following statement:
execute immediate 'truncate table table_name';
Prakash
-Original Message-
Sent: Wednesday, June 20, 2001 10:55 PM
To: Multiple recipients of list ORACLE-L
Hello guru , how can I execute a truncate table in PL/SQL ?? It only work
for delete
Hi Guys and Girls,
I was just wondering if anybody has a script that will create a schema -
much like the Scott or SQLServer North wind - in a test database, but with a
little more depth..
I'm looking for something that will create the tables, indexes, constraints,
maybe some users though I'm
ISO9000 because it will tell you whether the shop is methodical or not.
Whether there are expected consistent deliverables or not.
At the same time, because ISO certification is a double-edged sword, you
will find out whether the manager is an empire builder, and whether they
implemented ISO
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
http://news.cnet.com/news/0-1006-200-6333149.html?tag=3Ddd.ne.dht.=
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
Thanks everybody who answered.
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 4:26 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to show current working directory and in general shell
variable in Korn shell that prompt change when variable changes - for
Not true...If I open a sqlplus window and issue a truncate on the schema--no
problem. If I try and do it through a procedure like below--I get the
errors
lc
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, June 21, 2001 8:47 AM
To: Multiple recipients of list ORACLE-L
Not
Now I have another problem.
export PS1='$LOGNAME@$HOST:$PWD:${ORACLE_SID:-ORUNDEF}\n!-' - result is:
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTESTn133-
instead of
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTEST
133-
Looks like it does not understand \n as a new line
Anyone out there using OPS ver7 on Tru64 Alpha?
I'd be interested in swapping DLM parameters.
We just applied an OWS-suggested fix and it apparently
ran the box into the ground.
Any thoughts welcome.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
aud$ is one of the few system tables that can have an owner other than sys.
You can create it under another schema (like system) and give sys a private
synonym pointing to system.aud$. Then put the trigger on the alternate aud$
create table system.aud$ as select * from sys.aud$;
drop table
The way I see the ISO900x stuff is this.
If you say I kick every box before I ship it to a customer, and you do just
that consistency. You are a ISO900x perfect company.
Although consistency is extremely important, so isn't efficiency,
credibility, as well as many other big words.
Walking on
All,
that's because there are special security rules attached to stored
procedures and packages.
from sql*plus, you can do a truncate if you have the DBA priv. The DBA priv
is a ROLE, and the ROLE gives you the {delete any table} system priv.
from a stored procedure/package, you may NOT
Try with dynamic sql from user_tables which displays the table_name and then
the count on it.
-Original Message-
Sent: 20 June 2001 18:17
To: Multiple recipients of list ORACLE-L
All,
Anyone know how to get a list of tablenames and the count of rows in them
TABLE_NAMECOUNT
You can do a tspitr if you are using rman. You can make a clone database,
import the tablespace in question with the until time option. T hen export
the clone database tablespace and import it into the live database.
I hope this helps.
Ruth
- Original Message -
To: Multiple recipients
Yeah I do agree with you, I was going by the cost of a house here (Worcester
25M South of Birmingham) to the cost of the same sized house in Houston, TX
where my former employer was based.. There was in fact a HUGE difference!
-Original Message-
Sent: Thursday, June 21, 2001 01:22
To:
Hello list,
some of itrprof users encounter cursor 0. Since there is no parsed SQL
statement which has a cursor number 0, itrprof prompts "itp-05 [x] :
File corrupted." message.
I examined raw trace files and could not see an SQL statement which has
a cursor number 0.
I think this is a bug.
why do you need to do a bitwise or within sqlplus?
Good question... I have a really good engineer who is working with C and
Oracle OCI. He's developing an install routine and assures me that he needs
bitwise operators from SQL because he can do some really powerful things
with them. Then he
Oracle 8 (8i) docs were finally corrected for this age old mistake ;)
- Kirti
-Original Message-
From: Dennis M. Heisler [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: TRUNCATE IN PL/SQL
Oracle 7 docs
Have you put the datbase mtipdb into the tnsnames.ora file? If not, you
must do so.
You could also check for the lsnrctl executable in $ORACLE_HOME/bin.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 20, 2001 9:40 AM
Hi
Blah, I do about 2,000 lines just during lunch on a napkin before I go back
to work. And I ussually put it on two napkins, one in assembly and one in a
high level language like c++ so other people can read it. One time, I
actually had to disassemble Oracle.exe as there was some code I didn't
The Rasmussen Files... that rings a bell...
Can't remember what that was.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
Dear DBAs
Is anobody here setup email alert sent to exchange server from unix box on
Oracle or Oracle application server. Any suggested reading, white paper I
can get.
Thanks in advance.
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mitchell
INET:
I sure as heck won't be renting from Acme!
-Original Message-
Sent: Thursday, June 21, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
Oh I agree by far!! Having visited Amsterdam a couple of times myself in the
past couple of years I have to say from what I saw, that Holland has be to
the MOST relaxed country in the whole of Europe if not the world!!
And the golf courses are GREAT!! I would recommend anybody to visit the
place
Alex,
Sorry, about that messed up post. Hit send before completing the cutpaste:
Here is one way to do this:
PS1='$LOGNAME@$HOST:$PWD:${ORACLE_SID:-ORUNDEF}
!-- '
export PS1
Split the string for PS1 in two lines.
Hope this helps.
Regards.
- Kirti Deshpande
Verizon Information Services
No, this bug is one where the export hangs forever as per Kumanan's description. It's
fixed by patching 8.1.7 or by putting
event = 10297 trace name context forever, level 1
in the init.ora. I think the note is 144794.1 on Metalink.
Saul Solomon
Senior Database Administrator
PPG Industries
Darn! No more taking the rental cars out to turn donuts, local street
division races, etc...
Scott Shafer
San Antonio, TX
210-581-6217
I hate the country, all those animals walking around un-cooked.
-Original Message-
From: A. Bardeen [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June
Note:118005.1 says, at one point, that the DLM_LOCKS_CFG
parameter is the maximum amount of DLM locks available
this is somewhat misleading and therefore somewhat dangerous.
Our SAs set it to the maximum and (yes, foolishly, i think)
wound up setting it to about 1GB, and getting a kernel
Alex,
I just substituted a real CR for the \n and got the two line prompt you
are looking for.
Mike Hand
Polaroid Corp.
-Original Message-
Sent: Thursday, June 21, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Now I have another problem.
export
Title: RE: OT - interviewing your superior(fun question)
Interesting post Patrice. Thanks for sharing this.
-Original Message-
From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 11:02 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT -
I would create a file system that spans the two drives to hold your backups.
That way you dont have to split the backup into parts.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 20, 2001 5:26 AM
I need some suggesations
Remove the newline.
Scott Shafer
San Antonio, TX
210-581-6217
I hate the country, all those animals walking around un-cooked.
-Original Message-
From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
Subject:
and the docs (can't remember if it's 6 or 7) used to state drop any table
priv
after all, the docs are NEVER wrong
From: Dennis M. Heisler [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: TRUNCATE IN PL/SQL
Date: Thu, 21
Ahh, but in ISO9000 land, you need to fill the paper-work out to prove that
you have kicked every box before you shipped it like you said you would, and
then ask the customer if they can attest to the fact that you have kicked
the box.
what this has to do with delivering the product is quite
Kevin,
I believe the bug to which he was referring is bug
970640 documented in Note: 76670.1 ALERT:
Transportable Tablespaces can Corrupt Target Database
This bug is specific to 8.1.5 and is fixed in 8.1.6+
The bug is in the way export creates the dmp file of
the transportable tablespace
ISO9000 also proves another thing even if you are not technically
competent, you can write big documents that no one will ever want to read.
Happened to me at 2 companies that became iso9000 compliant ...
HTH
Raj
__
Rajendra Jamadagni
Alex,
Right, Again! It doesn't work.
Try the following:
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Hillman, Alex [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 10:26 AM
To: Multiple recipients of list
I recently moved from Tulsa OK, to Silicon Valley. Talk about cost of
living adjustments. In 17 months, my salary has doubled from what it
was in Tulsa. My standard of living has remained about the same.
Daniel Curry
Systems Administrator
CGtime, Inc.
625 Second Street
Suite 201
San
You can embed an actual newline in the assignment, as long as it's
between quotes. For example:
PS1='part1
part2'
-Original Message-
From: Alex.Hillman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 10:26 AM
To: ORACLE-L; Alex.Hillman
Subject: RE: Prompt in Korn shell
Look into Oracle Enterprise Manager 2.1 and greater. Works great, we use it
for notification all the time, it can email and/or page on certain events.
You can also include fix-it jobs that kick off on a particular event. Good
stuff.
Regards,
Amr
I did say it was a double-edged sword...
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 1:07 PM
To: Multiple recipients of list
LOL!
-Original Message-
Sent: Thursday, June 21, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
Blah, I do about 2,000 lines just during lunch on a napkin before I go back
to work. And I ussually put it on two napkins, one in assembly and one in a
high level language like
Hi,
These things are not in any view. You can write your own.
Use following query to see them (run as sys).
select ksppinm, ksppdesc
from x$ksppi
where translate (ksppinm, '_', '*') like '*%';
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
On a related note, once the PWD's been crammed in there is it possible
to substitute ~ for the home directory (like bash does)? Something
like:
mehoo@somewhere[~]$
instead of
mehoo@somewhere[/foo/bar/mehoo]$
It looks like ksh93 has some string replacement features which might
What do you use the sequence number at the end for?
Ron
-Original Message-
Sent: Thursday, June 21, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
Alex,
Sorry, about that messed up post. Hit send before completing the cutpaste:
Here is one way to do this:
Ross,
Have you tried submitting an enhancement request?
Note 146178.1 How Do You Create an Enhancement
Request through Metalink?
HTH,
-- Anita
--- Mohan, Ross [EMAIL PROTECTED] wrote:
Note:118005.1 says, at one point, that the
DLM_LOCKS_CFG
parameter is the maximum amount of DLM locks
1 - 100 of 218 matches
Mail list logo