Hi,
Create {public} database link LINK
connect to remote_db_username identified by remote_db_username_password
using
'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_link';
There may be some issues with global name settings that may force you to
name the database link
Hi,
In SQL*Plus set long 250
Jack
Mark Liggayu
Hi saurabh,
There are two types of database links.
Explict database link the syntax is :-
CREATE DATABASE LINK db link name
CONNECT USING user_name identified by passwd
USING connect_string;
Default database link the syntax is :-
CREATE DATABASE LINK db link name
CONNECT USING current_user
USING
Creating db link is pretty easy. This can be done
easily by reading the documentation.
On the other hand, think carefully to what you want to
do. What do you want to access and who will access it.
I've seen many clients not knowing who was accessing
what because they have grant everything to
Hi Raja,
There are two ways people do this - personally, I keep an archive of all
Lyris mail through Look-Out archiving off any mail that is older than 3
days old, every day to a Personal File on my HD.
If I have a specific question, I *usually* (not always :) try to import any
mail from the
Hi,
I' hav to build up foolowing matrix
DB Size ..
Operating system
NT
Sun Solaris
AIX
...
Has anyone a similar matrix to share?
Especially I'm interested in the size for NT.
I know there was a saying - put no database larger than 1 GB on a NT
machine.
Is this still
thanks a lot..
one more thing...how to get the value of return key using sql..
i mean using gui data is entered and the user used enter key for next line
so how to get that
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes.
list,
i cannot spare a separate drive for the redologs,
can i place the online logs with the same drive as
the solaris + oracle engine ?
(m,y solaris and oralce are also on the same drive)
TIA
Rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Can anyone tell me how to unsubscribe from this list?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
thanks a lot.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 1:20 PM
Hi,
Create {public} database link LINK
connect to
It was also reported by the SANS institute
--29 June 2001 Oracle8i Database Buffer Overflow Vulnerability
Security experts found and disclosed a pair of vulnerabilities in the
standard and enterprise editions of Oracle8i database. The Transport
Network Substrate (TNS) Listener has a buffer
Hi all,
I'm a fan of having the processing done by a user
different than the owner of the data.
Am I alone ?
For example, we're on a datawarehouse system where the
data owner is DWH. The etl tool repository owner is
TOOL_POWERMART and the reporting tool repository owner
is TOOL_BOWEBI. The etl
Stephane,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original
test
Best Regards
Sinardy
***
CONFIDENTIALITY CAUTION
This message and its attachments (Message) are intended only for the use
of the individual or entity to whom it is addressed,
Mark,
You could write a plsql by defiining a variable with 32K (like
fetch_log_valuevarchar2(32760))
You could fetch the long data type column value into fetch_long_value
variable after opening the cursor. After that you can use substr on this
variable.
Baskar
-Original Message-
Hi,
Regarding the issue of databases larger than 1GB on NT, could someone please
explain this to me, as I was not aware of this 'saying'.
Thanks in advance,
Steven H.
-Original Message-
Antje
Sent: 05 July 2001 10:51
To: Multiple recipients of list ORACLE-L
Hi,
I' hav to build up
Hi,
Is it possible to save the Bitmap Reports output in .txt or .pdf or .doc
like files, if its so pls tell me how to do it.
Thank you so much
Regards
GSK
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Senthil Ganapathi
INET: [EMAIL PROTECTED]
Fat City Network
Stephane,
I'm sure they would prefer to operate as the schema owner but to me it's sloppy
practice.
You're right; create the objects as DWH and grant the necessary permissions to
the application users.
That way only the schema owner has 'admin' rights (create, drop, alter etc.).
If they can't
Roland
You can find this information, right at the end of your email:
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
off course
-Original Message-
Sent: Thursday, 5 July 2001 5:16 PM
To: Multiple recipients of list ORACLE-L
list,
i cannot spare a separate drive for the redologs,
can i place the online logs with the same drive as
the solaris + oracle engine ?
(m,y solaris and oralce are also
i try to play by the same rule as you.
but if i can't then i put the ddl triggers on the tables owned by the
schema owner, which keeps at least the strucutures from being altered.
joe
paquette stephane wrote:
Hi all,
I'm a fan of having the processing done by a user
different than the
Me neither. I've had database 50-70G in size on NT. (Which, in the grand
scale of things isn't terribly large, but it's my personal experience
and sufficient for this example). Compaq ProLiant servers, Compaq RAID
controllers and storage arrays. Very nice equipment, rock solid and very
fast. So
Senthil,
In the parameters palette window, you have two options - Destination Type
and Mode.
Both options allow you to produce the report in other than bitmap format.
There is an options CHAR type format which is character-based.
hope this helps.
Tom Mercadante
Oracle Certified Professional
Thanks svend,
BFN.
-Original Message-
Jensen
Sent: Thursday, July 05, 2001 12:51 AM
To: Multiple recipients of list ORACLE-L
Here are two files, a NT cmd and a sql script that do hot backup of
archivelog
databases.
Remember to configure the scripts and ajust to your enviroment
Antje
I know there was a saying - put no database larger than 1 GB on a NT
machine.
The above is nonsense. I have a database that is 200G on NT. I know of no
limit regarding database size on NT.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, July
Guy,
rantDon't even get me started on
Unix, which sucks. Rebooting if you need more file descriptors?! Or
shared memory? All operating systems suck. Apart from maybe VMS./rant
Isn't saying all operating systems suck a bit harsh? :) Personally, I
think they all have their challenges, but they
(robert) - you ARE the weakest link! goodbye! :)
that's what I call immediate justice.
-Original Message-
Sent: Wednesday, July 04, 2001 7:36 PM
To: Multiple recipients of list ORACLE-L
Robert,
After going through the archives I find that in the past
year you have posted 14 times
Jared Still wrote:
Many folks find the acronym RTFM to be sufficient, as
it can also mean 'Read The Fine Manual'
Do you mean there is another meaning to RTFM :o)
Dave
-Original Message-
Sent: Wednesday, July 04, 2001 6:01 PM
To: Multiple recipients of list ORACLE-L
Isn't
Mark,
1. What do you mean by Look-Out archiving? Do you mean to say that you save the
email as File Save into your hard drive each and every mail, that is the ones you are
interested in (if this is the case, well I will like to save all emails basically, you
never know what you are reading
Perhaps it is confusion with filesize and then it is a whole different ball
game and not only for NT but some older unixes and other OS's as well. and
then we can start the arguments for using raw or not using raw for files
under unix.
Peter
At 10:45 PM 5/07/2001, you wrote:
Antje
I know
Title: RE: Script to find space bound objects
This is my two pence
select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from
(select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a,
(select tablespace_name,max(bytes/(1024*1024)) sf
I believe you'll need to be more specific. Using an alert is fairly simple, but
sometimes does not get the desired results.
Dick Goulet
Reply Separator
Author: Pulikkol Kumar [EMAIL PROTECTED]
Date: 7/4/2001 12:35 AM
Hi lists
Any one can help me
Stéphane,
Your not alone. I like having one schema that owns all of the objects and a
second or more that manipulate the data therein. The reason is that many times
the passwords for the other user accounts get hard coded into software making
them almost impossible to change. This way if
hahahah, roflmao, thats hilarious, my co-workers are wondering
whats so funny.
joe
[EMAIL PROTECTED] 07/05/01 08:51AM
(robert) - you ARE the weakest link! goodbye!
:)that's what I call immediate justice.-Original
Message-Sent: Wednesday, July 04, 2001 7:36 PMTo: Multiple
Rahul,
You can put them just about anywhere you want, but since they tend to be a
high IO item you may end up paying a price.
Dick Goulet
Reply Separator
Author: Rahul [EMAIL PROTECTED]
Date: 7/5/2001 1:16 AM
list,
i cannot spare a separate
Good Thursday morning!
I have a nagging question that I can find only sketchy documentation on. I
have been working with Materialized Views and their associated logs and have
been trying to figure out what the RUPD$_tablename structures are for. I
have watched those tables during incremental
Hi,
Please check this
Thanks
Muthu
---
CERT Advisory CA-2001-16 Oracle 8i contains buffer overflow in TNS listener
Original release date: July 03, 2001
Last revised: --
Source: CERT/CC
A complete revision history is
Title: RE: Online backup script..
Woo Hoo! Jared opened up a can on you Robert! c'ya!
--Chris
[EMAIL PROTECTED]
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 7:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:
1) Sorry about that - I was using a funny name for MS Outlook. Within
Outlook, you have an option called archiving, which I have set up as
follows:
1) Create a rule that moves all mail received in my Inbox from
[EMAIL PROTECTED] to afolder called Lyris automatically
Hi, following question on NT.
I need to install 817 JDBC-Driver as I neet JDBC2 compliance.
I just have a Oracle 8.1.6 database and installed
SybaseToOracleWorkbench817.
I copied JDBC-Driver in 8.1.7 home and was wondering if it is sufficient to
have the 8.1.7 Home and
OCI of 816 is used or do I
A couple of other reasons for this approach:
When you create a DAD in Oracle Application Server, you can choose to store
the password in the config file. On version 3.02 it is in unencrypted form
and is optional. On 4.x it's encrypted and mandatory (unless you cheat and
remove the password
I don't want to start another discussion on this topic, I just thought
that this was a good article. It appears that Unix is still king for VLDB or
mission critical apps...
Frank
-
DPRO-89898
Mary Hubley, Mary Ann
Terrian, Tom wrote:
Does anyone know of a way to determine which RBS extents have active
transactions?
Specifically:
select a.segment_name, a.bytes, a.extents, c.xacts
from dba_segments a, dba_rollback_segs b, v$rollstat c
where a.segment_type = 'ROLLBACK'
paquette stephane wrote:
Hi all,
I'm a fan of having the processing done by a user
different than the owner of the data.
Am I alone ?
For example, we're on a datawarehouse system where the
data owner is DWH. The etl tool repository owner is
TOOL_POWERMART and the reporting tool
On Thursday 05 July 2001 07:41, Mark Leith wrote:
folder called Lyris automatically when any
mail comes in. (This keeps the lyris mailseparate from any other
business mail, for ease of reading)
Mark,
You seem to be under the impression that we are still using
Lyris mail software. I
April,
How's Amarillo lately? ;-)
The only useful thing I found was on metalink forum (I'm sure you've
seen it) pasted below. Looks like a special log for UPDATABLE
SNAPSHOTS, which would make sense in the context of 2 way replication.
Scott Shafer
San Antonio, TX
Nope, under no such disillusions :) It's just that I have been on the list
since way back when, and have always called it the Lyris List.
I suppose I could call it ORACLE-L, but why change what I already have set
up? :) I was just describing *my* set-up. I suppose you could call the
folders
Thanks, I was able to write a script that gets me most of what I want:
select a.segment_name, b.start_uext ACTIVE EXENT NUMBER,
b.used_ublk USED RBS BLOCKS
from dba_rollback_segs a, v$transaction b
where a.segment_id = b.xidusn
order by
*excellent* !!!
thanks!
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 04, 2001 7:31
AMTo: Multiple recipients of list ORACLE-LSubject:
Wildly OT. Made me laugh.
For
the UNIX people out there
Unix csh/sh commands:
ALso, what does 1GB actually mean? That much data, if you dumped it
all out into a CSV file? A 1GB tablespace to hold all the data (and how
is that tablespace organized)? 1GB being the sum of the sizes of all the
datafiles? So, even if there were such a saying, it would be
meaningless.
What I
On of our applications is reporting a problem trying to access on a record
in a table. The application is reporting that a transaction is reserved for
update. The app in question hung whilst working on the record a few days
ago. I'm not convinced that this is an Oracle problem, i.e. a row lock
So what your DDL triggers are doing. And if they do not allow DDL to work
how you can execute DDL - disabling these triggers?
Alex Hillman
-Original Message-
Sent: Thursday, July 05, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L
i try to play by the same rule as you.
but if i
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the setup run sqlloader on the
data
-Original Message-
Sent: Wednesday, July 04, 2001 2:53 PM
To: '[EMAIL PROTECTED]'
I think you need this
comp sum of nfrags totsiz avasiz on report
break on report
col tsname format a16 justify c heading 'Tablespace'
col nfrags format 999,990 justify c heading 'Free|Frags'
Amarillo is still beautiful.. although the natives don't seem to share my
enthusiasm.
Yeah, I found this... I was just hoping for... more. I can find
considerable stuff on mlog$_ tables, but I'm still digging on this one. I
love the 'documenation' on some of these 'features'.
Thanks
April
I tend to leave out the sid in a datafile name, saves me from
having to rename it, if i'm doing the transportable tablespace
ordeal.
joe
[EMAIL PROTECTED] 07/05/01 12:03PM
ALso, what does "1GB" actually mean? That much data, if you
dumped itall out into a CSV file? A 1GB tablespace to
yeppers, if you want to prevent ddl on tables when you are
required to give out the schema owner password, you put those triggers on all of
the objects. This assumes the user logging does NOT have alter any
trigger. The triggers are owned by a separate userid and look like
this(besides you
Morning Folks -
Hope those of you in the US had a safe and happy 4th - for those of you who
didn't celebrate this particular holiday, hope your day was also safe and
happy ( every day should be safe and happy!).
I'm trying to set up some tracing for various events/levels. Not using
OEM. In
This is from www.gmsv.com http://www.gmsv.com from yesterday.
Oracle has embarked on an effort to develop client software that will
connect Oracle database applications to workstations running Apple's new Mac
OS X operating system
Diego,
I think log02 is not a redundant log01, I'm pretty sure
it's the second redo log group, without which it will
be pretty difficult to run the database :-). Maybe Rahul
shouldn't delete it.
Yosi
-Original Message-
From: Diego Cutrone [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Look near the end (~70% through) of the
$ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events.
This is about all I could find. Anyone else?
Scott Shafer
San Antonio, TX
[EMAIL PROTECTED] wrote:
Morning Folks -
Hope those of you in the US had a safe and happy 4th - for
Now THAT is both useful AND entertaining!
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 7:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Online backup script..
Robert,
After going through the archives I
All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg
The ones you're interested in are the ones above 1.
Regards,
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 12:11 PM
To: Multiple recipients of list ORACLE-L
Morning Folks -
Hope
Amen and Bravo, Jared.
-Original Message-
Sent: Thursday, July 05, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
Now THAT is both useful AND entertaining!
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 7:36 PM
To:
Hi Rick,
How about creating a private synonym for FOO_A and a public synonym for
FOO_B. When you drop the private synonym, the public synonym takes effect
immediately, and when FOO_A is ready for usage again, you can create a new
private synonym. That way there's always a table available.
Just
Has anyone seen this?
Change Manager (OEM 2.2.) on my machine takes a snapshot of Oracle 7.3.
databases all right, but when I try to compare this baseline against an
existing 8.1.7. database (or a baseline of same), Change Manager does not
detect the tablespaces, views, tables, triggers from the
Ari and his company have been noted in InfoWorld...
EPHRAIM SCHWARTZ Wireless World InfoWorld.com
Thursday, July 5, 2001
REDUCING THE COST OF DBAS
Posted at
Very cool, Thank You.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Scott Shafer
If only it were this simple:
..quantify the amount of time and money their companies would
save if their DBAs.could remotely...
remove from the database a user who is running a command that is
holding up the system.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Rick,
If your current process works for you, that's great!
My only thought was that, since you are already sqlloading the data, why not
right a PL/SQL procedure that would process the transactions into the
existing table.
For example, read a record from the sqlloader table, look for a matching
Checking my oraus.msb file on NT, I don't see any list
of events. Am I missing it or is it not there? I'm on
8.1.7 (didn't see it on 8.1.0 either).
Thanks,
yosi
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 2:07 PM
To: Multiple
So,
We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be
using the export/import method of migration.
Since I'll have the DB all to myself for the weekend, I want to also
partition most of our larger tables (1M-7M rows each -- it's not a huge DB)
in the migration. My
msG
-Original Message-
Sent: Thursday, July 05, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Checking my oraus.msb file on NT, I don't see any list
of events. Am I missing it or is it not there? I'm on
8.1.7 (didn't see it on 8.1.0 either).
Thanks,
yosi
-Original
Where I am the amount is zero as we all have remote access from home already.
What one can quantify is the amount of extra $ it costs for a VPN dial-up line
vs. the wireless connectivity this monster requires. Now that comes to
something (what I am not privy to), so good-bye PocketDBA.
Dick
Any one you guys/dolls out there who
are really using InterMedia, this one is for you
Have you come across a good, single user scanner/OCR combo for putting
hardcopy into a db under InterMedia?
I have a bunch of dox i'd like to put
on a CD or DVD, but want very high
quality OCR and don't
As I impose order on our servers, (moving from project-managed to dba-managed
db's) I perform this sort of task for individual schemas. The short form is the
same as yours except:
3.5) create schemas where tables or tablespace assignments will change.
4.5) create tables that are to have storage
Only in UNIX
-Original Message-
Sent: Thursday, July 05, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L
Checking my oraus.msb file on NT, I don't see any list
of events. Am I missing it or is it not there? I'm on
8.1.7 (didn't see it on 8.1.0 either).
Thanks,
yosi
for precreatng the users, pull the create users statements out
of the .dmp file.
joe
[EMAIL PROTECTED] 07/05/01 02:35PM
So,We're taking the leap from 8.0.6 to 8.1.7. For
various reasons, we will beusing the export/import method of
migration.Since I'll have the DB all to myself for the
Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo!
;-) to check on...
Scott Shafer
San Antonio, TX
[EMAIL PROTECTED] wrote:
Checking my oraus.msb file on NT, I don't see any list
of events. Am I missing it or is it not there? I'm on
8.1.7 (didn't see it on 8.1.0
While i don't shared DG's feelings
about the size and resource consumption
of the PocketDBA, I do share his feelings about the cost of the wireless
access.
Around here, Ricochet for the Palm PDA
runs about 50$ a month or so. What bullsh*t!
When I get wireless for an additional 10$ a month,
Well, we have remote access from home too, but it might be convenient to be
able to do this stuff while I'm running from a grizzly in the Absarokas.
That way I wouldn't have to hang around the house all weekend waiting for a
call that might never come.
Of course it's a moot point for us since
Yeah, thanx all. It seems us poor NT users can't see
the events list. We only rate an MSB file, not an MSG
file.
-Original Message-
From: Scott Shafer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 3:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Tracing
Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote:
WW Well, we have remote access from home too, but it might be convenient to be
WW able to do this stuff while I'm running from a grizzly in the Absarokas.
I hope I never have the opportunity to run from a grizzly. I
once bumped (not
If you're interested in a great opportunity, then consider this position in
Phoenix, AZ
with a leading company that needs an Oracle DBA to join its' I.T. staff.
We would like to submit someone who is a renter and who is interested
in Phoenix but has not applied to Phoenix companies and is not
We did something similar to this 4 years ago using the 2 way pagers, email,
home grown algorithm similar to secure key(give me a number and I'll check
to see if it's the correct sequence), and a heck of a lot of PERL
programming. So IF WE HAD COVERAGE on the 2-way pager(RIM pager using
I have some simple procedures in a DEV instance that run just fine (e.g.
enable_constraints, drop_table, insert_data). When I import them into the
PROD instance, they won't compile stating that
PROCEDURE ROSTERDBA.DROP_TABLE
On line: 7
PLS-00201: identifier 'SYS.DBMS_SQL' must be declared.
I am
Hey Don!
GREAT info! I'm wiping out my test DB right now to try it out. I already
have the scripts to create the TSs (I've learned a little in three years),
so that's no biggie. I'll letcha know what happens.
THANKS! :)
Rich Jesse System/Database Administrator
Rick Osterberg wrote:
Well, here's what I'm trying to do. I've got a pile of tables that are
read-only tables that are downloaded periodically (approximately daily)
from another system. They get slurped into our database via sqlloader.
A previous incarnation of this process had the
Ross,
What I was talking about is the added expense of wireless connectivity for a
PDA. Personally I don't own a PDA and have no desire to do so.
Dick Goulet
Reply Separator
Author: Mohan; Ross [EMAIL PROTECTED]
Date: 7/5/2001 11:19 AM
While
Sorry for wasting the bandwidth
lc
-Original Message-
Sent: Thursday, July 05, 2001 4:00 PM
To: ORACLE-L@fatcity. com
Cc: Lisa R Clary
I have some simple procedures in a DEV instance that run just fine (e.g.
enable_constraints, drop_table, insert_data). When I import them into the
Hi all.
I'm having problems with the following query:
select a1.MBR_TYP_CDE MBR_TYP_CDE,
(COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD ))
from MDSS_STAR.NOVUS_NETWRK_MBR_D a1
group by a1.MBR_TYP_CDE
It fails with ora-06000 (parameter 15851). I have
noticed that if I created the new table
I for one think Ari and his company need to be commended. In the future you
and I will be capable of admin'ing and monitoring multiple databases via
handhelds. Larger consulting companies will likely have teams of DBA's that
are responsible for large pools of databases. New databases will be
and 3) if you are working on that stuff while running from a grizzly you are
either planning on getting killed or a REALLY fast runner able to
concentrate on many things at once in the face of death
From: Weaver, Walt [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of
Title: RE: SQL ERROR--Nebulous definition
It's saying that execute permissions
on sys.dbms_sql must be granted
to ROSTERDBA
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
- Larry
Thursday, July 05, 2001, 4:15:20 PM, you wrote:
O We would like to submit someone who is a renter and who is interested
O in Phoenix but has not applied to Phoenix companies and is not working with
O other recruiters for Phoenix companies.
Now why in the world would any of this matter?
Best
I've been asked to create an index which combines two fields, date location.
For reasons I don't really want to explain, we need/desire this index to
be in the order of date, location. The minor gotcha is that while location
will be populated at the time the record is created, the date field is
But you can play games on them. I actually used to think the same way until
the company agreed to by me one. Since I use Outlook so much they are
actually
quite nice to have. Now, instead of carrying a day timer I carry a Palm.
Makes
life easier for me. Now I am going to go get the software
Ditto. This 'renter' thing sounds like some sort of thinly veiled
discrimination.
-Original Message-
Sent: Thursday, July 05, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
Thursday, July 05, 2001, 4:15:20 PM, you wrote:
O We would like to submit someone who is a renter and who
On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying:
. . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote:
. . . .|O We would like to submit someone who is a renter and who is interested
. . . .|O in Phoenix but has not applied to Phoenix companies and is not working with
. . .
I wonder if a similar thought was echoed in 1991? Maybe all of the DBAs
that were former DB2, etc DBAs could offer some war stories here. It's
funny that databases have become more cumbersome to manage, not easier IMHO.
DBAs have to understand more technologies that are outside the RDBMS box
1 - 100 of 126 matches
Mail list logo