RE: [Q] create tablespace with different block size error???

dba1 I think you must first create a buffer cache for this block size. http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 10:29 AM To: Multiple recipients of list

RE: OT: Solaris: Finding the cause for disk space growth

Naveen - Are you using autoextend on any of your datafiles? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:39 AM To: Multiple recipients of list ORACLE-L One way to determine where to start looking is via find: find

RE: internal date value

, Oracle9i has some new date types and you may find one that works better for your purposes: http://otn.oracle.com/products/oracle9i/daily/may02.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:40 AM To: Multiple recipients

RE: Help - 9ias broke - hostname was changed

. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 1:19 PM To: Multiple recipients of list ORACLE-L Yes, but how do I fix it? Do I need to reinstall? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:14 PM

RE: Healty ratio of index segment size vs table segment size?

dropping indexes on tables that exceed their quota? I haven't used the index monitoring feature, and a cautious DBA always makes a small test before widespread deployment, but from what I've been told, the monitoring feature is pretty low overhead. Dennis Williams DBA Lifetouch, Inc. [EMAIL

RE: Old thread - trace file location

Thanks Alexander. I wasn't aware of this new feature. It will certainly make my script much simpler. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:49 PM To: Multiple recipients of list ORACLE-L

RE: Metalink on the blink

Matthew - Works fine for me. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Is anyone else having problems with Metalink this morning or is it just us? We can't log

RE: data manipulation of a large unix file

CPU, that may not be unreasonable. The real question is how long the CPU is used. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:00 AM To: Multiple recipients of list ORACLE-L We are getting a feed of an 800 MB file

RE: Automatic or Uniform allocation

recent paper, please post it. With uniform extents, you eliminate tablespace fragmentation, in addition to Ron's points. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Brad

RE: How to get unique value using AWK?

Reminder to post to freelists.org per Jared - I'm crossposting this reply. Jay Pipe your output to sort, then uniq. grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3 $4 $5 $6}'|sort|uniq Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday

RE: What to look for in STATSPACK report

Chris - In Excel, click on Data -- Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file

RE: Re: pga_aggregate_target and a memory leak

Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which

RE: Automatic or Uniform allocation

Jonathan Thanks so much for posting this excellent article. Very high quality as all your writing is. This was my devious purpose in replying, in hopes something like this was out there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday

Freelists about 2 hours behind

Based on a sample of one message, it looks like Freelists may be running about 2 hours behind. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services

RE: Startup Migrate

Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle

[oracle-l] Re: Startup Migrate

Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle

[oracle-l] Re: What to look for in STATSPACK report

Chris - In Excel, click on Data -- Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file

[oracle-l] Re: pga_aggregate_target and a memory leak

Sandra - Are you on 9.2.0.4? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 10:44 AM To: Multiple recipients of list ORACLE-L I have had a problem on my 9i database for three weeks. I am getting a ORA-7445 error which

[oracle-l] Re: Automatic or Uniform allocation

recent paper, please post it. With uniform extents, you eliminate tablespace fragmentation, in addition to Ron's points. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Brad

Old thread - trace file location

I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET

RE: Old thread - trace file location

, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about

RE: Oracle vs Mysql

the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L

RE: Developer Mailing List

Mark - Maybe a good place to start is: http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.databases.orac le.tools (usenet newslist comp.databases.oracle.tools) If that doesn't suit you, post your request there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

RE: Oracle vs Mysql

- 733,000 hits or less than 5% of the MySQL hits. Admittedly these are just rough comparisons, and I think Jonathan's statement that MySQL books sell much better is a much more reliable statement. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20

RE: SYS Privilege

Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege

RE: Oracle vs Mysql

Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Thanx - I cleared the exam -- another OCP question

Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 15, 2004 6:04 AM To: Multiple recipients of list ORACLE-L Hi

RE: any student versions of 'business objects' ab initio or infor

Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 17, 2004 10:44 AM To: Multiple recipients of list ORACLE-L informatica? Something affordable. These are hot right now and I'd like to learn how to use them. I cant find anything on the web

RE: (Non)Unique Index Vs Unique Constraint

on a nonumique index. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 16, 2004 9:14 PM To: Multiple recipients of list ORACLE-L All, Please enlighten this Junior DBA. Which method is more efficient? When should I go for option (1)? 1)NON

RE: JVM for DBA

Bill - Will you be administering the server or do you need to talk to the administrator? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 10:15 AM To: Multiple recipients of list ORACLE-L Hi all, Does anyone have any good

RE: ** OCP for 9i requirements -- Instructor Led Class is a

. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 8:09 AM To: Multiple recipients of list ORACLE-L Sure. Read Important Program Announcement: Oracle University Hands-On Course Requirement Oracle customers and business partners

RE: sql question

David - Can you post the EXPLAIN PLAN for both? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 12, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b

RE: Backups in a DW Environment

Gene - As a part of putting the database back in archivelog mode, I hope you take another backup. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 4:44 PM To: Multiple recipients of list ORACLE-L I put all databases in archive

RE: Backups in a DW Environment

from Veritas for our size of server and said the additional disk area was cheaper, so we use RMAN to disk. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 6:39 PM To: Multiple recipients of list ORACLE-L I never heard about

RE: Backups in a DW Environment

off archivelog, then you will have a gap in your log sequence and only be able to recover to the point you turned off archivelog. I know that you know that Mladen, but I thought maybe some lurker on the list might not. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

RE: rman restore question

the disadvantage that you're stuck with a database that doesn't have all the recent transactions applied? Just asking, you're probably suffering from recovery fatigue now. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 9:39 AM To: Multiple

RE: rman restore question

by starting with an older restore, more archive logs must be applied. Take a look at this idea and see if it would meet your requirements. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:24 AM To: Multiple recipients of list ORACLE-L

RE: timing data

David - I'll second Carel-Jan's suggestion. If you are this interested in this topic, you'll find Cary's book invaluable. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 10:15 AM To: Multiple recipients of list ORACLE-L search

RE: Export / Import Question

of. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 8:09 AM To: Multiple recipients of list ORACLE-L I have a user who want to refresh only the DATA in a test database with DATA from the production database. He does not want to replace

RE: Export / Import Question

Ron - You have my sympathy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 11:30 AM To: Multiple recipients of list ORACLE-L That would require effort and planning on their part. Ron -Original Message- Sent: Friday

RE: Backups in a DW Environment

Oracle? We have a data warehouse that gets updated weekly. The day after the load we perform a cold backup. We don't use archive logging. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 09, 2004 3:25 PM To: Multiple recipients of list

RE: Error after resize of LMT

Robyn - Thanks for replying. So what was the consequence of the error? What did you have to do to fix the problem? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 07, 2004 8:40 AM To: Multiple recipients of list ORACLE-L This message

Error after resize of LMT

this error. And if it occurred, how severe were the consequences? I can't apply the 9.2.0.4 patch because the vendor says they don't support that yet. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS

RE: OCP Question (Perf Tuning)

University. I can't find anything nearly this detailed in the Student Guide, therefore I conclude that this question will not appear on the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 06, 2004 1:34 PM To: Multiple recipients

RE: Convert to Locally-Managed Tablespaces

by some REALLY large organizations with really, really large amounts of data, perhaps SAP uses a different practice. I would like to know if that is the case. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 05, 2004 8:09 PM To: Multiple

Upgrade your OCP

Upgrading Your OCP that explains how you can do this. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Hi list

Congratulations. I know the feeling! Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, January 03, 2004 3:15 PM To: Multiple recipients of list ORACLE-L List, thanks to all of you I finally completed my OCP exams (thought they would never end

RE: encrypt back-up data

this, be sure to test the recovery. Some utilities try to be helpful and remove wasted space in files. Oracle relies on the file being exactly what it created, empty space and all. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 02, 2004 9

RE: rman restore question

Joan - Which Oracle version? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY

DBA Unemployment

Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: A performance problem

changed with the execution plan. When they are after your head, quick is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 29, 2003 12:15 PM To: Multiple recipients of list ORACLE-L John, I can run this in our development environment

RE: Standard Vs. Enterprise Edition for Application Compilation

of Products. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 23, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Hi Qs Does a Pro-C application (Banking) need to be compiled with Standard Edition as Oracle Libraries are being

RE: RE: Career Advice

Viktor, Ryan - Is what you are experiencing the result of companies moving to open-systems Web-based architectures? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 8:34 PM To: Multiple recipients of list ORACLE-L I agree

OEM permissions

is responsible for the data in the database, so I don't see a problem with him viewing the data. There are few database links, and I'll be reviewing them. Any ideas on what mischief could occur? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ

RE: OEM permissions

on the other systems the links point to. I have also asked his group not to create any database links. Fortunately we have relatively few links. Again, thanks for your advice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 7:54 AM

RE: RE: Career Advice

advantage. The salary surveys I've seen show MS SQL Server DBA with lower salaries on the average. - Has anyone seen salary survey results for MySQL or PostgreSQL? The database is free, so how much should a company spend on a DBA? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: OEM permissions - thanks!

Raj, Thomas, Brad, Bill, anyone I forgot - I feel better about the situation now. Thanks for letting me run this issue past you. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 18, 2003 9:35 AM To: Multiple recipients of list ORACLE-L

RE: Career Advice

to a prospective employer that might consider hiring you over other candidates. If they are able to easily find candidates with years of experience . . . well, it isn't going to be very promising for you, regardless of how much self-study you've put in. Dennis Williams DBA Lifetouch, Inc. [EMAIL

RE: Career Advice

, and it hasn't been a quick learn for them. Based on what I've seen, I would push for Java training. Also, before you tear into Java, you may want to get a basic understanding of how the web stuff like HTML works. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message

Good news from Oracle

Oracle is posting healthy profits. http://www.informationweek.com/story/showArticle.jhtml?articleID=16700686 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City

RE: How to refresh

Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact replica in all respects, and you can test your backup as a bonus. If you are interested in this method, tell us how you backup your production database. Dennis Williams DBA Lifetouch

RE: How to refresh

(or in staging, if you implement that). Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 8:59 AM To: '[EMAIL PROTECTED]' Ron - You should consider refreshing the instance by cloning your production database. This way you get an exact

RE: table partitions

your needs without adding a new column. If you are still working there in 5 years, then congratulate yourself and create another 5 years of partitions. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 16, 2003 11:39 AM To: Multiple recipients

RE: After 256 connections : ORA-12154

Jay - You have received some great suggestions on this and no doubt you are researching them. I'll offer a slightly dumber long shot, but easy to check. What is your PROCESSES set for this instance? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday

RE: connection pooling from an application server to oracle

=glances=booksn=507846 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 15, 2003 6:59 AM To: Multiple recipients of list ORACLE-L The software engineers here are using an application server with connection pooling to connect to our oracle

RE: connection pooling from an application server to oracle

BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL

RE: automate backup and export

on the different methods. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, December 13, 2003 7:19 AM To: Multiple recipients of list ORACLE-L Any reference concerning the rman? - Original Message - To: Multiple recipients of list ORACLE-L

RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services

RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT

, was often quoted in the press about how they were able to reduce their I.T. expense. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 12, 2003 9:54 AM To: Multiple recipients of list ORACLE-L http://www.wintercorp.com/vldb/2003_TopTen_Survey

RE: Re[2]: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopT

pickles, and shooting anything that comes to mind. Sorry, that is the best I can do on the spur of the moment. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 12, 2003 10:49 AM To: Multiple recipients of list ORACLE-L http

RE: Performance tuning in complex environment

exactly suited to your issues. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hello Everyone, I am trying to get some help/suggestions reg. how

RE: Documenting databases

a help desk, they may be able to store this information as a configuration (or CI) in their tool. Another piece of data to consider is the database links. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 5:35 PM To: Multiple

RE: char is going away?

Gene Was another part of the rumor that Oracle was going to retire SQL standard compatibility? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me

RE: char is going away?

://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: char is going away?

simplifies things quite a bit. Especially if you sell your application to many sites that want to use Oracle underneath but don't have an Oracle DBA, at least not initially. Yeah it wastes a bit of disk space. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: accounting software

Grace Take a look at Lawson Software -- http://www.lawson.com Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 9:34 PM To: Multiple recipients of list ORACLE-L can anyone recommend accounting software for mid-range

RE: Re[2]: char is going away?

databases, you might consider CHAR as a safer bet. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 10, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Oracle has varchar and varchar2 both ... tfm The VARCHAR2 subtypes below have

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

Markus - Do you use Novell instead of tnsnames.ora as well as authenticating users? We use MS AD. Any insights as to how your method could be applied to MS AD? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 7:54 AM To: Multiple

RE: OpenLDAP instead of OID

Mladen - Glad your issue is resolved. In the interest of accuracy, this Dennis Williams hasn't looked at OpenLDAP. Our network guys think MS AD is where it's at and I'm hoping someone will figure out how to get Oracle working with MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: Antw: Re: Re: Oracle and Novell eDirectory LDAP

on each client. I considered the Oracle Names server, but Oracle has announced this is going away in favor of OID. But my network guys favor MS AD. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 10:09 AM To: Multiple recipients of list

RE: Oracle and Novell eDirectory LDAP

to continue to synchronize the two. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 03, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Embarrassed by Google/OTN, after stating I had not had time to verify what version integrates with AD

RE: RMAN restore on another server

it up from the backup pieces? On 8i this tends to be a problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 08, 2003 8:39 AM To: Multiple recipients of list ORACLE-L I have ftp'd the backup pieces into the identical backup location

RE: RMAN restore on another server

if you said that you separately backed up the control file at the end of the RMAN backup, and manually moved that control file into place on the test system. At least you would eliminate that as the problem. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday

RE: create table as select

Bulbultyagi My recollection is that with a LONG datatype you cannot use a create table as select, but must use the COPY command. I cannot confirm whether COPY is available in 10g. Sorry. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, December

RE: Cursor problem

Jacinta Okay, back to my second question. How are you doing connection pooling? Do you have an application server with a connection pooling feature, or are you writing your own connection pooling in Java, or are you using connection pooling on the Oracle database side? Dennis Williams DBA

RE: Database management techniques and frameworks

is available, pick an instance and audit it for security, performance, recoverability, etc. During the audit, make up a list of tasks to perform on that instance, and as time permits, execute those tasks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday

RE: Cursor problem

Jacinta - What language is the app written in? Java? How are you doing connection pooling? With Oracle? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Dear All My application

RE: RMAN restore on another server

NFS? I encountered a problem with NFS very similar to your symptoms. My sys admin assumed there would be only a connection or two over NFS, so left some stuff default. Come to find out RMAN opens a bunch of connections. Sorry, but that is all my brain can think up on Friday. Dennis Williams DBA

RE: RMAN restore on another server

Janardhana - That's a good point. Brian - were you expecting RMAN to extract your controlfile from the RMAN backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in 8i. I couldn't get that to work myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Export table to determine extent of block corruption

this. The last time I had this problem I saved Note 34371.1, but that may be obsolete now since it was about 5 years ago. But the horror seems like yesterday. Good luck. Now you've given me nightmares. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday

RE: Oracle and Active Directory

Denham - Besides getting it to work? This topic has come up a few times on this list and I have yet to see anyone claim they have it working. I have a few ideas, but haven't had time to look at it. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday

Perl / MySQL

. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to stop XDB

coat to leave for a holiday. I also don't like clever little features I don't use being added automatically. Especially clever little features that have security vulnerabilities posted. I like your idea of removing it from listener.ora. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED

RE: OS Level Defrag

Sujatha - If it helps, we have Tru64 and 8.1.6 here. My sys admin has defragged the disk quite a few times with no apparent ill effects. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 27, 2003 7:59 PM To: Multiple recipients of list

RE: an article comparing Oracle to other databases

that almost every deficiency can be viewed from a different perspective. SQL Server has a reputation for costing less, which means many corporations view it as cheap. Oracle has a reputation of being harder to manage, which may mean that Oracle DBA salaries are a little higher. Dennis Williams DBA

How to stop XDB

thoughts appreciated. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Active Directory and ORACLE passwords

an LDIF. So in theory you could import your tnsnames.ora file into cman and export an LDIF which you could import into MSAD. Again, I sincerely somebody that has actually tried this will reply. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday

RE: RMAN restore to different machine

can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent

RE: RMAN restore to different machine

the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production

RE: RMAN restore to different machine

My apologies, I bumped the send button. Stephen - my understanding is that you are correct, the platforms have to be the same at the binary level - i.e.., both Solaris, both Windows, etc. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24

  1   2   3   4   5   6   7   8   9   10   >