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 derfloh 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: jaxtell
  • Content: Threads
  • Order by date
  1. jaxtell

    setting a DEFINE value at runtime

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

    buffer_pool recycle size

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

    use dbms_metadata to change compression

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

    SQL Loader question

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

    implicit conversion question

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

    Get text strings from a binary file

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

    adding a partition

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

    offline a RAC instance

    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/
  9. jaxtell

    matching at multiple levels

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

    Batch file to update HOSTS file

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

    Copying a Database

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

    BFILE or BLOB?

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

    Pinning Objects

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

    Problem with context index

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

    Materialized View

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

    Convert a number to a date or timestamp

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

    Java stored procedure errors

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

    Code Migration

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

    aggregate string concatenation function

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

Part and Inventory Search

Back
Top