RE: Recommenations for a DB conversion using SQL Loaderf

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:

Re: Slightly OT : RDA from Oracle

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

PRO * COBOL

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

Re: Oracle on Pentium 4 conflict

- 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,

SOLVED: TNS-12537 TNS:connection closed

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:

/*+ NESTED_TABLE_GET_REFS +*/ hint

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

Re: PRO * COBOL

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

Oracle Financials DBA with 11i Needed in Tampa, Florida area..

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

web site on oracle info

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

RE: Slightly OT : RDA from Oracle

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

RE: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup

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

RE: SQL*Loader-417 Error

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

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

Re: SQL*Loader-417 Error

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

Re: Runing OS Commands from Stored Proc.

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

URGENT!! SQLLDR: How do I load a constant date with Direct Path?

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

RE: Book Club ?

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

RE: Wite paper link?

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

Locally managed tablespaces

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

RE: /*+ NESTED_TABLE_GET_REFS +*/ hint

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

Re: Locally managed tablespaces

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

SQLLDR and Direct Path Load

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

Re: URGENT!! SQLLDR: How do I load a constant date with Direct Path?

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

RE: Locally managed tablespaces

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,

RE: SQL*Loader-417 Error

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

Upgrade 8.0 to 8i - Was RE: Wite paper link?

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

Calling Presenters for 2002

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

RE: SQL*Loader-417 Error

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

RE: Upgrade 8.0 to 8i - Was RE: Wite paper link?

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

Re: Locally managed tablespaces

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

RE: using Net8 through NAT router

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

Re: Locally managed tablespaces

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

RE: SQL*Loader-417 Error

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

Re: using Net8 through NAT router

---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

Many small or few large extents for RBS Ora-1555

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

RE: SQL*Loader-417 Error

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

RE: /*+ NESTED_TABLE_GET_REFS +*/ hint

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

RE: Book Club ?

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

Logminer Question

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

RE: Openworld paper on my site

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

Re[2]: using Net8 through NAT router

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

NUMBER PROBLEM

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

Re: Many small or few large extents for RBS Ora-1555

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

RE: Openworld paper on my site

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

Re: NUMBER PROBLEM

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

Oracle Sequences

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

FIRST_ROWS and the data dictionary

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

Logminer in different SID

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

RE: Upgrade 8.0 to 8i - Was RE: Wite paper link?

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

RE: NUMBER PROBLEM

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

RE: Locally managed tablespaces

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

RE: Upgrade 8.0 to 8i

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

RE: Locally managed tablespaces

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

Re: FIRST_ROWS and the data dictionary

Have you recently generated stats from RAU? Jared Boivin, Patrice

RE: Mail list for Oracle Applications 11.0 and 11i?

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

RE: NUMBER PROBLEM

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

RE: Locally managed tablespaces

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

RE: Locally managed tablespaces

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

e: ORA-600 and ORA-603 issues with dlm resource hash list

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

Re[2]: using Net8 through NAT router

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

RE: Openworld paper on my site

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

RE: Mail list for Oracle Applications 11.0 and 11i?

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

OOW presentation materials download/ Re: ORACLE-L Digest -- Volume 2001, Number 347

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

RE: Openworld paper on my site

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

tns-12545

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

RE: FIRST_ROWS and the data dictionary

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

Re: OOW presentation materials download/ Re: ORACLE-L Digest -- Volume 2001, Number 347

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