Search results for query: *

I'd like to change a create table script to decide at run time which compression to use. Here is what I have so far set define on column compression new_value compress_for noprint select 'oltp' as compression from dual; create table .... compress for &compress_for ...; set define off I'll...

I'm trying to use buffer cache more effectively on a warehouse system. There are several tables between the external table and the fact table where the data will live. The interim tables are there to allow partition wise joins and break the data up into manageable sizes. Since I'm only...

Hi, I'm trying to use the dbms_metadata package to make a copy of a table, changing only the name and the compression. I want to change "compress for oltp" to "compress for query low parallel". Can I do this with dbms_metadata, or is there another way to do it? Thanks...

Hi, I am trying to use sql loader to import certain records based on if they match any value in a lookup table. Something along the lines of into table upload_interface_table when (1:2) = '01' and (60:61) in (select value from common_lookups where ...) I get the error SQL*Loader-350...

This query ran fine in 10.2.0.4. Now that I'm using 11g, It gives me an error ORA-01790 SELECT emp.oracle_user_id AS value_passed, emp.full_name AS display_name FROM employee_ref emp WHERE EXISTS(SELECT 'x' FROM action_history ah WHERE...

I am trying to figure out exactly what SQL statements an executable is running. I can view or grep the file to see the text, but there is a lot of it. Is there a good way to retrieve these string from a binary file? The closest I've gotten so far is grep -i --binary-files=text "delete "...

Hi, I have a some tables set up like so CREATE TABLE ACTIVITY ( . . . CLOSED_DATE DATE, . . . ) TABLESPACE ACTIVITY_MAX_D PCTUSED 80 PCTFREE 10 INITRANS 4 MAXTRANS 255 STORAGE ( PCTINCREASE 0 BUFFER_POOL KEEP ) LOGGING...

I have a RAC environment with 2 database instances. There is a need to restart the server running one of the two instances. Can this be done safely? What are the steps to do it? ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/

I'm working on a sql statement used to provide a list of categories and subcategories for a web site. Originally, it displayed all categories and first level subcategories SELECT par.web_category_id AS GROUP_ID, par.web_category AS group_description, CAST (MULTISET (SELECT...

Does anyone know how to write a .bat file to add a line to the HOSTS file? I'm looking for an easy way to fix a VPN DNS issue, and I think adding a line to HOSTS is the best/easiest way. Is there another place I should be asking this question? Thanks...

How complicated is it to copy a database? We take down our database every night, copy all the files, and bring it back up. Other than copying the files to a different server, what else needs to be done? I'd want the copy to come up under a different name (UAT instead of PRD), and I have some...

I'm about to add a new feature to my company's system but am having trouble deciding if I should use BFILE or BLOB. Here is the basic scenario. Our system has object type (contact , address, order, rma, etc) that can be associated with other types (contact with a site, order with a contact...

I'd like to understand pinning objects better than I do right now. Based on this link , I have an idea. Will the select owner,name,type,sharable_mem from v$db_object_cache where kept='YES' show all pinned objects? I see mostly table names and index names with type 'INVALID TYPE'. I was...

I'm having an issue querying a table using a context index, when there is an ampersand in the contains section of the where clause. For example SELECT inventory_item_id, keyword FROM item_keywords WHERE contains (keyword, 'AT' || chr(38) || 'T') > 0; returns a lot more than I'd expect. But...

I have a question about refreshing materialized views. In my environment, 95% of the materialized views are in a reporting instance and are only refreshed nightly, when no one is using the system. I now have a need to create a materialized view in our transactional environment, and it will...

Hi, One of the applications I'm using stores timestamps as numbers. IE 001206640065185 . Divide it by 100 and thats the number of seconds since Epoch. What is the easiest way to convert this to a Date datatype? Thanks. ----------------------------------------- I cannot be bought. Find...

I have a java stored procedure that doesn't seem to be working right. If it were writing to System.out or System.err, where would that be? I'm guessing I can look it up in the data dictionary, but I haven't had any luck finding it so far.

I'm looking for a good way to migrate changed code from development to test to production servers, for a group of less than a dozen developers. Right now, we use TOAD with team coding. The problem is that sometimes a developer will lock the package, make some changes, move it to development or...

Is there an aggregate function to concatenate strings? If not, can you provide some direction on how to make one? So something like select agg_concat(first_name, ', '), last_name from my_table group by last_name; would return something like John, Bob, Bill Smith Mike, Joe, Steve...