Search results for query: *

I am the resident computer geek amoung my friends but I was stumped today and was wondering if any of you guys might know. My friend wants to know when the last CD was burned on his computer. He had to fire someone recently and he is afraid that person may have took his data and made a copy...

Probably a poor subject line but I really dont know what I am doing. I am an Oracle developer that has inherited a 9 year old Perl script that moves files and kicks off Sql*Loader scripts. We are moving off of Unix and on to Linux and this script is acting crazy now. I wonder if any of you guys...

OK So I need a point in the right direction. Every month I load several snapshot tables based on end of month data. They are all stored in partitioned tables. At the beginning of each month I have several users running thousands of reports from Business Objects using these tables (amoung...

Can I do this? create table test_table (current_flag varchar2(1), status_group varchar2(20)) PARTITION BY LIST (CURRENT_FLAG) SUBPARTITION BY LIST (STATUS_GROUP) subpartition template ( subpartition ACTIVE values ('ACTIVE'), subpartition DCEASED values ('DECEASED')...

Hopefully I am in the right forum, I apoligize if I am not. I created a Macro which loads a table using the TransferDatabase method and it works fine. When I run the Macro, a DBF file is grabbed and loaded into in Access table and then an append query loads the final table. My question is...

Basically I need to replace a null value with a default value. Here is what I have done. UNRECOVERABLE LOAD DATA TRUNCATE INTO TABLE PS001.PS_EMERGENCY_PHONE ( SEQ_NUM POSITION(1:9) CHAR, EMPLID POSITION(10:20) CHAR, CONTACT_NAME POSITION(21:70) CHAR...

I have a NAWK statement that I am using to get data out of a comma delimited text file. My problem is that one of the double quote enclosed field sometimes contains a comma. Anyone know the syntax to handle this? For example you would put optionally enclosed with " if you were using...

Hi folks, Im new to AWK but I have about 150 files that I need to pull about a dozen fields from these comma delimeted files. When I run the AWK script I wrote I am getting a "has too many fields" error. The file has a lot of columns (more than 100 columns) Can any of you experts let me...

Ugh oh look out, Oracle guy in your forum. Please dont kick me out! I have a question for you guys. I have an oracle data warehouse which uses PeopleSoft data on a DB2 mainframe environment. Right now we recieve files from DB2 nightly using COBOL extract programs. This process is very tedious...

With the assistance of this board I was able to manipulate and Access Database so it will update our Oracle tables. I have completed my work on our development side and am ready to migrate to acceptance. Does anyone know an easy way to change how the pass through query connects to the Oracle...

Here is the easy question of the year. How do you grant a user the privilege to truncate a table on a different schema. I tried GRANT truncate on <table_name> to user But of course that doesnt work. I also looked on the user_tab_privs table and couldnt find the right privilege. Can any of...

Can anyone tell me how to truncate (delete data) a table in Oracle from Access? I have a an Access table that will be loaded monthly into our Oracle database. So far I have been able to load it with an append query but I cant figure out how to empty it from Access before I load it. Any help...

Our data warehouse was victimized last night by a stage table with stale stats. The load hang and users logged in to find missing data. (yuck) So I am now try to create standards for gathering stats on our tables. Anyone know a good resource for becoming an expert on the DBMS STATS PACKAGE...

Guys- I just got on with a team that is talking about moving to Oracle RAC. Anyone know where I can find resources (preferably not from Oracle) where everything about Oracle Rac is explained including pros and cons? Im hoping to get a better understanding of what it is before I start asking...

I am an Oracle developer that has no experience with SQL server. I need to push a series of tables from my Oracle environment to a SQL Server database. My first issue is connecting to SQL Server from UNIX. Can someone please point me in the right direction? Thanks

I have a table with about 3 million rows. I have a procedure that updates one column with current values. This takes about 18 minutes. My problem is that I need to also set the values to 0 for rows that are not in the source. I started by updated the table and setting all values to 0 and then...

Just finished testing the MERGE command on our data warehouse. WHAT AN AMAZING COMMAND!!! So quick and eliminates timely PL/SQL. PROBLEM: When running the MERGE command twice in the same session I get an error. QUESTION: Any clue on how I can refresh my session within a procedure? Our...

Quick question, I am a Oracle guy so be patient this is my first app ever in Java. I wrote this with the help of NetBeans if that makes a difference I wrote the following code to generate numbers: /* * JApplet.java * * Created on April 27, 2004, 12:59 PM */ /** * * @author bowcudj */...

Hi I am working on an HR data warehouse that requires a factorial in one of the aggregates. If you don't know, 7 factorial = 7 * 6 * 5 * 4 * 3 * 2 * 1 It also can be be written as 7! I wrote a function to do this but I would rather use SQL if this is possible. The function looks like ...

I have a complex insert statement that joins to a table that is specific to a small number of employees in our company, hence I need an outer join. The problem is that I have to join to the MAX(effective_sequence_nbr) with an outer join. I keep getting errors on that join example and...