Ken ,
there is only one book. :-)
That is SQL*Loader: The Definitive Guide by Gennick, Mishra
The pair explain very nice addons and features that are quite useful.
As usual its an Oreilly book.
Peter
Regards
Peter Lomax (Oracle DBA)
Expertise Oracle
ORANGE/DSI/SIMBAD/ATP
OrangeFrance
Bureau:
Oracle Support will listen if we ask for enhancements, I don't know if
we will get everything we ask for but I know they'll listen.
It was created to help make Support's life easier -- much easier to get
the information they need in the form they need it than to depend on us
to remember to do
Hi gurus...
My organization wants to use PRO* COBOL.
I need to configure and guide the application programmers in compilation of
the software...
please refer me where I can get relevent documentation... I was unable to
find it in oracle doumentation.
expecting early replies...
Banarasi Babu
- Original Message -
This doesn't work either..
I can load the products.jar file in to the 8.1.7 installer, it then asks
what I want to install (Database or Client), choose Database, it asks what
kind of database (standard, enterprise etc.) I choose either standard or
enterprise,
Hi list,
thanks everyone for help. I looked up metalink and found following
bug/workarround:
fact: Oracle Server - Enterprise Edition 8.1.7
fact: SQL*Net
fact: MS Windows NT
symptom: Client Connection Failure
symptom: TNS-12537 / ORA-12537: TNS:connection closed
symptom: TNS-12560 / ORA-12560:
Title: /*+ NESTED_TABLE_GET_REFS +*/ hint
Hi,
Our application runs in RBO Mode. We are frequently getting the hint /*+ NESTED_TABLE_GET_REFS +*/
in the V$SQLAREA. We don't have nested tables in our our application either. What is the possible reason for this hint?
Is oracle internally
You can find the documentation in technet site
http://technet.oracle.com/doc/server734.htm
http://download-eu.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm
HTH
--
On Fri, 14 Dec 2001 01:50:18
banarasi wrote:
Hi gurus...
My organization wants to use PRO* COBOL.
I need to configure
Come work for a great company in the Tampa Florida area (Clearwater) that
needs an Oracle
Financials DBA to join it's I.T. Team.
You will work with Oracle Applications and must have experience with 11i and
Excellent
communications skills.
*Company want someone who is willing to work in
Hi,
Does anybody know of a web site where I can get platform-specific info (Sun
Solaris and HP) on:
1. the max size of a data file
2. the max number of data files for each tablespace
3. max size of each Oracle extent
4. max number of extents for each Oracle segment???
We are doing some sizing
We got it few times ... you know what the script is designed for OFA
architecture. We have a rigged copy for our own environment. We had to get
special permissions from SA's to gather some system level information that
the script had no privilege (when running as Oracle owner).
BTW, I think
Thanks Ron,
The SGI install only has $ORACLE_HOME/lib32/ $ORACLE_HOME/lib/ dir's.
...JIM...
[EMAIL PROTECTED] 12/13/01 7:40:17 PM
James,
You need to have the library for the 64 bit of Veritas... on AIX, it is
done
as follows:
ln -s /usr/openwin/netbackup/bin/libobk.a
Rich:
The situation is that I have to default this date to 01/01/2002. I tried
loading it using constant and it won't work.
Ken
-Original Message-
Sent: Thursday, December 13, 2001 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error
I tried this and got the same error.
creation_date date (sysdate + 17 'mm/dd/'),
SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.
Any ideas as to how to get this to work?
Thanks,
Ken
-Original Message-
Sent: Thursday, December 13, 2001 4:40 PM
Ken,
You can't do a lot of things to the data in a direct path load. You
could modify your source data (awk, grep, sed, etc.) so you wouldn't
need to reformat the date field and then if there are no additional
problems, you will still have a problem with the FK that you are seeing
in the
Thank you Charlie . This document is excellent.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 13, 2001 5:25 PM
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=109095.
1p_showHeader=1p_showHelp=0
I need to load a constant date into a column (01/01/2002) and I need to use
direct path loading. I tried:
creation_date to_date('01/01/2002','dd/mm/'),
SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct
path.
This works with conventional path load. I have tried
Steven,
The only one I'm familiar with is http://lcis.booksonline.com . I was
satisfied with there service membership deal.
Mike
-Original Message-
Sent: Thursday, December 13, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Hi,
I want to join a book club to get benefit from
List,
We will be upgrading from 806 to 8172 on Tru64 40g/51 next quarter. We did
the upgrade on a sandbox system and the process went smoothly. However, my
biggest concern is any changes in the CBO. Are these concerns warrented? I
was planning on running a series of SQL statements with
I have just heard today that an external consultant, who is coming to
upgrade software for our Student Records system next week, wants to unload
the live, test and training databases, and recreate them using locally
managed tablespaces.
I've been reading all the incredibly positive things oracle
Title: /*+ NESTED_TABLE_GET_REFS +*/ hint
Oracle sys tab
accesses use RBO. I believe some have hints. check with the cognoscenti.
hth
-Original Message-From: Amar Kumar Padhi
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 14, 2001 5:55
AMTo: Multiple recipients of list
Hi
Any reason that this external consultant is not using the package
dbms_space_admin.tablespace_migrate_to_local procedure ??
This would seem a much cleaner method of doing this than the method they
are recommending.
>From the plsql supplied reference.
TABLESPACE_MIGRATE_TO_LOCAL
I want to put a number of ctl scripts together into one so I don't have to
run each script by itself. Is it possible to have scripts for direct path
load and conventional path load in the same sqlldr script? I don't think
so, but would like the opinion of others.
Thanks,
Ken Janusz, CPIM
HI Ken,
Two ideas
1.Have you tried using a default value on the column?
2.Load the data and then go back and do a mass update.
[EMAIL PROTECTED] wrote:
I need to load a constant date into a column (01/01/2002) and I need to use
direct path loading. I tried:
creation_date
Hi
John,
Thanks so much for ur
advice.never knew about that procedure before. By the
way,
could u please tell me what
do the allocation_unit, relative_fnowithin the paranthesis
mean ?? Or could u just
give me a document link where I can read more about this procedure
??
Regards,
Stephen:
I will probably stay with the conventional load and if I hid any FK
constraint problems I'll look into disabling the constraint. I'm doing a DB
conversion into 8.1.7 with no application software connected to it. The DB
is pretty much a duplicate of the production DB.
I am creating
Sorry for the subject SNAFU. That's what I get for cut pasting.
Mike
SNIP
List,
We will be upgrading from 806 to 8172 on Tru64 40g/51 next quarter. We did
the upgrade on a sandbox system and the process went smoothly. However, my
biggest concern is any changes in the CBO. Are these
If you have experience and experiences that would benefit other users, seize
this opportunity to share your ideas in 2002
Engage your colleagues with fresh approaches.
Excite your peers with innovative techniques.
Intrigue your associates with cutting edge topics.
Sign-up for a presentation on
You should be able to say:
creation_date CONSTANT 2002-JAN-01,
If you database's default date format is '-MON-DD'
Caver
-Original Message-
Sent: Friday, December 14, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Rich:
The situation is that I have to default this
I'm thinking that depending on how you're doing the upgrade (migration),
your statistics could change, which could obviously change the execution
plan. This could happen if you use the export/import method.
You might also want to check out the OPTIMIZER_% init.ora parameters and
their defaults
The two main benefit of lmt's are
- the enforcement of a consistent extent size.
- avoiding issues with FET$ and UET$
Using migrate_to_local achieves the latter but not the
former.
hth
connor
--- orantdba [EMAIL PROTECTED] wrote: Hi
Any reason that this external consultant is not
If you are trying to connect externally to a DB inside a NATed environment,
you will need to forward the port on the NAT interface you are using to the
internal IP of the database server. ie. Port 1821 on the external NAT
interface will be forwarded to port 1821 of the db server with the internal
If you can avoid the downtime, then its a good move.
Its really a move toward consistent extent sizes per
tablespace - LMT's just enforce that.
hth
connor
--- Docherty, Heather [EMAIL PROTECTED]
wrote: I have just heard today that an external
consultant,
who is coming to
upgrade software
Actually, I was thinking:
creation_date sysdate+17
...because I've used it before without the +17 (days). But of course
that's syntactically incorrect. :( SQL*Loader doesn't like the +17
there.
Sorry... :(
Rich Jesse System/Database
---BeginMessage---
Hi,
I'm using a mts-server through an openbsd-firewall (and also nat'ing
into the dmz-subnet) without cmgr. There's no problem with that. You
should test if your router is proper configured. Check the logfiles or
if other services work correctly. Have you bound the public
Greetings fellow-DBAs,
I just recently perused a paper by Tim Gorman entitled Cats, Dogs, and
ORA-01555 which used some analogies to give a very good explanation of the
Snapshot Too Old problem that can be an annoyance from time to time. I
believe the paper was recommended by someone on this
I've gone back to using the conventional path load.
Ken
-Original Message-
Sent: Friday, December 14, 2001 10:32 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL*Loader-417 Error
You should be able to say:
creation_date CONSTANT 2002-JAN-01,
If you
In versions of 8i and below, the hint specifies that
nested tables should be retrieved as refs, and is
pretty much only seen on export.
In 9i, where you can collections of collections, then
its use by 'us' appears to be supported, but still not
documented.
Cheers
Connor
--- Mohan, Ross [EMAIL
I have found www.bookpool.com to have the best prices and they generally are
well stocked on the O'Reilly and Oracle Press books.
Van
-Original Message-
Sent: Thursday, December 13, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L
Hi,
I want to join a book club to get benefit
Hi,
I have a process that inserts several rows into a table. Each row
contains a timestamp field that shows the time it was inserted. When I
interrogate Logminer looking for these rows, not all of them are shown. It
stops after a certain point. A commit was done and I know I have the right
Jeremiah - Thanks so much for posting this. I read your paper and didn't
find anything that made me want to stone you. Excellent suggestions and well
backed with reasoned discussion.
Does anyone else know where I can get more papers? I didn't get to
attend Openworld this year and hate to
I am trying to connect to a database on the inside of a NAT.
I get a tns connection time-out error. According to Oracle, I have to use
Connection Manager. I find this a little hard to believe. I would think a
CISCO router doing NAT would be smart enough to translate Net8 packet headers
Hi,
We have created our table column with datatype NUMBER (where it should be
NUMBER(38,0))
Now ODBC is treating NUMBER as double precision instead of integer which is
breaking our code.
Does there any way to convert NUMBER to number(38)..without export/import
utility???
Alter table is not
Gene,
It was a few weeks ago that I was made aware of this paper. I must have
simply downloaded it from the site that was mentioned in the original E-mail
and printed it for future (i.e. now) reference. All I can tell you is that
there is an About the Author section on the last page which
You can get most of the OOW white papers from their website...
http://www.oracle.com/openworld/us/conference/
-Original Message-
Sent: Friday, December 14, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L
Jeremiah - Thanks so much for posting this. I read your paper and didn't
When I encounter a situation like this, I usually make a temporary table
containing the primary key and the field in question, load it with data
from the table, update the field in the real table with null, modify the
field type, then reload from the temporary table.
At 09:25 AM 12/14/01
I have 12 tables that have the same named column in each. I will be loading
(via sqlldr) data into these tables. What I need to do is as each record is
loaded add a sequence number (currval) to each of these 12 tables. The
sequence number will be the same for all 12 tables to tie them
FYI,
I just logged a call with Oracle re. Designer 6.0 vs. all_cons_columns.
A developer noticed that whenever he queries that data dictionary table as
part of generating database from server models, the process slows down to a
crawl.
If the target doesn't have any constraints, no problem.
I
Hi Listers,
I copied the archived logfiles from production database (PROD) and trying to
start logminer in development (DEV) database (same platform but different
SID).
execute dbms_logmnr.start_logmnr(dictfilename = '/u01/prodlog.ora');
I got the ora 01295 error.
Can we analyze logfiles
Michael - We did this upgrade on Compaq Tru64 and experienced no CBO hitches
(or other hitches). Is there something in particular that raises your CBO
concern? Are you on RBO now?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 14, 2001
me too! nicely said Regina...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 14, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L
When I encounter a situation like this, I usually make a temporary table
containing the primary key and the
Heather - Is there a particular reason the consultant is doing this other
than maybe this is the first opportunity to learn this? Just my cynical
side. Mentioning cynical, I was leery of the procedure to convert an
existing dictionary-managed tablespace to a locally-managed one, but we
production
Dennis,
We are currently using 'choose' in 8.0.6.3. During our last upgrade from
8.0.4.x to 8.0.6.x our software vendor (SAP) recommended including event
10183 to disable CBO cost rounding. Although with this event it appeared to
be choosing the most efficient index, the response time was
Heather:
Another thing to consider. If the vendor of your student application
system has not worked with LMTs, you may encounter support issues should you
have problems with database accessibility. I would verify that LMTs are
supported before converting.
In terms of usage, LMTs are great
Have you recently generated stats from RAU?
Jared
Boivin, Patrice
Don,
I'm sure I have seen mention of one or more listservers for
users that are
in the Oracle Apps world. Would somebody be kind enough to
post those
listservers again, or point me where I could find them?
You can find them off 'http://www.oaug.org'
OAUGnet-DBA
Thanks, Tom!
At 11:55 AM 12/14/01 -0800, you wrote:
me too! nicely said Regina...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, December 14, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L
When I encounter a situation like this, I usually make
Hey Stephen - That's DENNIS damnit! And I didn't say that uniform extents
increase performance (I like autoextend and not getting awakened in the
middle of the night), but if anyone has evidence that they do, please share
it.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
Hello all,
FWIW, I use managed in dictionary, no auto-extend, on an HP-UX, OPS 8.1.6.3
system. I considered locally managed (and auto vs. uniform), but as I have
extremely fast I/O, I could not justify pulling it out of the dictionary (no
problems of excessive $FET and $UET pinging). Now, that
Hello,
Anyone out there having fun on OPS with the dlm resource hash list ORA-600
and ORA-603 errors. We are getting them more frequently with increased load
on the system. See below for some particulars. The really bad part is having
a critical process die with the 603 error.
applicable
I would suggest you put on a client trace to see what's getting passed
back. We've had this problem and there's a couple of things that
could be happening:
1) A hostname is getting passed back and the client does not know how
to
www.oracle.com/openworld and then click on session search and you
should get to the papers
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Jeremiah - Thanks so much for posting this. I read your paper and
didn't
find anything that made me want to stone you. Excellent suggestions
and well
Hi Don,
You can try to send ablank message to [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] to sign up for Oracle HRMS listserver
HTH.
Regds,
ChorLing
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Friday, December
Folks,
Make sure and download the ones you want, if
things go same as last year, they seem to
eventually start disappearing once they start
getting ready for the next year's conference.
http://www.oracle.com/openworld/us/conference
ORACLE-L Digest -- Volume 2001, Number 347
Thanks Rachel. Just like being there but not!
-Original Message-
Carmichael
Sent: Friday, December 14, 2001 5:05 PM
To: Multiple recipients of list ORACLE-L
www.oracle.com/openworld and then click on session search and you
should get to the papers
--- DENNIS WILLIAMS [EMAIL
hi,
can anybody help me w/ this error:
TNS-12545: Connect failed because target host or object does not exist
this message pops up when i try to login into my nt database .
i've already checked the tnsnames and the entry is correct.
thanks.
Best Regards,
Grace Lim
Suy Sing Comm'l
Title: RE: FIRST_ROWS and the data dictionary
My information on this may be a bit outdated. I had read it somewhere that statistics are not to be generated for SYS tables. Oracle will handle the dictionary information access, irrespective of the optimizer mode being used. The setting of the
blech/retch/fetch, over 2 hours to look through it all and download maybe 25%.
Volume in drive C has no label
Volume Serial Number is 2741-1700
Directory of C:\WINDOWS\Desktop\OOW2001
OOW20~21 ZIP38,249 12-14-01 5:45p OOW2001-W13614.zip
OOW20~20 ZIP 224,984 12-14-01 5:45p
67 matches
Mail list logo