• Hyperion Planning and AAS

    I just took over the Hyperion Desktop administration in the last few months. I am still learning the systems and studios to function appropriatley with Hyperion products. I have been working with IT on data transition information, but we have both come to a dead end with this problem. Whenever I...

    Bcissel5 pointsBadges:
  • Migration Plan for 9i Linux to 10g Solaris

    Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

    MLC5 pointsBadges:
  • Oracle 10.2.0.2 on AIX5L

    we installed oracle 10.2.0.2 on AIX 5l, we heard that there are performance issues with indexing (Oracle may pick the wrong index) . Has anyone had similar experiences and if so, what patches have you applied to resolve the problem?

    Jpenn5 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Microsoft Access – Find and Replace Issue

    In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

    Santino35 pointsBadges:
  • Using SELECT statements

    Can we get the number of saturdays in any month using a SELECT statement(i.e without creating a table or function)? If so, can you give me the logic?

    OracleATE190 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Database problem of Stop working

    We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top...

    IRFANB1465 pointsBadges:
  • Oracle Application Server

    I need to install Oracle Application Server 10g on HP Proliant DL580 with dual-core 64-bit Intel Xeon processor (7140M), & with Windows 2003 64-bit. I couldn't find any version or release for such environment, but I found for the Itanium processors. Kindly advise me about the right version &...

    Saadeddine0 pointsBadges:
  • oracle installation in win98

    When i install personal oracle8i, i got an error message oracle database could not start up it may be the problem of virtual memory .I reinstalled windows 98 and increased virtual memory but i got same problem.the oter thing is already it worked proprly and idon't no when the problem occured.Please...

    Hard ware engineer5 pointsBadges:
  • security problem

    Hello, I have small workgroup having 10 computers in my office. I do some personal work in office like using yahoo messenger, checking personal e-mails and some online banking site. But how does one of my senior knows it? I do everything lonely and securely so that nobody in the office knows it....

    BinooDas123410 pointsBadges:
  • Enabling the AdvanceSecurity layer (SSL) between the weblogic and oracle.

    Hi ALL, we are trying to enable Oracle Advanced Security encryption (SSL) on the JDBC Oracle Thin driver with a WebLogic JDBC Connection Pool.we are using the weblogic8.1SP4 and oracleclient 10.2.0.1...Can anybody know what are the steps to be taken to do...means of any changes in wl...

    Karthik usa5 pointsBadges:
  • Exporting MS Access data to Oracle

    Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....

    M15 pointsBadges:
  • Can Personal Oracle 7 or Oracle Developer/2000 be installed in XP?

    I have an older version of Oracle, Personal Oracle 7 and Oracle Developer/2000 which were designed for Windows 95 and NT. They will not install in XP (probably for obvious reasons). Is there a way to get them to install? Is there a patch or something that will allow me to install them??? Also.......

    Valhalla15 pointsBadges:
  • Oracle Data Import

    I am doing an import every week in the test and development database.The import is working fine in the test database.But while i import in the developement database .I am enountering with the errors.All the tables are getting imported successfully ,but after that i am getting the below import...

    Ajayjm5 pointsBadges:
  • Community Message: Answer these questions and earn Knowledge Points

    Hi all Here is a link to some questions that still need answers. Take a look a see if you can help out your peers and earn Knowledge Points with every answer. Remember the members that earn the most knowledge points have a chance to win some cool prizes in the contest we are having. You can find...

    ITKE345,015 pointsBadges:
  • %rowcount in 10G

    Can we use %rowcount in oracle 10G and if not what is the solution?

    Answerpls1230 pointsBadges:
  • how to store information in variables accessible to procedures in the packages??

    how do i store information in variables which are accesible by more than one procedures in the same package?? (i.e. i want to take input information using a procedure and i want to call other procedures internally which will use these input information to give results...) CAN ANYONE HELPME ON...

    Shankar o5 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