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!

  • Congratulations gmmastros 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: *

  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

    Yes, and that is my current strategy. But it seems more like a hack than the right way to do it. ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  4. 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...
  5. 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...
  6. jaxtell

    implicit conversion question

    Apparently it's a known bug. Workarounds include alter session set "_optimizer_squ_bottomup"=false; or alter session set "_optimizer_unnest_all_subqueries"=false; or alter session set "_optimizer_unnest_disjunctive_subq"=false; or use TO_NUMBER for explicit conversion...
  7. jaxtell

    implicit conversion question

    The "workaround" I've shown isn't what I'll actually use. I only came across it because my co-worker thought it was a problem comparing a number to a number(15). My guess was that it was a bug, but I'm not a fan of filing tars with oracle. Thanks for the help...
  8. jaxtell

    implicit conversion question

    Sorry about the formatting. I rarely use SQLPlus, and just discovered its dos only for 11g. SQL> select version from v$instance; VERSION ----------------- 11.2.0.1.0 SQL> select table_name, column_name, data_type, data_length from dba_tab_cols wh ere table_name in ('EMPLOYEE_REF'...
  9. jaxtell

    implicit conversion question

    Santa and Tharg, I'm not disagreeing with you. I simply wanted to know if it is supposed to work differently in 11g than 10g, or if it is a bug or configuration issue. Dagon, I wouldn't actually do that in production code. But one of my coworkers did it and thought he identified a...
  10. 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...
  11. jaxtell

    Get text strings from a binary file

    This is what I ended up with strings FILENAME | grep -i -o -P "delete [\W|_]+" > delete.txt ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  12. jaxtell

    Get text strings from a binary file

    Ah, yes it does. Knowing the right command makes things quite a bit easier. Thanks! ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  13. 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 "...
  14. jaxtell

    Log rotation with logrotate and log4j

    This isn't my area of expertise. I have an idea, although there is probably a better way. You could create a script that regenerates the configuration file with the current list of logs files. Then just run that script before you run logrotate. Not exactly efficient, but I think it would...
  15. jaxtell

    Please Help: Apachee and Folders

    I did a google search for apache authentication windows, it looks like the first result give you step by step instructions. It even has pictures. Do you need more help than that? ----------------------------------------- I cannot be bought. Find leasing information at...
  16. jaxtell

    Please Help: Apachee and Folders

    Did you follow the how-to and get stuck, or do you just want someone to do it for you? ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  17. jaxtell

    Please Help: Apachee and Folders

    You need to use some type of authentication on your windows machine. A how-to for apache authentication is here . ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  18. jaxtell

    problem with preg_match

    I think you should be escaping the special characters, including the slash in the middle of your expression. ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/
  19. jaxtell

    Advice me! Using Java instead of Oracle Forms

    I think ADF and JDeveloper work together. ADF is a framework. From oracle's site You don't have to use JDeveloper to use ADF, and vice versa. So you'd be using JDeveloper and ADF, instead of Oracle Forms Builder. I'm far from an expert on the subject. It's probably worth while to read...
  20. jaxtell

    Advice me! Using Java instead of Oracle Forms

    My understanding is that oracle forms is a thing of the past. You probably want to consider Oracle ADF for new development. ----------------------------------------- I cannot be bought. Find leasing information at http://www.joshaxtell.com/

Part and Inventory Search

Back
Top