Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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