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

    ITKE56,495 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:
  • Oracle Query: Return a date eg 29 February 2008

    Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance

    Csshahie5 pointsBadges:
  • How to pass data from JDE to web page

    There is a requirement wherein data which is on a JDE World screen should be passed to a web page when a function key is pressed. On pressing of the particular function key, data which is on the JDE World screen must be passed to and displayed on the web page. I need ideas about how this can be...

    AS400 - Ask the Expert485 pointsBadges:
  • login persmission Windows Server 2003

    I am trying to log into a windows 2003 server through oracle enterprise manager. I get a wrong username and/or password error. I use the same credentials to login alright when I use remote desktop. Are there any permissions or rights I need to change or grant in the server to be able to login....

    Niimajor25 pointsBadges:
  • Top products in eProcurement field

    I am an Ariba consultant with experience in Buyer,Contracts and sourcing. If I need to change the career to a different application that is in good demand in market and having similar functional knowledge, which are the ones that you would recommend? Could you tell me the SAP products that share...

    Lekha5 pointsBadges:
  • Oracel import question

    what happens if i import a particular table into a user schema which already contains the same table?

    fartman50 pointsBadges:
  • Update table to remove invalid char type (tab) Oracle

    I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space - I assume? Very few rows have this 'bad' data...

    Meb10 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