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

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/

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

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

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

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

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

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

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/

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/

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

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

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

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/

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/

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/

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

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/