The suit was over their derivative use of the phrase Windows. Seems
Microsoft thinks only they can use the word.
I seem to recall the suit was thrown out, but I could be wrong.
The last I heared from this case is judge ordering to
investigate whether window is still a ditinctive
word in
My guess will be that PHYRDS is the count of start i/o's. Each start i/o
read mutilblock_read_count blocks from the disk.
The data buffer that you read with each start i/o is the same: 8 blocks of
8k or 16 blocks of 4k. So you get the same number of start i/o's.
Yechiel Adar
Mehish
- Original
Tim, thanks thats pretty much what I do everytime someone asks.
joe
Tim Gorman wrote:
Life is too short to try to remember stuff like this...
SQL create table x (y number(9,2));
Table created.
SQL insert into x values (9.99);
insert into x values
On Tue, Nov 12, 2002 at 01:50:52PM -0800, Boris Dali wrote:
I guess disk explanation is the most logical one to
assume, but I've no idea how to confirm and overcome
it. As I mentioned I re-installed it in different
combinations multiple times. Would this file always go
the same place on disk
see silly stuff like that, my mind traps. Important stuff, like where
the bar is, my mind loses :)
stuff like that is what REFERENCE manuals are for... a place in which
to look up the answer to the life's too short to remember questions
geez, if anyone gave me a SQL test on an interview, I'd
Title: sqlplus ~no~output
To do it in a command file -
@sfsfasdf.sql.
Set termout off does not work for commands executed from
the command line.
Yechiel AdarMehish
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Old news Gene. MS lost the lawsuit.
Jared
On Tuesday 12 November 2002 11:57, Gene Sais wrote:
Not here but looking into http://www.lindows.com on a personal nature.
Also read MS is suing them, not sure how much longer they will be around.
[EMAIL PROTECTED] 11/12/02 02:03PM
Has anyone
Oh, thank you! That clears everything up.
Jared
On Monday 11 November 2002 16:28, Lyndon Tiu wrote:
Linux Rulz!!!
On Monday 11 November 2002 03:13 pm, [EMAIL PROTECTED] wrote:
Dear List,
Believe me, I am not trying to rehash an old topic, start any
flame wars, nor look for
Stephen,
I don't disagree with any of this, but you have to understand
that managers do not care about the same things we do.
Bottom line: what's it going to cost? What's the ROI?
Those are not easy things to answer.
Thanks,
Jared
On Monday 11 November 2002 18:58, Stephen Lee wrote:
Yes, use DBMS_LOB and UTL_FILE.
UTL_FILE has a 32k line length limit, so you will be required
to output to multiple lines for CLOB's 32k.
If you don't have any restrictions on how this is done, use
Perl, Java or C instead, and avoid the UTL_FILE limitations.
Jared
On Tuesday 12 November
Decimal point is implied the number would physically look like
12345678999.
-Original Message-
Sent: Tuesday, November 12, 2002 8:14 PM
To: Multiple recipients of list ORACLE-L
Totally off Oracle topic.
I am studying the mainframe layout specs for a flat file, and came
across this
Thanks for the link Jared.
For now, I just bookmarker it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 3:23 PM
Check out OraC, written in Perl of course. :)
http://www.tux.org/orac-dba/
Thanks everyone!!! Sorry for the OT post.
-Original Message-
Sent: Wednesday, November 13, 2002 8:29 AM
To: Multiple recipients of list ORACLE-L
Decimal point is implied the number would physically look like
12345678999.
-Original Message-
Sent: Tuesday, November 12, 2002 8:14
According to my Perf Tuning instructor from 08/2000, the index efficiency
table looked like this:
Oracle Version v5 v6 v7 v8.0 v8.1.6
Rows Returned 20% 15% 8% 4% 9.9%
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Thank you all, lots of excellent suggestions and ideas.
I'm currently involved in a 2 day offsite IT 'event', and won't
be able to digest all this till tomorrow though.
I'll let you all know what happens.Assuming we get
our budget approved, that is.
Jared
On Monday 11 November 2002 15:13,
We recently upgraded our Oracle server from NT to 2000. I have a batch
script that runs SQLPLUS that no longer works.
Like a good DBA I always included ORACLE_HOME and ORACLE_SID set command in
each script. Now the script woll only run if I remove the ORACLE_HOME and
ORACLE_SID set commands.
H...that's an interesting stance.
You won't trust Linux, but you'll trust Perl?
So why not rewrite Linux in Perl? :)
So you trust SAP on buggy/swiss cheese W2K?
-Original Message-
Sent: Wednesday, November 13, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L
Lyndon,
I
Dan,
Actually, there is an index on the objid within the subselect. Here is the
actually query with the results of the tkprof:
SELECT ObjId, ActionCode, RequestNumber, AbcDigits, DefDigits, SoClli, NodalSource,
StatusCode, ReplacedRequestNumber, TransactionId, Domain,
I would like to suggest Robert Freeman's book Oracle9i RMAN Backup
Recovery
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
Hisbn=0072226625
It has a chapter on Veritas, as well as how to backup to disk.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
Thank you Dennis, I was just going to do that. :)
It covers Net Backup as well as RMAN.
Jared
On Wednesday 13 November 2002 06:08, DENNIS WILLIAMS wrote:
I would like to suggest Robert Freeman's book Oracle9i RMAN Backup
Recovery
THANKS Stephane.
Cool stuff... But I don't like lot's of lines of code so I just went ahead
and did it in Python. Here's some code for the curious:
---
#!/usr/bin/env python
file=login.py Purpose: present a login form.
import cgi,
You're right .. but when will it become ready? MS always said their NT3.5 is
enterprise eady, they said NT4.0 is enterprise ready, W2K is enterprise
ready, .Net is enterprise ready. It's all in the marketing. If enough people
like me say Linux is ready, then it becomes ready. Readiness is
Ron,
Did you re-install Oracle after you upgraded to Win2k? I use ORACLE_HOME
and ORACLE_SID in all by Win2k scripts and it works fine.
Maybe the path got screwed up? What error do you get exactly?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday,
Whether their colleagues are using it too... if it's in use elsewhere, then
probably it is less of a risk.
At least they can justify the decision by pointing at how many other people
are doing it to.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent:
Jared,
Here's my recollection of a losing battle. I hope this helps.
I used to work on Unix (AIX and Solaris) and can only think about the good
ol' days...
Now, I work on Comcrap Servers (i mean HP) running Microslop NT and 2000.
We have tons of them :)
I asked my boss why they are using Windows
All
Ive finally returned to my desk from the server room/user
desktop trenches ;-)
with hopefully some time to pose this autostarting problem to the list.
I have about 12 oracle database(services) running on windows 2k server,
I believe by starting the service should start the instance
I heard in Oracle Week in Israel that Oracle is planing to add Linux to
their supported products and provide help desk for it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 4:48 PM
You're right ..
I'm ready.
-Original Message-
Sent: Wednesday, November 13, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
You're right .. but when will it become ready? MS always said their NT3.5 is
enterprise eady, they said NT4.0 is enterprise ready, W2K is enterprise
ready, .Net is
Title: How-To or Good Practices on Code Releases
Friends ...
I have a (sort of) problem ... what are the best practices to manage code releases to production environment ...
currently we get a bunch of scripts from development team, and we release code to production on the schedule
That is the problem with free stuff. There isn't a big expensive hype
machine around to push it.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 13, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L
You're right .. but
Hi
How to make search fast? We are building some application and this
application need to build more efficient fast search.
WIth regards
-Seema
_
Protect your PC - get McAfee.com VirusScan Online
Hi
How to make search fast? We are building some application and this
application need to build more efficient fast search.
WIth regards
-Dinesh
_
Add photos to your messages with MSN 8. Get 2 months FREE*.
Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 5:18 PM
All
Ive finally returned to my desk from the
undocumented parameter:
_search_fast = TRUE :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 10:38 AM
Hi
How to make search fast? We are building some application and
Title: How-To or Good Practices on Code Releases
Whenever I install a new release of software my
boss wants to know:
How do you return to the old version if this does not
work?
For each install script require an undo
script.
We are using toad to compare schemas and it can also
generate
Seema Ji,
Are U using Oracle Search for this purpose?
Are u using search indexes and using them
correctly?
What version of Oracle?
Regards.
OraCop
--- Seema Singh [EMAIL PROTECTED] wrote:
Hi
How to make search fast? We are building some
application and this
application need to
FTLP show sga
Total System Global Area 1.8088E+10 bytes
Fixed Size 103396 bytes
Variable Size 907014144 bytes
Database Buffers 1.7180E+10 bytes
Redo Buffers1064960 bytes
Hm . Maybe we'll hold off on that Linux stuff for a little while
longer.
(NOTE: I don't write the
Title: How-To or Good Practices on Code Releases
TOAD _until now_ had problems with 9.2 database ... it would complain
that (in our case) 903 objects were not found when I could go in, and perform
all kind of DML on those objects.
7.4 seems to be better ...
Raj
Have a look at the strtsid.cmd script which is used for starting the
instance/DB inside %ORACLE_HOME%\DATABASE.
This file does exist for version 8 on NT, not sure about higher versions on
Win2K.
Regards
Naveen
-Original Message-
Sent: Wednesday, November 13, 2002 8:49 PM
To: Multiple
Bob:
Let's try the simple solution first. How about using the Services utility
in Control Panel to check the service for startup =AUTO. Then specify
the parameters that are
to be used for startup, like pfile=xx. Specify the userid that is
supposed to start the database, preferably not the
The releases should be tried in the Development environment first. Then a
UAT (User Acceptance Test) environment, then production. The UAT
environment is usually a duplicate of the production environment. This is
the environment that you implement the changes , then test to see if the
changes
Title: RE: SERACH FAST
Intermedia comes to my mind ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have
Igor,
That was the 8i syntax, I believe it is changed for 9i to be more
flexible:
_search = FAST|MODERATE|SLOW|BCHR99%
;)
-Original Message-
Sent: Wednesday, November 13, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
undocumented parameter:
_search_fast = TRUE
Hi List,
I have a question regarding check_point_interval. In my setting
log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 , I findout
in the tuning manual which I have to change thelog_checkpoint_interval =
999 but nothing regarding the log_checkpoint_timeout, when I change the
I don't understand.
I could easily configure Oracle on Solaris to show this same output.
Your Oracle on Linux is probably misconfigured. You probably don't know how to
work Linux?
--
Lyndon Tiu
Quoting Stephen Lee [EMAIL PROTECTED]:
FTLP show sga
Total System Global Area 1.8088E+10
Seema - Can you be more specific about what you are searching for? Column
data? Can you index it? Text within columns? Basically faster search is what
all of we DBAs strive for, but you must use different techniques in
different situations.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL
This is for FDA regulation compliance. The audit
records need to show every change made to the
source table in order of change.
WHile audit the table will show who changed the
record, it won't show what was changed.
Steve
--- Yechiel Adar [EMAIL PROTECTED] wrote:
In my browsing of the oracle
18 Gig SGA.
And there are two other (smaller) databases on this box.
-Original Message-
I don't understand.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
And have a similarly tested and signed off rollback strategy in place. An
immediate rollback, as well as a rollback strategy after n number of days.
Raj
One attachment (0k)
Title: How-To or Good Practices on Code Releases
Are you working with UTF8?
They had some problems in the initial release but they are
corrected now.
Yechiel AdarMehish
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent:
Qs What would be the FASTEST way to Load ALL Data from a Source Database
Existing in 7.3.4 into an Empty Target Database in 8.1.7.4 ?
NOTE - Creation Fresh (NEW) Database is a Must because Some of the
Data Dictionary Objects have got Corrupted the Standard Migration of
the Same Oracle 7
Since we are in the medical records business, we too have the same
guideline. What we do, is create an exact table replica (we call it an
archive table and it does not have constraints) to which before every insert
and update on the primary table, sends the row data to the archive table. It
stores
Oracle 8.1.6,
From: OraCop [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: SERACH FAST
Date: Wed, 13 Nov 2002 08:15:19 -0800
Seema Ji,
Are U using Oracle Search for this purpose?
Are u using search indexes and
Steven - If you need this level of detail, have you considered LogMiner?
Just a thought.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, November 13, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
This is for FDA regulation
Raj - Can you provide more details? Is this an automated script, or just a
line on the form that says that you have some idea of how to rollback the
change in case anything goes wrong?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
Vivek - If it is critical, I would test each alternative on a small amount
of data. I have had pretty good results from the data link. Depending on the
number of CPUs, you can run multiple imports or multiple data links
simultaneously. Also watch your disk storage conflicts. For example, you
What's wrong with having 18GB SGA. It's never enough anyways so it's good to
have more.
Besides, Linux uses a flat memory system (I think) in that it fools application
into thinking Linux got GBs of physical memory when in fact most of it is
available as SWAP.
--
Lyndon Tiu
Quoting Stephen
Hamid - Which parameter to use depends on your Oracle version. If it is 9i,
use FAST_START_MTTR_TARGET. In 8i, use LOG_CHECKPOINT_TIMEOUT. Did your
tuning manual explain why you should set it to 999? That seems a little
strange. Basically shorter checkpoint queue lengths will shorten your
Hi,
Seema - Can you be more specific about what you are searching for? Column
data?
:soME CASES YES
Can you index it?
:Yes I did.
Text within columns?
:yes
Thx
-Seema
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
No matter how you do it, do it in parallel.
Export and import, or CTAS, by schema or tables so you can run them in
parallel.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 7:03 PM
Qs What would be
Actually, SYSTEM is one of the only tablespaces I like to have it set on.
While I originally set it to autoextend when I was doing an upgrade I left
it active on the grounds that while I know how to recover if by some chance
one of my datafiles runs out of space, I'm uncertain as to the
We call them Journal tables.
Great technique.
OraCop
--- Lisa R. Clary [EMAIL PROTECTED] wrote:
Since we are in the medical records business, we too
have the same
guideline. What we do, is create an exact table
replica (we call it an
archive table and it does not have constraints) to
which
U can use Oracle intermedia/Oracle Text/Ultra
search.
what kind of data Ur performing this search on.
What is the datatype of the data?
How exactly U r trying to search right now?
U need to gather all this information?
OraCop
--- Seema Singh [EMAIL PROTECTED] wrote:
Oracle 8.1.6,
We have journal tables that mimic every table in our database. Every
Insert, Update or Delete (we allow user deletes) gets the row written to
the journal table along with a timestamp and the Oracle userid. Now we
have to tie one Oracle userid to one and only one user.
Hi everybody
We have a 8.1.7 running on SuSE Linux 7.2. Remote connections other as as
sysdba or as sysoper hang.
I can connect locally (via TCP/IP or IPC) with no problem. Whenever I try to
connect from a different machine,
I get to see the potential ;) session in v$session. The process also
What about foreign keys, functions, procedures, synonyms, roles, grants and
triggers (if any)? I've used the db link and it's faster than imp/exp but
it doesn't do anything for other database objects. Also, if you do have
foreign keys then a certain amount of pre-planning is necessary to move
As an example, something that yours truly was involved with, and still have
the scars to show for it. A migration from a lower version of Oracle, to a
higher version, on a completely new server. The scripts ran fine, and the
implementation plan worked fine. However, the application started
Make sure that
remote_login_passwordfile=share
and did you select
v$pwfile_users,
did you see sys there?
-Original Message-
Sent: Wednesday, November 13, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L
Hi everybody
We have a 8.1.7 running on SuSE Linux 7.2. Remote connections
Tracy,
Lots of luck! We use SourceSafe religiously for the developers. Care to
guess what happens way too often? Change control is more of a philosophy than a
software package. Proving the worth of the mindset change is easy. Getting it
practiced is hard! :(
Dick Goulet
Jim,
Right on, good speakers with a decent Oracle idea to talk about.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED] (Jim Hawkins)
Date: 11/13/2002 10:24 AM
You're right...I should have modified my list to include just good speakers as
Run your script at 23:58 :-)
Yechiel AdarMehish
- Original Message -
From:
Barbara
Baker
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 13, 2002 8:24
PM
Subject: OT ksh day of week
yesterday
Will someone take pity on this poor VMS'er
Hello,
What are the major differences between AIX and Solaris regarding
operating system features?
We are planning a new machine purchase; currently we are on a Sun machine
running Solaris, but IBM is making a strong proposal to management
(meaning significantly less cost), and we are wondering
What about foreign keys, functions, procedures, synonyms, roles, grants
and
triggers (if any)? I've used the db link and it's faster than imp/exp but
it doesn't do anything for other database objects. Also, if you do have
foreign keys then a certain amount of pre-planning is necessary to
Title: OT: Getting data out of DB2...any DB2 DBAs out there?
Off topic post, please delete if not interested.
I am trying to get data out of a DB2 database that I do not have access to. The original spec called for me to create a flat file, which they parse, and query the DB2 DB to get
Bill;
I came from a shop that ran AIX servers and Oracle 7.3.4 to 8.1.7. As for
the OS and Oracle, all our 7.3.4 scripts worked just fine when we were under
8.1.7 we used the k-shell exclusively as well. I do not think you have
any problems there.
As for AIX in particular . I loved
A week or so ago I posted WRT having problems printing a report directly to
a printer from 9iAS R2.
I've been battling Oracle ever since to get this BUG resolved.
AFAIK, the bug exists for at least Solaris, AIX HP.
Since I only have been working with Solaris for the last 6+ years, I might
yesterday=$(TZ=EST26EDT date +%a)
On Wed, 13 Nov 2002, Barbara Baker wrote:
Will someone take pity on this poor VMS'er lost in a unix world??
I'm trying to create a script (ksh) that reads a log file created yesterday. The
log files are created with `date +%a` appended to the end of the
Why would there be problems with SCN numbers?
-Original Message-
From: [EMAIL PROTECTED] [mailto:timboles;citynet.net]
Sent: Tuesday, November 12, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle daylight saving
Oracle also uses an internal time that is
Title: RE: Oracle 10i features
No,
installing 9iAS is a 250 mph breeze. One definition of a tornado
is
"a
very strong breeze".
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 13,
2002 8:03 AMTo: Multiple recipients of list
That is exactly what my design would be given the
option. Thanks for concurring.
I have also been asked if the trigger can fire
off a pop-up box in the app to ask for a reason
for change that needs to be in the audit record
as well. Yeah, really... that's what they want.
Another option
Hello Listers,
This might be a very newbie-type question but I would like to know how I
can replicate a schema in the same instance under a different schema
name, of course - same data, etc.
Thanks for your help.
Saira Somani
IT Support/Analyst
Hospital Logistics Inc.
--
Please see the
From a DBA standpoint, the differences would be minimal. In the past, I
experienced very slight differences in some scripting syntax; usually
related to complex regular expressions for pattern matching. Even though
system administration is different for the platforms, HP, Sun, and IBM did a
-n2 to get two copies for HP-UX
-#2 yields:
lp: illegal option -- #
-Original Message-
Sent: Wednesday, November 13, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
A week or so ago I posted WRT having problems printing a report directly to
a printer from 9iAS R2.
We are on AIX servers here and they are very reliable. I
came from and HP shop and nothing beats that for reliability but the cost is too
steep for a state agency.
Ruth
- Original Message -
From:
Kevin Lange
To: Multiple recipients of list ORACLE-L
Sent: Wednesday,
I also have been burnt by an simple alter table add column default string
script. A pretty simple script. The developers tested it, the QA team too
approved it. Was expected to run in a matter of minutes. The problem was
the data in production was 100 times over. Missed out on volume testing.
Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.
This is windows 2k server service pack 3
Have a look at the strtsid.cmd script which is used for
starting the instance/DB inside %ORACLE_HOME%\DATABASE.
That must be a personal custom script.
Ive
We would, of course, pick up all travel expenses,
From how far :-) ?
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
My TZ is EST5EDT and I think the 5 implies GMT-05:00
What does the 26 in EST26EDT imply?
Just curious.
Ed
-Original Message-
Sent: Wednesday, November 13, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
yesterday=$(TZ=EST26EDT date +%a)
On Wed, 13 Nov 2002, Barbara Baker wrote:
Barbara Baker wrote:
Will someone take pity on this poor VMS'er lost in a unix world??
I'm trying to create a script (ksh) that reads a log file created
yesterday. The log files are created with `date +%a` appended to the
end of the log file name. Last night a log file was created called
We had an aix
box and ended sending it back and going with sun - only because we had a hitachi
san and there seems to be a bug between ibm and hitachi - something about depth
queue. [EMAIL PROTECTED] 11/13/02 12:48PM
Hello,What are the major differences between AIX and
Solaris
DDL does *not* belong in the developers hands.
DDL scripts should *not* be accepted from developers. this is what DBA's
are for. DBA's should be responsible for the health and well-being of
database tables. if a table needs DDL transactions applied, a request needs
to be sent to the DBA who is
same thing. time offset. This may not work on all systems because of how
TZ is used.
On Wed, 13 Nov 2002, Sherman, Edward wrote:
My TZ is EST5EDT and I think the 5 implies GMT-05:00
What does the 26 in EST26EDT imply?
Just curious.
Ed
-Original Message-
Sent: Wednesday, November
I used to use SPUFI (SP?) with TSO/MVS but that was many years ago. I
would hope that there's something better.
Grabowy,
what do you think about um export the squema a and after this
import using fromuser=squema a touser=squema b
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 5:44 PM
Hello Listers,
This might be a very newbie-type
Barb,
Try this:
#!/bin/ksh
#
# set up arrys of day strings, offset by one from real day
#
set -A days Fri Sat Sun Mon Tues Wed Thurs
#
# determine today's day of week index
#
index=$(date '+%u')
#
# Use index to get previous days abbreviation
#
echo ${days[$index]}
#
grep STRING
Thats Utopia for us. Production DBAs have no access to Development and QA
and Test boxes. The application developers code for everything, they test
it, send it to QA, who perform the implementation on the QA databases. We
only review the scripts, after it has been approved by QA, and do some
Bill - You may want to check with your system administrators. My
understanding is that the two systems are pretty much identical from the
user standpoint, but that AIX is quite a bit difference from the sys admin's
point of view. It may make a difference, depending on your sys admin's
background,
Stephen,
Good idea. Whilst your at it you might want to consider moving your swap
onto tape or CD/RW... Both formats have a better $/GB that disk, and
surely no-one will notice the performance difference?
Divide the 39GB between all the desktops in the office (so yu can run the
latest games)
Beside Oracle, we have db2 mainframe and db2 udb on
aix.
I've asked asomeone working with DB2 mainframe and
there is spufi which is like sqlplus and DB2
Interactive wich is more like the command center on
db2 udb.
I'll more details tomorrow.
--- Thomas Day [EMAIL PROTECTED] a écrit :
I
Raj - Been there, run over by that. We are tending to move to a 3-stage
implementation process - testing, staging, and production. The staging
system will hold full production volume.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
1 - 100 of 133 matches
Mail list logo