Hi
We're using Merant odbc 3.60 without any problem.
Powermart on Solaris is using Merant ODBC 3.6 to
access data on SQL Server 6.5/NT 4
Boy do I like this forum, I just discover what is
hsodbc !
--- Ed Maurer [EMAIL PROTECTED] a crit:
Anyone succeeded in getting hsodbc working (8.1.x);
I
Hi DBAs,
We r using Oracle 8.1.6 . db.
I would like to disable all the constraints on the Tables available
under one schema.
Is there any single command to do this in 8i . Any DBMS package
available?
Any other suggestions for doing the same??
Thank You.
Arul.
--
Please see the official
I should think so!!! :)
-Original Message-
Sent: Friday, March 02, 2001 07:20
To: Multiple recipients of list ORACLE-L
test, sorry.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Belov Igor
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
In order to automatically start Oracle on NT, OracleServiceSID and
OracleStartSID must be started. They should be set to AUTOMATIC in
control panel, on NT.Now my case is that both those services are not
available or created. Now I read that I have to create those services.
e.g.
oradim80 -delete
Title: RE: Report Metalink Problems
I
complained via our Oracle Account Manager (we had to find out his name first!!!)
and I got a response within 6 hours from UK Metalink admitting the problems and
blaming it on an upsurge in demand.
This
begs all sorts of questions re capacity planning
Vivek !!
Oracle 7.3.4.5 on Solaris 2.6
DELAYED BLOCK CLEANOUT means what ? - Could you possibly Give some more
Detail ?
http://www.geocities.com/kgkrish/transactions.html
There is an animated detailed explanation about this in the
above link.. (Note that this has some errros. I have not
MALA,
in the export log (typial) this is the order.
exporting job queues
exporting refresh groups and children
exporting user history table
exporting default and system auditing options
Export terminated successfully without warnings.
What you have to do is after importing you have to
Dear list,
The load average figure shown in top,
does it represent average number of running jobs or running jobs + jobs ready to
be run. One of my machine had 4 CPU, sometimes the load average is 10, so I
guess the load average number is not just running jobs. Any ideal??
Kam
When I run loadjava specifying a jar file what exactly gets stored where in
the database?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
Hey Joe,
No need to worry.Is the database working now.You don't have to reset control
file..If you are in doubt create the control file again using
the famous ALTER DATABASE BACKUP CONTROL FILE TO TRACE; etc
But if you want to retrieve the database from cold back up you have taken
while the
Supposely they are loaded into a BLOB column in the CREATE$JAVA$LOB$TABLE.
The loadjava utility
loads the java files into the database in addition to creating
CREATE$JAVA$LOB$TABLE and
JAVA$CLASS$MD5$TABLE.
Rick
-Original Message-
From: John Dunn [SMTP:[EMAIL PROTECTED]]
Sent:
Rachel,
The "experts" tell us that the disease only affects certain animals but not
humans, even if you eat meat contaminated with disease. I'm not enlightened
enough one way or the other to become a vegetarian as a consequence %-|
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
-- the FK
select 'alter table '||table_name||' disable '||constraint_name||';'
from user_constraints
where constraint_type = 'R';
there is check constraints, primary key, and unique, but i'll not give
you the entire answer.
joe
Arul kumar wrote:
Hi DBAs,
We r using Oracle 8.1.6 . db.
Hang on to your wallets. Oracle announced that the latest returns would not meet
the market expectations. Real $.10 Market $.12 stock dropped to $17 and change
this morning.
Maybe it was a fallout from BILL C@$$##
ROR mm
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Title: RE: OEM 2.2. installation blues
Hi,
We
installed oem2.2 on NT with 256 MB RAM.
Installation went through well and did not face any problems. The packs installed Tuning, Change
Management, Diagnostics.
Rao
[EMAIL PROTECTED]
-Original
Message-
From: Vincent Ruger
Ha! I beat you. 9i ias for AIX comes on 4 CDs.
Jeff T
Thomson multimedia, Inc
-Original Message-
Sent: Thursday, March 01, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Everything but the kitchen sink.. 9iAS includes Apache, Forms Server,
Reports Server, Portal, DB
For the Oracle database to -run- the OracleServiceTEST (created with the
oradim80 command below) must be running, so I infer that you're missing the
OracleStartTEST service.
You can try:
oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile
PATH/initSID.ora
and that might create it,
Nick,
After several years of directly dealing with Oracle, we've decided to go
through a third party VAR to purchase software. The reason is the licensing
methods that they use. Seems what you need to be a mathematician, astrologer,
and soothsayer to figure it out. I've even had Oracle
Hello,
Some data warehousing questions:
We are considering a setup where we have two separate machines,
1 for doing the ETL (ExtractTransformLoad)processing, and 1 for
the production machine. Our env is Oracle 8.1.6 on Sun.
The main idea is to insulate the production machine from the effects
of
Chuan,
Are you restoringthe archived logfiles; cause you need thelogfiles untill completion of the HOT BACKUP to clone the database.
Shaibal
"Molina, Gerardo" [EMAIL PROTECTED] wrote:
are you using recover using backup controlfile until cancel?make sure that the alter database open statement
Linda,
Where did you get the CD's for the 9iAS? I tried the download method and "FileSplit"
them back together. No luck. WinZip reported the file was corrupt. I tried the
download method twice but still no luck. How long did you have to wait for the CD's to
arrive in smailmail? If you
Hi list,
I need to cron a job every day at 10pm except
sundays, how do I acomplish this ? I need the INTERVAL
field.
I also need to cron another job every day except
sundays an saturdays too, can you please help me with
this?
thanks in advance.
I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans. It causes death in humans and cannot be killed
by cooking at normal temperature.
Hoof and Mouth disease is not transferrable to humans and should not be
confused with the common human
OK Folks,
I got this in the old inbox this morning. Most likely it came from one of
the job search services like Monster.com. Funny how those services just can't
forget you. Anyway it is of no interest to me, I like the New England area and
am not interested in moving, but there may be
If you're not archiving anyway the NOLOGGING option on import and index creation
might help things go faster (esp. if it's all on the same drive). Don't turn it
on for the import if you're appending to existing data (unless you like living
dangerously) but for indexes it's a good option for
You must have gotten in there before the rest of the east coast came to work.
It's slow now!! Was pretty quick at 5AM EST yesterday too.
Dick Goulet
Reply Separator
Author: "Adams; Matthew (GEA; 088130)" [EMAIL PROTECTED]
Date: 3/2/2001 6:01 AM
On Fri, 2 Mar 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
-OK Folks,
-
-I got this in the old inbox this morning. Most likely it came from one of
-the job search services like Monster.com. Funny how those services just can't
-forget you. Anyway it is of no interest to
Actually, I got it also and just figured someone was scooping the list
membership.
Dan
-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L
OK Folks,
I got this in the old inbox this morning. Most likely it came from one
of
the job
Hi Patrice,
I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
telling me that it was the only freaking way to get iFS installed on the
same box...) on my P-III 800Mhz running Win2K ("WinTuke") with SP1 and 512MB
memory. You don't mention where your repository DB is,
Well, serial and parallel is much slower than ethernet. You have to look at
what the bottleneck is likely to be. I'm not an expert on SANs, but with
that much data, there might be advantages to separating out the storage from
the actual database engine. If you want a bunch of info on SANs,
Dick,
I received this mail personnaly this morning and hit
the delete key.
--- [EMAIL PROTECTED] a crit: OK Folks,
I got this in the old inbox this morning. Most
likely it came from one of
the job search services like Monster.com. Funny how
those services just can't
forget you.
I got this also and I have a feeling he may have sent it to names he found
on this list. If us New Englanders got it he must have sent it to a lot of
names.
Greg
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L
OK
I suffer greatly from foot in mouth disease. Usually, I open my mouth and
jam both feet in up to the ankle, but I digress.
The last I read about BSE was that it was coming under control with the
elimination of refeeding, but it will be a few years before we know for
sure. The number of human
Yeah, it was in my inbox as well...sounds like these people are mining this
mailing list for addresses.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple
I also got that email,
I told him thanks for the thought but as I am in the UK the commuting alone
would probably kill me.
-Original Message-
Sent: 02 March 2001 14:32
To: Multiple recipients of list ORACLE-L
OK Folks,
I got this in the old inbox this morning. Most likely it
Hi Dick,
I got this message too. Hey, I'd like to ask you a question personal. Do you
have dba position open in your company?
I live in Andover. I can't stand this company anymore. I just start to
looking for.
Thanks,
Joan
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 02,
It you want great corn feed beef (the reason for mad
cow is how they feed their livestock) visit the Omaha
Steaks web page.
The US should never have any of these problems. We
feed our cattle with grains such as corn. We should
not have a problem with hoof and mouth because we
vaccinate our
I'm trying to install Oracle Enterprise server 8.1.6.0 onto our AIX 4.3.3 64-bit
IBM server.
I'm getting a problem during the link phase. I make sure we have 2x the swap
space as main memory. The Oracle techrep told me to run
$ORACLE_HOME/bin/genclntsh64. I did this but still get the same
I was SPAMMED by this LUSER, too.
It appears that he harvested addresses from this list.
If you deem this behavior to be unacceptable, you might
want to consider sending Richard Fischer, the president
of his employer a complaint [[EMAIL PROTECTED]].
FWIW - This SPAM is illegal in the state of
Hi Friends
The error is
2001-03-02[11:27:20]sfkecper: *** S T A R T of Log message ***
2001-03-02[11:27:20]sfkecper: Log message called from
/port.6.1b.05.01/vobs/tt/l
ib/al_1/al_strm.c: #495 keyword: strm
2001-03-02[11:27:20]sfkecper: Pid 107992 Uid 508 Euid 508 Gid 125 Egid 125
use 1-6 for every day except Sunday and
1-5 for every day except Saturday and Sunday.
Days in cron are labelled 0-6, starting with Sunday, respectively.
i.e.,
00 17 * * 1-6 /opt/oracle/admin/scripts/
00 17 * * 1-5 /opt/oracle/admin/scripts/
--Scott Shafer
San Antonio, TX
-Original
See Reply below
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 02 Mar 2001 06:51:05 -0800
Hi list,
I need to cron a job every day at 10pm except
sundays, how do I acomplish this ? I need the INTERVAL
field.
--
00 22 * * 1-6 file_name
Foot in Mouth disease? LOL..
-Original Message-
Gramolini
Sent: Friday, March 02, 2001 02:07
To: Multiple recipients of list ORACLE-L
I don't think that the experts are telling anyone that Mad Cow Disease is
not transferrable to humans. It causes death in humans and cannot be killed
Well then! To the list, my apologies. The original came direct, no CC or BCC's
included. Does look like we all got spammed. Again my apologies.
Dick Goulet
Reply Separator
Author: "Charlie Mengler" [EMAIL PROTECTED]
Date: 3/2/2001 7:56 AM
I was
Man, and I thought I was the only one who got it:-) I don't
feel its to much different then the dumb Bill Law ones except
he cost himself a lot more work instead of just sending to
one address. I am sure he has plenty of e-mail himself this
morning.
-Original Message-
Sent: Friday,
Yeah, I got it as well, I have a feeling everyone got it. Is our list under
attack by outside resources?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 10:56 AM
Hi Dick,
I got this message too. Hey, I'd like to ask you a
Jackson and Don,
I like Don's idea. I think it is strange though, I only have one more
question. How is the database started and stopped? Can you only use
svrmgl? I would have to go with Don's idea, if this is a 24/7 database I am
afraid it would have to be recycled. I would think that
Dennis,
I'm sitting in the middle of the East Coast dot bomb area. I know of three
dot bombs that paid a total of $100 million between them for Oracle licenses.
Now that the dot com sugar daddy has been licked clean maybe reality will
strike!!
Dick Goulet
Reply
I got that one too. and I've never signed up for Monster. And if I had,
I would NEVER have used this email address for it, I reserve this address
exclusively for this list. I think someone/something managed to skim the
mailing list (perhaps by signing up for the list and extracting the
Martin,
I replied privately to one of your colleagues as I sure would not mind the
commute to the UK. Spent 4 years there at RAF Mildenhall. Loved it.
Dick Goulet
Reply Separator
Author: Martin Kendall [EMAIL PROTECTED]
Date: 3/2/2001 8:40 AM
I used to buy Omaha steaks, but our home raised is even better than that.
RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 10:56 AM
It you want great corn feed beef (the reason for mad
cow is how they feed their
I doubt it, Oracle will say that their profit margins are too low so they will up
their licence costs for everyone else. Larry can you spell greed.
[EMAIL PROTECTED] 03/02/01 12:35PM
Dennis,
I'm sitting in the middle of the East Coast dot bomb area. I know of three
dot bombs that paid a
Thanks for the help everyone. The Oracle techrep solved the problem. He asked
me to do
lslpp -l all |grep libm
after this he saw that we did not have the math library installed.
thanks all,
..tom
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday,
Hey listers,
Does anyone know of a way to remove files from an O/S file system using
PL/SQL without calling a java or an external C routine?
Thanks,
Alan
Alan Aschenbrenner
Oracle DBA
IHS Group
(303)-858-6394
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
Hi Bill,
Is 200GB the total size of the database? If so,
have you considered only loading "new" data into
production?
Paul
--- Bill Becker [EMAIL PROTECTED] wrote:
Hello,
Some data warehousing questions:
We are considering a setup where we have two
separate machines,
1 for doing
$4.50 a pound plus shipping and I will send them overnight, just like Omaha
Steaks.
;-) Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March 02, 2001 2:16 PM
Talk is cheap Ruth!!! Put up or shut up!!!
I like mine medium rare by
I've actually got two copies of the CDs. S'pose the other set'll make nice
coasters. The first set came pretty fast from customer service, 3 or 4
business days. It was a rush order because we needed it before the demo
that Oracle sales was coming to do for us. The second copy I got from our
Hi folks,
I'll be working on a project pretty soon where I will have to use
Excalibur. The goals are:
- integrating the contents of my database with the company-wide running
Excalibur. Questions: How good is Intermedia at sucking content from Oracle
schemas? Is there a required format for
Hi All,
Anyone have a clue? Seen it before?
Completed checkpoint up to RBA [0x20f.2.10], SCN: 0x.00665693
Thu Feb 22 13:16:16 2001
Errors in file /home/oracle/SCQQQI/bdump/pmon_47776_scqqqi.trc:
ORA-00600: internal error code, arguments: [kssdys 2: bad ch], [0],
[807311928], [0],
Hi!
Create a function:
create or replace
function all_days_except_sat_sun (iDate IN date)
return date
is
oDate date;
begin
select decode (
Here's my code
update copy_rec_out_test
set
(copy_rec_out_test.sirsi_949m,
copy_rec_out_test.sirsi_949l,
copy_rec_out_test.sirsi_949k,
copy_rec_out_test.sirsi_949t,
copy_rec_out_test.sirsi_949x,
copy_rec_out_test.sirsi_949z)
=
select
Good suggestion, but 'host' only works within SQLPLUS (unless I am
mistaken). Any other ideas?
Alan
-Original Message-
Sent: Friday, March 02, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
How about the host command. This will shell out to the os and process the
command.
We're struggling with iAS/ iFS now with a similar box (only it's a leftover quad 400,
2GB mem from an appserver upgrade), could you elaborate on the "TWICE" part?
"Jesse, Rich" wrote:
Hi Patrice,
I've successfully installed OEM 2.2 *TWICE* (thanks to Oracle Support for
telling me that it
Last time I danced with our sales rep, power units were per server, not per
user... so the power unit price would be 400*100 = 40,000 for an unlimited (Ha!
at 200mhz?) number of users. If you ask nicely, yours may agree to convert any
concurrent or named user licenses you have into power unit
I've actually had a couple other requests to expound upon that, so here
'tis:
Nope, iFS is not working fine, which is why I've shut it down. I've got
8.1.7 on order (should have been here days ago!) for a couple of other
platforms, so I'll be able to move the database off of my machine, and
Sure.
use utl_file utility.
Write to a file , that another process reads, have it execute the command.
Minor security hole but, it will work. Need to make parse strings so nothing
'bad' gets written to the file.
Or
Have a process, read a table that has files to be deleted ( we use this in
Ok anyone seen this error.
here is the scenario:
dev box - firewall - internet - prod db server
on the prod db server, protocol.ora is enabled to screen only legit ip
addys.
connect from dev box w/sqlplus and get a 12537 error,
solaris, 8.1.5 on both dev and prod.
PC attempted also, 8.1.5
Yes, I have worked a while with Intermedia and I find it very easy to use and
very awful to administer. Its tight integration with Oracle is its main beauty
of course.
This as was a typo, I meant to ask: How good is Excalibur at sucking content
from Oracle schemas? Is there a required format for
Oracle's Procedure Builder has a basic debugger, and you probably already
have it if you use Forms and Reports.
-Original Message-
From: Venugopalan Nair C.N Nair [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 4:46 PM
To: Multiple recipients of list ORACLE-L
Subject: PL/SQL
Title: .trc file management
Has anyone written and is willing to share a shell which would:
find the list of .trc files, tkprof the files to output files, grep the output files for the total line and email the file of total lines?
And
find the current .trc files and rm the ones older
My $.02:
There are two ways (that I know of):
1. The long way: create different jobs for each day like:
INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''MONDAY'') + 22/24'
INTERVAL = 'NEXT_DAY(TRUNC(SYSDATE),''TUESDAY'') + 22/24'
2. Create another stored procedure and submit it as a job (Note I
Hi,
I am a beginner DBA could you tell me
what is the diffrent:
create user /tablespace or else using
svrmgrl
and sys account
oh ya.. I'm using Oracle8i
Thank you very much
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Hii all,
im a real newbie trying to learn 'bout Pro*c, i've installed the Oracle 8.1.6
on Linux Redhat 6.2. But when i do : proc iname=select.pc oname=select.c or
$ make -f demo_proc.mk build OBJS=select.o EXE=select
it gives me a message : segmentation fault (core dump)
does anyone here ever
Hiii all,
i'm a real newbie using Pro*C, but i find it hard to precompile because i always
get a message : "segmentation fault (core dump)" when i try to precompile samples
shipped with Oracle. I'm using Oracle 8.1.6 on RedHat 6.2, egcs ver 2.91-66
is it 'bout memory or environment ...?
if
Hi,
Anyone have idea, how Oracle8i make used of multiple rollback segments to
reduce system contention?
I am currently using 4 rollback segments what will happen if 3 of them are
offline?
:(
Thanxs,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET:
Hi u can try the bulk binding feature of Oracle 8i, U can reduce a lot of time in
inserts update and delete.
--
On Thu, 01 Mar 2001 21:41:03
Ranganath K wrote:
Dear DBA Gurus
I am using Oracle 8.1.6 Work group server on Sun Solaris 2.8.
I want to increase the number of inserts
halo all,
i'm a newbie trying to start learnig about oracle
programming
problem is.i don't where to start :(
enlighten pse...
...azmi...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: u.-azmi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
77 matches
Mail list logo