-- Forwarded Message --
Date: Fri, 04 May 2001 11:18:51 +0530
To: [EMAIL PROTECTED]
Hi,
We are in the process of migrating our NT based Oracle applications to Unix.
Sun Solaris was the choice. We have also many applications written in Pro*C
in NT. We want to migrate those
Hi,
Ever tried to export a let's say 50Gb database, let alone import it again??
I'd say the export utility should only be used to recover an accidentally
dropped/corrupted table and datafile backup (either hot, or if you have the
luxury, cold) is the way for backup Recovery of entire
Hi,
Setting the sort_area_size to something so big it sounds silly may actually
improve some querries dramatically. I don't see why it should degrade
performance if you have the physical memory to spare.
We had a batch job that took about 60 hours but had to be tuned so it
fitted in the 4
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
David,
I support what you say about
When I create tables with primary keys, Oracle gives the indexes a default
name.
Can I rename these indexes with meaningful names, or do I need to drop and
recreate my tables, amending create table statements to explicitly name the
indexes?
John
--
Please see the official ORACLE-L FAQ:
We actually distribute SQLExpert in the UK market place - and it really is a
hell of a tool - no marketing jargon! What it will do is take your SQL (you
can free format, harvest from source binary/forms/text files, online
(SQLArea), S.C.L.D files, and COBOL) then, it will rewrite as many
Patrice,
That's a hell of a write up! I knew the background to the SQLServer product,
but not in so much detail!
I also have a write up on the Ashton Tate/Microsoft/Sybase relationship, to
give a little more info on the early days:
Back then the PC database Market was dominated by Ashton
Hi, Sinha
indexing = for easy searching something like building table of content in
your book
sorting = you know SORT
hasing = using sort of formula for search particular item, there will be
hashing algorithm here
Have a nice day
Sinardy
-Original Message-
Sent: Friday, 4 May 2001
Hi,
For Oracle related information
1) You could go through PART V Database security of Oracle 8i
Administrator's guide .
2) You could refer to Oracle Security by O'REILLY Publications.
HTH
shreepad
To: [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc:
Are you sure the public synonym isn't pointing to an object in some other database
thru a link?
[EMAIL PROTECTED] 05/03/01 04:55PM
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER
I just downloaded patch 8.1.7.1.2 from metalink -
in the readme (yes I actually read it before installing ) it states that
the earliest version that this patch may be applied to is
8.1.7.1.1 - I can't find this patch on metalink
anybody know where I can get it?
. .-.. .--. .. ...- .
..or that the public synonym is really pointing at the object you think it is?
[EMAIL PROTECTED] 05/03/01 04:55PM
Why do I keep getting this error even though this object is not a view??? I am in as
the owner of the table, which has the DBA role to boot.
SQL show user
USER is FARS_OWNER
I think most of us here will prefer Oracle
Sinardy
-Original Message-
Sent: Friday, 4 May 2001 1:37 AM
To: Multiple recipients of list ORACLE-L
Probably this has been posed million times, but I
really like to know. We'll have a meeting about this
in our company, and I'd love to
Title: RE: rename indexes
-Original Message-
From: John Dunn [mailto:[EMAIL PROTECTED]]
When I create tables with primary keys, Oracle gives the
indexes a default name.
Can I rename these indexes with meaningful names, or do I
need to drop and
recreate my tables, amending
SELECT machine_name, login, Count(login) AS CountOfLogin
FROM login_history
WHERE ROWNUM 4
group by machine_name, login
order by count(login) desc;
[EMAIL PROTECTED] 05/04/01 01:25PM
Q: how can you specify with a select statement how many rows are given as a
result? I would only like to get
Don't forget breaking up common industry design standards like incompatible
data requirements for Kerberos implementations and the use of the latest COM+
for all IPC -- you know -- the ones that require you to buy and run Microsoft
products ;-).
David Messer wrote:
Sounds like MS is afraid
Here is Linus's response
http://web.siliconvalley.com/content/sv/2001/05/03/opinion/dgillmor/weblog/t
orvalds.htm
a good read ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
What's your version of Oracle? I usually have a stock answer on how to
solve this type of problem, but I just tried out your problem on my little
Personal Oracle here, and to my INCREDIBLE surprise, the trigger worked and
I didn't get an error. Does anyone know if that's just because I'm using
For me it's more a question of performance than
fragmentation.
At my last client (www.houra.fr), the images were
store at the OS level to speed up the showing of the
web pages and in Oracle so that each managers could
associate comments to the images.
--- David A. Barbour [EMAIL PROTECTED] a
Why would 0racle even consider the public synonym? I thought this might be a
materialized view, but I would expect to see an
undefined object type.
Ian MacGregor
-Original Message-
Sent: Friday, May 04, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L
Are you sure the public
I've scoured the docs and found nothing. My situation is this:
How do I set up a constraint on a table, where I want a unique combination
of fields, only when one of them equals a certain value?
For instance:
Col1 Col2
--
N 1 = OK
N 0 = OK
N
Financial services company in Lansing, Michigan is looking for a jr-mid
level Oracle
DBA to join its I.T. staff.
Only candidates in Michigan or closeby states will be considered.
This is a full time staff position, so no contractors or third parties please.
Requirements:
- Degree in C.S. or
-
4) NEWS: Clouds Over Oracle
-
Oracle's executive vice president of North American
sales, George Roberts, said at a technology conference in
San Francisco recently that the sales
UNTESTED, PLEASE VERIFY BEFORE USE:
---original message follows---
D a t e : Fri, 11 Jul 1997 14:41:53 +0100
R e p l y - T o : ORACLE database mailing list. [EMAIL PROTECTED]
F r o m : Jones, David (Oxford) [EMAIL PROTECTED]
S u b j e c t : Can i write a query for this.
This
where rownum 4
Sunil Nookala
Dell corp
Austin, TX
-Original Message-
Sent: Friday, May 04, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Q: how can you specify with a select statement how many rows are given as a
result? I would only like to get the first three lines.
Hi all,
We'll have a meeting about the following issue:
Due to large amount of transactions each trainee has,
the existing training database in Sybase used multiple
databases to handle each trainee's transactions. To
implement this in Oracle, we may need to create
multiple schemas in one
Mutating simply means you're trying to access the
table that you're trigger is currently firing on (in a
row level trigger).
The basic workaround is typically...
before-statement-level
- initialise a PL/SQL table
before-row-level
- store information you need in the PL/SQL table, eg
rowid's of
I am configuring multithreaded server configuration of
an WIN2000 Advanced server with Oracle 8i Rel3 EE.
All the parameter are set accurately and checked the
MTS configuration through loopback and see connection
entries in v$circuit accordinglybut when we
connect through some other PC it
Check the size of the archive log which it complains on primary.I have seen situation when the log has transmitted partially and the recovery comes to a standstill.
After getting all the archives properly, run a
recover automatic standby database;
then try to put it in managed recovery mode.
Couldn't you just drop and rebuild the index with a new name?
-Original Message-
Sent: Friday, May 04, 2001 11:12 AM
To: Multiple recipients of list ORACLE-L
When I create tables with primary keys, Oracle gives the indexes a default
name.
Can I rename these indexes with meaningful
You should use table level check constraint. See docs.
Alex Hiilman
-Original Message-
Sent: Friday, May 04, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L
I've scoured the docs and found nothing. My situation is this:
How do I set up a constraint on a table, where I want a
You
wouldn't trigger long discussions :-) if you mention thatremoval
ofservices is done deleting these services from registry from
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and from
HKEY_LOCAL_MACHINE\SYSTEM\ControlSetxxx\Services
Alex
Hillman
-Original Message-From:
Jenny,
Just to make sure we are on the same page, when I was talking about web
deployed, I was talking strictly internal networks, lan, wan, etc using the
web forms approach.
Anyway, I don't know that you should nervous based on just my comments
alone. It is kind of interesting, though, that no
Jared,
Thanks for taking the time to reply. I don't know if they are working on any
contingency plans, but, I guess they could stay on OAS and Forms 5.0 if
things don't stabilize. I'm hoping that it is just a little configuration
issue here, a tweak there, and so on. We will see -- they don't
34 matches
Mail list logo