• How to become an Oracle DBA

    I am a fresher and graduated in electrical and electronics engineering but I want to settle in the IT industry. What skills I need to develop to become an Oracle DBA? Thanks!

    tomcatafroz5 pointsBadges:
  • Install Oracle 8 on Windows 7

    How can I install Oracle 8 on Windows 7?

    zainulabedin5 pointsBadges:
  • Is it possible to license both Oracle DB EE and SE which installed on different LPARs on same host?

    Our customer has both Oracle DB EE and SE install bits on a same IBM host. The host have 2 processor pool and each provisions 2 LPARs. The bits locate on VM1 and VM3 which link to different proc pools. My question is: could I license EE by consider core capacity of pool 1, and license SE by...

    olivercao5 pointsBadges:
  • Connecting oracle forms 6i with 10g XE database

    I would like to know from anyone out there how to cnfigure an oracle client with developer 6i to communicate with server with oracle 10g XE.

    Omuga5 pointsBadges:
  • ORA-01445: cannot select ROWID from a join view without a key-preserved table

    Hello, For the first time in my IT-life I've encountered following error message when I try to run query using ROWID on a view: ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table I found something about key-preserved tables, but I'm not sure that my...

    LukyFox25 pointsBadges:
  • Encode URL in Oracle

    How do I encode all parameter in web.show_document? So user can't see the whole URL.

    gramii5 pointsBadges:
  • What needs to be taken care in Oracle 9i database when migrating from Windows Server 2003 to Windows Server 2012?

    Currently Oracle 9i database is hosted on Windows server 2003. We are migrating Windows 2003 to Windows Server 2012. Here are two questions: Is Oracle 9i compatible with Windows Server 2012? If not compatible with Windows Server 2012, then what should we do?

    Rajatgupta55 pointsBadges:
  • Oracle SQL query

    How do I list the mid-western vendors (Illinois, Indiana, Iowa, Minnesota, Wisconsin)? Also display the vendor ID, name, contact name (first & last), city, and state. Use formatting and concatenation to reduce the space required for the contact and city (30 characters should be fine). Order the...

    kmoses5 pointsBadges:
  • RDBMS and DBMS in Oracle

    What is RDBMS and DBMS in Oracle?

    Gkg5 pointsBadges:
  • ORA-12699: Native service internal error in Oracle 8i

    Hi, I am trying to pull the data from Oracle 11i to Oracle 8i with the help of DB link. It's stating that "ORA-12699: Native service internal error." I did in the Oracle 8i server file changes sqlnet.ora --> SQLNET.AUTHENTICATION_SERVICES= () I have executed the below listed commands:...

    Chidambaram5 pointsBadges:
  • Oracle 11g KEEP buffer pool

    What is the SQL to determine what table objects are in the KEEP buffer pool?

    jmarsh5 pointsBadges:
  • Setup website in Oracle 8i

    How do I setup a website in Oracle 8i? I’m using Windows XP. I have need to convert Oracle 8i to 10g.

    blighali30 pointsBadges:
  • Formatting PL/SQL code in SQL Developer

    Hi experts, I would like to know some keyboard shortcuts and clever formatting on PL/SQL codes in SQL Developer. Please help me out with some hints for this. Thanks in advance.

    Inprise610 pointsBadges:
  • Oracle 10g report paramater

    How do I use multiple parameters to call an Oracle 10g report from form. For Example: UserID=&UserID  And  StartDate=&StartDate  And EndDate=&EndDate; Thanks!

    AbdulShakoor5 pointsBadges:
  • Using select statement in an update query of Oracle SQL

    how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

    Farhandgr85 pointsBadges:
  • I forgotten my user name and password of Oracle 10g express edition.

    I'm using oracle 10g express edition, I forgotten my username and password so please suggest me any idea to recover the username and password or tell me any other possibilities to reset the username and password.

    Sreekannan5 pointsBadges:
  • Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Converting and deploying 6i Forms to Forms 10g

    I need to convert an application written in Forms 6i to Forms 10g. Recompiling the forms seems to be straight forward, but then what? I was told that I can no longer run the application in client-server mode. If that's true, then how do I run them? Is there a runtime with 10g? I feel like an idiot,...

    Herbiebill35 pointsBadges:
  • Problem with ORA-01034 and ORA-271017

    I am running Oracle 11 on Linux Ubuntu 12.10. The database has been running well for a long time. Now, suddenly, when I or one of my applications tries to connect to the database, the database replies with ORA-01034 and ORA-27101.  I've tried most of the available suggestions, and either they...

    tcnmann20 pointsBadges:
  • ORA-01009: Missing mandatory parameter

    Dear Friends I have this script in the WHEN-BUTTON-PRESSED Button DECLARE LOC_FLAG NUMBER; BEGIN :IM_NEW_ITEMS.COLOR_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.COLOR_CODE,0)); :IM_NEW_ITEMS.SHAPE_CODE := TO_CHAR(NVL(:IM_NEW_ITEMS.SHAPE_CODE,0)); SELECT NVL(FIN_FLAG,0) INTO LOC_FLAG FROM IM_CLASS WHERE...

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

Thanks! We'll email you when relevant content is added and updated.

Following