• How to update a oracle table containing 4 billion records

    I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is...

    Ws8oBPSQ15 pointsBadges:
  • How can I update a huge Oracle table containing 4 billion records

    I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace...

    Ws8oBPSQ15 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • DB Migration from 8.1.7 to 10gR1

    I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which has happend for such duration and...

    Ajmalziyad0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • Table not using index

    Good day, I have a table containing 4 billion records and adding 7 million records per day, working with a date and timestamp. Currently the table is created with a date (charging_date) and a timestamp (named timestamp but with format varchar2(6) - i.e. '065000' for 06H50 AM). I created a new...

    Ws8oBPSQ15 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • Testing how long an SQL script will takfe to run

    Running Oracle 9.2.x. We have to sun a couple of SQL scripts that will make some changes to tables/data. Is there a way of finding out approximately how long these scripts will take without actually running them? Is there some tool I can use to do this? Or some rule of thumb?

    Pingsc0 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Table Level Triggers – Triggers on Two Fields Within the Same Table

    Hi, I was wondering if some can have a look at the following triggers on a single table but on two different Fields that are referenced in both triggers: CREATE OR REPLACE TRIGGER AAL015_HWT_TRG BEFORE INSERT OR UPDATE ON AAL015 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN IF INSERTING OR...

    SamAvella30 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:
  • help! – - – trigger compilation error when calling a stored procedure.

    my trigger wont compile. below is the code and errors. Any help is greatly welcomed. thanks very much. DECLARE ROWCNT NUMBER; PIN NUMBER; SIGNUP_URL VARCHAR; -- -- BEGIN SIGNUP_URL := 'http://signup.2gn.com/signup.pl'; SELECT COUNT(*) INTO ROWCNT FROM SUBSSHORTCODE WHERE SHORT_CODE = :N.SHORT_CODE...

    Ceepari0 pointsBadges:
  • Simple but not so

    I have 2 table 1) Product_Inf and 2) Product_attribute_details I have prod_key, dye_class, prod_range in both the table. Their is no relation exist between both the table than how can i find the records available in Product_Inf but not in Product_attribute_details?

    Ilink880 pointsBadges:
  • career advice

    i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met a friend who...

    Haller80 pointsBadges:
  • CLOB and VARCHAR2

    Hi Isn't there a mid way between using the VARCHAR2 and CLOB datatypes? I need to have a column that will contains upto 6000 characters so I can not use VARCHAR2 for this. And i don't want to use CLOB as it might bring in some other problems like space management (coz it can occupy upto 4gb)....

    Abhivyakti0 pointsBadges:
  • Installing Oracle 9i on Windows XP

    When trying to install Oracle 9.2 on a computer that has Windows Xp, I am receiving this error message: Unable to install Orcale 9i: EDS cannot support more than two Oracle homes. Then the installation aborts. How can I fix this problem?

    Bushka0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following