Oracle

The most-watched IT questions this week: Oct. 13, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

How do I concatonate the data from the same field from multiple rows

I need to concatonate data from the same field with multiplre rows witha one to many relationship. As and example: oder_id     product 503          corn  503          beans 503         apples the end result wanted would be ...

Print Context ID Report in version 3.5.1

Can someone please tell me how to print a context ID report in UPK version 3.5.1?  I used to be able to get one in a previous version but despite much searching cannot find one in the newer version I have now.  Software/Hardware used: UPK

Converting FMX to FMB in Oracle 6i version

Hi All, As I have lost my FMB file, i wanted to convert to FMX to FMB. How do we convert FMX to FMB? Is there way to convert? Please give the steps do so. Software/Hardware used: Oracle 6i Forms and Reports

Content Canvas

How Can I Arrange Or Design The 60 Items With Displaying 10 items at a time.and others are accessible through scrollbar.Rememeber That We Don't Have To Use Stacked Canvas ? Software/Hardware used: Oracle Developer 2000

Using Property Class

How Can We Set The Property of An Property Class Runtime in D2k ? Software/Hardware used: Oracle Developer 2000

Exporting Oracle 9i tables

I have installed Oracle 9i server on Windows 2000 and clients on other machines. The database name is admin. I have created tables in my own login ora102 on the client machine. Now I want to export the tables which I have created in my own login. I used the following command on theclient machine to...

Microsoft Server 2003 to Oracle migration

Our organization is planning to migrate from MS Server 2003 and MySQL database server to RHEL5 and Oracle database. We currently havr 100 to 150 users.

ORA-02019: Connection description for remote database not found

I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of the operations...

Oracle 10g Database transfer

How can I transfer Oracle 10g Database under Windows to Oracle 10g under Linux? What precautions need to be taken? Software/Hardware used: Oracle 10g

ORA-31672 in oracle 11g

Getting Oracle Database Error Code ORA-31672 Worker process string died unexpectedly. Any quick fixes Software/Hardware used: Oracle 11g

Data issue in a Oracle Table

I have a 180 GB size table. When I select the table,it returns some columns with null data. But if I Select that particular record showing NULL column with a Primary key filter,it is showing data for that column. Please let me know what might be the problem with that table.

connecting oracle forms to mysql

the problem is, its is connecting but there is a packet checksum failure... please help us out. thanks. by the way, my email is lance_arch_angel@yahoo.com Software/Hardware used: oracle forms 9i, mysql

Soon you can redeem knowledge points for Amazon.com gift cards

Yes we are coming up knowledge points and will be announcing the ability to redeem all the points you have earned thru december this year for amazon.com gift cards. Next week we will be sending out an email with all the details but it should be fun to see who ends up asking and answering to beef up...

Auto tool for load/perform testing Oracle10g applic.

Financ. appl (client/server) based on Oracle6i must be migrated to Oracle10g (Web). Now at stage of analysing/estimating the proper auto tool for load/performance testing. Any advices or sources, please. Thanks in advance. Software/Hardware used: Oracle6i / Oracle10g, SQL

The most-watched IT questions this week: Oct. 6, 2009

Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How...

Oracle Migration 9 to 11g grants missing

a user get the 'table or view does not exist' error after migration from Oracle 9 to 11g - even though in the DD I can see owner grants select on the tables to role -> role is granted to the user (only grants direct to user are working fine) Software/Hardware used: Oracle 11g

Oracle LIKE statement on SQL Server 2005

I'm trying to execute the LIKE statement but it's not displaying  any values SELECT R_NAME FROM LAWSON.DEPTCODE WHERE (R_NAME LIKE :r_name) Software/Hardware used: oracle 10g

The IT Blog Top 10: Oct. 1, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. ...

SQL Server 2005 is running slow

SQL server 2005 is running very very slow while it hase 32 GB ram 200 GB SAN and 4 Processor of xneon 566 Ghz. The normal select query takes 30-35 seconds to returing 37 records. Please give me the suggestion how to increase the performance Software/Hardware used: OS-window server 2003 R-2,...