• 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:
  • Educating database users

    Database administrators must always be prepared to handle users' database problems and concerns -- even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don't understand the work involved...

    RobynLorusso230 pointsBadges:
  • problem related paper size (Crystal Report 9)

    My project (in VB & Crystal Report 9) needs different shaped bills (10?X12?, 6?X12?, 15?X12?) to print through DMP. But I am facing problem to control paper size through code.

    Sahanil0 pointsBadges:
  • Oracle SQL – convert rows in a table to columns in a query

    Please forgive me for being longwinded. I am trying to pull data from 2 tables, there is a courseid field that is the primary key linking the tables. The first table contains the demographic and course name, the second table contains some detail information for the course - mainly number of...

    Aaron251770 pointsBadges:
  • Oracle Export

    What woould I have to do to run an "Oracle Export" from my Clients Desktop. client has no knowledge of Oracle. I have finished the installation and now want my client to be able to "Export" the database. It is not a large database and can be exported ion a few minutes. Can you help? Vince

    Ogilface0 pointsBadges:
  • Old Approach App in XP

    Hello, Have an older Lotus Approach '97 DB App here that I have been asked to see what it would take to get back working in our XP enviroment. This is about 10 Approach Databases in an relational type of setup with about 2000 records and 150 or so custom layouts. Have messed with it a bit and for...

    R8escjohn0 pointsBadges:
  • Print Numbers in words

    By using a single SQL Query Is it possible to print numbers in words. Example : To print "5,550 Dollars" in words Expected Query result : "Five Thousand Five Hundred and Fifty Dollars Only" Is it Posssible by a single query

    Sanmails0 pointsBadges:
  • ORA-01000 error even if all statements and resultsets are closed in finally

    I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver 'Enable Resultset' is ON and 'Enable Closing cursors' is OFF Please suggest how to...

    DeveloperJava0 pointsBadges:
  • 64 bit Oracle

    Hi, I'd like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM's Power servers are tempting, even with the added expense of...

    Gabopagan0 pointsBadges:
  • Run exe from Forms 6i

    Hi Can I run an external exe app from a when-button-pressed trigger? If the exe expects input parameters and outputs a code can these also be processed by forms 6i? If so, how do I acheive this? My OS is Windows 2000. Thanks.

    Dlaw650 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