Hi.
Just curious to know if anyone out there has had any performance problems
with Oracle on a Sun E450 server before?
Our database is a dog at the moment compared to the same spec database
running on a Sun Ultra 10.
Any info would be appreciated.
Thanks
Clint
--
Please see the official
Dear all,
Could anybody suggest how to data transfer from Sybase to ORACLE
apart from converting to a text file and then use loader, without any
extra cost.
regards,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: tapas dutta
INET: [EMAIL PROTECTED]
Fat City
I'm currently testing the heterogeous services between
Oracle 816/Solaris and SQL Server 6.5.
We're using Merant ODBC driver which was bundled with
Informatica Powermart.
I'm able to read a table without problem in SQL Server
from Oracle.
My goal is to be able to execute a stored proc on SQL
tapas dutta wrote:
Dear all,
Could anybody suggest how to data transfer from Sybase to ORACLE
apart from converting to a text file and then use loader, without any
extra cost.
You can try wiht Infomaker application, wich have an element called
PIPELINES. Ive onle used it to transfer
Hi,
what information does the PASSWORD column in the DBA_USERS view provide.
I know that it's the encrypted user password, but how can I actually use
it ?
For example: Can I reassign a password to a user via his encrypted
password ?
or: Can I test a logon with another user's encrpyted user
Hi,
I want to find out what roles are currently enabled for users logged on. The
users are logging into Oracle from an application using a Web front end
which issues 'set role ...' for them.
I know about default_role in dba_role_privs which shows what roles are set
by default at logon. Also
http://www.swynk.com/faq/sql/sqlfaq_connectivity.asp#NonMS
Checkout the above link from the SQL Server FAQ which lists some options for
talking to SQL6.5/7 from UNIX boxes. Best best probably is to get hold of
some Sybase Open Client drivers as these should still work with MSSQL.
Ade
Hi!
I'm sorry if my question is somewhat irrelevant to the list...
My team has a project concerning Information / e-commerce portal and are
doing a study of application servers and portal frameworks. One of the
solutions we have in mind is Oracle 9iAS with Oracle PDK.
Has anybody got experience
Hi,
You can try http://www.uaex.edu/srea/
This is a script for you to login as other user without using their
password, basically that script change the whatever user password to
something else and start login with that new password and change it back
when you done what ever you do.
User can
Do you have any further details on this? Links to a web site perhaps? I
Would be interested in getting an Access to Oracle link set up so that I can
quickly generate some test data. Anybody else know a quick and (if it has to
be) dirty way of getting Access data through to Oracle?
At the moment
You are making your life so difficult... :)
As of Oracle 8.16, Oracle provides you with a free gateway to ODBC
datasources - you can easily access Excel just as though it was an Oracle
table. Why bother with all the transfers and all that? If you still need the
table as a native Oracle table,
Hi ,
I'd be grateful for the link to the web for this product !.
ta
Michael.
Sent: 30 March 2001 10:10
To: Multiple recipients of list ORACLE-L
Subject:Re: Data exchange between ORACLE SYBASE
tapas dutta wrote:
Dear all,
Could anybody suggest how to data transfer
session_roles
--- "Wilkes, Steve" [EMAIL PROTECTED] wrote:
Hi,
I want to find out what roles are currently enabled
for users logged on. The
users are logging into Oracle from an application
using a Web front end
which issues 'set role ...' for them.
I know about default_role in
Hi,
I have a table A with two identical, integer, nullable columns col1 and
col2, both of which are indexed.
The table A has 100,000 rows and takes up 11,000 blocks.
The indexes on the two columns take about 225 leaf blocks each with
BLevel=1.
The optimizer goal is set
Hello list,
Yesterday I had a problem with my computer, and I had to repair my
NT installation, and I lost all the data stored in the registers ( NT services).
As I dont have the services installed, I cant start/stop
them from NT services.
When I try to start the listener from the command
Clinton
I have run databases on E450s which outperform comparable E3X00 servers. I
would therefore believe that the fault is with your set up, SUN or Oracle.
You say the same spec but can you clarify eg no of connections, data volumes
etc
Allan
From: Clinton Naude [EMAIL PROTECTED]
Just get the Oracle Transparent Gateway for Sybase
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 10:46 AM
Dear all,
Could anybody suggest how to data transfer from Sybase to ORACLE
apart from converting to a
FWIW, I had a client who experienced occasional performance problems on an E450. It
looked like a disk bottleneck, but it was really a memory problem. A process with
high I/O activity overloaded the swap area. Adding a couple of gig of memory helped a
lot.
[EMAIL PROTECTED] 03/30/01
Hi,
I don't want it to count the rows with col1 as null. When I specify
col1=col2, I am implicitly saying that they are both non-null and equal to
each other.
regards,
ram
-Original Message-
Sent: Friday, March 30, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L
Well, how
search ORACLE-L "viewing concurrent enabled roles"
set ORACLE-L repro
status ORACLE-L
LISTS
INDEX ORACLE-L
END
=
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or
You are truly a goddess. Thanks!!!
Rachel Carmichael wrote:
Here goes..
Shortbread cookies
Ingredients:
1 pound sweet butter
1.5 cups sugar
2 egg yolks
5 cups flour
1. Cream butter until soft and smooth. Gradually beat in sugar until light
and fluffy. beat in egg
Hallo,
Can anyone tell me how to get sqlloader, how can I try and find out to see if I
have it already installed ?
How do i Install it?
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Last time I went to the ECO site, it looked closed. Are they still around?
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 29 Mar 2001 10:16:14
Jefferson, Dean wrote:
Check the IOUG-A sessions again. The presenters from Oracle were added
later, after IOUG and Oracle Corp. reached a new
Where exactly can I RTFM about this then?
I take it that I can make Oracle "think" that an Excel spreadsheet is a
table, and do a simple create table excel_table as select...?
Cheers
Mark
-Original Message-
Nissim
Sent: Friday, March 30, 2001 12:26
To: Multiple recipients of list
On Fri, 30 Mar 2001,Chuck Hamilton scribbled on the wall in glitter crayon:
-The problem with doing it that way is that 7.3.3 is no longer available
-for AIX (or any other platform for that matter), and that's what we're
-running on IRIX. My thought was that if you're able to open 7.3.3 files
The problem with doing it that way is that 7.3.3 is no longer available for AIX (or any other platform for that matter), and that's what we're running on IRIX. My thought was that if you're able to open 7.3.3 files with an 8.1.7 instance all on the same box, and if the file formats are compatible
No, but just a select can end up "snapshot too old"
(or update/delete because these includes a select).
The updates/deletes of the other transactions may lead to this,
because the select can't get a consistent view from rollback segs,
when the needed data is overwritten by another transaction.
Get to a command prompt and type sqlldr this will bring you in to the
SQL*Loader command prompt, then type help.
HTH
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 30, 2001 02:31
To: Multiple recipients of list ORACLE-L
Hallo,
Can anyone tell me how to get sqlloader,
Good question, which is best: IOUG or OpenWorld b/c most cheap companies don't pay for
both?
I never went to OpenWorld, but been to IOUG and the presentations from TUSC were some
of the best.
Any opinions out there?
[EMAIL PROTECTED] 03/30/01 08:21AM
Last time I went to the ECO site, it
Hi,
it comes already with Oracle.
Just try sqlldr at the command line.
You can actually find it in Oracle's bin directory.
For a manual, see the Oracle Utilities Guide, it explains SQL Loader,
Export and Import.
[EMAIL PROTECTED] schrieb:
Hallo,
Can anyone tell me how to get sqlloader,
hi all ,
He faced some hardware problem few days back. We started the system
from other server with its own
operting system (unix - but higher version) . after coping orcle related files to the
new OS hardisk we were able to
start up the oracle (7.1.3) database also. But the end
If it is already installed, it should be in your $ORACLE_HOME/bin directory.
The executable is named sqlldr.
Michael Armstead
Database Administrator, OCP-Certified
Corporate Finance Information Systems
Glaxo SmithKline
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL
Lisa,
No we did not. It's still there. It's a ridiculous design
but it was there when I got here and it's not going
away anytime soon.
Cherie Machler
Gelco Information Network
"Koivu, Lisa" [EMAIL PROTECTED] on 03/29/2001 06:58:20 PM
To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED],
Well YOU might be saying that, but is ORACLE understanding that...
Try adding two where clauses( and col1 is not null and col2 is not null )
and see what happens.
[EMAIL PROTECTED] 03/30/01 08:10AM
Hi,
I don't want it to count the rows with col1 as null. When I specify
col1=col2, I am
I think you can also check your oracle_home/bin directory and search for
sqlldr*.exe
Rick
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 9:02 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: sqlloader
Get to a command
Hi,
take a look at the documentation for Oracle Gateway.
If you are on an NT box, the part of Oracle Gateway that gives you
access to com sources like Excel is for free and comes with your Oracle
Server.
You just have to set it up ;)
But the manual is pretty clear.
Mark Leith schrieb:
Is "true" tablespace point-in-time recovery a feature of Oracle 8.1.6.x?
By "true" I mean that it is NOT the concept they brought forward with
7.3.x
where you recover datafiles to another instance; roll that forward and
then export the data
back to the original instance.
Does RMAN somehow
Hi Chuck,
Do you happen to have (or can get) 7.3.4 on AIX? If the IRIX files can be
used on AIX, then you could just run the cat7304 sql to bring the db to
7.3.4 level and them perform the migration to 8i.
I don't think migration to 8i (via Migration utility) is possible without
doing the prep
Cheers
Mark
-Original Message-
Jahnke
Sent: Friday, March 30, 2001 03:51
To: Multiple recipients of list ORACLE-L
Hi,
take a look at the documentation for Oracle Gateway.
If you are on an NT box, the part of Oracle Gateway that gives you
access to com sources like Excel is for free
Title: RE: -- OS user process parameter problem
Wow.
Did you really say 7.1.3? I think that came out in 1991, about ten years ago.
(Not that anyone would want to rush into a version upgrade before it is fully tested and all, but)
-Original Message-
From: chandan
OK, appologies for so openly showing my ignorance, but what does the acronym
ECO, as used in this thread, stand for? I have a feeling it has nothing to
do with Ecology, which is what I'll get a ton of hits on if I try to find it
with a search engine.
As to the comparison of IOUG-A Live! vs.
Hey all,
Is there anyway to see which tables users are accessing at certain point in
time?
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Taking a stab in the dark here..
When you say the users are not able to see all values, are they actually
able to connect to the database?
You say that you copied all files over to a new machine, then go on to say
that you have not changed anything, am I clear in saying that you have not
Hi,
If the OS in Unix, check the user .cshrc file
you are logging in
It should contain the Oracle HOME and other privileges for exec
the /oracle/bin directory.
S.S
[EMAIL PROTECTED] 03/30/01 08:31AM
Hallo,
Can anyone tell me how to get sqlloader, how can I try and find out to see if I
Hi Wendy,
Here's an example from a PL/SQL procedure:
inputFromDate := startMonth||'/'||startDay||'/'||startYear;
The '/' is a delimiter, if you don't want one just use:
inputFromDate := startMonth||startDay||startYear;
The individual data elements in this case were user input
TGIF..
We are gathering costs to move from Oracle's 10.7 character
version of the apps to there new 11i version. Does anyone know if there
are any white papers or sizing matrix on how to size your box(s) for
the new 11i environment. I am having trouble finding any info and
Oracle is being
The ECO conference is no more
From: "The Oracle DBA" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle training vs IOUG-A vs ECO
Date: Fri, 30 Mar 2001 05:21:01 -0800
Last time I went to the ECO site, it looked closed.
Eman,
I have the DBA set of TBT's. So far I have managed to almost complete the
SQL, PL/SQL portion. I have found the information provided to be fairly
thorough thus far. My only complaint is with the progress tests that
accompany each set of lessons. The answers that you provide must
Hello list,
Im working wiht NT 4.0 , and Oracle 8.1.6.
I need urgently information about the commands available from the MSDOS
command line. I have seen some information about some of them, but not
the ones Im interested in. Im trying to stablish / erase the Listener
Database NT proceses (related
Yustiono,
I'm a little confused. You don't have anything here that would incline me
to have more than one instance/database. Further, IF your going to be doing a
lot of linking of tables having more than one instance would cause complications
since a database link would be involved which
Michael McGinty wrote:
Hi ,
I'd be grateful for the
link to the web for this product !.
You can find Further information on Infomaker at the
sybase web www.sybase.com.
There is a pdf document at http://www.sybase.com/detail/1,3693,100,00.html
ta
Michael.
Sent: 30 March 2001 10:10
To:
Try
select s.USERNAME,
s.OSUSER,
s.SID,
a.OWNER,
a.OBJECT,
a.TYPE
from sys.v_$session s, sys.v_$access a
wheres.SID = a.SID
and s.USERNAME not in ('SYS','SYSTEM')
and a.OWNER not in ('SYS','SYSTEM')
order by s.USERNAME, a.OBJECT,
I'm not sure this will get you what you're needing, but to get a list of
MSDOS commands, type 'help' (without quotes) at a command prompt.
David
-Original Message-
Martinez Jimenez
Sent: Friday, March 30, 2001 9:22 AM
To: Multiple recipients of list ORACLE-L
Hello list,
Im working
Thank you very much Ana, that is a very useful littel scripts.
Kevin
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, March 30, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Try
select s.USERNAME,
s.OSUSER,
s.SID,
a.OWNER,
a.OBJECT,
Title: RE: SQL Server basic sources of info?
I think Mladen and Joe both have alot of respect
for the platform, and I am sure you'll see them
chime in here with bunches of info. Any minute now.
Guys?
-Original Message-
From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Title: RE: Users accessing tables
Dammit
Smitthers!! I had never heard of that view, guess I should have guessed it
existed. thanks Ross
kev
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent:
Friday, March 30, 2001 11:06 AMTo:
Pallav,
There is very explicit documentation for upgrading from 8.0.x to 8.1.x in
the Migration Guide of the 8.1.7 server documentation set. You can
see that documentation at technet.oracle.com. You need to be a
registered user to login to that site but it's free to become registered
and it
Wow. Another former Alpha 4 user. The first db I built was on dBase IV right after it
was released. After I worked with that for awhile as developer and dba, I learned
what the r in rdbms meant when the requirements changed causing a bunch of formulas to
need extensive rewrite. Soon after
Eman,
My first Oracle dba job the only training I got was the CBT's from Oracle for version
7. I thought they were great, but I like to work my way through cbt's. One
frustrating thing was that I found upwards of a dozen errors in the tests. I took
screen prints of a bunch of them and
Same here, I am the dba for an informix db. I just ignore it and hope it goes away :)
[EMAIL PROTECTED] 03/30/01 12:05PM
Oh its not that bad. I am "responsible" for 5 SQL Server databases
here and I just ignore them. All is fine.
-Original Message-
Sent: Friday, March 30, 2001 8:36
Kevin,
One other way, other than using V$ACCESS would be to turn auditing on and
then you could have the history for any point in time from SYS.AUD$.
Dick Goulet
Reply Separator
Author: "Kevin Kostyszyn" [EMAIL PROTECTED]
Date: 3/30/2001 7:35
Title: RE: SQL Server basic sources of info?
Michael Stonebreaker, one of THE seminal thinkers
in relational database theory, is also one of the
key players at Informix.
There might be some wheat to winnow from the chaff.
||-Original Message-
||From: Gene Sais [mailto:[EMAIL
I just took a look at amazon, and for some reason all of his books are
currently out of print. They are worth the effort to track down. The best of
the bunch are:
The Breads of FranceRecipes from all regions of France. It includes
everything from Bagels to bread shaped like wheat stalks, to a
Jeff,
Thanks here too. After a charring I took recently on another mailing list I
need some refresher training.
Dick Goulet
Reply Separator
Author: Jeffery Stevenson [EMAIL PROTECTED]
Date: 3/30/2001 10:14 AM
[Books]
Microsoft SQL Server 7.0
Chaim,
Check out the sqlldr case studies on OTN. Ross has the right idea with
the NULLIF. Here's a general description from OTN:
Loading All-Blank Fields
Totally blank fields for numeric or DATE fields cause the record to be
rejected. To load one of these fields as null, use the
You might want to look into the 'defaultif' option in the control file.
Prakash
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 12:27 PM
To: Multiple recipients of list ORACLE-L
Maybe some could help me.
I'm having trouble trying to load a csv file with
LISTS
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nancy McCormick
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Guys, I think it would be interesting to get together. Maybe in the evening
in the restaurant. Or somewhere else - like in one of Oracle buildings. Any
ideas?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat
Gurus,
I wanted some inputs on Revealnet knowledge base.If anyone is using this,i
want to how
useful has it been.
Are there any other tools that I can look in.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: [EMAIL
Title: RE: RevealNet
RevealNet good. Useful, yes.
Yes, there are other tools. Many.
www.google.com
:)
||-Original Message-
||From: Ravindra Basavaraja [mailto:[EMAIL PROTECTED]]
||Sent: Friday, March 30, 2001 2:56 PM
||To: Multiple recipients of list ORACLE-L
||Subject:
Ravindra Basavaraja wrote:
Gurus,
I wanted some inputs on Revealnet knowledge base.If anyone is using this,i
want to how
useful has it been.
i use it and like it.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
Alex, this is the 21st century (I think). Guys, like sir, is a generic term
covering pretty much every gender in the human race. You don't have to
apologize.
I mean, didn't you see _Starship Troopers_? That show was a powerful and
poignant statement on equality of the sexes. Very moving.
Of
I work in DC near Union Station. Support *brew place.
Alex Hillman
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 3:36 PM
To: Multiple recipients of list ORACLE-L
Subject:meeting of list
Title: RE: meeting of list participants working in DC area
Walt,
I, too, was deeply moved by Denise Richards in her
role as one of the guys.
Ross
||-Original Message-
||From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
||Sent: Friday, March 30, 2001 4:50 PM
||To: Multiple
I think that use of "guys" may be more of an Americanism. At least, my
wife and I had our British BB host in stitches when we were visiting the UK
a couple of years ago and we used the term that way. For the next hour or
so, he was walking around saying "hi, guys" and startling his other
Chaim,
Along these lines, can't you disable the not null constraint, load the
data, update the table/columns (UPDATE MY_TABLE SET THIS_COLUMN = 0
WHERE THIS COLUMN IS NULL) then re-enable the constraints?
David
Ron Rogers wrote:
Chaim,
If on the other hand the BLANK will not work properly
On Thu, 29 Mar 2001, Vadim Gorbounov wrote:
Hi Bill,
You may check www.merant.com. This will cost something, but as far as I know
there is no free ODBC drivers on Solaris.
rgds
vadim gorbounov
Oracle DBA
There are open source unix ODBC drivers available at:
www.unixodbc.org
Rather than increase the sort area size for everyone I need to alter the
sort area size for the session but how do I do this for the session over
the database link?
Any help is appreciated, Dave Turner
--
And you thought
okay, someone remind me when I get back :)
From: "Ruth Gramolini" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: why is short bread "short"? / Re: OT -- Friday Recipe was: Or
Date: Fri, 30 Mar 2001 12:30:23 -0800
Rachel,
Wendy,
If I understood you correctly,
You need to create a cursor, then scan it in a loop and have column(s) of
each row concatenated to a variable. The variable I feel has to be a
varchar2 with enough size to hold the data of all the rows.
Just curious, apparently this does not seem to be a
But if the data volume is huge, something around 15,00,000 rows, it fails
-Original Message-
From: Sergio Boix Moriano [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 2:40 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Data exchange between ORACLE SYBASE
81 matches
Mail list logo