• Using optimizer hints in Forms

    Hello everybody. A few weeks ago I posted a question about Sql Tuning in Oracle, and I have been experimenting with optimizer hints and execution plans (all this in Sql Plus), but now, a doubt arises to me. Can I use the optimizer hints in Forms 6i (program units or triggers) ? Since they look like...

    carlosdl65,110 pointsBadges:
  • Oracle table partitions

    I'm attempting to address some performance issues by using list partitioning. As an experiment I created two small tables (~1000 rows) of vehicle maintenance data, one with no partitions the other partitioned by vehicle type: create table myschema.mynewtable tablespace mynewtablespace parallel (...

    Wornout0 pointsBadges:
  • Oracle 9i Server and XP Pro

    I have installed Oracle Server 9i on a Windows XP machine. It works well when connected to from the same machine. It is not possible to connect to from another machine (Win 2000)using Client 7i or Client 9i or Client 9i, as though the listener wouldn't work. Is there any known issue with 9i Server...

    Baumic20 pointsBadges:
  • Start-up Needed for DB design for workflow for BPO company

    Can any one give some usefull and urgent tips about database design example where i get for designing BPO company work flow parts...

    Malaikanirr0 pointsBadges:
  • Capture screen w/scrolling marquee

    My company uses a 3rd party software. There's one screen that has a few graphs and a few lines that scroll across the screen. Similiar to a Screen Saver's Scrolling Marquee. They redesigned the software and this screen will no longer exist. I would like to capture this screen w/scrolling marquee....

    Drew65220 pointsBadges:
  • SQL server replication

    We have diiference in two databases which are being replicated. What may cause the difference and how to find the differences. SQL sever 2003 is tha databse. Thanks

    Anjuajay0 pointsBadges:
  • Doubts regarding speed in data access

    y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server which will read a text...

    Cmyahya0 pointsBadges:
  • Updating Access Database Structure At Run-Time

    I have an app that uses an access database for its back end. When a program update is issued someone has to manualy add the new fields, queries etc to the clients db file. Is there a way i can mimic the development database schema and update the database from the file upon installation of the...

    Middert0 pointsBadges:
  • Numeric values search from alphanumeric column of DB2

    In DB2 I have the requirement of sorting only numeric values from varchar data type column by using some range criteria. The database table contains numeric as well as alphanumeric values. For ex. `1?, `2?, `6?, `13?, `34? ,?ABC123?, `POE?, `12IUY?, `FG23RF? etc. Using range search of 1 to 20,...

    J2EEJava0 pointsBadges:
  • Oracle Client 7.3.4 installation on Windows server 2003

    hi, I need to install oracle client 7.3.4 on windows 2003 server.When I tried ,seemed like there is product available latest for only windows NT. Is there any work around for this ? ------------ If there is no way we can install ora client 7.3.4 on windows 2003. How do I handle the OCI calls with...

  • Zebra printer will not print CORRECTLY through Oracle application(s)

    Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held "pistol" scanner failed. Connected to a laboratory balance via Omnilink...

    Poppaman20 pointsBadges:
  • adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • Database Implementation

    What is the best practice for implementation of a new Database software package (I.E. creating teams, or work with a Committee) My boss would like me to learn everyones job, is this really necessary to implement a new Database package...

    Redstang900 pointsBadges:
  • Oracle Sql Tuning

    Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let's say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write 'where' clauses putting first the join conditions and after them, the table specific...

    carlosdl65,110 pointsBadges:
  • Updating a CLOB

    I am trying to remove carriage returns at the end of clob fields by using the following in sqlplus: update scbdesc a set a.scbdesc_text_narrative = (select substr(dbms_lob.substr(scbdesc_text_narrative),1, length(scbdesc_text_narrative) -1) from scbdesc b where...

    Warpmail5 pointsBadges:
  • Oracle boolean data type questions

    Greetings, Since Oracle Table structures do not support a boolean data type, there is a choice (Make it a varchar2(1) or Number(1)), with contents of 0,1 or Y,N The questions I have are: 1) From a comparison perspective, which provides better performance? Comparison of a number (1,0) or string...

    SrDataArch0 pointsBadges:
  • AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …

    Hello everyone, Hope all is well ... Any help, opinions, direction to whitepapers, benchmarch reports, overkill/underkill comments, and the like would be greatly appreciated: We are in the process of spec'ing out hardware needs for our targeted new data warehouse and new consolidated database...

    Ericggordon0 pointsBadges:
  • 16 bit application connection to ORACLE 9

    Our company has previously developed 2 old software 16-bit applications that connect to ORACLE v7. Q: Is it possible to get these apps to connect to ORACLE 9? I'm told that this may be generally regarded as a 16 Bit to 32 bit issue, and that we may need some an interface/translation from 16 Bit...

    GoldenSnitch0 pointsBadges:
  • Oracle 9i export unsuccessful since patch update.

    Hi, i'm quite new to oracle, i've got an oracle 9i database been running 1 year, which runs an export every night. Everything has been working fine on 9.2.0.1.0. I updated straight to 9.2.0.7.0. Everything else looks ok. Users, still happy. Now export fails with: Connected to: Oracle9i Release...

    aglking0 pointsBadges:
  • DataBase Administration

    Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier... but I'm not sure about that. Is that a good idea...

    carlosdl65,110 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