Consider also using "ALTER USER xxx ACCOUNT LOCK" instead of changing the
passwords...
on 11/26/03 6:49 PM, Browett, Darren at [EMAIL PROTECTED] wrote:
> Looks like that is what we will be doing, basically creating
> a generic user with read-only privileges. All the current
> users will have th
Thank You.
-Original Message-
Sent: Wednesday, November 26, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
Kevin Loney.
And you can find the same information in the first version of the DBA
Handbook
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote:
> I remember seeing a
Hi,
I am trying to merge data from two tables (over two servers, using dblink). Approx
40,000 records in each. Server1(source) and
Server2(dest)
On Server1, db-link "dblink1" points to Server2
On Server2, db-link "dblink1" points to Server1
Schema names are same on the two servers.
<>
Now, w
Wednesday, November 26, 2003, 7:44:25 PM, Jared Still ([EMAIL PROTECTED]) wrote:
JS> Oh, so *that's* what a cobol redefine is.
JS> How incredibly ugly. Must have been someone's
JS> crutch for poor (or no) design.
No, no, no. REDEFINE is very powerful. It's part of the
COBOL magic.
Best regards
Looks like that is what we will be doing, basically creating
a generic user with read-only privileges. All the current
users will have their password changed so they cannot access the
system.
Darren
-Original Message-
Sent: Wednesday, November 26, 2003 4:04 PM
To: Multiple recipients of
I think that you're going to have to take Mladen's advice
and send an Email to everyone
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
i can't use net send since not all users in the same local network.
i ca
i can't use net send since not all users in the same local network.
i can't also wall since all users are using win98.
do u know any 3rd party software like winpop(forlocal network) that can
send messages across the network?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Aut
Oh, so *that's* what a cobol redefine is.
How incredibly ugly. Must have been someone's
crutch for poor (or no) design.
Of course, I have seen this done in Oracle as well.
Jared
On Wed, 2003-11-26 at 13:34, Stephane Paquette wrote:
> Hi all,
>
> We'll do a conversion from IMS to Oracle (817
Kevin Loney.
And you can find the same information in the first version of the DBA
Handbook
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote:
> I remember seeing a paper delivered at an IOUG wa back, that
> spoke
> of the 22-disk solution. I know it's old and outdated, but I'd l
You can't.
Even if you were to set all possible tablespaces to READ ONLY, you'll find
that it doesn't prevent folks from dropping objects.
All you can do is restrict people to schemas/accounts which do not own any
objects and do not have permissions to create any. That way, you can
restrict them
Darren,
Couldn't you just open the database with a user that has all the
necessary privileges revoked?
-Original Message-
Browett, Darren
Sent: Wednesday, November 26, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
We are in the process of upgrading our peoplesoft app, using an ora
We are in the process of upgrading our peoplesoft app, using an oracle
database of
8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5
database as readonly.
I have read all the doc's but it appears I cannot open the database as
read only. Looks like
I could if the version was 8
Hi!
Check note 171658.1 from metalink, it has series of steps for removing XML
stuff from database.
Alternatively (if I recall correctly) you can just remove the XDB entry from
listener.ora.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent
Rich,
Cannot verify now but if I remember correctly, these files
are generated by a program in $ORACLE_HOME/bin
Look for something like gen* (gennttab ??)
This program is generally called during some oracle relink.
HTH
At 11:04 25/11/2003 -0800, you wrote:
>Hey all,
>
>Running Oracle 9.2.0.4 on
At 13:34 26-11-03 -0800, you wrote:
Hi all,
We'll do a conversion from IMS to Oracle (817).
The conversion team wants to move data on Oracle then processed it.
Off course, in the file format, the cobol redefine command is used on a
filler field (20 times). There is also a redefine command in a re
My networking people just notified me that XDB has port 8080 locked. Since I
wasn't aware that Oracle 9.2 had an XDB running, this quite has me baffled.
Is this something I can stop? Oracle has a lot of documentation on how to
configure it, etc., but I don't see a thing on stopping it. Any thoughts
A-ha! Just when I'm on the virge of bashing them, Oracle Support comes thru
(to be fair, I've had very good response from them lately). The files are
leftovers from linking and can be safely deleted.
Americans, Happy Thanksgiving! The rest of the world, enjoy working
tomorrow.
Rich
Rich Jess
I went thru a conversion like this many moons ago but was to DB2 and not Oracle but in
the end was the same.
We looked at each and decided what needed to be defined as a seperate table ( ie the
key and redefined portion became a table)
and others where we had the key and a large binary field tha
Hi all,
We'll do a conversion from IMS to Oracle (817).
The conversion team wants to move data on Oracle then processed it.
Off course, in the file format, the cobol redefine command is used on a filler field
(20 times). There is also a redefine command in a redefine command.
For the younger o
I remember seeing a paper delivered at an IOUG wa back, that spoke
of the 22-disk solution. I know it's old and outdated, but I'd like to
find a copy. Does anyone remember who wrote and presented this paper?
Thanks, and Happy Thanksgiving!
Mike
---
=
Brilliant, as always. Well deserved award, IMHO. No Academy(R) nomination
on the way just yet, though. ;)
BTW, the largest RDB customers seems like they've had a different experience
than the littler ones. When Oracle bought RDB, they came to our parent
company with a huge increase in the pric
i remember in tom kytes new book there is a 'softer parse' he was referring to using
dbms_sql instead of execute immediate. Im not referring to using dbms_sql when you
have to loop and use the same cursor repeatedly so you eliminate all parsing.
he didnt go into great detail on this just gave b
Yup, tried those with no hits. Those processes must be long gone.
I had mistakenly copied over my Windohs version of SQLNET.ORA, which the
SQLNET.AUTHENTICATION_SERVICES parameter seems to have a problem on Linux.
I tried re-enabling that, but am unable to recreate the dumps. I also see
that som
Don't do this:
Loop
Parse
Execute
Fetch
End loop
Do this:
Parse
Loop
Execute
Fetch
End loop
If you parse inside your loop, then all that using bind variables will
gain you is
V$SYSSTAT has a NAME attribute. V$SESSTAT doesn't. So seeing the name
when you're using V$SESSTAT requires a join with V$STATNAME.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Da
Mogens Nørgaard scribbled on the wall in glitter crayon:
> That's how I came to deliver the first-ever course at Lego in their HQ
> in Denmark (in a town called Billund, but certainly not named after
> The Bill).
yes i'm sure it's not named after me... oh you meant the other bill.;-)
> Oracle h
42 pounds here on the same diet since August 25
-Original Message-
Bellow, Bambi
Sent: Wednesday, November 26, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Oh, hell, I posted this privately to Mladen, but here it is for low-carb
consumption...
---
I've lost 50 lbs on At
> Could anyone explain me the cause of this error?
>
> I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6
This last line is your problem. I certainly hope you aren't running a
production system on this configuration.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
> Happy Thanksgiving to everybody. As for maintaining the
> weight, that precisely is the problem. I am unable to
> lose weight, not to maintain it. There quite an abundance
> of me, I want to shrink. Does anyone know if oracle 10g has
> any options for shrinking DBAs? Something like
> ALTER DBA SE
Here is what I use to monitor my cursor use. If session_cached_cursors
is at or near 100%, I increase is and continue to monitor. On the
system I just checked I'm up to 500. This reduced my parse counts for
some operations.
The other thing is whether there are any compiler flags that need to be
Hi!
Lookup from v$statname must also be used for v$px_sesstat..
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 4:34 PM
> Good point. I'd forgotten that. Just a lookup for v$sesstat then.
>
> Cheers,
> Mike
:)
Btw, I advise against memorizing statistic numbers, because they change over
versions...
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 3:34 PM
> v$statname is a lookup table for the statistic# that appe
Mladen wrote:
ALTER DBA SET WEIGHT=240LBS BANK_ACCOUNT=10M DROP POINTS FROM DRIVERS LICENSE;
Is there an undocumented _NLS_WEIGHT parameter to translate this LBS stuff
to KG (Dumb metric units)?
Regards, Carel-Jan
-- There will allwasy be another 10 last bugs --
--
Please see the official ORA
Hi Tim, and all others for your replies. Reminds me I've forgotten to close
this thread. Some 'specialist' of the reseller came along, still convinced
the characterset was wrong. Until he had to admit that he'd forgotten to
create an index..
I was just asking the question to the List because
Hi Rich
Try lsof or fuser on them?, if you get the process ID you could try
attaching truss to it and see what its being used for. IPC springs to
mind?
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracl
Pure bvllsh1t.
Slap a sql trace on the process and find out what's actually going on. Stop
the madness before some damager makes a stupid decision...
In the end, they might be right. But isn't it better to be certain?
on 11/17/03 3:49 AM, Carel-Jan Engel at [EMAIL PROTECTED] wrote:
> Hi Lis
Thanks, Jared.
Yes, running select vs select+rollback in a loop of
1000 iterations I got similar results (average over 3
runs):
STAT...user rollbacks 0 1,000 1,000
LATCH...enqueues 570 1,574 1,004
LATCH...shared pool7,434 9,063 1,629
STAT...recursive 7,754 10,264 2,5
In addition to the effect on the optimizer, there is also the issue of the
granularity of object locking.
Explicitly naming a partition in a DML statement places a "TM" enqueue
(a.k.a. DML lock) on just the partition. So, conflicting operations such as
INSERT /*+ APPEND */ against other partition
Hi List,
Almost fro all SQLs I am getting Prase count is same as Execute count. How to reduce
parse count?
1) We are using bind variable
2) session_cached_cursors set to 100
call count cpuelapsed disk querycurrentrows
--- -- --
Friends --
Thanks for the responses... I have compiled them (and slightly edited some
of them), and, at Jared's request, I have posted them elsewhere...
www.eclec.com/jobpost.html
Please post all flames to me directly. I can take it.
Happy Turkey Day to everyone in the US, and Turkey, of cours
I know this is OT and Jared has been kind enough to approve it.
Many of us on the list have come to know and respect Walt
Weaver. He and his family (wife Kathy, daughters Jenny and
Caitlin) are currently enduring a very difficult situation.
Jenny has recently undergone a bone marrow transplant in
Oh, hell, I posted this privately to Mladen, but here it is for low-carb
consumption...
---
I've lost 50 lbs on Atkins, if that helps. It's really quite easy and
haven't run into any of the "pitfalls" you hear about... oh, except the
third day... that's hard.
Bambi.
-Original Message-
On Wed, 26 Nov 2003, Hately, Mike (LogicaCMG) wrote:
> v$statname is a lookup table for the statistic# that appears in v$sesstat
> and v$sysstat. You use it in most queries on those tables unless you're
> named Tanel and have memorised the statistic numbers. =)
Remember Oracle likes to change ar
are you looking for the init.ora max_open_cursors(dont think i typed it exactly right).
even if the cursors are cached, they should not be counted as open. they doesnt make
sense from an oracle design standpoint.
>
> From: Lord David <[EMAIL PROTECTED]>
> Date: 2003/11/26 Wed AM 10:34:34 EST
>
nope. Drink driving
-Original Message-
Goulet, Dick
Sent: 26 November 2003 16:34
To: Multiple recipients of list ORACLE-L
In the UK I believe you simply classify it as "driving without due care"
don't you?? Damn, wish the police around here had that capability.
Dick Goulet
Senior Orac
Happy Thanksgiving to all
I think it is DUI - driving under influence (of alcohol or watever )"Goulet, Dick" <[EMAIL PROTECTED]> wrote:
In the UK I believe you simply classify it as "driving without due care" don't you?? Damn, wish the police around here had that capability.Dick GouletSenior Oracle
No - but seriously - and I am not kidding my Dad sells Herbalife products and could
probably actually help you with this Mladen. Frankly I think the stress - sitting our
jobs entails adds a lot to this. Exercise we all probably really need because our
jobs are so sedentary. Anyway, hang i
Below was the closest I got, but it still pretty much shows everything "empty" sort
of. Guess it's okay, I'll monitor. This is a warehouse so it's hard to say. So close
to the holidays, it's possible they aren't using a lot of temp.
set linesize 162
set pagesize 30
column tablespace_name forma
Mladen,
You should be writing specs for Oracle11 -:)
Happy Thanksgiving everyone...
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Mladen Gogala
Sent: Wednesday, November 26, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L
Happy Thanksgiving to everybody. As for main
David:
I don't really know if this will help you, but it
might be worth a try. You could try setting
session_cached_cursors.
Bjørn Engsig's white paper "Efficient use of bind
variables, cursor_sharing and related cursor
parameters" describes this parameter a bit. It can be
found at http://mira
Happy Thanksgiving to everybody. As for maintaining the
weight, that precisely is the problem. I am unable to
lose weight, not to maintain it. There quite an abundance
of me, I want to shrink. Does anyone know if oracle 10g has
any options for shrinking DBAs? Something like
ALTER DBA SET WEIGHT=
In the UK I believe you simply classify it as "driving without due care" don't you??
Damn, wish the police around here had that capability.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, November 26, 2003 11:10 AM
To: Multiple recipients of lis
I reckon its DRIVING WHILE INTOXICATED but I woudn't swear to it as I am in
the UK
-Original Message-
Quintin, Richard
Sent: 26 November 2003 15:59
To: Multiple recipients of list ORACLE-L
DWI = DDL while inebriated?
On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote:
> And may you all be
Works too.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Wedn
Man - I need to switch jobs.
-Original Message-
Sent: Wednesday, November 26, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Come to think of it, out fitness center has a special program ... it runs for 8 weeks
and the aim is "maintaining the weight" ... no points for loosing an
how 'bout a little DUI?
-Original Message-
Sent: Wednesday, November 26, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
And may you all be back here on Monday, in one piece, safe & sound. No
DWI's now, you hear!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Origi
- yes esp. during the after-football game libations.
-Original Message-
Sent: Wednesday, November 26, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
And may you all be back here on Monday, in one piece, safe & sound. No DWI's now, you
hear!
Dick Goulet
Senior Oracle DBA
Oracle
DWI = DDL while inebriated?
On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote:
> And may you all be back here on Monday, in one piece, safe & sound. No DWI's now,
> you hear!
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
> [mailto:[EMAIL PROTECTED]
If your users are part of your local network, you can use
the Windoze "NET SEND" command. I have recently found that
to be useful.
UNIX/Linux utilities like 'wall' only send a message to
users who are telnet'ed or rlogin'ed to the system.
To send a message to a browser is not something I know
ho
And may you all be back here on Monday, in one piece, safe & sound. No DWI's now, you
hear!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Guys,
Ha
Come to think of it, out fitness center has a special program ... it runs for 8 weeks
and the aim is "maintaining the weight" ... no points for loosing any. bi-weekly
weight watch and help to maintain weight is included.
Happy Thanksgiving everyone ...
Raj
---
if the messages are sent over WAN, don't you think 1 minute is inadequate time? There
is no built in utility in oracle to do what you need. You can however design something
using a small java applet that uses dbms_alert and display the message.
Raj
---
Hi,
We're testing an oracle
9.2.0.4 database with an oracle 7 client.
This is a C++ client, using OCI to go to oracle.
We see strange behaviour when using a sequence which worked
nicely before. The sequence is not incremented when issueing
"select
res_id.nextval from dual
Wh
Well, you could try...
select view_name from all_views
where view_name like '%TEMP%';
..and see what you get. I have lots of views that give me
information about the TEMP tablespace. YMMV, but it's
a place to start.
Cheers,
Mike
-Original Message-
Sent: Wednesday, November 26, 2003 6
Guys,
Happy Thanksgiving to everyone. May your bellies be full but your waistline not
expand, may you enjoy the time with your family and friends and avoid any of the other
drama
Thanks so much to everyone for their help and camaraderie.
Just enjoy yaself!
--
Please see the official ORA
Hi
Does anyone know whether its possible to control the size of the pl/sql
static cursor cache.
I'm running into ORA-01000: maximum number of open cursors exceeded errors
and part of the problem (apart from the usual developers not closing
explicit cursors) is that _all_ static sql statements in
Hi,
While trying to import a dump, i got an error during "create index":
IMP-3: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 23 (block # 47913)
ORA-01110: data file 23: '/data/oracle/DEV/IS_D2C_02.DBF'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/
Valerie,
It depends on who you are, how remote is remote and the OS you are using. I guess
that if you are a production DBA, the farther away from development the better. If you
are a developer, you may be blocked by those mundane IT problems which spice our
otherwise so dull lives, ie wron
Janne,
Thanks very much for your wonderful detail suggestion. I'll definitely use
it to analyze the redo.
David
From: Jan Korecki <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: insert in batch loading
Date: Tue, 25 Nov
Well, init takes one numeric argument (level) and ignores everything else.
That means that the command init 0 "Please log off the database" has the
same effect as init 0. Trust me, users will get the message. Did you see
the flags?
On 11/26/2003 02:09:24 AM, nelson flores wrote:
> Isn't the wall u
Good point. I'd forgotten that. Just a lookup for v$sesstat then.
Cheers,
Mike
-Original Message-
Sent: 26 November 2003 13:39
To: Multiple recipients of list ORACLE-L
both store that info
SQL> desc v$statname
Name Null?Type
-
Walt-
What version of Linux are you running?? As of RH 8.0 generic HS services
were not supported by Oracle. In fact the hsodbc exe does NOT exist at
$ORACLE_HOME/bin.
Using Perl or Python does not qualify for generic connectivity in my
book..
-Original Message-
Sent: Wedn
What are the disadvantages to managing/deploying applications with a remote
iAS server? Are there significant reason to try to have it local to the
development?
Thanks in advance!
Valerie
Valerie H. Webber
Valspar Corporation
7930 W. Kenton Circle
Huntersville, NC 28078
800-241-4568 ext. 6313
Thanks, Raj.
So yes, as I said in my other email - the rule stated
in the book seem to apply to EXEC db calls only (in
case of SQL fired from PL/SQL). I guess I
misinterpreted it the way that it applies to ALL db
calls for recursive cursors.
Thanks,
Boris Dali.
--- "Jamadagni, Rajendra"
<[EMAIL
But the previous email was a shining example of brevity in action! ;)
I'll have to wait for Cary, et.al. as well as my understanding is the exact same as
yours.
Daniel
"Jamadagni, Rajendra" wrote:
> Sorry about the last empty email ...
>
> Cary is right, the EXEC at dep=0 is the database call
You are right, that v$statname is not needed when querying v$sysstat,
since v$sysstat has "name" column.
But, if you look at v$sesstat:
SQL> describe v$sesstat;
Name
SID
STATISTIC#
VALUE
It appears one database I can not query the temp tablespace.
It's local, unform extents, but nothing shows up in dba_segments or any where I have
found thus far.
Has this progressed to a "trust me" type of situation?
Even TOAD gives me nothing but blanks on objects in TEMP yet on other database
Expanding the logic to its logical conclusion, we produce philosophies
similar to that found at www.despair.com.
CONSULTING: If you aren't part of the solution, then there is good money to
be made in prolonging the problem.
> -Original Message-
>
> I like that logic! I might just start
Ryan,
V$sysstat is system wide statistics. It contains name, value and
statistic# and class.
V$statname is used mostly as a lookup.
V$sesstat is session stats which does not contain the *statistic name*
column.
When joined with v$statname (statistic# column), the statistic name
and values can b
right, then why do we have v$statname?
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/11/26 Wed AM 08:44:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: RE: when do you use v$statname?
>
> but only v$sysstat has the "value" column ...
>
> R
v$sysstat has the NAME column also?
>
> From: "Hately, Mike (LogicaCMG)" <[EMAIL PROTECTED]>
> Date: 2003/11/26 Wed AM 08:34:26 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: when do you use v$statname?
>
> v$statname is a lookup table for the statistic# that a
but only v$sysstat has the "value" column ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
--
both store that info
SQL> desc v$statname
Name Null?Type
-
STATISTIC# NUMBER
NAME VARCHA
doesn't v$statname store the statistics# and statistics_name ... it's like a lookup
table. v$sysstat is the actual values for each of statistic.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in
v$statname is a lookup table for the statistic# that appears in v$sesstat
and v$sysstat. You use it in most queries on those tables unless you're
named Tanel and have memorised the statistic numbers. =)
Cheers,
Mike Hately
-Original Message-
Sent: 26 November 2003 13:24
To: Multiple reci
This view seems to be a smaller subset of v$sysstat? When is it useful?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mai
Sorry about the last empty email ...
Cary is right, the EXEC at dep=0 is the database call you should be looking for, why?
because until #1 is parsed, db has no way of finding what needs to do. And once it
finds that "Oh I must run a SQL", the dep increases. So, I'd look for a subsequent
EXEC
Title: Active Directory and ORACLE passwords
There is a product called MIIS ( Microsoft Integration
Information Server) that synchronize between Ad and Oracle LDAP. One of the
companies in Israel is checking it out now.
Yechiel AdarMehish
- Original Message -
From:
Bartolo,
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
Sent: Monday, November 2
Wanted a way to connect from within the Oracle DB. Cannot write the application to
move data the way you have indicated.
I did try Generic connectivity. Am getting the error while accessing the link as:
ORA-2854: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV connec
Hi,
When I issue
an alter table move statement and afterwards an alter index rebuild for the primary key on this
table I got
an error duplicate rows found. This primary key is unique.
The database
has just been migrated for test purposes. In production we are still on oracle
7.3.4
I have.
It works.
The steps:
1. Connect to Oracle.
2. Connect to SQL Server.
3. Transfer data, maybe using Perl. Or Python (this is for my buddy
Steve Orr).
4. If it doesn't work, contact a call center in India. They know
everything.
Generic connectivity is, indeed, supported on Linux. I'll bet
Isn't the wall utility used to send a message to everyone in Unix/Linux?
i.e
wall "This Database will Self Destruct in 5 seconds "
(although the utility has been removed from some systems due to some
security problems a.k.a root exploit)
p.d : What's Outlook Express??? ;)
-Original M
93 matches
Mail list logo