You have to run a procedure within the FND_LOGIN (forget the actual package
name) package to register yourself as part of an organization within
your Apps multi-org system. This package calls the
DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure to embed your ORG_ID in the
CLIENT_INFO column of
Title: RE: Encryption of data
I imagine they lost their job soon
thereafter... :-)
- Original Message -
From:
Marul Mehta
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, August 20, 2002 11:05
AM
Subject: Re: Encryption of data
What about encrypting
Tim,
It could be the client program.
There seems to be timeouts every now and again from clients.
The application is a warehouse application (Retail). The Operators have RF
units to pick stock that go to the stores.
The RF's are running Dr Dos. I am going to the site tomorrow morning and
Hello Peter
The easiest way to do this is to put the product in a separate directory on
a server with permissions only to the named users.
AFAIK oracle is not likely to come and check your computers the way
Microsoft do. At least here(Israel) they believe us (Mehish computer
services) about what
Thanks everybody for help.
regards..
Shishir Kumar MishraAgni Software (P) Ltd.www.agnisoft.com--Vidya
Dadaati Viniyam--
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Hi All,
I'm using 11.0.3 with 8.0.5 on Windows NT SP4
Every once in a while, the users complain that they cannot login into the
applications. At that time I observe that the process WWWLSNR30.exe in the
application server is taking too much of CPU(more than 50%).
No matter how much time I
dbms_utility is basically a wrapper around a series of
ANALYZE commands. Oracle's recommendation is to use
DBMS_STATS but do some testing first - I've send
instances where dbms_stats runs a lot heavier than
analyze
hth
connor
--- Chuan Zhang [EMAIL PROTECTED] wrote:
Hi, ALL,
Sorry if
I fully agree. Unfortunately management insists on it.
Russ
-Original Message-
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L
Dick,
There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite
Dear List,
I am trying to install Oracle 9i Release 1 (9.0.1) and Oracle 9i Application
Server version 1.0.2.2.0 onto a Windows 2000 server. The installation abends
and produces the following message:
NOT ALL THE DEPENDENCIES OF THE COMPONENT ENTERPRISE MANAGER COMMON FILES
2.2.0.0.0 were
To all,
I don't often complain about vendors, but this is what I call exceptional
case. I've no idea who the individual (not really the word I want to use) is,
but he came right out of the clear blue claiming to know who I was. OK, so I
went to their web site took a look at what they
Hi All,
Where can I get a list of all zip codes,city,states to load into a table. I
have searched but cannot find anything to download.
Anyone have a URL that I can get this info.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
If you need zip codes, city, streets for Czech Republic I can send it to you
:-)))
JP
--
Pruner Jan
[EMAIL PROTECTED]
http://jan.pruner.cz/
-
On Wednesday 21 August 2002 15:13, you wrote:
Hi All,
Where can I get a list of all zip
Rick:
We pay for a service that gives us this info (for the U.S. and Canada).
The service is from GreatData (www.greatdata.com). They send us updated
zips about once a quarter.
HTH.
Barb
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Hi,
Has anyone
played with Perl's SQL::STATEMENT? I pulled it down with ppm, and the
sample to evaluate the where clause gives the error:
Can't locate object
method "where" via package "SQL::Statement" (perhaps you forgot to load
"SQL::Statement"?) at test_sql.plx line 37.
And yes, I
Hi Rick,
There are alot of services out there that will sell you a database, with
periodic updates. Here's one -
www.zipinfo.com
Beth
-Original Message-
Sent: Wednesday, August 21, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Where can I get a list of all zip
The answer is yes. SQL*Net and Net8 may contain the same Oracle Homes, but
generally do not. Even if they did, SQL*Net connectivity would use the
16-bit drivers and apis whereas Net8 would use the 32-bit drivers and apis.
Both pieces of software are intelligent enough to understand which
Title: Message
Ive ordered the book from Oreilly about 2 weeks ago and at
that time it was not avaiable.
http://www.oreilly.com/catalog/oracleperl/
Jared, do you know when the book will beshipped? Im
really looking forward to this. Ive setup the DBIand Oracle modules can
connect and querry
www.zipinfo.com
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Where can I get a list of all zip codes,city,states to load into a table. I
have searched but cannot find anything to download.
Anyone have a
Title: RE: List of all zip codes,city,state to load into table.
Hi, Hope this helps. Its a text file, then you can load it using SQLloader etc.
http://www.cwpm.com/ZIP_DB.html
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday,
I have a question for from one of my developers related to PL/SQL and how
data is loaded.
I have a field (marketcode) that is defined as VARCHAR2(3).
I have a problem when I try to load the value of '20' into this field.
All values with three characters work fine. The problem is when
Hi,
One of our client has a table with column name access.
Since access is reserver word...they use double quotes..
now when we try using ODBC to :
select access from table
it gives error..but
select access from table works..
But we want select access from table to work
IS
I think you have to buy this kind of thing ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have
Gogala
Thanks for the tip this seems like just what I'm looking for,
however I must be doing something wrong as no errors are getting written
to my SIDalrt.log
Im running oracle 8.16 server on win2kpro (this is a development
database)
I just got around to running/testing this from my
I've heard good things about Quick Address over here in the UK, and see that
they may have a US version as well:
http://www.postcode.com/us/
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127
Rick - I think Barbara is right, to get the info in bulk you'll probably
have to pay. A few years ago a friend of mine got a diskette from the U.S.
Post Office that was intended to get bulk mailers to use 9-digit zip codes.
Might be worth a check.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL
Sure, please send it
:-)))
RC
Jan Pruner
[EMAIL
Russ,
You have my sympathies. I've been managing SAP databases for the last 7
years, and the last time I let SAPDBA control a reorg was 6.95 years ago.
It performs some tasks reasonably well, like datafile additions and managing
CBO statistics refreshes (especially since SAP wants certain
Sounds like in the table the field c.marketcode is a char(3) instead of
varchar2(3).
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of
Is the field in question in table C defined as CHAR or VARCHAR2? If CHAR
that is why it is blank padded. Check datatype of variables
in pl/sql
Rick
Rick,
You can purchase what you want from the USPS for something like $300. I have
never seen it free.
http://www.usps.com/ncsc/
Cheers,
Thom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell, Thomas M.Mr. NGB-ARNG
INET: [EMAIL PROTECTED]
Fat City Network
Is there an advantage to either of these over roll your own (select
'analyze table ' || table_name|| 'compute statistics')?
(Besides ease of use.)
Since I already have the scripts in place that run the analyze statmement,
I'm wondering if it's worth the effort to change the jobs to use
Barbara,
I can't speak for dbms_utility but dbms_stats is supposed to generate
statistics at both the partition level and at the table level for
partitioned tables, which analyze does not do. These are supposed to be
better quality statistics. Be aware that there are bugs related to
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
This is not a guaranteed method, but the fact that 'access' is stored in the
data dictionary is an indicator that they used to force the name. Anytime
you see lowercase, you can assume that they used . Of course, if the
created it as ACCESS, my method won't work...
Dan Fink
-Original
Have you check the USPS web site? RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 9:13 AM
Hi All,
Where can I get a list of all zip codes,city,states to load into a table.
I
have searched but cannot find anything
hello listmates
we installed on a first solaris 8 a database 9.2.0.1.0 and on a second iAS 1.0.2.2.2 -
it worked fine, until we decided (out of necessity) to configure portal for ldap
authentication.
the problem is: we have a file called ssoxldap.so which is a ELF 32-bit - but we
need one
Shirley - By any chance is this a Pentium 4 system?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 21, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Dear List,
I am trying to install Oracle 9i Release 1 (9.0.1) and Oracle 9i
Hi,
One of our clients has created a table with column name access
since access is reserved word , they use double quotes.
but when i query the table user_tab_columns it is still showing column name as access
and not access
how can we know that this table is created with column
Title: Message
Did
you run the perl makefile.pl
cd
dir\downloaded\fromppm\eg\.cpan\source\mymodule
make
make
test
make
install
For
win32 you have to download and use nmake from microsoft
bob
Hi,
Has anyone
played with Perl's SQL::STATEMENT? I pulled it down with ppm, and
Harvinder,
The columns created with double quotes show as such in user_tab_columns, i
mean they show the name in the same case
so...
NameDisplayed
Access - Access
ACCess - ACCess
and so on. and when u query the table use select Access FROM.
Naveen
-Original
When you say Oracle 9i Release 1 (9.0.1) and Oracle 9i Application Server
version 1.0.2.2.0
are you installing the two different products into the same ORACLE_HOME ?
They have to be seperate Oracle_Homes. 9iAS 1.0.2 is not built on 9.0.1
libraries,
it is on 8.1.7 libraries.
I believe that
It is in the session trace file not the alert log file.
Anjo.
On Wednesday 21 August 2002 16:38, you wrote:
Gogala
Thanks for the tip this seems like just what I'm looking for,
however I must be doing something wrong as no errors are getting written
to my SIDalrt.log
Im running
To all,
I too often allow the dark side of my personality to rule uncontrollably.
The previous e-mail on this subject/vendor was a manifestation of that dark
side. I would like to apologize to all for the rantings that were expressed.
Please be so kind as to delete the message
Harvinder,
Why do you want this grief? I would do everything in my power to convince the client
to rebuild the table with a different column name.
To the best of my knowledge, you have locked yourself into a situation requiring the
double quotes. I don't know of any way around it. Maybe
Yes ,that would be one of my favorite points , but the backup is done
by EMC BCV split at the OS / storage level, i.e. this is not an argument too
;-(
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, August 19, 2002 6:28 PM
To:
Thanks a lot to all who replied !
The upgrade issue is postponed by the customer ;-(
Apparently they'll need to upgrade the O/S as well (they currently use
Digital 4.0d , while the earliest version Oracle8i OPS is certified on is
4.0e, and 9i RAC is supported on 5.*).
So , now the customer should
Russ - A couple of ideas for you.
1. Check directly in Oracle before you perform a task with the tool. And
check afterward to verify what the tool did. This will make you a better
DBA. And in a future job interview, you'll have a more interesting
conversation than just saying duh the only way I
As long as you don't need current data. This page says the file was
last updated Jan 8, 1997. In my personal contact manager, I'm still
using one I downloaded from quite some time ago. Unless you need real
current data, the price is right. (Send the guy $10 though)
Stephen
[EMAIL
It looks like there's a number of people on this list
that could benefit from subscribing to the Perl DBI list:
http://lists.perl.org/showlist.cgi?name=dbi-users
Jared
Bob Metelsky [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 08:23 AM
Please respond to ORACLE-L
To:
Harvinder,
The column won't be created with a quotation mark as part of its name.
Oracle won't allow it.
All the quotation mark does is allow the creation of the column in the first
place, circumventing the syntax rules.
This is not a good thing. I'll lay good odds that it causes problems
John - It is available at http://www.hotsos.com/catalog/
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 20, 2002 7:09 PM
To: Multiple recipients of list ORACLE-L
Mike,
Just one more thing to check before you close this: Can you run a
Harvinder
You've made my day! I have always fought developers on issues like this.
My advice would be for you to use this situation to get the column name
changed. I predict that this column will continue to cause you grief.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
...snip...
marketingcodeVARCHAR2(3);
...snip...
FILELOCATION :=
Shirley,
it sounds like you're hitting bug number 1965439.
It occurs because the 9i database is installed when you try to install 9iAS.
It's allegedly fixed at 1.0.2.2.2. There doesn't seem to be a patch
available.
Regards,
Mike Hately
Oracle DBA
-Original Message-
Sent: 21 August
Thanks Dennis,
Yeah, I know how to do the work without the tool, using sqlplus. That's not the
problem. Management won't even allow us to use OEM for maintenance tasks, only
sapdba. My hands are tied, at least for the moment.
Russ
-Original Message-
Sent: Wednesday, August 21,
Check the definition of table C. It sounds like it is defined as CHAR(3) instead of
VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for
storing the value -- the trim should have eliminated this problem if it was put in the
right place.
Kevin Kennedy
First Point
Raj,
Is this what you meant and what you would get?
SQL get 1
1 select m.id, cast(multiset(select fname
2 from t s
3 where s.id = m.id) as mystrtype) as fnamelst
4 from t1 m
5* group by id
SQL /
ID FNAMELST
--
Interesting. Apparently, my ZIP in a city of 24K people didn't make the
list.
I guess you get what you pay for. :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent:
Hello List,
Does anybody there know the following error message and how to resolve it?
java.sql.SQLException: Io exception: Connection reset by peer: socket write error
Environment
classes12.zip
Oracle 8.1.6.3
Solaris 2.8
Thanks,
Mike
Follow your instincts. Use ipcrm and clear out those shared
memory segments. Then it should start OK.
-Original Message-
Sent: Wednesday, August 21, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.0.5
Solaris 2.6
HA Cluster 2.1
This is wacky.
Any ideas on this one
Ironically, analyzing tables is one of the jobs I leave up to SAPDBA.
There are a number of tables that shouldn't be analyzed, ( ~150
on my system ) and the system knows which ones they are.
Just schedule the job through transaction DB13 and forget about it.
Jared
paquette stephane
How about defining a view?
I know you can escape individual characters but I don't think you can do a
whole string.
-Original Message-
Sent: Wednesday, August 21, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L
Hi,
One of our client has a table with column name access.
Since
Bob,
I don't have mine either. :(
My editor just received a copy on Monday, so they have been printed,
and should be shipping now.
Jared
Bob Metelsky [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 08:23 AM
Please respond to ORACLE-L
To: Multiple recipients of
Interesting web site.
They claim to eliminate chained rows by rebuilding the tables.
I'd like to see how they intend to do that.
They also claim that their product can detect corrupt indexes
and rebuild them. How hard can it be to detect ORA-1578?
This kind of thing is fairly rare, and hardly
But the data would be *very* secure.
Jared
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 12:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Encryption of data
I imagine
Hi All,
I'm using 11.0.3 with 8.0.5 on Windows NT SP4
Every once in a while, the users complain that they cannot login into the
applications. At that time I observe that the process WWWLSNR30.exe in the
application server is taking too much of CPU(more than 50%).
No matter how much time I
Title: Message
Thanks
Bob. I thought if you pulled the module through ppm that was not
necessary.
Russ
-Original Message-From: Bob Metelsky
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:24
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
:STATEMENT
So I set NLS_LANG to AL16UTF16? I'd like the note to be more explicit. I thought
that would be the value to which I would set the character set argument of the
create database command. The two are not the same. For instance the character
set argument of the create database might be
how can we know that this table is created with column name
When the column name is a reserved word, or appears with lower
case characters.
Jared
Harvinder Singh [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple
Yup, exactly that's what I meant.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but
Tim, more specifically could large SQL have
been passed across
the
net ? Stored procedures could help here.
FWIW.
Mike
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Hi Cherie,
I can't speak for dbms_utility but dbms_stats is supposed to generate
statistics at both the partition level and at the table level for
partitioned tables, which analyze does not do.
A small correction, ANALYZE also generates statisics at partition level
and when an analyze
I believe it is acting appropriately. You are trying to load a
two-character byte filed into three-byte character field. Loader, if
you don't terminate by whitespace or nulls, will add the blank into the
field because it is character.
Thus, you have two options:
1. Change the field to
Mike,
I've made the pitch before and will again. Wish me luck.
Russ
-Original Message-
Sent: Wednesday, August 21, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Russ,
You have my sympathies. I've been managing SAP databases for the last 7
years, and the last time I let
It is in the session trace file not the alert log file.
Where would I find this file?
Many thanks in advance
bob
Anjo.
On Wednesday 21 August 2002 16:38, you wrote:
Gogala
Thanks for the tip this seems like just what I'm
looking for, however
I must be doing something
FWIW, someone from Senware presented a paper at IOUG 2002 titled
'Performance management from the ground up' (or somthing like that) which
was a load of *$% to say the least. Most of the audience (many on this
list) walked out in disgust after the first 10 minutes (Does someone
remember the
Oracle 8.0.5
Solaris 2.6
HA Cluster 2.1
This is wacky.
Any ideas on this one (other than reboot the box)???
I cannot start up this database (claims it's already running).
Clearly it is not. No background processes for this instance. The only
process I see even remotely related to this
Barb,
check for an LKdbname file in your $ORACLE_HOME/dbs directory too. If it's
there, delete it.
Just another thing to try.
Regards,
Mike Hately
-Original Message-
Sent: Wednesday, August 21, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.0.5
Solaris 2.6
HA
The USPS department called AMS (Address Management Service) sells this data
in subscription format - we get it monthly. Don't know cost, and data is
provided in ascii file that you the load into a table of your design. We
use SQL Loader for the piece we need and it loads (with truncate
No,
this is "to client", so it is the result of a query
(either to many columns or too many rows returned).
Large SQL statements would result in "from client"
during the Parse phase and if people keep on parsing the same statement, the
client side will keep on sending it to the server.
Point taken. I'll redirect the question.
Russ
-Original Message-
Sent: Wednesday, August 21, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L
It looks like there's a number of people on this list
that could benefit from subscribing to the Perl DBI list:
I guess this is not the case.
1. create table t(TABLE Varchar2(10));
2. select table_name,column_name from user_tab_columns where table_name='T';
TABLE_NAME COLUMN_NAME
-- --
T
Yeah, that's what I do too. I just wish it wouldn't clobber the stats on
the indices after I've so carefully gathered them. We have the 6.2 sapdba,
so I don't think it's using dbastatc as much to control when and how it does
the stats.
Russ
-Original Message-
Sent: Wednesday, August
Did you try shutdown abort? That should do it. But remember to startup
restrict, shutdown normal, startup to allow smon to do his thing.
HTH
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 2:33 PM
Oracle 8.0.5
check your init.ora setting for user_dump_dest (I believe).
Anjo.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 8:43 PM
It is in the session trace file not the alert log file.
Where would I find this file?
um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions
I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/
Oracle 8.1.6. Please suggest the options.
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dharminder Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
I'll add to John's comments. It took John, Kirti myself to keep Gaja calm
during the presentation. Once we all walked out, Gaja went outside and
vented. Their solution is unusual as they believe that performance can
optimized by adding hardware to the solution.
Thank You
Stephen P.
Or go into svrmgrl, connect internal, issue a shutdown abort, then startup.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Hately Mike [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE:
udump directory
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 2:43 PM
It is in the session trace file not the alert log file.
Where would I find this file?
Many thanks
You missed the 'or' in my sentence.
Maybe I should use || ? ;)
Jared
Marul Mehta [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 01:03 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re:
Seema - My interpretation of your question is that you are asking whether
having the indexes for a table on a separate physical would increase
performance.
Since this was a standard recommendation for many years, I feel it merits a
more detailed reply.
If you have an OLTP benchmarking
Kumar
Ummm . . . are you using any 9i features? I'm assuming you have
considered using 9i on Red Hat. Sounds like probably use the 8i export
function to create the export file. I'm assuming the data involved is small
enough to make export/import practical. If you create a Net8 connection, you
Geez, after re-reading my post, it seems that it
didn't make much sense to me, so to clarify...
I had a cursor in my procedure that took as an IN
param a varchar2 variable. The cursor failed to
return any rows because in my where clause I was
comparing a char field against a varchar2 variable.
Hi,
I had noticed that one of our triggers is performing very badly. I had disabled the
trigger to test replication and there was a issue with the trigger. When the developer
changed the trigger and enabled it, replication slowed down to one record per second
(other tables are being updated,
Dharminder,
You will need the 9i disks for RedHat and then create a database on
the Linux box and export the data or insert as select from the Win
2000 database.
There is no simple method of going across platforms.
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 08/21/02 04:24PM
I want to move the Windows
Ok Im having a problem with this
[from init.ora]
user_dump_dest = D:\db_track2data\admin\LTRACK2\udump
[recommended from a user on this list]
select name, value
from v$parameter
where name like '%dump%' ;
NAME VALUE
Title: Message
Yes, I thougt the
same thing... here is a site that will give clear direction of installing
modules
http://perl.about.com/library/weekly/aa030500a.htm
They
cover ppm and perl -MCPAN -e shell
check out all the
links on this page
bob
Dennis,
Try changing your insert statement to:
insert into JOBOFFERFACT_LOAD
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
If the trigger does DML, check that it's written to not fire for
replicated transactions, just local ones, using
DBMS_REPUTIL.FROM_REMOTE.
[EMAIL PROTECTED] wrote:
Hi,
I had noticed that one of our triggers is performing very badly. I had disabled the
trigger to test replication and
1 - 100 of 122 matches
Mail list logo