Oracle Tag Directory

Featured Oracle Questions

  • Error installing linux on Dell Poweredge 2950

    I'm trying to install Novell Linux OS on a  Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a "no hard disk found" error

    ITKE342,985 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • Parameter Manipulation – Turning ‘abc’ type string into a number

    I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ' - ' || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN...

    tmbdnelson70 pointsBadges:
  • Error Message ORA-00903 in SQL table

    Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I'd be grateful for any help.

    Kmuller5 pointsBadges:
  • How to prepare for OCA 10g

    Can anyone provide me the exam pattern/dumps for OCA(Oracle Certified Assocaite) 10g

    Srinus5 pointsBadges:
  • What next for an Oracle professional?

    I am now working at a pharmaceuticals company as an assistant officer , IT after completing Oracle Certified Associates(OCA) and Oracle Certified Professional (OCP). I also completed MSc in Chemistry.I want to build my carrier in IT (Global).So, I want to go for addmition in BSc in Computer Science...

    Akbarmscjnu20 pointsBadges:
  • OCA 10g certification dumps

    Hi [Br _extended="true" />i am preparing for the 10g OCA certification Exam , can anybody pls help me in finding the dumps and assignments for OCA fundamentals and Admin I exams. [Br _extended="true" />

    Sweety17195 pointsBadges:
  • Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2

    Hello, What are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

    Donpatrona5 pointsBadges:
  • How can i connect database from sql explore

    Hi all, My OS is Windows 7, I install Oracle 10g Express Edition then i install Oracle 10g client. Installation is Sucessful then i config ODBC setting.ODBC is Connection Sucessful.But SQL Explorer is Not Connected.How can i solve this Problem?Kindly Help.

    Yes115 pointsBadges:
  • How to prepare for OCA

    I want to become a DBA .can you please advice me how should i proceed ?Should i start with giving certification exams?

    Poojamalik5 pointsBadges:
  • Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.

    using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. I have...

    Mariaali10 pointsBadges:
  • OLTP in Oracle

    while using OLTP in Oracle 10g stanadard edition, does row level locking happen? What are its benefit?

    Akansha150 pointsBadges:
  • Oracle 10g Certification

    I am interested in pursuing my Oracle certification, but I'm not sure of the best way to proceed. For those of you who have recently completed your OCP, could you help me by answering the following questions? Is it better to get my 10g OCP now and take the upgrade exam for 11g later, or begin with...

    Edstalnaker5 pointsBadges:
  • ORA-07445

    Hi, I got the following error and my Instance went down. Can any one help me out to solve this error. Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x17a, PC: [0x100ff7428, 0000000100FF7428] *** 2008-02-16 05:12:08.804 ksedmp: internal or fatal error ORA-07445:...

    Thedevil5 pointsBadges:
  • ORA-00257

    What's the quickest way to resolve an ORA-00257 error? What are some ways to prevent this from happening?

    Sanders635 pointsBadges:
  • Suggestions regarding OCP

    Hello friends, I am a 5th semester student of BTech/BE(Computer Science & engg) student.I have studied database management system subject in my course syllabus at college and now I wish to take OCP test.During my study I referred to Database System Concepts by Korth,Sudarshan & Silberschatz (McGraw...

    Apubergeek5 pointsBadges:
  • Oracle ODBC Windows Server 2003 scheduling issue

    One of my new servers running Instantclient 10.2 fails when trying to run a query through the Windows scheduler. Running the same query from the console works fine. It's apparently a permissions problem with the instant client and the Windows local machine system account, but the same process works...

    Ttstudio45 pointsBadges:
  • OneWorld – Xe – Enterprise One

    Other than name change each time product was sold (JDE>PeopleSoft>Oracle) and of course updates/enhancements is there any real difference between OneWorld, Xe and Enterprise One?  Hence does a OneWorld certification count in Enterprise One?

    Dpkm20215 pointsBadges:
  • error with Jasper Server

    java.sql.SQLException: ORA-00923: FROM keyword not found where expected when performing a drill through operation

    Lscuthbert5 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