Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: THoey
  • Content: Threads
  • Order by date
  1. THoey

    Is DBA a Salary or Hourly position?

    Hi all... My job has recently moved me from a salaried position to an hourly position and we are already running into issues bumping against my "schedule". I am trying to gather information to take back to my management to show that it really isn't in their best interest to have me on a...
  2. THoey

    SQL to determine locks

    SantaMufasa had a great reply to thread759-1363380. I am needing to take it a little further and see the query that is actually causing the lock. Is there a way to do that? Terry ************************** * General Disclaimer - Please read * ************************** Please make...
  3. THoey

    Kaspersky found a virus

    All, been trying to clean up a PC. Was getting the following error: Generic Host Process for Win32 Services has encountered a problem and needs to close. I ran Spybot, Adaware and SuperAntiSpyware and cleaned anything I found. Ran Norton's and it said it was clean. Then I ran Kaspersky's and...
  4. THoey

    Exporting LOB Tables

    Are there any known issues with exporting LOB tables? I did an export from database A, schema A. Then did an import of that data into database B, schema B. The import generates warnings as it is trying to create three of the 82 tables in a particular tablespace instead of the default user...
  5. THoey

    Scripts to write scripts

    I have gotten pretty good at writing SQL that generates other SQL. But try as I might, I can't figure out how to add this twist to it. I have a call history table that has a record with data for each call into our system. I need to move this data from one schema to another in. Since...
  6. THoey

    Moving IOT Tables

    All, We are having an issue now with a tablespace that grew too large and needs rebuilding. Part of the process required that we move all objects from the tablespace and then resize it. The issue we are running into now is that there are several Index Organized Tables (IOT's) that are in...
  7. THoey

    Recreating Indexes Through EXP / IMP

    I did a search and came across a couple of threads that showed how to create DDL scripts for indexes by performing an EXP and then an IMP with the following options: SHOW=Y INDEXFILE=SOMEFILE.NAME When I do this, I am getting a lot of errors during the IMP and the INDEXFILE is created but...
  8. THoey

    Quick Synonym Question

    Is there a privilege that can be assigned to one schema to allow it to modify, or drop and recreate a synonym in another schema? If more detail is needed, it is a little convoluted, but here goes: A developer created a schema for an 24 X 7 application. For security reasons, I have been...
  9. THoey

    Separate Application and User Accounts

    Trying to figure out the best way to do something and unfortunately, I am at home and away from all my books to research it with. Hopefully you can help. I have a schema that is the application owner. Inside this schema are all the tables, indexes, and packages that make the application...
  10. THoey

    Table Design and Indexing

    I should know the answer to this, but it has been too long since tuning class. I have a client that currently has a table similar to the following: CALL_HISTORY PHONE_NUM VARCHAR2(10) NOT NULL CUST_CODE VARCHAR2(3) NOT NULL CALL_DATE DATE NOT NULL ... Currently, there are two...
  11. THoey

    Database Links and Stored Procedures

    I am trying to create a stored procedure to pull data from an external DB nightly. I first wrote the code to query this DB through a database link. Once I got that refined, I converted this to a stored procedure, but when I run that procedure I get an ORA-00911 Invalid Character error. I...
  12. THoey

    Design Question

    I have a developer that designed a "tall and skinny" table. Each record has a date, a tag id, and a count. That was fine until we started having almost 4000 tag id's per day. Now, when they are starting to pull weekly or monthly reports using Business Objects, and due to a limitation of...
  13. THoey

    Stored Procedure Job Locked

    We were doing some maintenance and noticed that a stored procedure run through DBMS_JOB that analyzes a schema was taking way to long to run. The code for the stored procedure is: CREATE OR REPLACE PROCEDURE "SMFRPT_PROD"."ANALYZEREPORTSOBJECTS" IS BEGIN DBMS_UTILITY.ANALYZE_SCHEMA...
  14. THoey

    Export Compression

    All, I have 26GB worth of tablespaces that I will need to export, FTP, and then import into a new database. The two servers are in the California and Texas, so we are now having concerns how long this is going to take. Anyone used the compression that comes with the EXP utility? How...
  15. THoey

    Duplicate Records

    I have a table with about four millions records in it. This is a call history table and tracks the customers phone number (TN), the date they called, and some other data. I am trying to write a query to pull out all TN's where a customer has called X number of times within a certain time...
  16. THoey

    BLOB Size

    Someone has come to me requesting a table that will store a 20 KB .WAV file in the database and they are wanting to store it in a BLOB data type. First, does this sound like a good use of the BLOB type? Second, I am trying to estimate the size of the records that will be in the table...
  17. THoey

    Analyze Objects using a Stored Procedure

    I am trying to write a stored procedure that will be ran on occasion to analyze the two tables and three indexes owned by a schema. I have tried a couple different formats to the calls and the procedures compile cleanly, but they do not execute. I am sure it is something simple, but...
  18. THoey

    Testing a Stored Procedure with Return Parameters

    I wrote a stored procedure that requires several parameters and then loads a record into a table. The procedure is supposed to return a 1 if the load was succesfull and a 0 if it failed. The code is here: CREATE OR REPLACE PROCEDURE INSERT_CALL_RECORD ( INPUT_TN IN...
  19. THoey

    OEM and Passwords

    I just got a new desktop at work. Is there a passwords file that I can move over that will keep my logins and passwords for OEM? I have a lot of different databases in the OEM tree and it would take me all day to log into each of them and remember the different passwords. Thanks in advance...
  20. THoey

    Materialized View Update

    Hi all, Just need to check to see if I did something right. I have created a Materialized View on a local instance of a table from a distant database instance. I want this MView to refresh every hour. I created the view and the log file with the following code: -- CREATE MATERIALIZED...

Part and Inventory Search

Back
Top