Hi Suhen,
I guess the flwng is the syntax:
$ mknod -p /mydir/pipe_file 200m
$ exp user/passwd file=pipe_file tables=abc
correct me if I am wrong
thanq
srinvias
-Original Message-
Sent: Tuesday, October 02, 2001 3:25 AM
To: Multiple recipients of list ORACLE-L
Srinivas,
Try
Hi lists
How to find out a server (solaris) IP address, that I logged in .
Any command ?
thanx in advance
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Title: How much data can SQL*Server hold?
Lisa,
It may
be a little late for your needs but I am attending a meeting in London (Oct1
5th) about this very thing. Apparently (and I was blissfully unaware of this)
we run a large-ish (about 70Gb) SQL*Server database for a major communications
$ who am i
root pts/12 obre 2 09:11
(192.168.11.33)
Regards.
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
How to find out a server (solaris) IP address, that
I logged in .
Any command ?
thanx in advance
srinivas
--
Please see the official
hello i've update my database from 8.1.7 release 3 to 9iand now
following statement don't use my optimizer hint in 9i (in 8i
itworks)upper_artikel_kurztext_idx is an function based
indexselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from
artikelwhere upper(kurztext) LIKE
Your IP address is 127.0.0.1 :-)
JP
Try ifconfig
On Tue 2. October 2001 09:30, you wrote:
Hi lists
How to find out a server (solaris) IP address, that I logged in .
Any command ?
thanx in advance
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Thanks a lot
-Original Message-
Sent: Tuesday, October 02, 2001 5:15 AM
To: Multiple recipients of list ORACLE-L
$ who am i
root pts/12 obre 2 09:11
(192.168.11.33)
Regards.
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
How to find out a
Title: How much data can SQL*Server hold?
Hi
Lisa,
About
the biggest MSSQL implementation I am aware of is this:
http://terraserver.homeadvisor.msn.com/terra_tech.asp
1.5
terabytes on SQL Server 2000, Windows 2000 Datacenter and Compaq ProLiant.
There's even a picture of what it looks
If its the actual data you could look at the minus, intersect operators etc
eg
select * from schema1.table
minus
select * from schema2.table
give the data in schema1 not in schema 2.
Iain Nicoll
-Original Message-
Sent: 02 October 2001 04:15
To: Multiple recipients of list
Try this:
Alter table table_name disable table lock;
--- Ha Duy Thien [EMAIL PROTECTED] wrote:
Hi all
Does anyone know how to unlock a locked table?
Thanks in advance
Ha Duy Thien
__
Do You Yahoo!?
Listen to your Yahoo! Mail
Hello All,
When you take begin back up of tablespace what exactly oracle does
internally.
what happen the transcation in that period.
Please tell me .
Regards,
saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: [EMAIL
Thanks, christoffer, finally I have solved this and it works.
The parameters set I have now, is the following:
shared_pool_size 68157440 (size in bytes )
shared_pool_reserved_size 3407872
large_pool_size 614400
java_pool_size 5250
java_soft_sessionspace_limit 0
Hello,
Slightly unrelated question... is it better to (in pseudo code) :
1)
for each tablespace loop
put tablespace in backup mode
end loop
for each datafile in the database loop
copy data file
end loop
for each tablespace loop
put tablespace in normal mode
end loop
Hello !
After having defined all the tables, now I have to parametrize each table.
I have some tables that every day must be deleted and reloaded through sql
loader.
I think to set PCTFREE = 0, but I don't know if I have to specify a
particular value for PCTUSED.
Anybody can give an advice about
HELL of a reason to learn Perl!
Nice..
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0
Well, but can you put some words about performance of Perl versus PL/SQL
(where to use what)?
JP
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
Hi list members,
I'm new in the field of Oracle DBA. I'm trying to change the size of
Redo Buffers by setting the log_buffer parameter in init.ora file. But
its value does not mach to redo buffers when I connect to svrmgr and use
show sga command to view the SGA parameters.
Can anyone help me by
I'm sure Perl would be more efficient especially as you don't have to name
the columns, but if you don't have to worry about the combined columns being
too large isn't it equivalent to
select col1||'|'||col2 etc
from table
having col1||'|'||col2 etc like '%value%'
Iain Nicoll
-Original
Title: RE: Hot Backup Issue
Guy,
I would have thought 2) was best as you are reducing the concurrency (I think that is the right word) of redo log activity.
As each tablespace is in backup mode it writes the full block to the redo log when any changes are made. On the assumption that all
hi ,
We have been studiyng about a project which is include Oracle Real
Application Clusters on Windows 2000 Cluster System.
And Our hardware vendors present to us snapshot technology on their
storage systems .We have orginized two meeting with DELL and HP vendores and
they said to us
There are no strict rules, but its all about trying to
reduce the amount of wasted space under the high water
mark for the table.
That wasted space is when you have free'd up some
space in a block but the block is still deemed
sufficiently full for it not be considered for new
data.
This is
srinivas,
Also look at using the COMMIT=Y command line prompt. This will commit the
imported records every so often which would allow you to perform your select
count(*) command.
Be aware that if your import plan requires a complete rollback if something
bad happens, then using COMMIT=Y is
Andrea,
If it were me and I had tables that were reloaded every day, I would set the
following:
PCTFREE=5 : Since you are not doing deletes inserts, keep this small
PCTUSED=95 : Since you are not doing updates, pack the data right in tight.
PCTINCREASE=0 : I ALWAYS set this to 0.
and, make
This function comapres two tables.
It's easy to write a cycle for tables in two schemas.
Enjoy it.
Jan Pruner
create function compare_tables( tbl1 VARCHAR2, tbl2 VARCHAR2) return NUMBER
/* Function compares content of two identical tables
|| tbl1, tbl2 are names of tables in format
well 1 is simpler to code. :)
However, if you put all tablespaces in backup mode at once, you will be
generating a LOT of extra redo and archived logs.
That's because even if you are not currently backinf up that tablespace
(say you already HAVE backed it up), you will still have to write full
Guy,
Some reasons why NOT to put all tablespaces in the backup mode at once (step 1) is
that the tranactions against the database could create a lot of redo and archive logs
that could fill the space, tranaction time could be longer as it now reads the redo
not the tables, Snapshot to old
The main disadvantage of #1 is that lgwr will write full blocks to the redo logs
for the entire database until the entire backup is finished. If that takes a
while and there is significant activity, it can generate tremendous amounts of
redo - and archive. Lgwr and the I/O subsystem are doing
that will kill the job...
if you want it to continue after you log out, you should run:
nohup compress /u01/dmps/zvr_dd.dmp
this will allow it to run disconnected from a terminal and will
continue after you log out. You will get the message you have running
jobs when you type exit, just type
it can be because of log_buffer is enforced to 4 times of OS block size.
-Original Message-
Sent: Tuesday, October 02, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Hi list members,
I'm new in the field of Oracle DBA. I'm trying to change the size of
Redo Buffers by setting
It freezes increasing the SCN of the data files associated with the
tablespace. Then it writes full block data to the redo logs instead of the
standard old, new, operation data. If the block has already been written
out, it will use an algorithm to avoid constantly writing out the same
blocks.
You can do all three, but if you do not declare it you can't use the 'for update
of' clause. Of course the 'for i in ()loop' does replace a lot of lines of code.
Dick Goulet
Reply Separator
Author: Steve Smith [EMAIL PROTECTED]
Date: 10/1/2001 7:50
Saroj,
Oracle does two things when you issue the start backup command. 1) It
freezes the SCN in the header block of all datafiles in that tablespace and 2)
it begins writing full block redo, from my experience for all tablespaces in the
database. Some folks, including Oracle themselves, do
I did the same reorganization two weeks ago, not the same amount of data,
but
I used 128k for index tablespaces, 4m for the most activity TS (Sales) and
5160k for the others.
I am very, very, very happy with the performance.
I read two articles that some folks from the list sent me.
Good
Title: RE: Database Hangs -- System shows latch contentions
Thanks. Yes its shared pool and Library cache.
Shared pool was 4 GB initially I reduced it to 1.5 GB
then we had problem and we increased it to 1.9 GB.
We can't go to 8.1.6 new as it requires lot of testing and users are not ready
Title: RE: Hot Backup Issue
That
makes sense, I just wanted to check :0) And of course, transactions in other
tablespaces would be writing redo as normal. The overall level of redo generated
would surely be less, tho'? Because say you had 5 tablespaces and put them all
into hotbackup mode.
Hello,
Out of curiosity just now, I ran strings on a backup of my control
file. In it, there are lots of repeated references to archive log files
- there are groups log file names, and the same name might appear in
multiple groups. Is this a list of the redo logs that you would need to
recover
right...okwell.
save=write
??
that's what I have always ASSumed...?
hth
- Ross
-Original Message-
Sent: Monday, October 01, 2001 11:10 PM
To: Multiple recipients of list ORACLE-L
ok, I know the meaning of the undo block and undo header statistics, but
I don't know
Did you bounce (shutdown startup) your instance?
If you set an initialisation parameter, you will need to cycle your instance
for these parameters to be reinforced.
HTH
Mark
-Original Message-
Bahar
Sent: Tuesday, October 02, 2001 14:45
To: Multiple recipients of list ORACLE-L
it
The freware tora tool also has some compare capabilities. I've tested
if with whe users scott and scott1 (both populated throuh the demobld
script and, therefore containing vast masses of data) and it worked well.
I haven't tested it on a real life database, mostly because the word
freeware
is
What happens? What happens is exactly what is described in the DBA guide
and concepts manual. You can find bth of those on http://technet.oracle.com.
Read the fine manual.
-Original Message-
From: Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 6:30 AM
Hi Friends,
We are going to add new disks other than existing disks!! My front end is
baan, my system is AIX 4.1.5 with 200Gb data( I think its before AIX 4.3
version). My task is to test new disks performance like is it viable or
not!! So what are the things I need to monitor?? or any
Apologies for asking another question on this (posted one yesterday) but I'm
stuck,
I am using patchadd to install 2 patches (107545-03 and 106542-17) to
Solaris for Intel, these patches are required for Oracle 8.1.6. I keep
getting the following message:
Checking installed patches...
One or
I cannot find a definitive definition of these two terms on metalink. Can
these terms be used interchangeably or is there a difference?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services
Why not try the time tested brute force method?
Select * from owner1.table1
intersect select * from owner2.table2;
If you get the same number of rows as there are in the tables individually then
they are equal. BTW: it's cheap too.
Dick Goulet
Reply
Save undo headers are made for the Billy Graham's database only. Just
kidding.
The save undo headers refer to the deferred rollback segment, which are
created if a tablespace goes offline with uncommitted transactions. Those
deferred rollback segments are created in the tablespace SYSTEM and
On Monday 01 October 2001 19:55, satar naghshineh wrote:
Regards,
Satar Groping Hands Grandma Fetish Naghshineh
OK, it's already been on the list once, that's enough.
Don't prolong it.
Jared
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Just thought I would ask. How does everyone feel
Ramon,
Why use an extent size of 5.16 meg when you are
already using 4 meg?
Jared
On Tuesday 02 October 2001 07:40, Ramon Estevez wrote:
I did the same reorganization two weeks ago, not the same amount of data,
but
I used 128k for index tablespaces, 4m for the most activity TS (Sales)
By any chance are any on this list members of TCOUG(Twin Cities Oracle Users
Group)? If so are you planning on attending tomorrows conference in
Bloomington on Oracle System Performance given by Cary Millsap?
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
That is completely a myth. There is no notable performance different with a
table with 10,000 extents and one with 1.
The only problem is when it comes to the bitmaps when dealing with LMT and
cluster when dealing with dictionary managed. When you query the extent
views, or do space
Hi Guys,
While running a job(with lot of updates)in oem i get this error:
ORA-00054: resource busy and acquire with NOWAIT specified.
data base is 8.1.7 on NT.
please help me how to fix it.
Sunil Nookala
Dell Corp.
Austin, TX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
You can not make an intelligent guess at what these values should be without
knowing:
1. Average Row Length
2. Blocks Size
3. Average Rows/Block
4. How active the table is for insert, deletes, updates.
5. Average size of updates (1,2,3 columns, 1 byte, 10 bytes)
Without these pieces of
well, only when you are deleting massive amounts of data or truncating
with drop storage.. then there is an impact because of the hits on the
dictionary tables.
but basically yes... I've been told by various Oracle employees that up
to 4096 extents cause no problem whatsoever.
--- Christopher
On a logical level perhaps.
Try coding it. It will also be slow.
Perl is *much* faster for something like this.
Jared
On Tuesday 02 October 2001 06:00, Nicoll, Iain (Calanais) wrote:
I'm sure Perl would be more efficient especially as you don't have to name
the columns, but if you don't
Save undo is when a tablespace has undo information, but is currently
offline.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707)
That is not elegant and doesn't have a GOOEY interface.
It also requires the knowledge of SQL, which is a lot
to ask from a poor little DBA like me.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 12:21 PM
To: Multiple
read the oracle docs om error 54.
joe [EMAIL PROTECTED] 10/02/01 12:40PM
Hi Guys,While running a job(with lot of updates)in oem i get
this error:ORA-00054: resource busy and acquire with NOWAIT
specified.data base is 8.1.7 on NT.please help me how to fix
it.Sunil NookalaDell Corp.Austin,
Can I somehow use a variable for the table name in a cursor select?
Here is the example:
--Declaration Section
sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_'
||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC';
--cursor for tmo daily source records
CURSOR cTMODaily IS
SELECT*
Sunil,
Depends on what your job is doing. From the error message I would expect
that it needs an exclusive lock on a database object that someone else is using.
Please post the code.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date:
Hi,
Have you checked OPTIMIZER_FEATURES_ENABLE?
oli
[EMAIL PROTECTED] wrote:
hello i've update my database from 8.1.7 release 3 to 9i
and now following statement don't use my optimizer hint in 9i (in 8i it
works)
upper_artikel_kurztext_idx is an function based index
select /*+
Back in the V6 days it was a desired characteristic to have every thing in the
first extent of an object for performance reasons. Thankfully those days are
gone and it really does not matter how many extents there are. Rachel has a
presentation on Oracle Myths where she actually portrays having
Use DBMS_SQL or EXECUTE IMMEDIATE
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North,
Erik - I believe the upgrade / recovery manual will have the more concise
definition you seek. Look for the Oracle version you are on and the one you
want to move to and it will tell you whether you need to upgrade or migrate.
With an upgrade you usually just bring up the new version and run some
Hello
Can you please clarify the relation
between 'save undo headers' and Billy Graham.
If making a joke out of what is 'unplatable'
or 'inconvenient' to believe is comforting you
by all means go ahead.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Hello Everybody
I am here with a question, please help.
I am running 7.3.4.4 on our two different departments
and sales deaprtment runs dblink and snapshots to
refresh from the central department. Both department
running 7.3.4.4
Core Central department upgrading the database to
8.1.7.
Now,
Yea - I keep hearing and seeing tests that show that the number of extents
had no bearing on performance (up to a point). It just 'bothers' me to see
a 500 or 1200 or 2000 extents on a table.. grin
Here is a question - is there any situation that having only 1 big extent
would reduce
that's not an oem problem per se... but is related to the fact that you
are trying to update a row or table that is already in use
review the updates and order of updates you are making. Is anything
else running at that time?
--- [EMAIL PROTECTED] wrote:
Hi Guys,
While running a job(with lot
On Mon, 1 Oct 2001, Dash, Saroj (CAP,CEF) wrote:
When you take begin back up of tablespace what exactly oracle does
internally.
what happen the transcation in that period.
Check out my hot backup article.
http://www.speakeasy.net/~jwilton/hot-backup.html
--
Jeremiah Wilton
Jun,
What exactly do you mean that it doesn't work after the first inner loop?
One thing you should do is close and open the inner cursor after the inner
loop completes.
Are you sure the outer loop returns more than one row?
Tom Mercadante
Oracle Certified Professional
-Original
Hello all,
I want to load in ther server two jar files, through the loadjava
utility. But, where should be this files physically stored? Should they
be in any folder under ORACLE_HOME directory?
A lot of thanks in advance
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
Yes. If you need to do parallel query, multiple
extents may help you out a bit.
Jared
Steve Smith
On Tue, 2 Oct 2001, Ron Rogers wrote:
Some reasons why NOT to put all tablespaces in the backup mode at
once (step 1) is that the tranactions against the database could
create a lot of redo and archive logs that could fill the space,
tranaction time could be longer as it now reads the redo
I am trying to find an environment variable that returns the current
session's SID. I see things like ora_login_user but can't find anything SID
related. Basically I want to take a statspack snapshot using the SID of the
current session. - E
Yep - here's an example. There is really a whole lot more that goes with
this, but I've included the pertinent portions so you can get an idea.
Hope this helps.
SET DEFINE OFF;
CREATE OR REPLACE PROCEDURE Student_Course_Report(
fromSchool varchar2,
toSchool
Thank you very much.
Your answers explained everything about explicit and implicit cursors.
At 07:00 2001.10.02. -0800, you wrote:
You can do all three, but if you do not declare it you can't use the 'for
update
of' clause. Of course the 'for i in ()loop' does replace a lot of lines of
code.
Hi
We are using IFS 1.1 version on HP UX. Large number of XMl documents are
loaded into IFS ( around 5.5 gb of table space occupied).
Our req. is , given a file name , we need to lookup for the same in IFS
repository and load it if exists. Search is based on file name ( attribute
search) not
something along those lines...
as with everything there is no real black or white on this... but
transactional systems that do a lot of small (non-sequential) reads you
are better off with lots of extents while data warehouses are often
better off with fewer extents as the reads tend to be
I have designed systems on Sun Solaris Cluster (1.2 and 2.2) with OPS (7.3.x and
8.1.x) that used EMC snapshots (BCVs and SRDF), but not Windows 2000 clusters,
DELL, or HP. Those used BCVs for backups of OPS databases and worked well.
Since the EMC snapshot was performed at a layer common to all
netstat -in
Will also tell you if there are any other assigned ip
addresses to that server, for example in a cluster
configuiration.
Regards,
Satar
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
How to find out a server (solaris) IP address, that
I logged in .
Doesn't matter, they get loaded into the java tables as lobs.
As long as the loadjava command has access to the file when you run it.
You can then delete the files if you so choice.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a
Migrating is the process of transforming one database version to a later
database version. Oracle 7 to Oracle 8
is migration.
Upgrading is the process of transforming one database release to another
database release of the same database
version. Oracle 8.0.1 to 8.0.5 is upgrading database.
HTH
I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install
the 8.1.7.2.1 patchset according to the readme directions (shutdown all
Oracle* services first, etc.), but when I try to run setup.exe, nothing
happens. The icon flashes momentarily after being double-clicked, but
Jun the corrected code should be ... assuming you want to process channel_id
for each row of pla_id.
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where
The reasons this doesn't work are fairly numerous. What is it you're
trying to accomplish here? Perhaps if you could explain your requirement,
somebody could help you out. I'm quite surprised you were able to get a
version of this to compile and run even if you did use a 'FOR' loop. Is it
Title: Oracle - SQL Server
I know there is a way in SQL server to query oracle tables, is there a way to do the reverse?
I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database.
Anyone have any ideas on this, I searched technet
SELECT s.study_id, s.status, sp.status
FROM s, sp
WHERE s.study_id = 5014
AND s.study_id = sp.study_id(+)
AND s.status = 'A'
AND sp.status = 'A'
I'm stuck trying to figure out how to make this SQL work, and am starting to
wonder if it's even possible.
I'm trying to get this SQL to
That's fine, but I would look into using the nohup
command to solve error issues and to report any
errors.
Regards,
Satar
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi Lists,
Shall I close the unix session after submitting my
job (compressing the
dmp file after
From the performance perspective, you can safely
ignore the save undo statistics.
Anyone know where I can find a list of the v$sysstat, v$system_event and
v$session_wait items I can safely ignore?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET:
I didn't mean to offend anyone and I apologize if I did so.
By the way, it's spelled unpalatable and not unplatable.
-Original Message-
From: Cyril Thankappan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE:
Guy,
I assume the database involved in 8.0 or higher :) Starting 8.0, the
control files retain the list of archive logs in addition to recording both
the list of database and redolog files. In fact, I found that it retains a
list of backup controlfiles too... The list size for archive logs
Or use a cursor variable.
Jared
Christopher
Title: Oracle -> SQL Server
I have
not used it but Oracle Transparent Gateway can query against a SQL Server
database. This is a very expensive product.
Rick
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41
PMTo:
I had that same problem with it. I ended up getting it to work OK when I
navigated into the directory structure that the zip file creates (or on CD,
whichever you're running it from) into patch_base\install\win32\setup.exe
and ran it from there. This actually runs the OUI instead of the
Never mind - please ignore. Sorry for bothering. Brain fart.
-Original Message-
Sent: Tuesday, October 02, 2001 2:01 PM
To: Fatcity's Oracle ListServ
SELECT s.study_id, s.status, sp.status
FROM s, sp
WHERE s.study_id = 5014
AND s.study_id = sp.study_id(+)
AND s.status = 'A'
Part of the code must be missing because plan_id cursor is being
open/fetched but NOTHING done with it.
Rick
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
The reasons this doesn't work are fairly
Okay, I'll preface this by saying we did find a work around but this
was strange and I wondered if any of you had run into this.
Background:
two 8.1.6.0 databases, one is Solaris 2.8 32 bit and the other is
Solaris 2.6
the local database is on the 2.8 machine, call it users
the remote database
When using the Oracle Migration Workbench in Oracle 8.1.7, the SQL Server 7
Source Model generates 6 errors. I then fix those errors and generate the
model again. The problem I have is when I actually Migrate to Oracle.
This procedure generates 69 errors. How can these errors be fixed? Am I
doing
In PL/SQL, if I need to know if I've fetched the last
row, I can do this:
IF recCursor%NOTFOUND THEN
...
...
END IF;
How would I do this in Perl? Looking at the DBI docs,
there does not seem to be a similar method. It
suggests doing a COUNT(*) or possibly use the
following:
$hash_ref =
Ron,
An outer join on sp.status will only return records from s if no records
exist in the sp table.
If a record exists in the sp table, it HAS to be a value of 'A'.
I suggest he drop the 'and' clause altogether.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
I found out the session which kept the table locked.
killed it, jobs run fine now.
thanks for help.
Sunil Nookala
-Original Message-
Sent: Tuesday, October 02, 2001 12:37 PM
To: Multiple recipients of list ORACLE-L
that's not an oem problem per se... but is related to the fact that you
Same problem, go into the install directory and Win32 I think it was, the
install works fine from there.
Just shear luck I just setup two Win2000 boxes in my lab for Replication,
heh.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a
1 - 100 of 180 matches
Mail list logo