I'd be interested to get an opinion on the fastest way to do an indexed
search on a substring aka I'm looking for the WHERE MYCOL=%ABCD%
functionnality. The underlying table is very huge. I can see several ways to
do that but I'm sure this has been explored before.
Thanks
Christian
--
Any stat missing in a CBO situation will be set to the hard-coded default
values found in the source code. One example (out of about 40 or so
values) is default selectivity for equality predicates. Before 7.3 it was
0.125 (meaning that a where= condition would assume you needed to scan
1/8th of
-Original Message-
From: Guidry, Chris [mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 juni 2001 0:33
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: What stands for i in Oracle 8i
Hi,
Since every word requires a vowel
You're sure ?
How about 'd*mn' or 'm*cr*s*ft' ?
Hi all gurus..
I want to create my database on NT . but svrmgrl
gives error of
SVRMGR startup nomount
pfile=D:\oracle\ora816\admin\uybs\inituybs.oraLRM-00109: could not open
parameter file 'D:\oracle\ora816\admin\uybs\inituybs.ora'ORA-01078: failure
in processing system parameters
How
Does Implementing this Parameter Need the Indexes to be in ANALYZED
State ?
-Original Message-
From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OPTIMIZER_INDEX_COST_ADJ
Chaim,
thanks for the info - puzzlingly, however, when I went to the server which
I'd quoted as being 8.0.5, I discovered I'd been mistaken, and it is in fact
running 8.0.6. The Intelligent Agent on there is 8.0.6.0.0, so according to
the compatibility matrix, my OEM 2.1 should be able to
Hi All,
Someone mentioned to me today that it is possible do an export and pipe the
output to the oracle import utility to import the data into another
database.
Does anybody know if this is indeed possible and if so, how and what are
the things to be aware of?
TIA
Jack
Just check if this file inituybs.ora is present in
the
specified directory
D:\oracle\ora816\admin\uybs.
Alternatively you copy this file (inituybs.ora) to
ORACLE_HOME\database directory, which is default
place for this. In this case you
can directly use
startup nomount.
HTH,
Rajesh
The actual act of putting something on the freelist
and/or taking it off I don't think is the cause of the
overhead. However, you do need to update the segment
header block which contains the freelist header
information, which means the segment header becomes a
'hot block'..
The only empiric
I'd be interested to get an opinion on the fastest way to do an indexed
search on a substring aka I'm looking for the WHERE MYCOL=%ABCD%
functionnality. The underlying table is very huge. I can see several ways
to
do that
I can't see any ways to do that. If there's a leading % Oracle won't
First would be to prepare and send a synopsis to the
'big name' oracle publishers - O'Reilly, Wrox and the
like..
hth
connor
--- Jim Hawkins [EMAIL PROTECTED] wrote: All,
I am very interested in collaborating with others in
the writing of an
Oracle technical book (DBA subject matter). I
Literary background is meaningless in writing a technical book... I don't
have one and I managed :)
Developmental editor if you can't write? Not hardly likely. That's what I've
done on both Marlene Theriault's Networking 101 and Gaja's Tuning 101 books.
You need to be able to write to make
I am saving this excellent email as advice to anyone who asks me about DBA
work.
What an absolutely top posting
Cheers
Don.
-Original Message-
Sent: 07 June 2001 06:50
To: Multiple recipients of list ORACLE-L
Do you want a paper to say you are marginally qualified to be a DBA or do
Hi All
Running Oracle 817 on Red Hat Linux. File layout is as follows.
oradata3/prod:
control01.ctl indx01.dbf redo01.log system01.dbf tools01.dbf
oradata4/prod:
control02.ctl redo02.log temp01.dbf
oradata6/prod:
control03.ctl rbs01.dbf redo03.log
oradata7/prod:
redo01b.log
Bunyamin
LRM-00109 could not open parameter file 'string'
Cause: The parameter file does not exist.
Action: Create an appropriate parameter file.
Are you sure that the init file is not in:
Are these defaults recorded somewhere that
mere mortals have access to?
Jared
On Thursday 07 June 2001 00:25, Mogens Nørgaard wrote:
Any stat missing in a CBO situation will be set to the hard-coded default
values found in the source code. One example (out of about 40 or so
values) is
I
would suggest that your init.ora file is not where it should
be
ie.
check that
D:\oracle\ora816\admin\uybs\inituybs.ora
is
exactly where the parameter file is and that it is named
correctly.
Cheers
Lee
-Original Message-From: Bunyamin K. Karadeniz
[mailto:[EMAIL
Do it with Perl. If you don't know it, it's
time to learn.
This script will do it:
#!/usr/bin/perl -pw
chomp;
next if /^\s+$/;
$_ =~ s/^\s+(.*)$/$1\n/;
run as my_script file_to_fix.txt fixed_file.txt
Jared
On Wednesday 06 June 2001 07:55, you wrote:
Hey all,
I am looking for
Bilou,
This was discussed not so long back on the list, and I'm pretty sure the up
shot was that to search for a string with a % wildcard on either side you
need to look in to the Intermedia (Context) cartridge.
HTH
Mark
-Original Message-
Bilien
Sent: Thursday, June 07, 2001 08:26
On Wednesday 06 June 2001 22:10, Seley, Linda wrote:
(Course I don't even like the new
installer, I want the old one back! huge whine!)
Hey, we feel your pain.
Gimme the old (reliable) installer.
I'm tired of 'Oh! I don't like the version number I see
on your java and I'm going to die
Just a thought, but what is your GLOBAL_NAMES parameter set to in your
init.ora file?
Mark
-Original Message-
Sent: Thursday, June 07, 2001 12:06
To: Multiple recipients of list ORACLE-L
Ok folks here's whats happening when I run 'sqlplus foo/bar@DEV':
SQL*Plus: Release 8.1.7.0.0 -
Here is my production /development db ,
Oracle7 Server Release 7.3.2.3.0 - Production Release
With the distributed, replication and parallel query options
PL/SQL Release 2.3.2.3.0 - Production
How can I enable TOAD to trigger the debug option in order for me to trace
out the PL/SQL code ?
I
Jim, Check the O'Reilly web site. There is an area where they describe how
they work with authors.
- Greg
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 1:29 PM
All,
I am very interested in collaborating with others
Hi all,
I was just wondering if there is any alternative method
of getting the numeric values of rowid other than
dbms_rowid.
Other way, what is the algorithm for calculating
numeric value of rowid's values. e.g.
SQL SELECT DISTINCT SUBSTR(ROWID,10,6) BLOCK# FROM
PRASANTA.TPSV ;
Hi
Bunyamin K. Karadeniz,
I
assume your init*.ora at that path
(D:\oracle\ora816\admin\uybs)
Since
you know your parameter stuff, just create new one at other hdd and
retry.
If
work you have to checkyour hdd might be containing some bad block (can't
read but can write problem)
But if I want to conserve the carriage return
-Message d'origine-
De : Jared Still [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 7 juin 2001 12:36
À : Multiple recipients of list ORACLE-L
Objet : Re: Help for Unix text file processing
Do it with Perl. If you don't know it, it's
time to
Is there ANY reason at all not to use spare space on oradata 3,4,6,7 to
store other files ? They won't be read or written during times when the
database is under load.
Cheers
GS
Can't see any.
Regards
Stephane Faroult
Oriole Corporation
--
Diese E-Mail wurde mit
Hi Don,
Thanx for the inputs Don. I wanted to be a DBA , but dint know the exact
path to follow. Ur inputs seems to be like a guideline for all those people
who want to be a DBA.
I ll stick to what u have said and create my own oppurtunites to become a
DBA in my company.
cheers,
Ravi
Hi all gurus..
I want to create my database on NT . but svrmgrl gives error of=20
SVRMGR startup nomount pfile=3DD:\oracle\ora816\admin\uybs\inituybs.ora
LRM-00109: could not open parameter file =
'D:\oracle\ora816\admin\uybs\inituybs.ora'
ORA-01078: failure in processing system parameters
In performance terms it won't really make a difference but from an admin point
of view it's not a great idea.
It's way too easy to accidentally move or remove a file during a routine
operation and it can can confuse backup and restore operations. If I ever have
to do this I create a
Hi All,
Someone mentioned to me today that it is possible do an export and pipe=
the
output to the oracle import utility to import the data into another
database.
Does anybody know if this is indeed possible and if so, how and what ar=
e
the things to be aware of?
TIA
Jack
mkfifo mypipe
Just out of curiosity, what would happen if I was to install the SUN JDK on
a server that has 8i on it?
Would the Oracle one (8.1.6.0.0. or whatever) and the SUN ones interfere
with each other?
I know next to nothing about Java.
Likewise, if I was to install the SUN HotJava Web browser on a
Hi all,
Can someone explain what is Quorum device, what it is the different from
disk and quorum device ?
Thank you,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
I have an old server here, NT with OWS 3.0.1.1. on it. We are upgrading to
iAS 1.0.2. soon...
In the meantime, we now have a conflict on the server, a PL/SQL cartridge
application is causing errors - the transaction table is full.
ORA-02042 too many distributed transactions
This is definitely OT, but the Egyptians used to omit vowels from words,
perhaps because they thought vowels were breath.
The vowels happen to be... yi ah o ou w e h
In French, a e I o u - the order is scrambled -- I a o u e
Yahweh.
Interesting, no?
: )
Patrice Boivin
Systems Analyst
Jared:
In the Oracle 8.1.6 Docs:
Oracle8i Designing and Tuning for Performance
8 Gathering Statistics
Table 8-2 Default Table and Index Values When
Statistics are Missing
Kevin
-Original Message-
Sent: Thursday, June 07, 2001 6:21 AM
To:
I have already circulated with my dba friends circle. Excellent article.
--
On Thu, 07 Jun 2001 00:36:33
Robertson Lee - lerobe wrote:
I am saving this excellent email as advice to anyone who asks me about DBA
work.
What an absolutely top posting
Cheers
Don.
-Original Message-
On Wed, 6 Jun 2001,[EMAIL PROTECTED] scribbled on the wall in...:
-Lisa,
-
-Please! Have a glass of a decent (or at least cheap) Merlot and come back
-to the dark side - UNIX BIGOTS UNITE!!!
NO NO NO... single malt rules!
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.
PMFJI.
If you set OPTIMIZER_GOAL=FIRST_ROWS for the entire
database you'll have a *big* problem in your hands with
most of the dictionary views, including catexp, becoming
exceedingly slow.
It's better (if you can) to stay with CHOOSE and analyze
just what you need. Then you fiddle with
Title: HELP: Hanging Autotrace
Good morning everyone,
I'm trying to help out our user community here by tuning up some queries. Should be easy, right? Well I don't have dba privs and I have a crappy old W98 PC w/200-some processor. when I issue SET AUTOTRACE TRACEONLY EXPLAIN and start a
Raymond,
We are using Reference Cursors as follows:
My Applications group creates stored packages that provide the reference
cursor to to VB applications through ADO. ADO performs the actual
record-stream manipulation for the VB tool, transforming the data stream
into XML for VB to present to
Don,
Excellent article. Even today, after 6 years, I still do the looping you
mentioned.
Rao
-Original Message-
Sent: Thursday, June 07, 2001 1:50 AM
To: Multiple recipients of list ORACLE-L
Do you want a paper to say you are marginally qualified to be a DBA or do
you actually want
The order is different in Japanese as well, although I'm blown if I can
remember the correct one.
-Original Message-
Sent: 07 June 2001 13:26
To: Multiple recipients of list ORACLE-L
This is definitely OT, but the Egyptians used to omit vowels from words,
perhaps because they
Mark,
Create profile and assign the profile to the user. Also, enable resource
limits to take effect. Following is an example for creating a profile.
Step 1.
CREATE PROFILE duh1
LIMIT SESSIONS_PER_USERUNLIMITED
CPU_PER_SESSIONUNLIMITED
IDLE_TIME
Linda,
Thanks for the info, misery loves company. I've tried using the old character based
installer for discoverer per Note 131662.1, it doesn't work either(cant find some .lib
files). I have a TAR open on that and a Portal issue. Hopefully I'll learn some tricks
that I can share.
On Wed, 6 Jun 2001,Joseph S. Testa scribbled on the wall in glitter crayon:
-Hey, i resemble that remark, damn, i wasnt supposed to tell anyone i was
-certified.
-
-I'm going to indulge in hostess snack cakes as a punishment.
-
-joe
have them with some nice single malt.;-)
me i'm certifiable
--Boundary-00=_TQ9KG6G0
Content-Type: Text/Plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi List,
(SunOS 5.7, Oracle 8.1.6,Newbie DBA)
I have been reading Oracle DBA 101 and have come accross an initsid.ora=
parameter
log_checkpoint_to_alert.
But its so much more fun not to tell them in my experience.
Case in point. After constant reminders (all mails copied to manager) to,
amongst other things, remember to log out, an auto log out procedure is
adopted.
First irate developer/user rings up and complains in a less than friendy
manner.
Hi
THX, I guess that someone was right than.
Jack
sfaroult@oriol
I have a small database with only about 6-10 users. I am getting ORA-04031
errors indicating shared_pool problems. Can anyone give me a suggestion on
how to size the shared pool?
My current parameters are:
shared_pool _reserve_size 209715
shared_pool_size 4194304
large_pool_size 614400
Ron
Greg
My concern is How can I reuse the deleted space, I have 20Gb Table with 15Gb
Indexes, So I may not touch the table due to massiveness, I can do atleast
indexes rebuild for availing 3-4Gb back. So in that regard pct_used has
greater significance for reusing the space for future
Hi All,
Can somebody enlighten me what is included in the memory usage per session.
We have a sort_area_size of 1M and have found sessions that have as much as
200Mb memory usage (Exceptional) and 20-40Mb on regular basis.
TIA
Jack
So the user groups and DBAs can identify the bugs before the release to the general
corporate public.
ROR mª¿ªm
[EMAIL PROTECTED] 06/06/01 12:12PM
My question is, if they are developing on HP-UX, why was 9i for SPARC
released first?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
The reason is that the 'FIRST_ROWS' parameter didn't give the expected
results. We wanted index access strongly favored and setting
OPTIMIZER_INDEX_COST_ADJ to 30 (we tried with 75 and 50, too) gave us the
plans that we were expecting. The problem with cost based optimizer are
the bind variables,
This message uses a character set that is not supported by the Internet
Service. To view the original message content, open the attached message.
If the text doesn't display correctly, save the attachment to disk, and then
open it using a viewer that can display the original character set.
Amen, my straight-talking brother!
sarcasm
But, why on Earth don't you want to spend hours spewing
arcane 0.001% performance tweaks you learned during the
Advanced OCP Certification Boot Camp?
Don't you want to impress people? Don't you want a limo,
yer own helicopter, and an oracle web
Welcome!!
Good to see you back here
- Kirti
-Original Message-
From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2001 1:01 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING
Thanks for the reply, Rachel, and all others who wrote back offline and
through the list. Basically, here was my idea:
Most DBA topics have been beaten to death, and I would have nothing new to
contribute. There is one area, however, that I see could be explored...
Here goes...
Tips, Tricks,
Greg's bit on show me got me going.
I dug up this site by a guy who knows
CPUs up and down, and writes OS emulators
in assembler. That was enough to impress me.
http://www.emulators.com
He has some nifty history, tweaks, and tips
on his site.
- Ross
|| -Original Message-
|| From:
RS -
You'll get alot of posts on this, but.
Basically
multiply your pool by about 5x ( at least! )
along with the reserve size. Set the min_alloc
(as/if relevant in yer version to about 16K)
If you are doing parallel execution and or
RMAN stuff, grow the large pool, too.
Oh, hell, you
I know this has been
sort of 'done to death' in the past but I have been reading through the Oracle9i
New Features document I received this morning and far from being able to do away
with DBAs, a common thread throughout the doc. is
The administrator
will be able to ..
This will
$ORACLE_HOME has to match the ORACLE_HOME= directive in the listener.ora
file EXACTLY... 3 days of tracking down a bug because I didnt put a /
after the 8.1.7 in the ORACLE_HOME directive... oh well, live and learn :)
thanks,
jon
On Thu, 7 Jun 2001, Mark Leith wrote:
Just a thought, but what
Hi
If the pattern of deleted dta leaves you with many almost empty leaf blocks then
you may find that you would benefit from and index COALESCE rather than a
REBUILD.
On the subject of wasted space in table blocks it's very difficult to
generalise. The best way to go may be to analyse the table
Harvinder Singh schrieb:
Hi,
I am running couple of ddl statements dynamically
problem is whenever oracle is unable to execute particlar
statement it just exit from procedure and don't go to next
statement.
How to modify syntax.
Thanks
Harvinder
--
Hi,
just catch the
thanks for sharing, dude.
|| -Original Message-
|| From: Mark Leith [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, June 07, 2001 10:42 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: LOT (Little OT): Interesting Oracle related URL's.
||
||
|| Thanks for your input guys -
LOG_CHECKPOINTS_TO_ALERT not LOG_CHECKPOINT_TO_ALERT. If you typed it the
same as your init file then you forgot the s on checkpoints.
-Original Message-
Sent: Thursday, June 07, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L
--Boundary-00=_TQ9KG6G0
We ran into the problem of having an ungodly amount of memory allocated to
each of our users sessions as well. What I had to do was to to into SMITTY
and modify the MBUFFS parameter under the environment. Apparently, if
MBUFFS is set large or wide open , Oracle will take ALL YOU GIVE IT.We
Hey Ron I believe the name of that init parameter is
LOG_CHECKPOINTS_TO_ALERT (notice the S) and it will record checkpoints
in the alert file. Someone correct me if I'm wrong. Another way to get
some ideas about your checkpoints is v$sysstat.
Keep in mind however a checkpoint can
Bruce,
Not off the top of my head - never really worked in a forms environment -
but I will have a look in to it tonight, as I've had a bit of a busy day
doing my Real job today :)
Maybe somebody can help in the meantime? But I'll certainly see if I can
find an answer tonight..
Regards
Mark
For those of you interested in this thread.
Here is my conclusion.
Some of my initial tests were flawed with files not existing that I
thought existed and strange results from executing the procedure.
While this is valid from the O/S /usr/bin/ls /u20/app/oracle/* , it
doesn't work from
I blundered into writing. A few years back, an editor saw
some of my newsgroup posts, and shot off an email asking me
to write a book. At first I thought it was one of these
spam-type, work at home, get rich quick, etc. emails,
and I actually deleted it. Two days later, I dug it out of
my trash,
The process at Oracle Press for DBA 101 went like this:
1). one of us would write the chapter (we broke the book out by you write
this one, I'll write that one -- if we did it correctly, you can't tell
which chapter is Marlene's and which is mine)
2). the other would read and make suggestions
I know this is silly, but wouldn't it be neat if the OEM console was the
background for the desktop in the CDE or in Windows?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
I would one of self-publishing houses like Technion where you can get 33% of
sales.
If your book is any good it will sell in the same volume as with any other
publisher (not that they spend a lot of money for promotion any way).
Alex Hillman
-Original Message-
Sent: Thursday, June 07,
At 09:50 PM 6/6/01 -0800, you wrote:
Do you want a paper to say you are marginally qualified to be a DBA or do
you actually want to learn database administration?
To a large extent I agree with you about the relative unimportance of paper
qualifications. However, one thing that a formal course
The Oracle DBA's Guide to NT
Guy Harrison
Published Spring 1998:
http://www.oreview.com/9805harr.htm
( linked from: http://home.mira.net/~gharriso )
--- excerpts ---
...
The architecture of Oracle in an NT environment is somewhat
different [than Unix/etc.] (see Figure 2).
About CURSOR_SHARING - EXACT means that SQL statements are not changed, and
FORCE means that constants are changed to bind variables.
Alex Hillman
-Original Message-
Sent: Thursday, June 07, 2001 11:52 AM
To: Multiple recipients of list ORACLE-L
The reason is that the 'FIRST_ROWS'
self-publishing houses charge you to publish the book (yes, they do, that's
how my father-in-law published his book)
I also doubt that they give you much in the way of help in editing your
book, so that if your English is not good (as the case of the author that
Jonathan is working with) you
I need to ftp several archive logs from one server to another. Do I need to
specify either ASCI or BINARY modes? What difference does this make when
ftping files? Thanks.
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Probably. I'm not responsible for posts I answer
in the middle of the night.
Jared
On Thursday 07 June 2001 07:21, Connor McDonald wrote:
Didn't I already say Chapter 8
:-)
Connor
--- Jared Still [EMAIL PROTECTED] wrote:
Are these defaults recorded somewhere that
mere
Jonathan,
You had nice editors... letting you slip 6 months on the deadline.
When I talked about giving up your life, I was talking about a much shorter
writing schedule. We took from March (when we signed the contract) until the
middle of September (when we sent in the first draft of the
I have heard alot of people complain that CURSOR_SHARING force causes 600
errors, I haven't seen it but I stay away from that setting.
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/7/01 1:06 PM
I have cursor_sharing set to FORCE (but we don't run Case)
we found
I wouldn't. Learn how to use vi. vi is on every unix flavor and usually its the only
editor available in single user mode. just my $.02.
[EMAIL PROTECTED] 06/07/01 12:31PM
Can anyone please tell me how to use emacs when i want to edit unix files.
I am using vi but want to use emacs now. I
* Stop the agent on the remote node
* delete all the q files
* on the OEM side , remove all the databases from the node in
question.
* start agent on the remote node
* rediscover the node on OEM
The steps above should solve the problem
vikas
InnoVentry Inc
680
Vivek,
My guess is probably yes, but I should be honest
that I really have not worked with an environment with
these parameters turned on and not having statistics
on the objects (both tables and indexes), as if I
recall correctly, these parameters came into being in
8.0.4/8.0.5. I have used the
was just talking to the campus IBM mainframe sa the other day, and he
said that they run multiple instances (test/production) of the usual
IBM mainframe *os* on the box, and that they run not only multiple
versions of the usual IBM mainframe os, but that they also have red
hat linux running
Probably not common on Unix in general, but we typically slice Sun E10ks up
into multiple domains with each running as an independent node - unique IP,
different versions of Solaris, etc.
-Don Granaman
[Certifiable OraSaurus]
- Original Message -
To: Multiple recipients of list ORACLE-L
Since Greg originally asked Is there ANY reason..., I'll add another
element to the consideration. I agree with what Mike says, but if you are
really, really picky, putting other files on the filesystem with Oracle
datafiles can cause file fragmentation when a datafile is extended in size
(auto
Ya know, having read that entire chapter last week
you would think I could remember this.
Jared
On Thursday 07 June 2001 05:30, Toepke, Kevin M wrote:
Jared:
In the Oracle 8.1.6 Docs:
Oracle8i Designing and Tuning for Performance
8 Gathering Statistics
Here's a great article for installing Oracle on Linux
for all you unix wannabes. :)
http://www.oracle.com/oramag/oracle/01-may/index.html?o31linux.html
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network
Nope. DBAs are chosen, not trained. To become a good DBA one must
go to Mt. Sinai and talk to a burning bush. If the bush talks back,
then the applicant will have the power to split the seas of data into
partitions. Instead of appealing to pharaoh to let his people go, the real
DBA uses the
Add a second column and store the value in decimal; then sort by that
column.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 12:56 PM
One of our developers was looking for solution for his problem ..
Any idea folks ..
On Thursday 07 June 2001 09:47, Jon wrote:
I dont have the GLOBAL_NAMES parameter set.
It's in your database.
e.g. select * from global_name
use ALTER DATABASE to change it
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL
Jim,
It's a good idea!!
Let me add this to your thoughts in progress: think of a way
to make a very good index for this. Many, many technical books
fall flat on their front cover when it comes to an index.
So, for example (following our own Greg from this morning) if
I want to figure out
On Thursday 07 June 2001 04:10, ALEMU Abiy wrote:
But if I want to conserve the carriage return
Then change the script from '\n' to '\r\n'
Jared
-Message d'origine-
De : Jared Still [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 7 juin 2001 12:36
À : Multiple recipients of list
Title: RE: What next ?
Ross, you are being superceded as the chief goof. Get busy!
Me, I had to kiss the current dbas' feet, shower them with compliments about their databases, ask them tough questions, show them how to write pl/sql, grow some grey hair and buy them beer. I also planted a
Lisa,
Have you tried approaching this politically rather
than technically?
Let the manager of the local users know what you are
trying to do, and why you can't do it.
Then maybe some pressure can be applied to get you the
privs you need. You don't even need DBA privs, just
SELECT ANY
I'm just wondering if the best way to handle a rollback of added columns is
to alter the table to mark the column as unused and then drop the unused
columns via ALTER TABLE t1 DROP UNUSED COLUMNS; or would the ideal thing be
to export the table(s) before adding the columns and then reimport,
I think it is a great idea. I have some tips or tricks that I could contribute.
-Original Message-
Sent: Thursday, June 07, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
Thanks for the reply, Rachel, and all others who wrote back offline and
through the list. Basically, here
I am sure that any of working DBA's have this money to put up front. I don't
think that risk to invest in the book is more than in the stock market. Also
what is the problem to hire editor (especially not technical). Should not be
too expencive. Of cource it is more work, but one can get much
1 - 100 of 193 matches
Mail list logo