Probably your clients or the users have in their
sqlnet.ora the parameter use_dedicated_server=TRUE or
in the entry of the tnsnames.ora a clause like
(SERVER=DEDICATED).
Also issue an netstat to see if everything is alright.
If you find any problem with the ports of the
dispatchers, try forcing
That's precisely the point - we have a bunch of system-generated names
that we'd like to change to meaningful names...
g
-Original Message-
Sent: Tuesday, July 24, 2001 2:32 PM
To: Multiple recipients of list ORACLE-L
g,
Why use system generated FK names. does SYS12345 maen any thing
list,
in my rs/6000, i found the following...
# lsdev -Cc adapter
ascsi0 Available 00-06Wide SCSI I/O Controller Adapter
ascsi1 Available 00-07Wide SCSI I/O Controller Adapter
# lsdev -Cc disk
hdisk0 Available 00-06-B1-2,0 16 Bit SCSI Disk Drive
hdisk1 Available 00-07-A1-3,0 16 Bit SCSI
Mark,
RCMD from the Resource Kit for NT4, and presumably for W2K, might provide a
solution. I have not used it myself so can't comment on it's operation etc.
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
Can someone please explain how to monitor latch free waits on LIBRARY cache
and provide examples of using bind variables. THE PL/SQL reference does not
seem to make much reference to bind varaiables
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
Hello List,
I would like to know any statement to know which 'object directory'
exists in the oracle instance, for a specified user.
TIA,
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de Boecillo
How many Characters(Alphanumeric) can be inserted into a Field of
Datatype LONG ?
Why ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
A helicopter was flying around above Seattle when an electrical
malfunction disabled all of the aircraft's electronic navigation and
communications equipment. Due to the clouds and haze, the pilot could
not determine the helicopter's position. The pilot saw a tall building,
flew toward it,
Dear All,
Can anyone of you help me for the following.
I want to give a generalized SQL syntax for Outer Join for both oracle SQL
server. Can I use ANSI Syntax say for example
select empno, ename
from emp
join dept on emp.deptno = dept.deptno (Something like this)
Bye
Sundar
--
Please see
list,
i just ported a system to 8.1.5, the application DOES NOT make use
of bind variables, each and every query (fired from 8 clients every 2-3
seconds)
parses and executes, this keeps the shared pool patch also very busy...
i cannot tune the app, is there something i can do to reduce the lib
Rahul
You may need to rebuild the system completely depending on what is
currently on those disks.
On the other hand if you are using something similar to the HP Logical
Volume Manger then you may be able to drop that volume out with out
deleting the contents and when you reboot the system
Character data of variable length up to 2 gig. The length of LONG datatype
values may be limited by the memory available on your computer.
Dave
-Original Message-
Sent: Wednesday, July 25, 2001 6:56 AM
To: Multiple recipients of list ORACLE-L
How many Characters(Alphanumeric) can be
Jack,
I was going to suggest, what you did, but then I noticed the version Rahul
was using.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 5:58 PM
Why don't you try it?
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 8:35 AM
Dear All,
Can anyone of you help me for the following.
I want to
Thanks for all replies.
Suren
-Original Message-
Sent: Tuesday, July 24, 2001 5:58 PM
To: Multiple recipients of list ORACLE-L
Handbook of Relational Database Design by Candace C. Fleming and Barbara
von Halle is pretty solid.Not sure if its still in print or not though.
Listers:
Solved my own problem and thought I would share the solution
with you all.
To find the name of a user-defined lock:
SELECT s.sid
, s.serial#
, DECODE(
s.process
, NULL, DECODE(SUBSTR(p.username, 1, 1), '?', UPPER(s.osuser),
p.username)
What is required to submit a paper/presentation to IOUGA and get excepted.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, July 24, 2001 8:41 PM
To: Multiple
Set your time_statistics=false i think this is a bug in 8.1.5 we had the
same issue.
and also I am not sure whether you can set cursor_sharing=force in 8.1.5 if
yes try this out this will convert all the literals to bind variables
From: Rahul [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
I
don't remember in ODBC/OLEDB, but in JDBC there's quite a nice streams interface
to CLOBs. You open the CLOB, then just read it as any other stream, for example
as if it were a disk file, using the CLOB as a handle rather than a file
descriptor.
g
-Original Message-From:
Depends on if it's a user-defined exception or not. : )
Seriously, I presented for the first time at IOUG-A 2001. I submitted a topic
by the deadline date, which contained a brief ( 250 words, I believe) synopsis
of what I wanted to speak about. The accept/reject decision is made from that
You can use Materialized Views in Oracle 8i to load data from one database
to another (via the DB link) either manually or at scheduled intervals.
David
David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide Inc.
4815 Emperor Blvd., Suite 110
Durham, NC 27703
Tel. (919)
I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of
an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the
file itself, plus adding a pipe (|) sign for a delimiter, and save the IP
address as a file name with a .dat extension, before loading the
Maybe some spelling errors in the abstract -:)
Alex Hillman
-Original Message-
Sent: Wednesday, July 25, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
What is required to submit a paper/presentation to IOUGA and get excepted.
Walking on water and developing software from a
Title: RE: Data load options
Hi Sean,
Others have given you different options. Here's some considerations:
1. SQL Script.
Can be SLOW
May require intermittent commits in your script
Manual and error prone
Must go through SQL engine
2. SQL Loader
Can be very fast (direct - bypassing
Sean,
Depends on what the data is, volume thereof, do you need real time loading,
etc... We use to use SQL*Loader, but found a lot of problems scrubbing bad data
from our testers during the load process as well as other problems.
Consequently we now use Pro*C exclusively.
Dick Goulet
...just kidding, thought that would get your attention.
But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L?
I'd like to chat w/you if so.
Thanks!
- Ross
p.s. hmmm...maybe there *is* a bug in AIX and that's one of
the things I'll learn:-)
-Original
to submit a paper, you just need an idea, a title and an abstract. The
abstract needs to be somewhat catchy, the idea should be relevant and
something that might interest attendees (anything on version 6, Oracle7 or
Oracle8 is not a good idea G).
To be accepted (to be excepted would be to be
Hi,
COPY command.
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 04:16 AM
To: Multiple recipients of list
Ethan,
Is it possible for you to use your function instead of decode? I guess
that way you can evaluate situations wherein decode would not work. That way
you could have it work on older versions of Oracle.
Shailesh
-Original Message-
Sent: Tuesday, July 24, 2001 1:29 PM
To: Multiple
Title: Blank
Hi,
Does anyone know about the Oracle Certified
Instructor program. I looked in the Oracle site and didn't found
anything.
Regards
Ramón Estévez
(809-565-3121 x
225
- [EMAIL PROTECTED]
Blank Bkgrd.gif
Hello Rangachari,
Oracle9i supports the ANSI join syntax. I just finished an
article on it that should appear in the Nov/Dec (I think)
issue of Oracle Magazine.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
Jon,
User defined locks do not lock anything, except a very small chunk of the
SGA, part of the shared pool. Now the question is: is the procedure hanging
while holding the UL or while trying to acquire the UL? A UL must be acquired
by using the DBMS_LOCK package, namely the
Title: RE: OT, WOW really early
For those of you who have been speakers before,
there appears to be a new wrinkle in the
submission process. They now want an outline of
the presentation submitted along with the
abstract. I don't remember submitting an outline
for past conferences.
Guy Hammond wrote:
Is there a web site where we can submit bug reports for MetaLink
itself?!
yes you can submit an iTAR on metalink.;-)
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program
My experience with getting data into Oracle on an NT platform.
If a small number of rows are being inserted or updated, use an application
or SQL script.
If the data already exists in some form outside of Oracle, transform the
data into some form of a flat file and use SQL*Loader.
If the data
Hi,
I have configured the server to use MTS and still dedicated connections r
used.
What might be the reasondatabase is 8.1.6.3.4
LSNRCTL services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
ora2000 has 6 service handler(s)
Hydrocodone Acetaminophen. Pain reliever for DBA's most probably; at present
jobsite we get dosage of Prosac when we swipe our access badges.
--- Hallas John [EMAIL PROTECTED] wrote:
Go on then Lisa, I rise to the challenge
For us UK based listers what is Vicodin?
John
Jon,
Your right, thanks. But for the edification of others who may not be using
user defined locks today, here is the results of Jon's query from one of my DB's
that does use them:
SIDSERIAL# PROCESS USERNAME TERMINAL
-- --
Mark,
If you have the Resource Kit you can also use NETSVC.EXE.
If you do not, you may download freely from microsoft the
Resource Kit Support Tools which contains SC.EXE.
HTH
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL
Christopher Spence wrote:
What is required to submit a paper/presentation to IOUGA and get excepted.
brains, knowledge and skill? or sheer luck?
all i have to depend on is the luck part.;-) now to figure out if it's
good or bad.;-)
--
Bill Shrek Thater Certifiable ORACLE DBA
Telergy,
Chris,
I don't think anyone is disagreeing with your evaluation of what SHOULD be
done (emphasis on purpose).
But, you have to deal with the people and politics of the client. As I said
before, it sounds like something else is going on in the organization, and
someone decided to pull and
Since you have so many files, you are likely to hit problems with the line length of
the various shells. Assuming that all of the files are in the directory
/usr/myfiles and that the script mentioned below is named cvtip, is executable and
is in /usr/local/bin (or some other directory in the
Title: RE: Data load options
Cheers
John, I wason the verge of asking myself
-Original Message-From: Hallas John
[mailto:[EMAIL PROTECTED]]Sent: 25 July 2001
15:57To: Multiple recipients of list ORACLE-LSubject:
RE: Data load options
Go
on then Lisa, I rise to the
Title: RE: UNIX SCRIPT ISSUE - URGENT
No unix expert but the first option can be achieved automatically
by running the following script
for filename in `ls *.file`
do
unix script as listed
done
Rename a couple of the files and try out the syntax and work out the timings.
Once it all
for i in `ls`
do
YourScript.shl $i
done
Unless you are also processing your newfile.dat in the script you need
to make unique names for the output files.
Something like:
sed s/Report by Hosts/$IP| Report by Hosts/ $FN new_${FN}.dat
so you will get an output file from each input file.
ouch it hurt my brain :)
joe
[EMAIL PROTECTED] 07/25/01 11:16AM
"Oracle 9i XML Web Apps for Wireless ERP/CRM Support in
Deep DB2/SiebelTerritory"Is that catchy enough? Something you
can sink your blueteeth into?;-)-Original
Message-Sent: Wednesday, July 25, 2001 10:52 AMTo:
select * from user_objects;
-Original Message-
From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
Subject: statement for directory objects
Hello List,
I would like to know any statement to
Title: RE: Data load options
Go
on then Lisa, I rise to the challenge
For us
UK based listers what is Vicodin?
John
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: 25 July 01
15:26To: Multiple recipients of list ORACLE-LSubject:
RE: Data load options
Andrea,
Look at the last line of your procedure. I'll bet you a dozen donuts that
you do not have a carraige return after the last line of typed cdode, and
that the last line of code is 35 chars long.
Simply add a carraige return at the last line.
hope this helps
Tom Mercadante
Oracle
Lisa,
SQL*Loader in direct path can cause you storage problems since it always
appends to the table(s) ignoring blocks on the free block list. I found that
out after a developer was using it for our data warehouse. At the end of a year
he had burned almost 100GB of disk it kept increasing
Title: re-archiving a redo log file
Is it possible to re-archive an already archived
but still online redo log file?
the 8.1.6 sql*plus manual says it is, but
I can't get the syntax down right apparently.
SQL archive log 227
returns a ORA-16013 (does not need archiving) error
and
SQL
Is there a web site where we can submit bug reports for MetaLink
itself?!
-Original Message-
Sent: Monday, July 23, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
Is it me or everyone? Is Metablink working for anyone this morning ?
--
Please see the official ORACLE-L FAQ:
Hi All
I had a long PL/SQL prg to run .
I created a special rollback segment for that script with the storage of
(initial 1 m next 1m minextents 2).
After a few minutes of running I got the Snapshot too old error.
In the v_$rollstat view I got : extents=2, rssize ~ 2 M, hwmsize ~ 2 M.
Check the client's sqlnet.ora. It can override the server config with
USE_DEDICATED_SERVER=ON setting.
Steve
-Original Message-
Sent: Wednesday, July 25, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L
Hi,
I have configured the server to use MTS and still dedicated
Hi Jon,
Thanks for your reply. I am aware of this option and I am currently doing
the same way(i.e.,analyze database and delete SYS schema stats).
But, I was wondering which release of 8.1.7 fixed this problem since Oracle
claims that it is fixed in 8.1.7.
Excerpt from oracle tech support mail:
Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel
Territory
Is that catchy enough? Something you can sink your blueteeth into?
;-)
-Original Message-
Sent: Wednesday, July 25, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L
to submit a paper, you just
I will second Lisa's recommendations.
If you have much data, and/or will be doing this frequently, SQL*Loader
is your friend. It is very fast.
Loading from a SQL script is very bad unless you have small amounts
of data.
I once worked with a duhveloper who could not be dissuaded from
loading
We had a similar problem when installing the patchset for Oracle Client on
Windows. We ended up renaming each existing .dll (.dll.old) and continuing.
Worked fine.
Jay Miller
-Original Message-
Sent: Tuesday, July 24, 2001 7:55 PM
To: Multiple recipients of list ORACLE-L
Had a
yeppers, if i've got the outline done, then the whole presentation is done
at that point, geez. :(
joe
[EMAIL PROTECTED] 07/25/01 11:06AM
For those of you who have been speakers before, there appears to be a new wrinkle in the submission process. They now want an outline of the
Try awk or perl. They can handle string manipulation from OS commands
simply and quickly. A simple awk script to take the first 16 characters of
the output of ls and put it into a data file follows:
gawk 'BEGIN { while (ls | getline) print substr($1,1,16) | Report by
Hosts}' new.dat
Defry
The other week a new production process was running much more slowly than
anticipated. A file needed to be sent out by 6:00pm and at the rate the
table was being populated it wouldn't complete until around 9:30pm. The
production people and developers came to me for help and I saw that the SQL
What is required to submit a paper/presentation to IOUGA and get
excepted.
Christopher R. Spence
Why Chris? Were you excepted? ;)
Jared
Christopher
Ross,
We're running 8162 OPS on AIX 4.3. Chat away...
Durinda
-Original Message-
Sent: Wednesday, July 25, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L
...just kidding, thought that would get your attention.
But seriously: does anyone out there use Oracle 8i on AIX 4.3
We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris
-- 2.6, 2.7 and 8. It seems likely our HP Service Guard will also migrate
to VCS as well.
The SC2.2 product has had more sensitivity to the Oracle version than the
VCS product. It also seems to have more of its guts
Yes, Big Blue-teeth.
-Original Message-
Sent: Wednesday, July 25, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel
Territory
Is that catchy enough? Something you can sink your blueteeth into?
;-)
Hi DBAs,
Currently I have NT server 4.0/Oracle 8.0.5 with about 400 million
records/450 tables,indices,etc.
We will be getting a new NT server with Oracle 8.1.7. We will increase
block size from 2k to 8k
What would be the best way to move data/users/sequences,etc from existing
server to new
Alex, how did the paper/present go?
-Original Message-
Sent: Wednesday, July 25, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
Maybe some spelling errors in the abstract -:)
Alex Hillman
-Original Message-
Sent: Wednesday, July 25, 2001 9:46 AM
To: Multiple
Austin, Steve
Hey, didn't I see you on Monday Night Raw and Smackdown?? :o)
-Original Message-
Sent: Wednesday, July 25, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris
-- 2.6, 2.7 and 8. It seems
How could we check patch level(like c,d etc) for AP module. We are running
Oracle Financials 10.7 char with database 7.3.4.5.
TIA
MOHAMMAD RAFIQ
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Kamel,
Looks like you may have had multiple transactions in your PL/SQL prg.
Since one transaction ended, the slot used by it to store undo information
was reused by other transactions. Your query did not find the required undo
information and thus Snapshot too old error. Had this been a long
Yep. That's what we do also.
-Original Message-
Sent: Tuesday, July 24, 2001 8:51 PM
To: Multiple recipients of list ORACLE-L
objects
Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
Dear friends !
I'm desperately looking for a reporting tool with the following
characteristics.
It should be able to deploy various types of charts (Bar, Column, Line, Pie
etc.) to a web environment.
It should be able to extract its raw data from an Oracle (or other) RDBMS ,
using SQL.
It
Your best way is to do a full export of the 8.0.5 data and import it into
the new 8.1.7 database.
Hope this helps,
Defry
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 12:02 PM
Hi DBAs,
Currently I have NT server
Hello again,
Before sending this email,I have done some intents to get this
information. One of this was through this view (user_objects) but there is
no object directories in it.
The way in which I have created it is 'create directory XX AS 'E:\XXX';,
and I get no error, the one I think is the
it's possible that the index was small enough to stay cached in the SGA?
From: Miller, Jay [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Tuning question - Why did this index help so much?
Date: Wed, 25 Jul 2001 08:31:28 -0800
Truncation was the solution in this case as I observed in the past that
direct load option use empty blocks above HWM thus using lot of space above
it. If it is possible target table should be truncated before such loads...
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple
I've seen some data models where the only book they read was probably
How To Smoke A Big Fat Pipe O' Crack.
About the only book I've actually needed was Korth's Database System
Concepts - all the rest of the knowledge needed is application-domain
specific, for example, understanding how the
The fact that you see the same busy file from your script as
Jon's script shows is merely coincidence.
Consider the output with varying levels of read and write activity.
Jon's approach is more correct.
Jared
Title: RE: Data load options
It's a pain-killer:
http://www.painmanagementsolutions.com/products/vicodin/vicodin.html
BTW, in the US, a lot of Hollywood stars are in
rehab due to the addictive effects of this drug.
Defry
- Original Message -
From:
Robertson Lee -
lerobe
Rukmini,
select * from V$version
Baskar
-Original Message-
Sent: 22 July 2001 17:17
To: Multiple recipients of list ORACLE-L
Hi All,
How can we find what version of oracle (standard/enterprise/workgroup) is
running in the system.
Is there any view/table ?
Thanks
rukmini
--
At least she didn't have a commit after every insert and ask you to tune the
database ;)
Denny
[EMAIL PROTECTED] wrote:
I will second Lisa's recommendations.
If you have much data, and/or will be doing this frequently, SQL*Loader
is your friend. It is very fast.
Loading from a SQL
Hi Friends
I obsered in my big database Tables and Indexes set different Initial and
next extents..So How it will effect on performance?? Suppose one my big
table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low
Initial and next around 245Mb..Any ideas about the
Title: re-archiving a redo log file
I don't think, it's possible.
Most probably it checks 'archived' column in
v$log.
Also, it keeps track of archived files in
v$archived_log.
Igor
- Original Message -
From:
Adams,
Matthew (GEA, 088130)
To: Multiple recipients of list
Hi gurus
Which command is for to see disk layout in sun cluster and veritas cluster
on sun solaris.
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official
this option is not set so i assume default is OFF...
any other clue...
-Original Message-
Sent: Wednesday, July 25, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
Check the client's sqlnet.ora. It can override the server config with
USE_DEDICATED_SERVER=ON setting.
Discoverer 9i the demo at ODTUG was capable of doing almost everything
that you mention here. Only two problems ...
1. works with Oracle only (AFAIK)
2. It is not available yet (last time I saw, it wasn't).
Raj
__
Rajendra Jamadagni
Kirti made a similar suggestion. But I had done a select count(*) on the
table so that all the table rows would be loaded into memory. I suppose
that the index blocks might not have been, but even there the likelihood
that any given one of the million plus reads wouldn't find one of the 4,000
Hi Andrey,
Try Cognos.
http://www.cognos.com/
HTH,
-Rocky
--- Andrey Bronfin [EMAIL PROTECTED] wrote:
Dear friends !
I'm desperately looking for a reporting tool with the following
characteristics.
It should be able to deploy various types of charts (Bar, Column, Line,
Pie
etc.) to a
I think it's because the optimizxer did not have to go to the table b to
satisfy the query - it went to the index only.
does this make sense?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, July 25, 2001 12:57 PM
To: Multiple recipients of list
I haven't yet seen a reference to David Hay's 'Data Model Patterns :
Conventions of Thought'.
If you haven't read and understood it, then sorry, you don't know data
modeling.
http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=996081527/sr=2-1/ref=aps_sr_b_1_1/104-1357679-6149513
'A
I forgot to add: there was a commit for every 1000 rows.
Jared
Denny
Rahul,
The 3 drives are sharing the controller and are daisy-chained. An IBM CE can
reroute the cables, and depending on what's currently there, you *may* need
to purchase cables/end connectors. Since you have the same Wide SCSI
adapters/drives, this is less complicated than it could have been..
You should be able to see the one you created in dba_directories:
select * from dba_directories;
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 1:10 PM
but you haven't lived until David Hay has made an origami animal for you :)
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: books on data modelling
Date: Wed, 25 Jul 2001 10:28:37 -0800
I haven't yet seen a
A couple of things I would check. I don't believe you need the ADDRESS_LIST
parameter, unless you will have multiples. I would remove the spaces in the
parameter. I would make sure that the HOST equals the machine name,
possibly make the entry upper case. As foolish as it sounds, I've seen
Hmm, would it work to do an OS level copy so long as you get to the redo log
before it starts being written to again?
Just a random thought...
-Original Message-
Sent: Wednesday, July 25, 2001 12:42 PM
To: Multiple recipients of list ORACLE-L
I don't think, it's possible.
Most probably
You're showing your age. ;)
I'm more akin the the $6.0 E+06 homo sapien. You know, a man barely
alive; we have the technology, blahblahblah -- all that Six Million
Dollar Man stuff (whose character was -also- Steve Austin for those who
haven't caught it in reruns).
It's amazing how much of
Hi Tom,
That's why I expected a 25% decrease in processing time (instead of reading
2 index blocks and 2 table blocks it read 2 index blocks and 1 table block).
But why would it give a 75% decrease?
Jay
-Original Message-
Sent: Wednesday, July 25, 2001 2:29 PM
To: Multiple recipients
Mohammad,
That only works if you can truncate the table.
Dick Goulet
Reply Separator
Author: Mohammad Rafiq [EMAIL PROTECTED]
Date: 7/25/2001 9:16 AM
Truncation was the solution in this case as I observed in the past that
direct load option
i tried removing the spaces but it didn't help..if the client and server
r on the same machine ...
will it use ipc instead of tcp and if so do i have to configure dispacher
for ipc and mention ipc in local_listener.
-H
-Original Message-
Sent: Wednesday, July 25, 2001 3:09
1 - 100 of 152 matches
Mail list logo