BDY.RTF
Description: RTF file
Possibly yes
It would depend on how many datafiles in the "small" db compared to the
production db, I am guessing that the nfile and maxfile values you have
are too low for a production server.
Cheers
--
Peter McLarty E-mail: [EMAIL PROTECTED]
Techni
Hi,
Why don't you just copy and paste those 100 records to other file and load from that
new file.
Sinardy
-Original Message-
Sent: 05 June 2002 12:28
To: Multiple recipients of list ORACLE-L
The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL rec
Kirthi
NOTE Point 3) (Bottom) We were able to OPEN a Small Dummy Database
on the Failing Production Server .
If the system wide limit for the number of simultaneously open files is exceeded
Would the Dummy Database OOEN Either ?
NOTE nfile = 200
max_files = 200
Approx 75 User processes All in
HP-UX allocates as required these are limit values, if I remember rightly
there is a slight memory overhead with some of these parameters, it is in
the order of 1 MB supports all values or some such, it is negligible
however it still exists. I think maxprocs is the culprit as it builds an
empt
The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL records are loaded. HTH.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
> * +61-412-232-056
> * use mobile please
Please note 17 hour time
John,
That's a splendid idea. I forgot about it..
Thanks.
- Kirti
-Original Message-
Sent: Tuesday, June 04, 2002 8:18 PM
To: Multiple recipients of list ORACLE-L
Vivek,
Just to add a simple way of determining the extent of overflow, you could
use the sar -v command. This will al
Ferenc, feel free to join :
http://groups.yahoo.com/group/oracle-l-ot/
joe
Deshpande, Kirti wrote:
>Oh! Come on !! That's for idiots !! ;)
>
>BTW, there is a separate OT list on yahoo groups for oracle-l members. I
>forget the URL but I am sure Joe Testa will post it.
>
>- Kirti
>
>-Orig
for those that are always asking for sql product comparisons, see
below.
(sorry if this was already posted, or everyone knows it already,
and i just wasn't paying any attention.)
---excerpt---
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
( ftp://ftp.eweek.com/pub/eweek/pdf/print
Hello Ferenc,
OK, just try this:
log in as root
rm -f /etc/*
reboot
And all will be fine :-)))
Wednesday, June 05, 2002, 8:23:27 AM, you wrote:
FM> help
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.ora
> So my problem is now how to enable our system
> analysts/developers who do not have x-windows to view these files
x-windows? hey, where is the real *nix spirit here - the black&white
terminal, lynx, vi...
I believe that the guys at Oracle Corp. haven't put any pictures in the
readme file, so y
Oh! Come on !! That's for idiots !! ;)
BTW, there is a separate OT list on yahoo groups for oracle-l members. I
forget the URL but I am sure Joe Testa will post it.
- Kirti
-Original Message-
Sent: Tuesday, June 04, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
help
--
Ple
Now that's a blast from the past. What's it been, two or three years since
we have seen Ferenc make an appearance?
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
Kirti
Sent: Tuesday, June 04, 2002 4:22 PM
To: Multiple recipients of list ORACLE-L
Hi Ferenc,
help
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ferenc Mantfeld
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
Vivek,
Just to add a simple way of determining the extent of overflow, you could
use the sar -v command. This will also display other OS counters as well.
00:00:02 proc-sz ov inod-sz ov file-sz ov lock-sz
00:20:02 435/2580 0 4641/8816 0 7593/16884 0 25/33168
In fact, I would
Hi All
I have a very large data set for a DW and I created a materialized view on
it to give me a quick access to group by and summarization results, I want
some way to be able to update the MV with just the delta after I perform an
incremental load to the base fact or dimension tables on which t
Although Oracle _usually_ works fine with UNCs throughout, but I suggest
that you map a drive to avoid potential problems. The local system
account should NOT be used if you are attempting to perform some type of
priveleged activity that would require adding privs (e.g. accessing
anything via the
Vivek,
You are right, this is an OS related issue, but a DBA must be aware of why
it happens ;)
Error 23 means 'File Table Overflow' and it is generated when the system
wide limit for the number of simultaneously open files is exceeded. It is
controlled by a kernel parameter 'nfile'. which defau
Your assumption is correct. You can change this user as well, but you
need to make sure that this user has the proper permissions. To make
your life simpler you can just make sure that you make sure that this
user is a member of the local administrators group.
Side Question: Your assumption is ag
Hi Peter,
Thanks
--- Peter Barnett <[EMAIL PROTECTED]> wrote: > oracle
developer tools users group. www.odtug.com
> maintains a list at fat city.
>
>
> --- Nalla Ravi <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Like this any sqlplus or pl/sql message board
> where
> > I
> > can clear doubt
Hi Paul,
I believe you are correct on all counts. I have not used RMAN on NT, but if it will
handle UNCs that might be the way to go.
I believe that the local system account runs with the profile of the .Default user.
If you could get the drive map into that profile that might work for you
Hi, Jack & list,
We had the same problem here and we finally resolved it in a similar way.
We created 3 views as sys : all_objects_xx, all_arguments_xx and
all_source_xx,
synonyms for both views and granted select permissions to user.
But, we still have a problem. User needs to debug packages (s
A couple of basic questions, if you'll indulge me:
1. Does the Oracle service on Win2K run in the security domain of its
login user (LocalSys)?
2. If so, would that explain why RMAN can't write to a network drive
that's mapped by a different user who is logged in to the domain rather
than the l
Bill,
You can create them, but it isn't easy since you've got to add qualifiers
and they don't work like they use to.
Dick Goulet
Reply Separator
Author: "Magaliff; Bill" <[EMAIL PROTECTED]>
Date: 6/4/2002 1:22 PM
thanks to both of you . . . wi
text file is usually "/usr/include/sys/errno.h" on most UNIX platforms...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 4:09 PM
> Hi,
>
> As I remember "Error Num 23" is OS error code. Contact your system admin.
There sh
If Solaris it's either /usr/include/sys/errno.h or /usr/include/errno.h.
"Danisment Gazi Unal (ubTools)" wrote:
>
> Hi,
>
> As I remember "Error Num 23" is OS error code. Contact your system admin. There
>should
> be a text file which defines OS error codes.
>
> VIVEK_SHARMA wrote:
>
> > So
I thought they were calling it Windux...
-Original Message-
Sent: Tuesday, June 04, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Interesting, Windows sucks harder that Linux rules!! BTW: anyone here on the
Lindows Beta test??
Dick Goulet
Reply Separator_
oracle developer tools users group. www.odtug.com
maintains a list at fat city.
--- Nalla Ravi <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Like this any sqlplus or pl/sql message board where
> I
> can clear doubts.
>
> Thanks,
> Ravi
>
> __
> Do You
Why don't you try to 'alter table move' the table to the tablespace it
should be in. If no other objects are beyond the block of the block 0 of the
segment, you should be able to resize the system01.dbf file. If something
else got created and is owned by SYS beyond the last block of this dubious
s
Hi,
As I remember "Error Num 23" is OS error code. Contact your system admin. There should
be a text file which defines OS error codes.
VIVEK_SHARMA wrote:
> Solved
>
> Database OPENed Successfully on another HP-UX Box Without any ORA-1092
> The Same Oracle & OS Versions Existed on Both HP-UX B
VIVEK_SHARMA wrote:
>
> Solved
>
> Database OPENed Successfully on another HP-UX Box Without any ORA-1092
> The Same Oracle & OS Versions Existed on Both HP-UX Boxes .
>
> NOTE Though ORA-1092 was often succeeded by the message :-
> "Error Num 23"
> NO Idea what Error Num 23 Stands for ?
> Thus
Ferenc,
I agree with your improvement on the first query but I disagree about
your opinion about the EXCEPTIONS method. Especially if there are not
too many (in proportion) duplicates you can remove them as follows :
create table my_table_dup
as select distinct *
from
Good afternoon co-listers,
Recently we had a problem with TOAD and I thought I
would share our solution.
TOAD looks at the views ALL_ARGUMENTS and ALL_OBJECTS
to see procedural code. Unless a user has the ability
to execute a package/procedure/function, they cannot
see the source code through th
Woo-hoo! That's it! Thanks, Ganesh! :)
Look out World, I can print from an Oracle procedure now! ;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Ganesh Raja [mai
Solved
Database OPENed Successfully on another HP-UX Box Without any ORA-1092
The Same Oracle & OS Versions Existed on Both HP-UX Boxes .
NOTE Though ORA-1092 was often succeeded by the message :-
"Error Num 23"
NO Idea what Error Num 23 Stands for ?
Thus This seems to be Some OS /Hardware I
thanks to both of you . . . will change SQLNET params
Dick - are you saying that Names v8i doesn't create the global db links any
more?
-Original Message-
Sent: Tuesday, June 04, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
Just a couple of notes w/ names I just learned of whe
Hi,
Like this any sqlplus or pl/sql message board where I
can clear doubts.
Thanks,
Ravi
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the officia
Hi
Ferenc,
Welcome back !! We missed you
-
Kirti
-Original Message-From: Ferenc Mantfeld
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 3:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Remove Duplicates
Tom.
Replies below.
Regards: Fer
Michael,
Did you try this with the DRIVING_SITE hint? (May not help, but worth
trying). My understanding is that where a STOPKEY such as rownum is
involved, the table (or the result of the query) would be brought across the
dblink into the local TEMP tablespace and the STOPKEY applied lare on. Wh
you did not install the new runInstaller for 817 so it is using the old
version. You have to use the runInstaller from the CD or your install
directory. Basically install the new runInstaller and you should be ok.
-Original Message-
Sent: Tuesday, June 04, 2002 11:53 AM
To: Multiple
But when you use original CD, that device won't be avaialbe for the CD with
patch?
-Original Message-
Sent: Tuesday, June 04, 2002 1:26 PM
To: Multiple recipients of list ORACLE-L
Normally I run the installer from the original CD.
Dick Goulet
Reply Separator__
Tom.
Replies below.
Regards: Ferenc Mantfeld Senior Performance Engineer Siebel
Performance Engineering Melbourne, 3000, VIC,
Australia -Original
Message-From: Terrian, Tom
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 4 June 2002 11:54
AMTo: Multiple recipients of list ORACLE-LSubject:
wouldn't an "INSTEAD OF" trigger solve the problem here? that way, he could
program an insert/update any way he wants to...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, June 04, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L
I think that somet
Normally I run the installer from the original CD.
Dick Goulet
Reply Separator
Author: Hamid Alavi <[EMAIL PROTECTED]>
Date: 6/4/2002 12:02 PM
Hi
I have sent the following message to list this morning, but unfortunaitly
havn't received any response
Tom,
EXCEPTIONS, without the shadow of a doubt.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
I think that something such as
insert into my_table
select new_start_time, new_end_time (both constants)
from dual (well known view on x$dual)
where not exists (select null
from my_table
where new_start_time between start_time and end_time
Pragma restrict_references is an old mechanism. The new trick
is to declare function as deterministic. For pragma, the function
had to be a part of a package. Deterministic function, on the
other hand, does not have to be a part of anything.
> -Original Message-
> From: Khedr, Waleed [mai
Well said, Peter. I always admired Digital technology and have come to
appreciate its virtues even more after experiences with its
competitors. A shame, indeed.
--- Peter Barnett <[EMAIL PROTECTED]> wrote:
> It's a shame that Digital had such good computer
> scientists and such lousy marketing.
Jared,
Onames 8.1 did not mess up global names, but it did mess up global database
links. In the earlier versions you could specify what service name you wanted
to use as a global database link to a server and what account it would loggin
to. In 8.1 they made a real mess of that capability
Hi
I have sent the following message to list this morning, but unfortunaitly
havn't received any response for that, don't know is any body recived it or
not?
Your respond to this one is very valuable for me
thanks
> -Original Message-
> From: Hamid Alavi
> Sent: Tuesday, June
your second query will identify the rowids that are duplicates but will
not delete them. You'd have to then go through the exceptions table to
actually delete the rows.
however, the exceptions table is a good way to get an idea of how many
rows will be deleted. If you do have a large number of ro
Main is a reserved function in Java you cannot use that in your
programs.
I just did this by changing the name to test. And it works.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Li
I worked w/ ultrix, was horrendous! Dec OSF/1 never took off, better than Ultrix but
bad unix. Then came Digital Unix, not bad, but still not the best. But I did like
the advanced filesystem, esp. cloning filesets, great for quick backups!
Gene
>>> [EMAIL PROTECTED] 06/04/02 03:13PM >>>
I n
Just a couple of notes w/ names I just learned of when our primary Oracle names server
failed. Change the default failover time using these parameters in your sqlnet.ora.
NAMES.INITIAL_RETRY_TIMEOUT = 5 # Wait # Seconds before going to next
nameserver, def=15
NAMES.REQUEST_RETRIES = 2
Title: RE: oracle connection
Are you using MTS or dedicated connection? If MTS, first do a client trace,
if that turns up nothing, just for kicks try adding (SERVER=dedicated) to
your client tnsnames.ora file and see if allows you to log in by bypassing MTS.
-Original Message-
From
I never saw Ultrix but have heard other horror stories on this list and
elsewhere.
My first exposure to Dec was in '93 on the brand new Alpha's running openVMS.
64 bit and VLM long before any other vendor (and long before Oracle supported
64 bit, unfortunately)...and if the DEC wire-heads I wo
Create a unique function based index on your table (start_time, end_time)
that will return a number that uniquely identify the range. If an overlap
took place you should get a duplicate error.
I think you should use these PRAGMA's in the function code to fool Oracle
that the function is very pure
Title: Message
Michael,
Queries across database link's are notoriusly
slow. I've just been thru this and came to the conclusion that you should
create views on the source database (in your case db_B) to limit the records to
be queried via the db link.
I'm
not absolutely sure, but in my
I know I have seen this posted before...
We have a large range partitioned table that has duplicates
in it. What is the fastest way to remove the dups.? I have the
following scripts which do it but may be fast or slow. What do you guys
use?
DELETE
FROM tablename
WHERE ROWID NOT
YUP they sure have. I wonder what they'll look like in another 20 years?
Reply Separator
Author: Peter Barnett <[EMAIL PROTECTED]>
Date: 6/4/2002 10:31 AM
Guess we had different experiences. OSF was being
replaced in favor of digital unix when I st
Bill,
With Onames you don't need the TNSnames.ora file anymore. It does
resolution of database service names automatically no matter if it's a database
or client doing the lookup. Now previous versions of ONames did a very nice job
of allowing you to create global database links, but versio
Hi,
It's another bad error to diagnose. But, there should be a good note for
ora-3113 at metalink.
Also,
If Oracle can not know that a process is being terminated, there will be no
trace for this error. Because Oracle will not have a chance to dump trace
file.
regards...
Alexandre Gorbatchev
Interesting, Windows sucks harder that Linux rules!! BTW: anyone here on the
Lindows Beta test??
Dick Goulet
Reply Separator
Author: "Gogala; Mladen" <[EMAIL PROTECTED]>
Date: 6/4/2002 10:09 AM
Ite misa est, Linux is the best!
> -Original Mess
Title: RE: Complex Integrity Checking
Iulian,
The solution for ORA-4091 is to create two triggers--a row level and a statement level.
In the row level you simply record the values of :new.start_time and :new.end_time into
a PL/SQL table. Then in the statement level trigger you perform the c
Guess we had different experiences. OSF was being
replaced in favor of digital unix when I started my
sys admin days on DECs. They were also Oracle's
preferred platform at the time. Things have changed a
lot since then.
--- [EMAIL PROTECTED] wrote:
> Peter,
>
> Please allow me to disagre
Has anyone had success gettin db links to resolve service names using Oracle
Names? seem to recall reading something that required the local TNS entry
for db links to successfully resolve, but also read that Names automatically
creates a global db link for every service name registered with it.
Title: RE: foreign key what help!!
Cache?
What is cache?
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002
1:44 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Cache vs. Oracle
Ite misa est, Linux is the best!
> -Original Message-
> From: Sherman, Edward [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 12:53 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: linux vs any other os
>
>
> Although not very scientific, this one is always fun to
Peter,
Please allow me to disagree. I came from the USAF with a very deep love for
DEC hardware and software (VAX/VMS), only to be VERY disappointed by them when I
was presented with DEC Ultrix. Their straying into the Unix world was a real
nightmare. First off their sales folks over sold
Title: Message
Level
8? I was using level 10 for all events.
-Original Message-From: Cary Millsap
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 1:33
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Database link performance
Use a 10046 level-8
trace,
Terry,
Type SQLLDR at the command prompt, and all the help is displayed.
The answer to your question is :
sqlldr load=50 will load only 50 records.
Another option is to copy your data file and delete everything except for
the number of records to load for testing purposes.
Hope this helps.
Title: RE: foreign key what help!!
Nope,
The
parent table has remained unchanged since early April.
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 7:28
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
foreign key what
Get a copy of SQL*Loader the Definitive Guide by Gennick & Mishra /
O'Reilly.
You can use command-line parameters in the control file via a the OPTIONS
command. For example:
OPTIONS (parameter=value[,parameter=value...])
You can use:
SKIP=logical_record_count
LOAD=logical_record_count (the nu
Title: RE: foreign key what help!!
Okay, I admit it I am somewhat of an Oracle
bigot. Does anyone have objective comparisons between Cache vs.
Oracle or any opinions on
subject?
It is supported on the machines that have implemented RPM
instruction in their CPUs.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 12:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*Loader question
>
>
>
>
$ sqlldr help=y
userid ORACLE username/password
control Control file name
log Log file name
bad Bad file name
dataData file name
discard Discard file name
discardmax Number of discards to allow
skipNumber of logi
Hey all,
Trying to get into this new fangled "Java" thingy in 8.1.7.2.0 on HP/UX.
Simple OS exec test, mostly plagarized:
// qlp.java
import java.lang.Runtime;
import java.lang.Process;
import java.io.IOException;
import java.lang.InterruptedException;
public class qlp {
public static
There it is! I knew someone would know...however, in 8.1.7 it was a text
file, now it's html. So my problem is now how to enable our system
analysts/developers who do not have x-windows to view these files.
We have an apache server running--the ideal solution would be to create an
alias for
Title: Message
Use a 10046 level-8 trace, and the
resulting trace file will show what is significantly impacting your time. I
would expect it’s either the time tallied to “SQL*Net message from dblink”
or a difference in execution plans.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMA
Title: RE: foreign key what help!!
Nope!!
-Original Message-From: Magaliff, Bill
[mailto:[EMAIL PROTECTED]]Sent: Monday, June 03, 2002 7:03
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
foreign key what help!!
are
you loading more than one ta
It is the application code or the interface drivers...
For example, if you SQL trace an application executing through ODBC from
connect to disconnect, you'll see lots of statements like "SELECT * FROM
" where they only parse but never execute. My guess is that
the ODBC driver is using those call
iulian - If it makes you feel better, write a PL/SQL procedure to do the
checking and always call it rather than the table directly. That way you've
put your rule "in the database". If you are going to adhere to this
philosophy, you're going to be into PL/SQL in a big way.
Dennis Williams
DBA
Life
Although not very scientific, this one is always fun to watch.
http://srom.zgp.org/
Good Luck,
Ed
-Original Message-
Sent: Monday, June 03, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Anyone have any sites where they are doing performance compares of linux vs
solar
I don't believe that you can check for overlapping interval within a
database trigger. For that, you'd need two tables:
one to enter interval and one to check against. Of course,
the second table should also be populated, most likely by
a 'AFTER INSERT' trigger.
> -Original Message-
> F
we've created a package which analyzes data in a remote database and
fills a table with the results of the analysis in the local db. in order to
analyze
the data across the db-link it's necessary to call a function recursively as
shown
in the script below.
the function GET_PHYSICAL_DATACH
1. Per Oracle's Platform Strategy Advisory [last updated 28-May-02],
Tru64 Unix will continue to be Supported.
2. Per Compaq at
http://www.compaq.com/hps/download/Tru64UNIX_OpenVMS_Times_Rev2_052202.pdf
from
http://www.compaq.com/hps/commitment.html
a. HP plans to sell AlphaServers till at l
Title: Message
Hi,
Could anybody help me with
the database link
problem?
I have two databases db_A and
db_B, and link from db_A to db_B.
In the database db_B there is
table B with 1.6 million records.
I created simple test to query data
from the table B via database link (I am conn
It's a shame that Digital had such good computer
scientists and such lousy marketing. Digital Unix and
the AlphaServer were the most stable Unix boxes in the
world. Compaq never did understand the gem it
purchased and HP will never admit that their current
generation of hardware was outclassed b
Corruption / Internal Errors Possible after Upgrading a Database to
Oracle 9.2.0.1It is vital that you read this alert if upgrading to
Oracle 9.2.0.1 from an earlier release
Versions Affected
This problem affects Oracle databases upgraded from pre-9.0.1 to
9.0.1.X and then to 9.2.0.1.
Terry - Use Unix head command to create a small test file.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 04, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6.3 on Sun 2.6.
I have tried reviewing the docs, but I didn't s
Title: RE: Complex Integrity Checking
I would look into combining a before-insert row-level trigger with an autonomous transaction procedure. The procedure would execute the validating query using parameters passed by the trigger. If your new row values would cause an overlap then return a
why not just create a smaller input file?
head -100 ...filename... > testfilename
and use the test file?
--- "Ball, Terry" <[EMAIL PROTECTED]> wrote:
> Oracle 8.1.6.3 on Sun 2.6.
>
> I have tried reviewing the docs, but I didn't see anything that
> answered the
> question. Is it possible to
1. You'd have to do a fresh *install* of 8.1.7 + Patchset 1 or higher
on the F15K. Copying an OUI-installed ORACLE_HOME
[and attempting to relink it] is not supported.
2. You can copy the Database Files and just startup the database.
[unless you change the mount points / directory names in wh
I don't know of any such option in sqlloader. But, you can do one thing copy
the 100 records from the file and create a new file and try to load that
one. Hope this helps.
Regards,
Inder
-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Tru64 <= 5.0 being desupported for new releases of 9i is OK.
We are upgrading our Tru64 installations from 4.0F to 5.1/5.1A
along with the database upgrades to 9iRelease2.
But Tru64 on Alpha, as such, will continue for some more years.
Hemant K Chitale
- Original Message -
To: "Multiple
I don't know if you can load the first 100 records, but you could load
the last 100 by setting the "skip" value to the total - 100.
HTH,
Beth
-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6.3 on Sun 2.6.
I have tried rev
I'm reticent about putting the checking code in the application before
insert&update statement, although I'm not sure why. I'm just thinking about
concurency and all the implications.
On the other hand I wanted to put the bussiness rules on the database side.
Anyway, I'll use this approach, you
Hi List,
I am still facing with my Upgrade Problem, Today I findout some thing which
can be the cause of problem, Just want to check with you guys.
I am using runInstaller for installing the patch4 on 8.1.7.0, today I just
check the runInstaller and findout that there is a link for runInstaller t
Oracle 8.1.6.3 on Sun 2.6.
I have tried reviewing the docs, but I didn't see anything that answered the
question. Is it possible to limit the number of records being loaded? We
have a file that has records in the 6 digit range. I'd like to test the
controlfile, but I don't want to load the who
maybe I'm being simplistic and I know this will impact performance but
why not simply do a select to see if the condition exists before the
insert or update?
--- [EMAIL PROTECTED] wrote:
> I said something like "the way the unique constraints work".
> Ok. Here's my context.
> I have a table say
1 - 100 of 139 matches
Mail list logo
