RE: Intermedia Indexing

on 8.1.7.3.0 under Win2k. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Friday, April 26, 2002 1:18 AM

RE: 9i new features, the saga continues?

Yes! Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent:

RE: DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM

, so we've not needed it. However, like any kind of insurance (e.g., backups), as long as it doesn't cost too much, aren't you glad to pay to leave it unused? ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin

RE: Help needed

Rakesh, Yes. You can certainly export a single partition at a time for logical backups. If you put each partition in its own tablespace, you can physically back up individual partions as well. Jack Jack C. Applewhite Database Administrator/Developer OCP

RE: Dynamic create and execute procedure

Cool! A PL/SQL procedure that responds to your every wish! I want one of those too! Seriously Gilbert, be a bit more specific about your desirements. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas

RE: How to calculate time using SQL

it that way so it's more obvious what my intent is. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- David M Sent: Monday, April 01

RE: LAST REBUILD INDEX

Seema, Probably Last_DDL_Time in DBA_Objects, though that just tells you the last time any DDL was executed on the object. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL

RE: Rebuild Oracle Listener Service

Ron, The easiest way to do that is use the Oracle Net8 Configuration Assistant. It's under Programs/Oracle - OraHomeYour8iHome/Network Administration and a snap to use. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc

RE: How to calculate time using SQL

User_Refresh ; You need to do a little reading in the Oracle SQL Reference under Datatypes to find out details of the Date datatype and Date arithmetic. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas

RE: LAST REBUILD INDEX

Seema, What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in DBA_Objects *does* show when an Index last had an Alter Index xxx Rebuild executed against it. I just now tested to verify that. Jack Jack C. Applewhite Database Administrator/Developer

RE: Do programmers tune SQL?

. If you make the Java developers aware of these issues up front, maybe they'll go ahead and learn how to code it right initially. Sorry I can't give details, 'cause all I know about Java is how to spell it! ;-) Jack Jack C. Applewhite Database Administrator

RE: Long-running SQL

that returns that value and takes :b1 - :b9 as input arguments could be tuned to be faster. It could be used in the SQL Select. Check out the docs for the use of stored functions in SQL statements. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA

RE: Check Constraint

with the RowIDs of the rows that violate the Check. See the Constraint_Clause section of the SQL Reference for details. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327

RE: Automatic shutdown on NT does a shutdown abort

is equivalent to a Shutdown Abort? Try increasing ORA_sid_SHUTDOWN_TIMEOUT and see what happens. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original

RE: Automatic shutdown on NT does a shutdown abort

Jared, Thanks for the links. However, we should be wary since the document at the end of the first link states (near the bottom) 1000 microseconds make one second! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin

RE: Windows NT and Virtual Memory

. and references to papers on the MS site. I went through that investigation a while back, but the exact details have left my brain cell. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com

RE: Re[2]: Fav. Urban Legend...Mem vs Disk

processes releases that memory and is an OK workaround. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Eskridge Sent: Wednesday

RE: Standby Database Problem

Title: Standby Database Problem Hussain, As long as none of your datafiles were corrupted by what I assume was the crash of your Standby Instance, you can reinstall 8i and bring up the Standby just as you describe. The datafiles don't care at all where Oracle Home is. Irecently had to

RE: How to register an package in oracle Database!!

Ayyappan, You can use the procedures in DBMS_APPLICATION_INFO to publish and interrogate the states and actions of modules. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL

RE: what pl/sql construct can return multiple rows?

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Bill Sent: Tuesday, March 19, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hi, Is there a way

RE: Locally Managed Tablespaces

Antonio, We use LMTs for all tablespaces - except for System, of course. No issues, problems, etc. We're happy. 8.1.7.2.5 on Win2k; ~340GB in 29 tablespaces. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin

RE: calling program

Big Planet, Whoa, now there's a can of worms! In a word - no. Not unless you pass that info. in as an argument. Think about what you're asking. Since PL/SQL procedures can be called from, not only other PL/SQL procedures and functions, but the SQL*Plus command line, ODBC calls, Java

RE: calling program

Ouch! Looks like I need to RTFM, not only before asking a question, but before answering one - shoot from the hip = shot in the foot. 8-( Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com

RE: Identification of tables NOT being used in the System.

(for cold backups, for instance), do it right before shutdown. It's just a quick thought...which I probably absorbed from someone else's posting on this very valuable list. ;-) If so, then my thanks to the originator. Jack Jack C. Applewhite Database Administrator

RE: Locally managed ts

Ayyapps, Use the DBMS_SPACE_ADMIN supplied PL/SQL package. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED

RE: Oracle Indexing

recommendation is to have one or a few standard extent sizes in locally-managed tablespaces. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message

RE: Primary keys

that knowledgeable, so who cares if they're happy?!?! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Singh Sent: Thursday, March 07, 2002 11

RE: Restrictng tables during export/import

/imported. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Singh Sent: Thursday, March 07, 2002 10:18 AM To: Multiple recipients

RE: Hundreds of schemas in one instance?

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, March 06, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi Our

RE: EXTENTS?

block can belong to one and only one Extent. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday

RE: Which FM???

Rodd, Oracle8i Reference Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

RE: SNP0...SNPx Memory Hogs

:20 2002 Restarting dead background process SNP3 SNP3 started with pid=11 ... --- Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327

RE: poor query performance

Plan reports is purely relative and can't be used for comparison across different queries. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original

SNP0...SNPx Memory Hogs

. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services

RE: Global variable in Pl/SQL

Andrey, You can't make a PL/SQL variable value visible to all sessions. You'll have to put the value in a row in a table and commit it. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com

RE: datafile compression

the latest version of PKZip? Command line PKZip would be my first choice. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Worley

RE: Where does a DBA go from here?

) I think I've learned about as much as if I'd sat in a bunch of classes - and saved a pile of money. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068

RE: capacity planning??

Shibu, Go to http://www.orapub.com Craig Shallahamer is THE Guru on the subject. I took his course a couple years ago - excellent! Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL

RE: Removing data form a table

Lance, Truncate Table YourTableHere ; This deletes all the rows in the table without the cost of rollback. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327

RE: Oracle and Document Management: any real stories?

-friendly interface for the query operators, you need N programmers (and DBAs) writing M lines of code - in our case Cold Fusion, Java, and PL/SQL. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com

RE: 8.1.7.2.5 interMedia Text Slow Sync - SOLVED

available. BTW, it didn't hurt that I spread the datafiles of the tablespaces that hold the DR$$X segments across 2 drives, instead of just 1. That boosted re-syncs from 600 CLOBs per minute to 750. I/O distribution never hurts. Jack Jack C. Applewhite Database

RE: Where to store BLOB's

segments are in yet another tablespace. BTW, we have about 15 million CLOB documents, so we're not talking a tiny amount of data here. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL

8.1.7.2.5 interMedia Text Slow Sync

, it doesn't write to the online redo logs - it waits until it's reading from DR$$X segment before it writes to the redo logs. I wonder why it doesn't do the writes to redo in parallel with the writes to DR$$X. Thanks. Jack Jack C. Applewhite Database Administrator

RE: Searching Inside CLOBs

. interMedia even supports section searching, so you can search only between selected tags within a CLOB. Check out the interMedia Text docs. It's even available in Standard Edition. You (and your users) will love it. Jack Jack C. Applewhite Database Administrator

RE: multiple extents are OK, dagnabbit!

Title: Message Jerry, If they want to pay you to reduce their extents, then let 'em! ;-) "A fool and his money are soon parted." If they employ youand want you to work weekends on this, then it's worth the effort to educate them. I'm surprised an official Oracle white paper didn't

RE: Partitions

The latter. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Wednesday, January 16, 2002 3:07 PM To: Multiple recipients

RE: Partitions

access to table partitions automatically - your code does not have to be modified. I was attempting to answer your question in a succinct manner - sorry for not being clear enough. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc

RE: Recover Primary DB from Standby DB

. --- Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Wilton Sent: Friday, January 04, 2002 2:10 PM To: Multiple recipients of list

RE: Oracle 8.1.7 on MS 2000

works nicely - it was a dog (in my limited trials) on 8.1.6. Our DB is spread across about 340GB of datafiles on 20 disks, so there's a significant amount of data. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin

Recover Primary DB from Standby DB

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City

RE: Error in Package

Ramon, You've declared the Procedure SELECCIONAR differently in the package spec and body. Oracle must think you're creating an overloaded procedure with different arguments for each version. The spec and body declarations must match. Jack Jack C.

RE: DB SIZE ?

Seema, Several possible solutions - you pick. - Delete Data - Drop Tables - Drop Indexes - Drop Tablespaces That ought to get you started. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas

RE: DBA Weakest Link

trivia absolutely WON'T. Respectfully, Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, December 07, 2001 8:20 AM

RE: RAID system max throughput

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- WILLIAMS Sent: Friday, December 07, 2001 10:40 AM To: Multiple recipients of list

RE: SQL to find duplicate rows...

Group By MyColumn Having Count(*) 1 ) ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Thursday, December 06, 2001 3:34 PM

RE: SQL to find duplicate rows...

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- JAMES W [IT/1000] Sent: Thursday, December 06, 2001 2:26 PM To: Multiple recipients of list ORACLE-L

RE: Duplexing Archived Log Files

Begin Backup command and get instantaneous results - which I had to do recently to restore some datafiles to the Standby after one of its disks failed. I wonder why you get such slow response? Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA

RE: V7 online backups

logs, as well as backup control files, and you've got it covered. Oh, and don't back up your online redo logs - they'll be worthless for a recovery and can cause you grief if you restore them over your current, good, ones. Jack Jack C. Applewhite Database

RE: SQL Loader Commit Point?

Ken, Check the Loader log file. The records are being rejected for some reason and Loader only tells you in the log. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED

RE: deleting duplicate records

Sunil, If there are multiple duplicates foreven a few SKU_Num values, you're doing multiple scans (full table or full index) to get all the dups out. You might reconstruct the SQL to not use a looping construct if there are lots of duplicate rows for each SKU_Num Delete From FMS_Test

RE: rman disk channel destination

Title: rman disk channel destination Lisa, You specify the destination directory with the FORMAT keyword, by which you both format the backup piece files and specify their destination. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8

RE: svrmgrl and W2k

Title: svrmgrl and W2k Lisa, I'm running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl using internal@test or internal@dev. Works just fine.Am I missing part of the problem? Jack

RE: Revoke Delete

FGAC and Application Context successfully to enforce complex security, but the more I think about it, you could really do some fiendish tricks with it - if you were the fiendish kind. ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA

RE: IOT and ora-600 [ktbgcur_2] on NT 81714

currently on 8.1.6.0.0 under Win2k) and I'm hoping the problem will just go away. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message

RE: CLOB datatype

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 4:37 PM To: Multiple recipients of list ORACLE-L Does

RE: how to enable FGAC ?

to implement FGAC properly. Both worked very nicely for me - at least in 8.1.6. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent

RE: Stored Procedures Question

to recompile... Alter Function x Compile ; Alter Package x Compile ; Alter Package x Compile Body ; ... Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327

RE: Problems with Intermedia

Samir, interMedia Text, Audio, Image, Video? What version of Oracle? What platform? We need more info. We use interMedia Text heavily (Oracle 8.1.6 on Win2k) and I've never seen the ctxhx process. Jack Jack C. Applewhite Database Administrator/Developer OCP

RE: Privileges

words are. I have also tried Metalink and could not find a definitive list. Any help would be appreciated. Dave Leach -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: providing 24*7 database ---

Narender, Transportable Tablespaces might allow you to load data in an offline instance then quickly plug in the new data to the production instance. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas

RE: Intermedia Performance Benchmarks anyone ?

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Kendall Sent: Thursday, October 04, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hello all, Although I

RE: Intermedia Performance Benchmarks anyone ?

do now. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Thursday, October 04, 2001 5:36 PM To: Multiple recipients of list

RE: RE: Extents size.

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 12:15 PM To: Multiple recipients

RE: For i (Select..)

arguments to your public cursors and specifying that they return Table%RowType records. That further isolates your code from table changes. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL

RE: Physical access to servers for maintenance

Title: RE: Physical access to servers for maintenance Me too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2 Webservers) at a colocation facility and have used either PCAnywhere or Terminal Services to access them over the Internet for the last 9 months. The developers

RE: ENABLING FOREIGN KEY CONSTRAINTS

= Re-Enabled_PK_Name ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Singh Sent: Wednesday, September 26, 2001 11:40 AM

RE: Design Issue - Quick response appreciated

, then, it is a question pulling all the records with the surrogation key + (all the generation numbers). Thanks, Rao ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Best Uses for Oracle Designer 2000?

David, I've used Designer (and Oracle*CASE before it) for about 10 years now. I've always used it for logical data modelling and physical database implementation. In my Developer past, I've done a ton of Oracle Forms and Reports generation from Designer, as well as Web Server Generator

RE: Need assistance with a 'VIEW'.

or Group By Code1,Code2,Date? In other words, do you want just one resultant row representing the aggregate of all rows with Date InputDate, or a resultant row for every Date? We need more info. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8

RE: veritas backupexec horribly slow on one NT server

Jeffrey, What version(s) of Oracle? Are you using RMan? We use Veritas NetBackup Data Center 3.4GA because our colocation facility supplies it. We run Oracle8i 8.1.6 under Win2k (dual 500MHz CPUs, 2GB RAM) and see in the neighborhood of 300MB/min ( about 200GB of backup in about 10 hrs),

RE: ORA-1410 on interMedia Text Index - SOLVED

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Applewhite Sent: Wednesday, September 12, 2001 7:40 PM To: Multiple recipients of list ORACLE-L Hi, 8.1.6.0.0

RE: how to zip email?

Andrea, Search for the file outlook.pst. That's the single file in which Outlook stores all emails, notes, addresses, everything. It's a pain, but what do you expect from Micros**t. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA

ORA-1410 on interMedia Text Index

. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack Jack C. Applewhite Database Administrator/Developer OCP

RE: nvl not using index

BigP, You could have an If Then ElsIf...Else statement that tested the input arguments of interest (looks like p_loginid and p_firstname), each part having an appropriate Select that did not use NVL if that input argument was Not Null. In essence, you'd be tailoring your Ref Cursor to the

RE: OOW presentations

Girls there knew how to Jitterbug. However, all in all, it wasn't worth the trip. That was my last OOW. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068

RE: [1] oerr

Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, September 07, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I don't have an NT database

RE: Kind of cool feature! DBMS_RANDOM

Anjan, Look in Oracle_Home/RDBMS/admin for the dbmsrand.sql file. The package is better documented there, at least for the 8.1.6 release. I used it last year to generate a Session ID for a Web-accessible application to maintain state across a User's multiple page hits. Jack

RE: Stored Procedure Performance Problem --- Please Help

Title: Stored Procedure Performance Problem --- Please Help Viral, Are you saying your entire database is on one 13GB drive? If so, it's no wonder this operation takes a very long time - you're I/O bound in a big way! The inserts and updates of tables and indexes, not to mention disk sorts

RE: 8.1.7 on W2K

) for Windows. There you'll also find out other goodies, like how to set up for the instance to Shutdown Immediate when the server is shutdown. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL

RE: Auto log apply to standby db using Perl

Rob (Jo?), This is from the Oracle8i docs (Chapter 5 of "Oracle8i Standby Database Concepts and Administration"), but it's so basic that I believe it would apply to 8.0 ... 9.Write a script that you can periodically run to check the log files in the managed recovery directory and move

RE: Flat File vs. Database

You're dang right it's an no-brainer! ;-) Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Wednesday

RE:

happen, then each Oracle process would indeed correspond to an Oracle database. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message

RE: Stored procedures that return multiple rows

Paul, For acouple of projects that I've worked on, several Java programmers have liked having Ref Cursors returned from PL/SQL stored procedures. They could work with those much more easily than PL/SQL tables. Can't remember if we even tried VArrays. I don't think I'd like them for

RE: CLOBs storage vs Varchar storage

in the Create Table command. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- T (Richard) Sent: Monday, August 13, 2001 12:50 PM

RE: For those who got Code Red in the face

? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday, August 06, 2001 2:24 PM To: Multiple

RE: View Help

uses a customized version of the view. It's a handy technique! BTW, create the variable with a default value (Null or some real value) such that the view will work as desired even if the variable is not explicitly assigned a value. Jack Jack C. Applewhite Database

RE: retrieving BLOB column..

Saurabh, Check out the DBMS_LOB package. There are lots of procedures and functions for manipulating BLOBs and CLOBs. Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL

RE: waits on sequential scans - how did i solve it

index is not maintained. Check out the docs on IOTs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 8

RE: RMAN

Joe, The Oracle-supplied "Oracle8i Recovery Manager User's Guide and Reference" has served me well. I'd advise experimenting with the various backup and recovery options and RMan commands on a little test DB to get the hang of it. RMan works very nicely. It's been much more reliable than

RE: Re[2]: security problem with 8i

Schema), plus all the usual default schemas like ctxsys/ctxsys... Needless to say, I closed those holes pretty quickly! Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512

  1   2   >