Search results for query: *

One of the application administrators set foot in my office today (how dare he!) and started off a question with "In the SQL Server World....". Apparently, in SQLServer, there is a way to say that if user Bob is trying to connect through MS-Excel, then we allow it, but if he tries to connect in...

(This is probably more Perl related, and I've posted the same message in the Perl forum, but in case anyone here uses the tool and has come across this before - or a similar problem) I use a tool called OracleTool (http://www.oracletool.com) to help with certain DBA functions on my Oracle...

I use a tool called OracleTool (http://www.oracletool.com) to help with certain DBA functions on my Oracle databases. I had been happily plodding along on oracletool 2.0 for that last 2 years, I visited the site and saw that there was a newer version, version 2.2. So I downloaded and installed...

We run CICS/TX-Series 5 (CICS at PTF 4, Encina to PTF 3) on HP-UX 11.11 with Oracle 9. In one of our regions, we keep getting core dumps in /var/cics_regions/<region> for that region. We've been wondering what's been causing them and I think I finally found a connection yesterday. I was...

I've got two tables in one of my databases each currently with 102,650 extents. At one stage, they had a lot of rows in them, but now they have very few. I want to reclaim this space drop exporting, dropping, recreating and importing them. However, it's the truncate and delete that I'm...

I'm doing some work on an old machine that is running HPUX 10.20, Oracle 733, MIMS 4.1 and TP 2o (told you it was old :)) Was trying to copy to a testing machine - and couldn't get the 2o to compile. Had a tar of a 1r TP lying about so I thought to myself "Self, let's try to install that"...

We have a production database used mostly for OLTP and a few batch jobs and then a replicated copy of the prod database that ad-hoc queries run again. One of the query developers has come to me with a problem. Her query runs in about a minute on the replicated database and runs for 30 minutes...

So the Internal Auditors decided that we need to do a little more Oracle Auditing than we are now. So, I did the following: In init.ora: audit_trail = db audit_sys_operations = true I bounced the instance. When the instance came back up: audit dba, resource whenever successful; audit all...

I have customer who is on HPUX 11.0, Oracle 8.1.6 who wants me to try to do the following: Take their hot database backup DB files and try to create the database from those control files under Oracle 9.2 on HPUX 11.11 I'm wondering, will this work? I'm wondering whether the information in the...

OK, hobbiest Delphi programmer using D5 Pro here. When I was first learning Delphi many, many moons ago (learning on D3 Pro), the instructor at the time showed us how to create a project inside what I think was an ActiveX component and then he brought the resultant application up inside...

Hi, I'm in the process of doing a slight reorganization to my database moving from auto allocated LMT's to Uniform Extent LMT's. I've pretty much got it all scripted and tested but I've seen some conflicting articles on whether you can do it with the database open and with users updating the...

We have a third party application that runs on an Oracle 8.1.7 database on HPUX 11.0. As a part of this application, there is a SQL Server database that replicates, using some function of SQL Server, certain data from the Oracle DB into the SQL Server DB. From time to time the power goes out...

I have a requirement to take the contents of a TDBRichEdit with some bolded text and drop it out to a text file with all bolded characters converted to uppercase. So for example: This sentence needs to be processed Would need to look like this after processing: THIS sentence needs to be...

My application writes out files with a *.dek file type. I've had a request from my users to be able to double click on these files, launch my app and open and process the file. My questions are, then: (a) How do I associate this file type with my app? I assume that there a Registry setting...

I've been looking around for a good script to monitor next extent failure conditions (i.e. the next extent an object is going to want is bigger than the biggest segment of freespace in that object's tablespace) for locally managed tablespaces. We had a monitor in place when we were dictionary...

Hi, I'm looking for a way to make a Tlabel's text run up and down - not like this: L a b e l I mean taking the word "Label" and doing a complete 90 degree rotation (so that you'd need to tilt your head left or right to read it). I'm using D5 Professional edition and can't seem to work it...

I was wondering if anyone has managed to separate Production source access from Development / Test / Whatever through Mincomcm. We have everything on the same machine (HP Superdome) and the auditors were less than pleased to find that all of the programming staff has access to production source...

I have a form with a DBGrid to the left and a DBRichEdit on it to the right. The grid lists all current result set and the DBEDit will show the text of the current record. DBRichEdit1 points to DataSource dsReview which is a TQuery. The DBRichEdit has DataField set to 'Text' (which is the...

We're looking at a way to do password change management and while we're talking about developing something I thought I'd ask if anyone knows of any downloadable tools to do what I'm about to suggest. We have users logging in to the database through a third party query tool. In order to do...

The developers in our organization have an application that is writing to the utl_file directory. (HPUX, 11.11, Oracle 9.2.0.2). Permissions on the files are 600. Of course, ownership of the file is oracle. The users want to be able to access the file. Umask for oracle is 027 - I had...