I wouldn't want anyone to think that I personally think that the math is
a mistake for the book, my concern is that it may hurt sales
unnecessarily. I don't think that DB's amazon review helps much either,
but it is revealing.
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto
Ryan,
I do not recall seeing a single dy/dx or integrand in the text.
The type of math that he used, I saw in high school, and that was in the US, at a public school. Cary easily could have used "real" math to prove his points. He didn't. He used graphical methods, visual basic and intuition. Bu
Of course, if you just want to learn the file name, oradebug tracefile_name
will do the trick. Looks like this:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Thu Oct 23 01:00:57 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9
Generate "grant" script from dba_role_privs, use "vi" to replace old role with
the new and execute the script. Drop the old role.
On 2003.10.23 00:49, setiady wrote:
Dear all,
Is it possible to rename a role? If it can't be done, what is the best
approach to port all the users in the "old" r
I don't know exactly how to scope your question, so I'll answer the two
things I think it might mean.
For every chapter except for Chapter 9 (Queueing Theory), even college
calculus would be extreme overkill, even if you're looking to *derive*
all the formulas in those chapters. Understanding the
Well, Rafiq, when you move the table, indexes are marked stale, which means
that you must rebuild them. Marking indexes unusable shouldn't generate any
redo log, except for the dictionary block that was altered. Other then that,
moving table is an opration roughly analogous to CTAS and I suspec
No, you don't. I made mistake and tried to learn queuing theory from it. This
book is not a course in queuing theory, it's a book about the optimization
techniques and how to use queuing theory to actually predict the response time
and write SLA's. It's not written in the usual form for mathe
my point is that relative to 'execute immediate' how many people use
utl_tcp?
execute immediate isnt on the exam at all.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 2:04 PM
> I am using utl_tcp as we speak to send
1. create the new role
2. create script
spool /tmp/move_role.sql
select 'alter user ' || grantee || ' grant new_role;' from dba_users where
granted_role = 'OLD_ROLE'
host more /tmp/move_role.sql
--@/tmp/move_role
Sinardy
-Original Message-
Sent: 23 Octob
Thanks, Jack! Julian dates were mentioned here and I was just curious.
On 2003.10.22 21:09, [EMAIL PROTECTED] wrote:
The 15th of March.
>From http://www.infoplease.com/spot/ides1.html :
Kalends (1st day of the month)
Nones (the 7th day in March, May, July, and October; the 5th in the other
mont
Title: Re: Boolean dates...
...and just by way of trivia, the Latin word “kalends” is the only word in that language to start with the letter “K”...
on 10/22/03 6:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
The 15th of March.
From http://www.infoplease.com/spot/ides1.html :
Kalen
Yes ,Dennis.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 7:04 PM
> Sultan - Are you referring to the Oracle shared pool components that are
> identified as state objects? A quick Google also revealed that Java has
Dear all,
Is it possible to rename a role? If it can't be done, what is the best
approach to port all the users in the "old" role to the new "role"? Thanks
in advance.
Regards,
seth.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: setiady
INET: [EMAIL PROTECTED]
Title: Re: 10046 trace question
DBMS_SYSTEM.KSDWRT should do what you want. First parameter is a numeric value 1 or 2, second is a string. If 1, the string is written to a “.trc” file (which is what you want). If 2, then string is written to the alert log.
on 10/22/03 9:39 AM, Jamadagni, R
if someone wants to dig into the type of math you are using in your book in
more depth, what level of math expertise would you recommend? Do you have to
go beyond college level calculus ?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, Oc
No need to say yes(not a valid option either) as logging is default.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 22 Oct 2003 15:05:05 -0800
So how do I turn logging to YES on the index?
-Original Message-
Sent: Wednes
Waleed,
I agree with you as I moved a 5GB table last week with nologging option with
extent size 500M and did not see any normal redo generation for that. It is
8.1.7.0 database. that table has 8 indexes for total size of almost 3GB.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recip
the basics are they i want 'C' so i can use a file pointer. I need to do
some search and replace in a group of files. If I use straight scripting I
have to redirect the output to a new file and do a 'mv' to rename it back.
with the filepointer, I was hoping to be to use fopen in C to open the file
Dennis,
Thanks. In fact, I feel the same way about this as many of you who have
written about the book in the prior two days. I think the material that
ended up being Part II needed to be studied, refined, and documented.
And I believe it is important that this material be written in a BOOK
instea
> -Original Message-
> From: Mladen Gogala [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 23 October 2003 06:00
> To: Multiple recipients of list ORACLE-L
> Subject: Mauve databases use least RAM
>
>
> I just received "Effective Oracle by Design" and reading the foreword
> I noticed not only
Apologies not needed - I thought it was rather amusing actually!
It's easy to confuse Robert and I. We've worked closely together on a
number of books, and we're both equally cute! :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's mu
Microsoft?? A secret SQL Server developer? Address spoofing is a child play now-a-days
...
Raj
-Original Message-
Sent: Wednesday, October 22, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L
And with an email address like mine, who do you think I work for? :)
Pete
***
I have two favorite email signatures. One is used by Gary Dodge who is
commencing his 68th quarter at Oracle Corporation. It reads:
"Building tomorrow's legacy systems today, one crisis at a time..."
And the other is used by a gentleman named Gene Fosnight, formerly of Oracle
(now happily r
Maybe your memory is suffering. Wasn't it a 42? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Steve McClure
Sent: Thursday, October 23, 20
Wednesday, October 22, 2003, 5:09:35 PM, Niall wrote:
NL> Stephen Hawking in 'A Brief History of Time' writes "Someone
NL> told me that each equation I put in the book would halve the sales. I
NL> therefore resolved not to have any equations at all. In the end,
NL> however, I did put in one equatio
Hi Hemant,
If you purge 80% of rows from a table without intending to reinsert them
anytime soon, then yes, a table reorg would be a recommended step. No
arguments from me there ;)
I had lunch with Pete Sharman today and he mentioned that he sent an email
to the support person responsible for the
Hi Stephane,
If you're using a conventional file system on AIX, you can expect a
reduction in performance by moving to 16K from your already imperfect 8K.
See Steve Adam's notes why the DB block size should = the file system buffer
size (www.ixora.com).
And that's *4K* on AIX.
Cheers
Richard
-
-Original Message-
Sent: Thursday, 23 October 2003 01:39
To: Multiple recipients of list ORACLE-L
I think what your boss really means is 'julian' date.
Does he also want his database in mauve?
-
Nice Dilbert reference, Jared. One of my favourites ... stuck prominently on my wall
Alter table ...Move TS nologging
is 100% equivalent to CTAS and should generate minimal amount of logging
even if it ran serially (no PQ).
Actually the type of command is considered "CREATE TABLE"
So I'm not sure how the original poster was able to determine that the
operation generated huge
I apologize. I was somehow connecting you with TUSC and Robert Freeman. Not
that it's a bad thing, but I should have noticed.
On 2003.10.22 20:54, Pete Sharman wrote:
And with an email address like mine, who do you think I work for? :)
Pete
"Controlling developers is like herding cats."
Kevin
The 15th of March.
From http://www.infoplease.com/spot/ides1.html :
Kalends (1st day of the month)
Nones (the 7th day in March, May, July, and October; the 5th in the other months)
Ides (the 15th day in March, May, July, and October; the 13th in the other months
Jack C. Applewhite
Database
So now the blame rests solely on Richard for any material in the note that's
wrong. :)
Check the latest update:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab
ase_id=NOT&p_id=182699.1
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbo
On 2003.10.22 20:19, Michael Milligan wrote:
database "experts" who purport that the "relational" in RDBMS represents
relating tables.
Just for completeness, the definition of a relation is, quite literally, "a
subset of cartesian product". Set theory studies mostly relations of ordering
and equ
Mladen - I can think of far more reasons why an employee would NOT
participate on a public list than reasons why they would.
5. You can easily become the target of wrath for anyone that hates
Oracle.
4. The slightest misstatement on your part could easily be interpreted as
a lack of knowledg
And with an email address like mine, who do you think I work for? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Mladen Gogala
Sent: Thursda
but exporting the metadata just adds the necessary information to the data
dictionary. It doesn't touch the data file headers (or does it???).
Henry
-Original Message-
Rachel Carmichael
Sent: Wednesday, October 22, 2003 3:25 PM
To: Multiple recipients of list ORACLE-L
I didn't say you w
>If you gave me a quiz on relational algebra today, I'd probably flunk
>it, like many people that daily work with relational databases. But that
>doesn't stop us from making use of the fruits of the theory. Similarly, I
>don't think we need to understand Part II in detail to successfully use
>Cary'
Pete Sharman is also an Oracle employee. And I know of at least two
Oracle University instructors who are members, albeit not using their
Oracle email addresses.
There are several other Oracle employees on the list, some lurk because
they've joined using their Oracle email addresses and may be afr
So, what is the problem? There is detailed documentation about
how to set up PHP with oracle on Linux. One of the sites that I'd
check would definitely be
http://www.php.net/manual/en/install.apache2.php
What doesn't work? Apache? PHP? Oracle? What happens when you try
phpinfo? Did you check y
A quick look at the docs for 'alter index' will reveal all.
"Roger Xu" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/22/2003 04:05 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
Title: Message
I'm
not entirely sure what the problem with granting execute on dbms_system is here?
dbms_system.ksddt and dbms_system.ksdwrt seem to give exactly what you
wish?
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Dani
Great comment. I believe your analogy to relational theory to be very apt.
Back when we were all in junior high and our teachers were drawing those
Venn diagrams on the board, we were probably thinking "When will I ever use
this stuff?". Personally, I use it every day. What you said about relationa
Thanks Daniel,
I'd rather do that using Perl because this has to happen on both nodes of
RAC also I'd do this if it is the last option.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expresse
I am using utl_tcp as we speak to send feeds out to our customers ... encrypted of
course. We have a program that uses utl_http to go to espn.com, fetch data, filter
out what we need and use that to populate the database.
Yes, we do use it ... but I am not Oracle employee.
Raj
-
or use a Java stored procedure on Oracle, accessing pgsql via JDBC.
[EMAIL PROTECTED] wrote:
xml?
-Original Message-
Sent: Wednesday, October 22, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Oracle external procedures, accessing PostgreSQL would do the trick
without flat files
Jared's close. It's 2718 - BC -.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent:
Wednesday, October 22, 2003 3:24 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Boolean dates...
Jared,
If that's true there
When, exactly, were the Ides of March?
On 10/22/2003 04:59:25 PM, Stephane Faroult wrote:
Mladen Gogala wrote:
>
> Nope. It's the dates according to the format invented by Booleous
> Caesar.
Who was counting his days 'ab urbe condita' (753 BC), hence the 700
years shift.
> On 10/22/2003 12:24:30 P
"Quintin, Richard" wrote:
>
> fork() and exec() are what you're looking for. I haven't done it in a
> while, but you should be able to find plenty of info online.
>
> On Wed, 2003-10-22 at 11:44, [EMAIL PROTECTED] wrote:
> > The unix and C forums are pretty inactive. Hope its ok to ask this here
I guess that your review is fair (and balanced, of course). In my
review, I confessed the sin of having a math degree, so the perspective
is necessarily, different. I believe that it probably is hard for a
person equipped only with the high school math apparatus. To give
credit where it's due, I
Me thinks he meant 'Julian Dates' but this qualifies for interesting quotes
section in Dilbert newsletter though.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly p
Title: Setting environment variable in Perl script
I need some help with a perl script! I have a script that currently does batch compiles of forms and reports so I know it works. However, I need to have a version of it for compiling forms in French using the NLS_LANG=FRENCH_FRANCE.WE8ISO88
But now since you've discussed whats on the test, the oracle police will
come and confiscate your "certified" copy of your completion certificate.
bwahahahahaha
Joe
[EMAIL PROTECTED] wrote:
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it today and passed it.
Title: Message
Niall,
This is a very kind, and I believe (maybe
it’s only hopeful belief) a very accurate depiction of what the book is. I
have read Hawking’s note to which you refer. Honestly, I included the
formulas for two reasons:
1)
To communicate the
relationships of tr
How/where did you find this? I know older versions of Perl/DBI/DBD::Oracle
silently fail on login attempts, but we've had no problems with Java on
8.1.7.4/HPUX.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
>
I think Cary deserves a vote of appreciation for Part II of his book. I feel
(based on the comments of others, haven't waded through it myself yet) that
he has put Oracle performance tuning on a solid mathematical foundation.
My first education was engineering and I learned was that a practice
It's because there's more magic behind the scenes that does things like the
little endian big endian conversion. It's not transparent as you would need
it to be for a straight copy at the OS level to work.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no
So how do I turn logging to YES on the index?
-Original Message-
Sent: Wednesday, October 22, 2003 4:29 PM
To: Multiple recipients of list ORACLE-L
In addition to operations provided in Mladen's explanation, all partitioning
operations such as exchange/split.. partition, etc. do not gene
what is the microsoft,. sybase, and ibm database pricing?
anyone know the differences in prices?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 22, 2003 5:24 PM
> http://www.crn.com/sections/BreakingNews/dailyarchives.asp?Arti
Trace file size is not a problem ... the file system has 35GB ... the problem to be
able to put some kind of marker in the live trace file when a problem is experienced.
Raj
Rajendra dot Jamadagni at nospamespn dot c
user_col_comments, all_col_comments, dba_col_comments
regards
Jo
Bob Metelsky <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/22/2003 22:44
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:question o
You can attach comments to both tables and columns:
COMMENT ON TABLE mytable is 'My table comment';
COMMENT ON COLUMN mytable.mycolumn is 'My column comment';
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or enti
First
feedback is that it is not rac but a step up..
brian
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, October 20, 2003 6:34
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
anyone have opinions on the future of the
'grid'?Fro
Bob Metelsky wrote:
>
> All
> The powers that be have it in their minds that there is a place
> for comments on each "column" in a table. afaik.. comments are only
> associated with tables not columns
>
> Eg
> Select * from user_tab_comments;
>
> People here seem to think they can "docu
Title: RE: OT: How to call unix shell scripts from 'C'?
If it is just a simple script call use system("/home/me/myscript");
Be careful, your env vars might not be what you expect them to be.
-Original Message-
From: Quintin, Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October
Dammit!
I see now
select * from user_col_comments order by table_name;
-Original Message-
Sent: Wednesday, October 22, 2003 3:41 PM
To: '[EMAIL PROTECTED]'
All
The powers that be have it in their minds that there is a place
for comments on each "column" in a table. afaik.. com
Guys!...
Thanks a lot to all!
As usual... great list..., great answers!
I'm gonna check the suggestions... just that, doing a
select from that field (using Julian dates) shows the
dates about 500+ years into the future.
Anyway, most of your mails put light into this subject
to me.
Thanks a lo
I didn't say you wouldn't have to export the metadata, as you do in 8i
and 9i
--- Henry Poras <[EMAIL PROTECTED]> wrote:
> I don't see how this would work. You still have to move the physical
> data
> file to the new machine. What makes a transportable tablespace
> trasportable
> is that you
Hi:
I have another problem that I have been trying to solve. I have this query
that works perfectly in 8i, but does not work in 9i. The query is
-- not working in 9i but works in 8i:
select distinct arc.TermID, arc.ParentTermID
fromarc
connect by prior arc.Paren
Probably a Sybase DBA
-Original Message-
Sent: Wednesday, October 22, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just
took it today and passed it. I didnt study at all.
Id like to state that it is an incr
All
The powers that be have it in their minds that there is a place
for comments on each "column" in a table. afaik.. comments are only
associated with tables not columns
Eg
Select * from user_tab_comments;
People here seem to think they can "document" their columns by comments.
Maybe I
Thanks. It is working now after I made the change.
Guang
On Wed, 22 Oct 2003, Richard Foote wrote:
> I've just posted the answer to this question at the
> comp.databases.oracle.server newsgroup !!
>
> Here it is again.
>
> If you look closely at the execution plans, they're performing a BITMAP
>
Pete,
Thanks for the reference. I'm still a bit confused, however. If you can't
just copy a datafile between OS's because of the differences in the file
header formats, why can you copy datafiles between OS's when done as a
transportable tablespace?
Henry
-Original Message-
Pete Sharman
I think you have mentioned that once or twice. :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Mladen Gogala
Sent: Wednesday, October 22, 200
Jose,
In my experience - long ago - managing dates rarely involved Boolean logic,
which is Two Valued Logic, True or False. Instead, they involved MVL
(Multi-Valued Logic) with the most common return value being one of a
bewildering assortment of INDETERMINATE variations, followed by frequent
FA
Uh-oh. I'm sure Jeremiah is digging up some old
posts for cut and paste to avoid typing.
Here, I'll save him the trouble.
=
There are unknowns with every feature. ABORT is a feature just as
IMMEDIATE is. In version 7, I encountered a bug with IMMEDIATE that
requir
Java drivers seem to require US7ASCII.
I'd love to leave it alone.
"Goulet, Dick"
But I want to do it the other way round. No, there are no '?'s. The data
is all US7ASCII. Yes, you're right, the import was done into a database
with the wrong character set. I know about the export/import route but I
believe that there is some utility that will do the conversion from
WE8ISO8
You might try ALTER DATABASE CHARACTER SET internal_use us7ascii;
Make sure you know what you're doing. See Metalink Doc Id 100751.996
On Wed, 2003-10-22 at 15:29, Goulet, Dick wrote:
> Thomas,
>
> Well I can't help you on that score. I do remember a discussion on going from
> US7ACSII
In addition to operations provided in Mladen's explanation, all partitioning
operations such as exchange/split.. partition, etc. do not generate data
related redo for segments marked nologging.
HTH.
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Well, let me know when the shotgun goes off. I'll send the black lab out to find
you!! *-)
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, October 22, 2003 4:20 PM
To: Multiple recipients of list ORACLE-L
I found it. Trying to explain it tr
http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://w
Title: Message
I also am not Cary .I have however read Cary's book
from cover to cover (including spending rather too long on a romantic weekend in
paris with my wife contemplating a 10046 trace parsing project :(). I Am
rereading and intend to require my fellow DBAs and sysadmins to read
Mladen Gogala wrote:
>
> Nope. It's the dates according to the format invented by Booleous
> Caesar.
Who was counting his days 'ab urbe condita' (753 BC), hence the 700
years shift.
> On 10/22/2003 12:24:30 PM, [EMAIL PROTECTED] wrote:
> >
> > Are you sure he didn't mean Julian dates? Somewhere
That's because nologging attribute only affects the "direct"
operations, i.e. the the operations that prebuild blocks and add
them below the flood watermark. That includes sqlloader with direct=y,
inserts with /*+ append */ hint and CTAS. Normal SQL based operations
are not affected.
On 10/22
Yosi,
Missed that one, it makes sense now. The only thing
left is to know what date 728646 really means in the source
system.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Yosi Greenfield
[mailto:[EMAIL PROTECTED]Sent: Wednesday, October 2
> Hi Gurus,
>
> I have a couple of questions regarding "nologging".
>
> 1) alter table tabname move tablespace tbsname nologging;
>
>How come this sql still generated same amount of redo logs equal to the size of
> the table?
>
> 2) alter index idxname rebuild tablespace tbsname nologging;
Jacques - Thanks very much for looking that up. Since I learned something
new, I'll feel that the day was worthwhile, despite having to spend the day
doing a lot of . . . well, you get the idea. Thanks.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednes
I found it. Trying to explain it tripped those last few synapses. Not
sure if it should be shared since it can completely destroy your database.
But when you're certain about your data, it's a lifesaver.
Kids, don't try this at home -
Alter database character set INTERNAL_USE new_character_s
Raj,
I'm not speaking from experience, but why don't you start the trace the
same time you send the email. And maybe by limiting the size of the trace
file you don't have to worry about turning the trace off.
chaim
"Jamadagni, Rajendra" <[EMAIL PROTECTED]>@fatcity.com on
10/22/2003 03:44:34
Raj,
Could you create a stored proc/function that opens each of their
trace files, writes a line, then releases the file?
Daniel Fink
"Jamadagni, Rajendra" wrote:
Thanks
KG, I
think I wasn't very clear so here is version 1.1 ...BTW
this is all in a Oracle Forms custom application that we (deve
Pete,
I remember trying to read an 8.1.7.3 database on w2k (ntfs) from a Suse Linux 7.1 install (dual boot). In theory, it was supposed to work.
In practice, it hanged the system.
Rachel, someday, I'll get LILO on that box to default into windows so that you don't have to catch it during boot
This may clear it up:
select
to_char(sysdate,'j')
, to_char(to_date('06/05/2718','mm/dd/'),'j')
, to_char(to_date(2713944,'j'),'mm/dd/ bc')
, to_char(to_date(728464,'j'),'mm/dd/ bc')
from dual;
Jared
"Goulet, Dick" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
I just received "Effective Oracle by Design" and reading the foreword
I noticed not only the familiar names of Connor McDonald, Anjo Kolk and
Mogens Norgaard, but I also saw this list mentioned explicitly.
Is Mr. Tom Kyte a member of this list? Does he read it? Does his staff
read it? I was wanderi
Not I, never even seen the questions to tell you the truth. I believe
there's an email address you can raise exam issues with -
[EMAIL PROTECTED] You might want to send this to them to see if they
have more relevant feedback than I'd ever have on this exam.
Pete
"Controlling developers is like h
Rachel is in fact correct. See page 4 of the Self Managing Database paper
presented at OracleWorld
(https://www.oracleworld2003.com/published/40090/40090.doc).
Cloning from one OS to another simply doesn't work because the file header
formats are different between the different OS's. You can't j
Title: 10046 trace question
Thanks KG,
I think I wasn't very clear so here is version 1.1
...
BTW this is all in a Oracle Forms custom application that we (developed
and) use in-house
07:00am Johndoe logs in and his session automatically starts tracing
10046^8 through a login trigge
Actually, Oracle's implementation is a Julian date.
The YYDDD format is most definitely not a Julian date, though
many persist in calling it that.
Oracle is using what is called a 'Modified Julian Date'. A Julian
date actually begins at Noon on -4712, which is 4713 BC.
That ordinal vs. cardina
> -Original Message-
> DENNIS WILLIAMS
>
> I think this is very perceptive - Julian vs. Boolean. I just
> want to mention
> that what Oracle calls a Julian date is the number of days
> since Jan 1, 4712
> BC. As far as I know, that is exclusive to Oracle. Other
> systems define
> Julian
I don't think using abort = corruption potential.
If you have a cluster for high-availability, how can you afford to do
a weekly bounce and cold backup (decidedly low-availability
practices)? Why not leave it up and do online backups?
If you absolutely must have a cold backup, then the [checkpoi
Thomas,
Well I can't help you on that score. I do remember a discussion on going from
US7ACSII to WE8ISO8859P1. And if my memory servers me correctly that is a one way
trip. I believe you may well have to re-export the data & rebuild the database. Is
there a specific reason why you
1 - 100 of 171 matches
Mail list logo