• Oracle performance under NT versus Linux environments

    When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec. When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec - nearly 100% drop in performance. The explain plans are the same for both environments (NT and...

    OracleATE190 pointsBadges:
  • Remote Operation Error

    I am trying to create a standby database using oracle's enterprise manager gird control. I have to specify the login credentials of the host machine that houses the production and the standby. For some reason it only accepts my login credentials once when it gets to the next step it gives a Remote...

    Niimajor25 pointsBadges:
  • Need help with CORBA object error in Oracle Management Server

    When I am in OMS, and try to shut the DB down, I receive a CORBA Object_not_found error. Does this mean that I have not installed the CORBA objects correctly?

    OracleATE190 pointsBadges:
  • Oracle -fetched column value truncated error

    Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error "ORA 01406 -fetched column...

    Shwetavyas15 pointsBadges:
  • Pl/sql code for queries

    Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...

    User714085 pointsBadges:
  • Two Applications sharing the same database

    Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question:...

    Said5 pointsBadges:
  • Oracle 10g Standby Database not opening readonly

    Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files='P:\oracle\product\10.1.0\oradata\tceng\control01.ctl','C:\oradata\tceng\control02.ct l','E:\oradata\tceng\control03.ctl' Then I have created standby database in standby server where the...

    Ora dba20 pointsBadges:
  • Not able to set preferred credentials on OEM console

    using Oracle 10gR2 on Windows 2003 server. I can't setup the preferred credentials on the Job scheduler screen on the console. I also have the email issue. I tried to use DBCA and clicked on database options and everything is greyed out and I cant seem to proceed. How can I configure to receive...

    Jh199310 pointsBadges:
  • Oracle Enterprise Edition versus Standard Edition

    We are looking at converting our "enterprise database" licenses to "standard edition". I need to know what to look out for. I have read the Oracle notes on the differences but you know how that goes. We are doing this as a cost cutting measure. Has anyone done this ? What should I be aware of...

    Rob E30 pointsBadges:
  • copy files

    Using SQLPLUS how do you copy files from one location to another

    Ga800715 pointsBadges:
  • Database Move

    What is the quickest way to move a database from one server to another...same platform and O/S version, same Oracle version (8i)?

    Mjevans0 pointsBadges:
  • Oracle 10g on Windows 2003 virtual server

    We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

    Markv5 pointsBadges:
  • VB.NET ans ORACLE database

    Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

    Flyer15 pointsBadges:
  • SQLServer equivalent to dba_role_privs, dba_user_privs, dba_object_privs ???

    Is there a SQLServer equivalent to being able to retrieve internal application specific metadata that to the users/roles v.s. object privs (select, insert, update, delete, execute, etc.) ? In oracle it's achieved by forming SQL selecting data from the appropriate "dba_" views. In SqlServer this can...

    DaveSTC0 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • Validation Error – Oracle database on Windows Server 2003

    I am trying to log into an oracle database residing on a windows 2003 server through enterprise manager. I keep getting the error Validation error - �. I have added my username to the "log on as bacth job" properties. but I still keep getting this error. Please help

    Niimajor25 pointsBadges:
  • Community Update: New Site updates and Contest Announcement. Win a Nintendo Wii!!!

    Hello Community If you haven't noticed we have added a few new features to the site. First we added more questions to the home page to allow you to browse the latest 200 Questions, Answers and a new tab of Unanswered questions. Also on each main topic page we have added a recent answers and...

    ITKE342,195 pointsBadges:
  • Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrate an Oracle database to SQL2005

    I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

    mnman66265 pointsBadges:
  • How to export all Oracle users from EBS?

    I want to print all the Oracle users in our EBS. How to do it? Thx.

    QAQA65 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