Oracle

Oracle Certification?

Hi, I want to know, the total procedure for Oracle data base certification. Thanks

A framework compatible with oracle 10g

Please i need a .net framewoork compatible with oracle 10g.

The IT Blog Top 10: Nov. 5, 2009

10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

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

Calculating concurrent users based on active members in DB

Hi: We are in the process of implementing the customer portal for our CRM system (Oracle Siebel). Need to know how to estimate the number of concurrent users based on the active members in the database. Currently we have about 1 million active members in the database with 40% email address...

The most-watched IT questions this week: Nov. 3, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

SAP Oracle DBA security privileges

What roles, privileges, transactions should we allow the Oracle DBA to use and access. Presuming DEV-PROD. Were moving the DBA role out of the BASIS group. We know all DB.. transactions, plus ST22, and looks like SE11 and SE16 are suggested. Thank you for your help. Software/Hardware used:...

Oracle table update exist ?

dear all, i want implemente a update on many table but i don't know the syntax please help me. My update is at less on 5 table

isa server 2006

I install isa server 2006 internet is working fine but i enable isa client firewall in client side that time externel email working but oracle application not working when i disable  isa client firewall externel email not working but oracle application is working fine i want working both oracle...

How to convert LONG to CLOB or to VARCHAR type in select statement

Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT...

Entering more than 45 data Selection Values in Data Selection for Version in Version List in DreamWriter

How do I enter more than 45 values for a field (this appears to be an upper limit - with only 45 fields (15 lines of 3 fields per line) available on the display) within Data Selection Values for a Version on Version List in DreamWriter in JDE. Thank you to anyone for helping with this. 

The IT Blog Top 10: Oct. 29, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

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 Software/Hardware used: Dell poweredge 2950, Novell Linux, Linux,

Configuring listener.ora

This is regarding Oracle 10g networking. On the server side I had configured listener.ora. and on the client side I had configured tnsnames.ora, but when I started listener.ora I got an error: tns name is incorrect. Could u please explain to me how to configure on Linux? Software/Hardware used:...

Data Guard implementation for Oracle 10gR2

I am making a standby database for dataguard on 10.2.0(windows 2003 VmWare) following this tutorial. I am confused about the standby database creation. I successfully configured the PD with these steps, but I simply ran the oradim command for the standby databae creation then mounted the database...

Flash Recovery Area in Oracle 11g

What is the easiest way to handle the flash recovery area in Oracle? I'm having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind after the...

How can automatically execute a oracle process

Give me the steps to create a batch file or some executable to run a oracle process (form/report) at any given time. Eg. Every day at 10 PM  

sql query

i am working on a project. If i enter the a/c no and i found correct then the companies name and their share values are provided to me.. After that when i buy a no of shares i get the Transaction amount(no of shares*share value),broker value(1.5% of transaction amount),total amount (transaction...

Oracle 9i install failure

Friends, i am using 1gb ram, 80 gb hard drive, i am trying to install 9i on my desktop pc of above config. After the installation of database, before installation of configure tools, oracle db configuration assistant and oracle intelligent agent are failed to install..(The first two were installed...

About Time

Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet   Software/Hardware used: OC