Title: Message
But wc -l
OBCONT.LOAD.030909 gives 9488 .
how will I find the value 8842
from the file.
Thanks
Manoj
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel
PoderSent: Wednesday, September 10, 2003 11:19 AMTo:
[EMAIL
Unless the stored procedure was created with invoker's rights, then it is
probably executing using the permissions and schema of the account that owns
it. Who is the owner of the stored procedure? Is it different from who you
are logged into SQL*Plus as?
The explanation might be that, through
Hello Jared
What is the oerr utility?
I just finished searching my disk for *oerr* and no exe or com file found.
Oracle 9.2.0.4 on windows.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 5:54 PM
We also has site licensing.
It was done 3-4 years ago. Maybe Oracle changed tactics since then.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, September 07, 2003 1:49 PM
Oracle does site licensing... but only if you are
Tanel,
the 11.5.9 docs ask you to get in touch if you're interested in a DVD
release. It doesn't sound like it's actually available but they must be
gauging interest for future releases.
Cheers,
Mike
-Original Message-
Sent: 10 September 2003 02:50
To: Multiple recipients of list
Nancy,
look in the Oracle Store. You can buy it for next to nothing.
Click the CD Packs tab, choose the platform you want, select 11i Release 9.
Cheers,
Mike Hately
-Original Message-
Sent: 10 September 2003 02:24
To: Multiple recipients of list ORACLE-L
I would like to evaluate Oracle
Yechil,came across the info' below in metalink.
---
there is nothing equivalent to 'oerr' available on Windows NT.
The oerr utility used on Unix to get Cause/Action lines, is a shell script which
Mladen,
A security risk would be if you had remote access to an Oracle user and
create library, you could create a procedure that calls the system
function then execute your code from a remote SQL call!! - of course you
would need a huge mail box!!
cheers
Pete
In article [EMAIL PROTECTED],
Hi Patrice,
I would describe it as casting not overloading. If a varchar2 column
contains a string representation of a number and its compared to a
number in a where clause then it will work.
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com -
Yechiel,
oerr isn't installed on Windows machines - only on UNIX installs.. oerr is
basically a shell script that reads the oraus.msg file under a UNIX install
(and some others too I think). Windows has a binary file under
%ORACLE_HOME%\RDBMS\mesg\oraus.msb, which if you open it has the
Thank you all of you who answered to my first question.
No, the problem has nothing to do with permissions. The record existed in the
table, but here it is what I discovered. Can anyone explain please? It may be the
normal Oracle behavior, but I believe it was not working like
I have written in the past a small C program which does the same as oerr only faster,
especially for 'high' error numbers (using binary searches on the files); it is
written for Unix but can easily be adapted to Windows - for those who don't have perl
installed ...
Hi everybody,
Where/how can i buy a voucher for oracle exam ?
I noticed two payment methods while filling up a Prometric registration
form for Exam #1Z0-031.
One of them was voucher.
how and where do i get it ? how much is it ?
...anyone in this list from Japan ?
Regards,
Jp.
--
Please
Dear Freinds,
what is a materilized view ? what is the use of it and how to create it.
Any docs or notes or white papers will be helpful.
TIA,
Rajuveera
**
This email (including any attachments) is intended for the sole
Dear Friends,
Can somebody send me / direct me to startup documents for ORacle
Replication.
TIA,
Rajuveera
**
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76994/mv.h
tm#721
Ofer
-Original Message-
Sent: Wednesday, September 10, 2003 1:04 PM
To: Multiple recipients of list ORACLE-L
Dear Freinds,
what is a materilized view ? what is the use of it and how to create it.
http://www.google.com/search?hl=enlr=ie=UTF-8oe=UTF-8q=materialized+view
spell=1
http://oracle.oreilly.com/news/oracle8_0600.html
http://technet.oracle.com/products/oracle9i/daily/jul05.html
A materialized view is like a view in that it represents data that is
contained in other database tables
For replication docs, go to:
http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a87499/toc.htm
Fermin.
-Mensaje original-
De: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 10 de septiembre de 2003 13:09
Para: Multiple recipients
That would be a question for Madonna, not for this list.
Read The Fine Manual.
On 2003.09.10 07:04, Veeraraju_Mareddi wrote:
Dear Freinds,
what is a materilized view ? what is the use of it and how to create it.
Any docs or notes or white papers will be helpful.
TIA,
Rajuveera
Hello Jesse
I do not know if this apply also to Linux but:
I am installing now 9.2.0.4 on windows and I saw that you need to install
the new installer first on all the nodes of the RAC first.
Then you can install the patch.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
There is a seminar by Oracle re. these, search for Oracle Internals.
I highly recommend it along with the other ones in that series!!!
Patrice.
-Original Message-
Sent: Tuesday, September 09, 2003 7:00 PM
To: Multiple recipients of list ORACLE-L
where can i find a list of sqltrace
When negotiating site licensing, does Oracle encourage the customers to buy
EE licences?
Or can people negotiate for a mix of EE or SE.
Just curious, I don't know how that would work -- not very compatible with
OracleStore, it seems to me.
Patrice.
-Original Message-
Sent: Wednesday,
how many of those trace events have people written papers on? other than hotsos, where
can i find some articles on them?
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2003/09/10 Wed AM 08:12:23 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: overloading and =
www.oracle.com
do a search for certification. select a track. you can get to a prometric site
throught there. put down OTN20 in the voucher to save $25.
the forms 9i one is in beta and is only $40 now. however, its a pain. 165 questions...
and boring.
From: Prem Khanna J [EMAIL PROTECTED]
Hi all,
Can anyone give me info about oracle express list ? Is there any oracle
express gurus here ?? I need some help for oracle express.
Thanks
Shibu
DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged.
Before opening attachments
ROFLMAO ... What a kidder ...
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974 DSN 651-9974
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 7:59 AM
To: Multiple recipients of list
Someone on this list ordered me a CD Kit of the 10i Applications Suite, it's
52 CDs.
You may be able to order one from the OracleStore.
Two years ago I couldn't do that from the oracle.com site because they only
accepted U.S. States and Zip Codes... I called a 1-800 number they had
suggested for
Just wondering... How many UNIX servers can read DVDs?
Patrice.
-Original Message-
Sent: Wednesday, September 10, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
Tanel,
the 11.5.9 docs ask you to get in touch if you're interested in a DVD
release. It doesn't sound like it's
I think they're available on most hardware platforms now. I don't know how
many sites would back-order parts to replace CD drives but it's probably
worth specifying them for new kit.
I'd be interested in DVDs even if it's just for piloting new releases on
Linux at home.
For the record I think
Title: RE: Oracle 11i
ours has a dvd drive
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11
-Original Message-
From: Boivin, Patrice J
I have a problem with unwillingness to invest effort and do some very basic
research from the readily available literature. Oracle has a manual called
Database Concepts which is accessible on approximately 87 billion places
on the internet, for free, of course. Previous incarnations of this list
Patrice
Which license do you think provides the Oracle sales representative the
largest commission? Money is considered an acceptable motivation for a sales
rep. The key word in your statement is negotiating.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Hi Fermin,
given that I understand you correctly:
pl/sql DOES exactly what you want:
it returns 0 rows. That results in a exception
called NO_DATA_FOUND and is assigned
to the ORA-01403 error.
To get a result '0' you have to query
the table using 'Count'.
Greetings,
Guido
[EMAIL PROTECTED]
is SE alot more affordable than EE? CAn you un-bundle Oracle software and just buy the
pieces you want to use or do you always have to buy the whole bundle?
what about 9iAS? do you have to buy the whole bundle or can you just get pieces?
From: Hitchman, Peter [EMAIL PROTECTED]
Date:
Hi,
I looked into SE but found that Oracle would not allow it to be used on a
machine that has 4 or more CPUs or can support that many CPUs, which for
this company is a problem because we generally run Oracle on Sun servers.
Don't know if that has changed now with later Oracle releases.
Regards
Ryan
Yes, MUCH more affordable, assuming you can live with the limitations.
Check Oracle Store for current prices. I understand the 4-CPU limit still
remains. There aren't too many unbundling options.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Title: RE: what is a materilized view ?
Mladen,
I completely agree with you on everything you said here except for the pre-requisite experience-wise. I think this list is good for people at any experience level (including newbies). The issue is when the newbies decide to ask very basic
For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so
desperately needed by anybody unfortunate enough to have to deal with 9iAS.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Linux can, and SUN can. I know that HP (HP-UX 11.0) can as well. I'm not
sure about the
IBM, but I suppose that they can do that too. You can get a DVD read-only
drive for $50
at CompUSA. Software can be found at http://www.linuxvideo.org.
--
Mladen Gogala
Oracle DBA
-Original
how restrictive are db2 and sql server on bundling licenses? and CPU limitations?
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/09/10 Wed AM 10:29:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: DB2 has a foot in the door
Ryan
Yes, MUCH more
Title: Message
I
stand corrected, you are right.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Stefick Ronald S Contr ESC/HRIDDSent: Wednesday, September 10,
2003 10:35 AMTo: Multiple recipients of list
Title: RE: making me crazy
Dealing with 2 Oracle Homes - one if which I need to run the listener from and one in which I need to use the tnsnames.ora definitions from and no I can't just copy the tnsnames.ora to the 1st Oracle Home. Even when I set the oracle home from which to run lsnrctl it
Fermin,
You are running into the well documented behavior of the CHAR datatype. Use
VARCHAR2 instead if you wish to avoid those pitfalls.
Hope this helps...
-Tim
on 9/10/03 3:29 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:
Thank you all of you who answered to my first question.
No,
Both 11.5.8 and 11.5.9 are 22 CDs, totalling about 12Gb. If you start with
11.5.8 or below, you'd also want to download the 11.5.9 patch anyway, which
is a further 2.5Gb or so...
on 9/10/03 2:19 AM, Hately, Mike (LogicaCMG) at [EMAIL PROTECTED]
wrote:
Tanel,
the 11.5.9 docs ask you to get in
List,
A nice tidbit into the contents of the book.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PERL MEETS ORACLE | Andy Duncan Jared Still
Perl is a very powerful tool for Oracle database administrators, but
too few DBAs realize how helpful Perl can be in managing,
Maybe copying isn't an option, but if on NIX how about putting a symbolic
link in or tnsnames in the /etc (checked before $ORACLE_HOME/network)
directory and not set TNS_ADMIN
Jack
-Original Message-
Sent: Wednesday, September 10, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
About half of those disks are needed for standard 11i install, other stuff
is various additional Oracle software which you might want to use (and pay
the licenses for)..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 10,
The opposite of an immaterial view :)
Henry
-Original Message-
Veeraraju_Mareddi
Sent: Wednesday, September 10, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Dear Freinds,
what is a materilized view ? what is the use of it and how to create it.
Any docs or notes or white
Hmmm... Try making this the first line followed by a blank line:
Content-Type: text/html
Just guessing...
-Original Message-
Sent: Tuesday, September 09, 2003 7:14 PM
To: Multiple recipients of list ORACLE-L
Hi DBAs!
I am trying to generate an HTML report, and send it through the
Thanks for the suggestion. And perhaps it explains what I'm seeing. I
tried the 9.2.0.4 installer many times between two installs. Each time the
2.2.0.18 (new) installer crashed and there was no help on MetaLink nor
Goo5le (Happy 5yrs!). Out of desperation I tried the 9.2.0.1 installer and
it
Perl? Isn't that Pathologically Eclectic Rubbish Lister? Why would
anyone want use perl besides the fact that it's very portable, it's fast,
it's practical, it has bindings for ton of software and is very, very well
documented indeed? The problem with perl is that it's free and management
Doesn't this go back to the Application DBA vs. Production DBA
discussion? I've talked with folks that employ a Patch DBA -- all they do
is manage 11i patches. Fun!
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex,
Ha! Tell me about it. I'm at the tail end of an upgrade. Just applying the
unified driver to bring all of the products bang up to date.
Just when you think you're on the home straight. A driver file with 920,000
lines that starts 71,000 scripts.
It's enough to start me drinking!
Mike
Title: RE: Oracle 11i
Anything break badly?
We are going to be starting in about a month down the 11.5.8 - 11.5.9 road.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of flying a kite
Adam
I was told by one Oracle instructor that new features of 9i, including
Oracle Managed Files, could allow you to create a viable production database
by simply typing CREATE DATABASE -- once the init.ora (SPFILE?) was
created and the hardware layed out properly.
Perhaps not something many will use,
Title: RE: making me crazy
Hi Paula !
You have 2 options :
1) provide symlink to your "listener.ora"
file.
2) In case you start the listener process via sth like thata
"BASH_PROMPT lsnrctl start " you can "fake" the
shell
with the command " TNS_ADMIN=/tmp lsnrctl start" ( no export of
We went from 11.5.6 to 11.5.9. As part of upgrade we implemented
autoconfig. Initiallly could not print. Then put on a patch for
grants and now can print - patch was titled fixes for non-standard
schemas. Still can not access report server. Don't know if due to
autoconfig or 11.5.9 since
We
are having issues with reports server, too... I think it is
Autoconfig.
Did
YOU notice that you got a whole NEW set of services (are you on Win?) when you
went auto config... FEATURE!! Some of the new ones work sometimes,
sometimes only the old ones will.
April Wells Oracle DBA/Oracle
Title: RE: Oracle 11i
NO... it is only 1.8 gig zip file... haven't had the courage to unzip it yet... 11.5.8 unzipped to nearly 8 gig.
and that doesn't address the pre-req patches to lay down the new tablespaces for the new users created in the upgrade.
=)
April Wells
Oracle DBA/Oracle Apps
Thanks, Mike. It still asks me to provide billing info when I tried to
order the CD Packs. How did you get it for free?
Nancy
From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle 11i
Date:
Hi!
Actually you can issue just create database with non-OMF configuration in
9i as well. The command creates files like log1orcl.ora, log2orcl.ora,
dbsorcl.ora, und1orcl.ora under $OH/dbs (or $OH/database as I tested on
windows with 9.2.0.4).
Tanel.
- Original Message -
To: Multiple
http://www.databasejournal.com/features/oracle/article.php/3075071
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
Database Database Administrator.
(Database DBA)
: )
Patrice.
-Original Message-
Sent: Wednesday, September 10, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Doesn't this go back to the Application DBA vs. Production DBA
discussion? I've talked with folks that employ a Patch
FYI: You run the risk of corrupting your oracle inventory
files by using that installer.
Jared
On Wed, 2003-09-10 at 08:04, Jesse, Rich wrote:
Thanks for the suggestion. And perhaps it explains what I'm seeing. I
tried the 9.2.0.4 installer many times between two installs. Each time the
April,
Nothing disastrous has happened actually (touch wood!) which was a surprise.
We're going from 11.0.3 so I've seen things that no man should ever have to
see. =)
Mostly small data fixes specific to us. I'll let you know if we get a fix to
this current problem.
Feel free to get in touch
The following may be pertinent to the current discussion of Oracle pricing
models.
Ellison sees new software pricing model
Posted September 10, 5:07 a.m. Pacific Time
SAN FRANCISCO -- The model of pricing enterprise software on a per-processor
basis should be replaced with a flat annual fee that
How about using the extension .HTM? OE is a vewy, vewy screwy program and
makes
decisions purely on extensions. You could even make it open an executable
extension
which would send all of your friends message like I love you, which would
replicate
itself when opened. All it takes is a preview of a
Title: RE: making me crazy
Paula,
Would
putting both listeners in one listener.ora file help. You would, of course
have to change one or bothto a non-default name.
Mike
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September
10, 2003
Yet I do not understand why it returns a row in SQLPlus and it does not in a
stored procedure... The problem is now fixed, but I'd like to know the reason it won't
work leaving it as it was. It also fails if I put a string instead of a variable in
the stored procedure.
Thanks!
The curious among us would like to know what kind of situation
prevents you from correcting the listener.ora in the ORACLE_HOME
that is running the listener.
On Wed, 2003-09-10 at 07:44, [EMAIL PROTECTED] wrote:
Dealing with 2 Oracle Homes - one if which I need to run the listener from
and one
Title: RE: Oracle 11i
It actually just doesn't speak well of the sanity of those involved in maintaining the beast. And this is coming from the Corporate Systems chief beast keeper...
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few
Hi list
My companie is trying to
demonstrate the virtuews of 9ias compared with BEA.
Can any one help me
here?
Regards
PG
Has Oracle made any progress on the problem. We have duty managered
the TAR with no solution to date. Last update is that Oracle wants an ODC
session.
We are W2K on two tier.
What services are giving you a problem?
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit
sometimes listener... but sometimes not (when new works
old doesn't but if new doesn't start... old will)
sometimes apache... but sometimes not (when new works
old doesn't but if new doesn't start... old will)
sometimes CM... but sometimes not... (when new works
old doesn't but if new
Ah, so it was to tape.
How many people still use dd to go to tape?
Jared
On Tue, 2003-09-09 at 19:49, Tanel Poder wrote:
Are you sure that your exportfile is intact, that it was saved fully and correctly
to tape and it is read fully and correctly from tape. And it is passed fully and
SQL and PL/SQL are not the same until Oracle 9. There are distinct
differences between the two in earlier releases.
I don't have an 8.0.3 version of Oracle but the following is the result
from 8.1.7:
SQL create table wb (c1 char(8));
Table created.
SQL insert into wb values('abcd');
1 row
Hi List
Due to a corrupted controlfile, I create a new controlfile with the
CREATE CONTROLFILE statement. Unfortunately I missed one datafile. Is there
any solution to for this case. We are running under 8.1.7 release.
Thank You.
Best Regards
Kamel Benlatreche.
--
Please see the official
Hello,
I have a moderate size 8.0.4 database that has been running perfectly for
years. I took an export of the structure only of this database and imported
it onto another server also running 8.0.4. I then inserted only a few rows
into key tables. This is now serving as a testing database
Fermin,
The pl/sql manual has an appendix on char versus varchar2 semantics.
I guess SQL*Plus isn't as restrictive(?) and I gues the behaviour might
have changed since 7.3.
I wonder why baan uses char datatypes
chaim
Guido Konsolke [EMAIL PROTECTED]
@fatcity.com on 09/10/2003 10:14:24 AM
Philosophically speaking, when the scales fall from the eyes of an
idealist and he/she becomes a rationalist, they've adopted a
materialized view. ;-) But maybe it only exists if you believe it
exists.
-Original Message-
Sent: Wednesday, September 10, 2003 5:04 AM
To: Multiple
Title: RE: Oracle 11i
Don't forget the installation and patch sizes vary
dramatically between platforms...
(11.5.7 standard installation for Linux is 24 disks
for example (I counted oraAux in)).
Tanel.
- Original Message -
From:
April Wells
To: Multiple recipients of
Hi!
One more interesting issue with CHAR datatype is, that it is not *always*
padded with spaces as sometimes understood. When the CHAR field is NULL,
then no spaces are saved into row. But as soon as you update even one single
char into it, the full CHAR length is used for this field in a row.
Hi!
Yes, if you know where your file is.
Use alter database create datafile as syntax as seen below:
SQL alter database backup controlfile to trace;
Database altered.
SQL alter tablespace users add datafile
'C:\Oracle\Oradata\ORCL\USERS02.DBF' size 1m autoextend off;
Tablespace altered.
SQL
Kamel,
What do you have for backups on the schema(s) that use the tablespace with
the missed datafile?
Bryan Rodrigues
DBA
Elcom, Inc.
-Original Message-
Sent: Wednesday, September 10, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Hi List
Due to a corrupted controlfile, I
Hi all,
How to work with Array in PL/SQL. I have an input
string like 12,34,56,.. I need to get the values
out and assign them to an array, and loop through the
array to call a function. Do you have sample code for
1) value assignment to array and 2) loop through
array. And it's all in
Dennis,
Do you have the source of this report???
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, September 10, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
The following may be pertinent to the current discussion of Oracle
I don't know which schema is using the tablepace, but I have a yesterday's
Export file.
Regards
-Message d'origine-
De : Rodrigues, Bryan [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 10 septembre 2003 17:24
À : Multiple recipients of list ORACLE-L
Objet : RE: Missing a datafile
Title: RE: Oracle 11i
Heh-heh, imagine you're migrating from 10.7, where
you have additionalfew tens of thousandsAutoUpgrade scripts as
well...
Btw, I have sometimes used the unsupported
_wait_for_sync=false parameter to speed up commitswhen doingupgrades
or extensive patching. You've
Dick - Sorry, Infoworld, I didn't realize the link would get stripped off.
http://newsletter.infoworld.com/t?ctl=443575:1F31A10
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 10, 2003 12:39 PM
To: Multiple recipients
You also need to consider replication issues. If you will have another
site that needs to store the documents, you will need to include that in
the decision. For example, if you store them inside, Oracle can handle
the propogation of the documents to the alternate site. If you store them
outside,
otn.oracle.com go to documents. look pl/sql table. its a dynamic array.
asktom.oracle.com will have examples.
From: Andrea Oracle [EMAIL PROTECTED]
Date: 2003/09/10 Wed PM 01:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: array question ???
Hi all,
How
Having fun, while Jared isn't watching?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Orr, Steve
Sent: Wednesday, September 10, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Philosophically speaking, when the scales fall from the eyes of an
idealist and he/she
Consider this :
Research is the best way to discover and to remember information.
The acquisition of information increases a DBA's skill.
Skilled DBAs should (?!!) always be in demand.
Therefore, by encouraging people to read manuals you're helping to make me
unemployed.
Just something to
Here it is :
http://www.infoworld.com/article/03/09/10/HNellisonpricing_1.html
Stephane
-Original Message-
Goulet, Dick
Sent: Wednesday, September 10, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Do you have the source of this report???
Dick Goulet
Senior
Yay!
Five years ago, everybody *knew* that Oracle was the center of the
universe. Two years ago, everyone *knew* OiD was the best thing since
sliced bread and fifteen minutes ago, you *knew* that OUI could do no wrong.
Imagine what you'll know tomorrow.
(with apologies to Barry Sonnenfeld)
Title: RE: what is a materialized view ?
I have our print room print them double sided and glued binding.
It's just so hard to highlight and mark up a PDF
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the
hi.
I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here
thanks
Gene
__
Do you Yahoo!?
Yahoo!
Something like that at the bottom of this article:
http://www.computerworld.com/news/2003/story/0,11280,84773,00.html
Patrice.
-Original Message-
Sent: Wednesday, September 10, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Do you have the source of this
Re:
PS Personally I think that the discontinuation of paper manuals was a
disaster. I used to take concepts manuals when I went in the bath. A great
place to learn. No kids, no TV.
Absolutely! I still have several of my old v6 and v7 manuals
just because of the little schnibbles of
Olga,
Does select * from global_name ; do the trick?
-Original Message-
Sent: Wednesday, September 10, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
v$instance and v$database
hi.
I think there was a dbms package to get some of
the environment variables for a session, but I
1 - 100 of 144 matches
Mail list logo
