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

    carlosdl70,270 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:
  • 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...

    carlosdl70,270 pointsBadges:
  • Is there an IBM Tool to Rebind Plans/Collections

    I am an applicaiton developer, (analyst) resonsible for ensuring four test regions (and sometimes the produciton region) performs as effieciently as possible. We have approximately 1000 programs that have not accurate statistics (run stats are not updated, another question). Our DBA's tell us it is...

    MEAnderson0 pointsBadges:
  • Developer to Data Architect

    Hi, I am currently working in Java/J2EE technologies and Oracle Technologies. I have very good knowledge of Oracle (SQL, PL/SQL and Performance Tuning). I want to tune my career as a Data Architect in the current Application. Please, guide me in this aspect. Regards, Viswanath

    Viswanatharaju0 pointsBadges:
  • What partiotions (slices) I should use for Oracle 10G?

    I am building a test server with Solaris 10 and oracle 10G. I would like to know what is the best partitioning that I should do? Thanks, Luis

    Ghostsword0 pointsBadges:
  • purchasing a computer laptop

    what do i need to watch out for before purchasing a laptop,am hoping to become a programmer in future.am currently studying computer science and working also in the IT department

    Tawakalitu0 pointsBadges:
  • Oracle Longops Queries.

    Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.

    Techanalyst100 pointsBadges:
  • Oracle RAC – Hotstandby (physical)

    I have a 2 node RAC cluster (10.2.0.1) running on AIX. For testing and documentation purposes I need to create a hot standby on the second node. I have attempted this with varying error messages. I have an SR open with Oracle but have gotten no where at all. If anyone has done this or has an idea...

    Sequential0 pointsBadges:
  • Group data by week

    Hi, I would like to group my data by weeks( and the user gives the from to Through date). But the problem is the week in this report starts from Friday and ends on thirsday. for instance if the user gives 1/3/06 to 1/12/06 then I want to display my data like this 1/3/05 - 1/5/05 Sum of my fileds...

    Smitha800 pointsBadges:
  • Partitioning a large financial table

    i hv a large table (GL details that is abt 30-50mb) that contains financial data. i want to partition it by these fields 1) company code 2) Quarter (based on the financial periods) 3) Year Eg, data Select GLCO, GLYEAR, (TO_CHAR(GLYEAR) ||'/'||TO_CHAR(GLMNTH)) As Yrmth, GLMNTH, GLAMT FROM GLPGL;...

    Mayleong0 pointsBadges:
  • Oracle Developer 6i and 9i database connection problems

    I cannot connect to a 9i database patched to 9.2.0.6 (I can if the server is patched to 9.2.0.5) from a 6i Developer client on XP. Tnsping80 is OK but not SQL. I get kicked out of SQL and the error report references ora805.dll. When I install the 9i client I can connect with it but still cannot...

    6to4to30 pointsBadges:
  • index usage on dynamic search criteria

    Hi, I have a very dynamic searching requirement. We can searh any columns of the tables in the database, using any criteria columns of tables in the database. Right now, we are facing some performance problems as the data grows in a rate of 2,000,000 records every three months. We plan to build the...

    Cassidy6o60 pointsBadges:
  • read only user

    I've got an Oracle 9.2.0.5 database and I need to create a read only user that can view any table, view, package, etc. I've created the user but I can't figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I...

    Skovac0 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