Matthew,
SAN's incur (much?) more codepath. If that makes things run faster
that's excellent and fantastic. If removing a bunch of code and 8 or 9
layers between a server and a disk plate makes things slower there's
something else wrong. Time and again we see how a laptop or desktop PC
disk
I agree with the benefits of being able to
wave benchmark papers around and
saying But look what they HAD to do !
The line from one of the HP ones (1M tpcc)
that I really liked was:
quote
Most of the space on the arrays in the tested system was unused during
the performance tests, but is
List,
Can someone give me a doc/URL for the steps invloved in standby database
configuration ( manual recovery mode ) on 9iR2 SE ?
I do have a doc for standby database configuration ( managed recovery
mode ) for 8i EE .
except automatic log transfer which is not a feature of SE ,
will the
Standby is only for Enterprise Ed.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Prem
Khanna J
Enviado el: martes, 16 de diciembre de 2003 8:24
Para: Multiple recipients of list ORACLE-L
Asunto: standby database configuration in 9iR2 SE ?
List,
Can
No Juan . SE also has the feature but Managed Recovery
is not possible as in EE .
A metalink doc says :
quote
Basic Standby Database is a feature of SE .
that is it Allows the DBA to manually clone a database,
and to copy and to apply log files to the standby
/quote
anyway i'm looking for
Not just hash clusters, single-table hash clusters
with user-defined, and very carefully designed hash
key. Not something you can usually get away with
in a dynamic table of 19 billion rows.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who
I am sorry.
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de
[EMAIL PROTECTED]Enviado el: martes, 16 de diciembre de
2003 0:34Para: Multiple recipients of list ORACLE-LAsunto:
RE: RedHat Advanced Server v3.0, anyone?
MetaLink is an official Oracle
support mechanism for paid
Hi,
This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and
we encountered
a strange problem in issueing
alter tablespace name offline.
I had to reorganize tablespace and when testing this I did this manually and no
problem at all.
I put the statements in a
- Original Message -
I beg to differ.
When I ask for 2 external storage units of 14 drives apiece (DAS), and they look at
me like I obviously have no clue
about their intentions of a 3 drive RAID something other than 10 config, a
configuration that they can download just by
showing
Gives a whole new meaning to the expression
surrogate key...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 7:19 PM
Not just hash clusters, single-table hash clusters
with
Hi
Jeroen,
What
is problem? Error msg or something?
Sinardy
-Original Message-From: Jeroen van Sluisdam
[mailto:[EMAIL PROTECTED]Sent: 16 December 2003
18:12To: Multiple recipients of list ORACLE-LSubject:
alter tablespace offline
Hi,
This
weekend I was
Hi Sinardy,
Instance
was terminated when opening
Errors
in file /opt/oracle/product/admin/DECA/udump/deca_ora_28080.trc:
ORA-00376:
file 6 cannot be read at this time
ORA-01110:
data file 6: '/migratie_deca/DECA/DATA/tools01.dbf'
Error
376 happened during db open, shutting down
did you also rename the datafile within the database? the error
message on the line starting with ORA-01110 tells you that the database
thinks the file should be at /migratie_deca/DECA/DATA. If that is the
original location, that should tell you that as far as Oracle is
concerned the datafile is
Hi
Exact steps are:
1) alter tablespace tools offline
2) shutdown immediate
3) move the file on os-level
4) startup mount this failed
5) Here I wanted to exec the rename
I know it's weird but this really happened and
When I tried this with a new testdb again and used alter tablespace name
Your high value for each partition can just be the beginning of every month. For
example:
CREATE TABLE ACCOUNTS
(
STATEMENT_DATE DATE NOT NULL,
ACCOUNT_NUMBER VARCHAR2(8)NOT NULL,
BILLING_CYCLE VARCHAR2(2)NOT NULL,
Resending, since my message was truncated...
Your high value for each partition can just be the beginning of every month. For
example:
CREATE TABLE ACCOUNTS
(
STATEMENT_DATE DATE NOT NULL,
ACCOUNT_NUMBER VARCHAR2(8)NOT NULL,
BILLING_CYCLE
Does myFunction1 often get called with the same arguments? In your example, the
second argument is never repeated, but in the real thing, would the same second
argument be likely to repeat? If myFunction1 gets the same arguments, will it always
return the same value? If so, then it is a
Rick,
If you partition on the date field then you set the partition limit
with a date type limit.
PARTITION aadedup01 VALUES LESS THAN ('02-01-2003')
TABLESPACE aadedup01_data,
PARTITION aadedup02 VALUES LESS THAN ('03-01-2003')
TABLESPACE aadedup02_data,
PARTITION aadedup03 VALUES LESS THAN
From what I understood, he's asking how to put all January records in one partition,
all Feb in another etc.
So you end up with 12 partitions for as many years as you wish. I could not think of
any other solution then the one he does not want to.
rw
Your high value for each partition can just
Oracle is posting healthy profits.
http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City
Hi
My SSL certificate is going to expire and I need to renew it.
I am running 9iAS 9.0.3 on Solaris8. All the documentation
seems to be about setting up the original certificate and I
can't find anything on renewals. Has anyone done this?
I have requested a new certificate from Entrust using the
Sinardy, where does oracle say anything like that about free memory? Please,
quote me an article or URL. Second, if you are not using MTS, your PGA is a
part of your dedicated server address space, not SGA. It does exist, though.
Similarly, UGA goes to shared pool instead. Buy yourself The Book
the question for technical people is where the sales are located. are they in the US?
or somewhere else
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/12/16 Tue AM 08:59:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Good news from Oracle
Oracle is
In good, old times when I was much younger then today, things
that were benchmarked were called MIPS, which was short for
Marketing Invention for Pushing Sales. Today they have
TPC transactions which are equally relevant to the real
world, but have no good translation. Whoever chooses hardware
One of our hardware guys is seeking an opinion on SANs. He is comparing the Hitachi
Thunder 9500 to the HP EVA 5000. Does anybody have any pros or cons to offer for
either one? Good or bad experiences?
Thank you,
Jay
**DISCLAIMER
This e-mail message and any files transmitted with it are
Of course they are. Support and development cost them much less now that they've
outsourced it to Elbonia. The quality of the code is another matter. Fortunately,
they have broad and wide open beta testing program so that we all know what we can
expect. If the first relase of 10g is usable, I'll
check the subject heading for tech note 33174.1
Type: REFERENCE
Status: PUBLISHED
Howzzat?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
If you are an owner of Oracle stock as I am, I don't care where the sales
are. They all help make the stock price rise. However, I do prefer that
the sales be in the USA.
My $0.02,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
I need to do a refresh of a test database using production data. We use
import for this. In the past we have always dropped the schemas (4 or
5), recreated the schemas, and then did a full import with ignore=n.
This time the user does not want to lose any of the new functions and
procedures that
Ron - You should consider refreshing the instance by cloning your production
database. This way you get an exact replica in all respects, and you can
test your backup as a bonus. If you are interested in this method, tell us
how you backup your production database.
Dennis Williams
DBA
Lifetouch,
Ron - As far as losing the new functions, this is one reason we've moved to
a 3-instance layout. Production, staging, and test. This takes off a lot of
the pressure for overwriting test as you describe. Other than that, it
becomes a matter of negotiation. Describe what your options are, and let
Ron,
Of course, your milage may vary, but this is what I do:
1.) exp [EMAIL PROTECTED] file=prod_data_exp.dmp
owner=list,of,comma,separated,schemas direct=y
2.) connect to test_db.
3.) Disable all constraints. When you script this, make sure you order it so that
referential constraints
Like I said. There are new packages, procedures, functions, etc... in
TEST that we do not want to lose.
Ron
-Original Message-
Sent: Tuesday, December 16, 2003 9:04 AM
To: Multiple recipients of list ORACLE-L
Ron - You should consider refreshing the instance by cloning your
production
For this kind of situation I do normally like this
Store all table names in single file.
Exp constraints=n triggers=n indexes=n tables=`cat tables.lst`
file=table_data.dmp grants=n
Import the full file or by fromuser, touser option.
-Original Message-
Sent: Tuesday, December 16,
You can always disable triggers and constraints in existing schema
before running import (and then, enable them after import is done).
Also, specify CONSTRAINTS=N and TRIGGERS=N when exporting.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Smith, Ron L.
Sent: Tuesday,
The first argumant (myID) is a variable that is different every time the
function gets called. The second argument is a hard code number (just as in
my orginal message). So I guess I could not use DETERMINISTIC here. I have
not heard of DETERMINISTIC before but I will take a look of this becuase
Seems like last time I tried to disable constraints Oracle complained
and wouldn't let me due to dependant objects or something.
Ron
-Original Message-
Sent: Tuesday, December 16, 2003 9:15 AM
To: Multiple recipients of list ORACLE-L
You can always disable triggers and constraints in
What are all the problems with triggers and constraints? If you're talking
about unique/primary/foreign keys, disable constraints and those pesky things
that protect the integrity of your data will no longer be in your way. Of course,
you will not know whether your data is inconsistent or not, but
Hi Ron,
For just testdata you might take a look at http://www.databee.com/main.htm,
this can help you.
Dennis' method will work, but doesn't answer your question, because a
production copy will overwrite all new functionality as well. However, his
suggestion isn't as bad as it might seem on a
Ron,
here's an ugly way to do this:
Empty your TEST database of data. Drop constraints Indexes.
Perform and export of the TEST database with ROWS=N - this will export all
Functions, packages and procedures.
Import data from production.
Import the stuff from step 2 above. This should overlay
Here is a sample of the script I run to disable FK constraints:
declare lTables DBMS_SQL.VARCHAR2_TABLE;
lConstraints DBMS_SQL.VARCHAR2_TABLE;
nJ BINARY_INTEGER;
BEGIN
SELECT table_name, constraint_name
BULK COLLECT INTO lTables, lConstraints
FROM user_constraints
WHERE owner = 'IPN_DBA'
what does myfunction1() do?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original
Hi Ron,
For just testdata you might take a look at http://www.databee.com/main.htm,
this can help you.
Dennis' method will work, but doesn't answer your question, because a
production copy will overwrite all new functionality as well. However, his
suggestion isn't as bad as it might seem on a
Below is the code for myfunction1 in the package, It calls a bunch of other
functions, such as getBlastMatches, escapeGene, genes.gene2protein and
addItem.
Guang
---
type blastMatch is record (
geneName gene.name%type,
percent number
);
function myfunction1 (seqid in number,
Will this work?
--
#!/usr/bin/ksh
THINGY=0
cat swt | sed 's/:/ /' | while read A B JUNK; do
if [ $THINGY -eq 1 ]; then
B=that
THINGY=0
else
THINGY=1
fi
echo $A:$B $JUNK
done
Thanks! I'll try it.
Ron
-Original Message-
Sent: Tuesday, December 16, 2003 9:44 AM
To: Multiple recipients of list ORACLE-L
Here is a sample of the script I run to disable FK constraints:
declare lTables DBMS_SQL.VARCHAR2_TABLE;
lConstraints DBMS_SQL.VARCHAR2_TABLE;
nJ
Raj, you proven once again that you're an invaluable source of
good information. Let me share it with the others. The note
that Raj is talking about has the tfollowing title:
ORA-600 [12235] Oracle process has no purpose in life !
I guess it will be accompanied by ora-600 [x] Look
Whoops somehow one line got snipped by listguru ...
S_u_b_j_e_c_t: ORA-600 [12235] Oracle process has no purpose in life ! ... really?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in
It will replace colons with blank and display $A:that Junk on
even number of iterations.
which is used to evaluate the if condition.
On 12/16/2003 11:04:31 AM, [EMAIL PROTECTED] wrote:
Will this work?
--
#!/usr/bin/ksh
THINGY=0
cat swt |
I do that every night, but I drop the user to be refresh in the test db,
is not a big DB.
Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994
-Original Message-
Sent: Tuesday, December 16, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Hi Ron,
For just testdata you might take a
If the developers have code in dev they should have DDLs that generate the
triggers and changes. I hate it whenDevelopers think they can get away with
telling some else to own thier code...Database CODE in my mind always
includes the scripts to generate the object in addition to the funtioning
No, no lawsuit.
Just receiving threatening correspondence from an attorney was enough to ruin my day.
Jared
Eric King [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/15/2003 03:49 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Or perhaps
ora-600 [x] I didn't expect the Spanish Inquisition !
mvg/regards
Jo
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/16/2003 17:19
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Mladen, you seem to be getting more warped, bitter and twisted each day!
:)
I think you need a holiday, or at least a good bottle of whiskey. If
you contact Connor McDonald, he has a list of VERY nice scotches (up to
11,000 pounds IIRC) that you might like to pass on to someone to choose
a nice
Title: RE: Good news from Oracle
More like
ora-600 [x] Spam spam spam spam. Lovely spam! Wonderful spam!
I'm sure Jared will soon agree.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: [EMAIL PROTECTED]
Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the velocity of a laden swallow thing from the Holy Grail,
almost everybody knows Brian and some other sketches. Do we have
any lovers of the Red Dwarf and
The methodology we developed for one client goes like this:
There are three databases - dev, test, and prod.
dev starts as a clone of prod, and fixes, changes and enhancements are developed and
unit tested there. One of the REQUIRED products of development is a script that will
upgrade prod to
Oh, smeg
-Original Message-
Sent: Tuesday, December 16, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the velocity of a laden swallow thing
Yes, this is what I was looking for. I don't care about the year, and don't
want to worry about adding new partitions for every new month that comes
along each year. This table will only needs to contain six months worth of
data. I will not be archiving it at all. I wanted to truncate the
Smeg! Love a hologram...forget that pompus self rightous illusion...
-Original Message-
Sent: Tuesday, December 16, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The
$ oerr tns 0
0, 0, Not An Error
// *Cause: Everything is working as it should.
// *Action: Don't worry: Be happy.
Different song... less Pythonesque...
-Original Message-
Sent: Tuesday, December 16, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Raj, you proven once
Everybody loves Monty Python, don't they? I liked Red Dwarf well enough to
make the effort to see it.
Are we all big LOTR and B5 fans as well?
Mladen Gogala scribbled on the wall in glitter crayon:
Nobody expects the Spanish Inquisition! Why is that there are so
many Monty Python lovers among us oraclites? The other day, Bambi
has used the velocity of a laden swallow thing from the Holy Grail,
almost everybody knows Brian and some
Most definitely ! Smoke me a kipper and all that.
I'm heavily biased in favour of anything British as far as comedy goes :
Blackadder (absolute no. 1), AbFab, ...
mvg/regards
Jo
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/16/2003 18:29
Please respond to ORACLE-L
Rick - Well, a simple way to do it might be to create 5 years of partitions,
based on date as described. Then map all the Jan partitions to the same
tablespace, Feb partitions to the same tablespace, etc. Instead of
truncating a partition, just drop it to reclaim the space. Crude, but might
meet
Before Jared sends you all to my list
nope. hated LOTR (the books and part 1) and never saw Babylon 5
--- Thomas Day [EMAIL PROTECTED] wrote:
Everybody loves Monty Python, don't they? I liked Red Dwarf well
enough to
make the effort to see it.
Are we all big LOTR and B5 fans as
Pete, I wholeheartedly agree with you. That is why I took two weeks off
as of this Friday. Unfortunately, as far as Scotch is concerned, I'm more
of an Irish Cream guy. Bailey's, Feeney Irish Cream and St Bredans Irish Cream
are my favorite poisons. Connor, I hope that you're not disappointed.
Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Februrary of 2004
...
truncate the partitions as needed and reuse by changing the date in
Well, that Irish Cream stuff usually includes whiskey anyway, though of
the Irish variety of course. I have fond memories of my university days
when a friend used to make his own Baileys by the 5 gallon bucket. Same
great taste, only creamier. Ah, those were the days! :)
Pete
Controlling
April,
Look for a syntax error.April Wells [EMAIL PROTECTED] wrote:
Okay, I have been trying Google and Tahiti for 2 days, and I can't for the life of me figure out how to clue in my database.
9.2.0.2 on AIX 5l
I am running multiple databases and am trying to get all of the instances running
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
Or perhaps
ora-600 [x] I didn't expect the Spanish Inquisition !
NOBODY expects the Spanish Inquisition!;-)
--
Bill Shrek Thater ORACLE DBA
I'm going to work my ticket if I can... -- Gilwell song
Dear Gurus,
We are getting the following error if we try to create more than 256 connections from
the same client. The problem is easily reproducible bt writing simple java program and
keep creating connections(do not close it).
Did anyone encounter this kind of issue and how did you solve it?
What is the setting for processes in the database? What is your per-process-file
descriptor limit?
If you are on Solaris following may apply to you ...
Solaris only
Problem Description
---
You have a JDBC program connecting to the database. This program may run standalone
or
Id the file name $ORACLE_HOME/dbs/orapw$ORACLE_SID? The file MUST BE properly named
in order for oracle to recognize it.
On 12/16/2003 01:54:24 PM, M.Godlewski wrote:
April,
Look for a syntax error.
April Wells [EMAIL PROTECTED] wrote:
Okay, I have been trying Google and Tahiti for 2
Anytime you see a number like 256 it is likely you are hitting some limit.
My guess is you are running out of memory in your application on that
client.
If you are trying to open that many connections from a single client you
should start to look at connection manager to pool these connections
Hmm...my first thought is that this could be an OS/network configuration limitation on
the client side? Though it does seem odd to raise an ORA-12154, after many successful
connections
What OS is the client?
-Original Message-
Sent: Tuesday, December 16, 2003 2:39 PM
To: Multiple
Mladen,
I notice that the linux vendors are charging for their distributions...
The free linux argument doesn't hold true anymore, in my opinion.
Patrice.
-Original Message-
Sent: December 15, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L
On 2003.12.15 07:09, Boivin, Patrice
Linux is just not an option in some environments.
: )
Patrice
-Original Message-
Sent: December 15, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L
That's right, it is just another crap. I would rather use Linux instead of
Solarix for x86.
- Original Message -
To:
Jeroen,
The errors look like its from the database open not the mount. As
Rachel has already mentioned the file rename has to take place after
the mount but before you open the database.
Mike
-Original Message-
Sent: Tuesday, December 16, 2003 8:04 AM
To: Multiple recipients of list
My first thought is that JDBC has an array of connections indexed by
a byte-sized index. Let me paraphrase Marie Antoinette, lady famous
for her shrewd dietary advice.
Let them use DBI.
Marie Antoinette's dietary advice came back to haunt her and gave
her a huge albeit very short pain in the
Hello all
I am planning to install Linux; the idea is to install Oracle RAC.
I have two questions:
Q1. Which Linux is best suited for it(RH?/SUSE?/Mandrake?).
I know i can get Oracle download from OTN but it should be
installable on the particular flavor of Linux. Also, i would
like to know
Title: Message
I'll
throw gasoline on the fire here...
On
Win2K you may hit resource limits when you get to 1.5G or so memory used on a 4G
server...
Because Windows allocates half the memory to the kernel processes, half
to the user processes.
Patrice.
-Original
On 12/16/2003 03:29:25 PM, quriyat wrote:
Hello all
I am planning to install Linux; the idea is to install Oracle RAC.
I have two questions:
Q1. Which Linux is best suited for it(RH?/SUSE?/Mandrake?).
I know i can get Oracle download from OTN but it should be
installable on the
Correction... Homo sapiens does not have the largest brain in the animal
kingdom. Elephants have larger brains and sperm whale brains weigh in at
a whopping 20 pounds. So this is not necessarily a case where size
matters, it's the spirit within that makes the difference. Of course the
size of the
And make sure all your indexes are local."M.Godlewski" [EMAIL PROTECTED] wrote:
Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Februrary
Title: Unreadable time_stamp format
I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below. Is there a way to decode it to be readable?
SQL desc USER_ACTIVITY_LOG
Name Null? Type
-
column time_stamp format 9 head 'TIME STAMP'
Nguyen, David M [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/16/2003 01:39 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Unreadable
Steve, you're a genuine cornucopia of almost useful information.
I stand corrected. Sperm whales have larger brain then humans,
which makes them smart enough to forgo Java. Legend has it that
they are using a whale version of perl, based on whistling.
(This is the place to insert I'm a believer
Jay - You have received some great suggestions on this and no doubt you are
researching them. I'll offer a slightly dumber long shot, but easy to check.
What is your PROCESSES set for this instance?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday,
We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the
memory on ora.exe process reaches around 1.4G, our application runs into
Listener unable to start a dedicated server process At this point no one
will be able to connect to the db and we are forced to restart.
We are exploring
I know there's a lot of folks who grumble about the spartan-ness of SQL*Plus, but the
only real feature I wish it had was GNU readline capability for command history and
editing. I've looked at some wrappers (yasql, gasql), as well as replacements
(henplus, which is quite nice, actually), but
Title: Unreadable time_stamp format
Now I got.
USER_NAME TIME STAMP
--
eholley
1069716948959
jmdavis
1069715246467
jmdavis
1069715324466
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bobak,
To extrapolate, then, do you think that Neanderthals(at a cranial capacity
of over 1700 cc) would have been using Oracle 11h, or do you think they
would have prefered OODBMSs?
-Original Message-
Sent: Tuesday, December 16, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L
On
Now that's great! Here is my contribution, pasted directly from
SQL Reference:
TIMESTAMP (fractional_seconds_precision)
Year, month, and day values of date, as well as hour, minute, and second values of
time, where fractional_seconds_precision is the number of digits in the fractional
Title: Unreadable time_stamp format
Which
I assume means you have no idea how to get a readable date out of that? A
thought, it could a be a julian date of some kind.
I
tried several different guessesnone of which panned out. These types
of things usually work better when you have the
At 14:09 16-12-03 -0800, you wrote:
I know there's a lot of folks who grumble about the spartan-ness of
SQL*Plus, but the only real feature I wish it had was GNU readline
capability for command history and editing. I've looked at some wrappers
(yasql, gasql), as well as replacements (henplus,
I would go for the one that promises to have a RAID-5 implementation
that doesn't suffer from the usual RAID-5 problems. Heh-heh.
Mogens
Jay Hostetter wrote:
One of our hardware guys is seeking an opinion on SANs. He is comparing the Hitachi Thunder 9500 to the HP EVA 5000. Does anybody have
Possibly a Boolean date?
-Original Message-
Which I assume means you have no idea how to get a readable date out of
that?
A thought, it could a be a julian date of some kind.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL
OK. You got me going on this for a solution when GNU sed is not available.
(See what you did.)
Instead of the ksh example, here's a non-GNU sed one that works. It works
on GNU sed too.
sed '
$!N
s/\(^.*\n.*:\)\(this\)\(.*$\)/\1that\3/
p
d
'
Here's an awk that is essentially the
1 - 100 of 114 matches
Mail list logo
