How can I check with port is open in windows 2003 server
What will happen when you manually refresh a materialized view with "COMPLETE REFRESH" option.
Let us assume that this option takes about 30 Min for completing the refresh.During this ti...
We are considering to implement Oracle high availablity for a Finance application, but as we do not have experienced DBA resources for implementing Oracle RAC, can we implement Oracle 11g fail...
Just to check my unserstanding, if I use Oracle 11g with Windows and Equalogic PS4000 iScsi SAN and oracle snapshot agent (when it becomes available) , I would be able to take a snapshot backu...
I am trying to use LIKE to display ISBN and TITLE of books that have a pattern including '0321'
I am getting the answer "no rows selected"
Are the hyphens considered as characters?
hi fellow experts,
I have a table with xml column where it stores customer's header information such as show on Code (A), and i want to create a
constraint key of customerdata table's id ...
How do I create an Oracle database that will accept double-byte characters to store in the database? I have tried to define the database with UTF-8, however, I have not succeeded.
Is there a was to use Oracle's impdp datapump to discover what schemas are part of a dumpfile? The log that was created with the dumpfile is gone and I do not want to import the whole file.
I am executing the following:
SELECT REGEXP_SUBSTR('2009-452XAB','([[:alpha:]*])') FROM DUAL
My expected resut is XAB
I have tried moving the splat (*) around without any success. I have ...
I have 750 conditions that i want to test, and will need to put case statements both in the select fields (concatenating the results) and in the WHERE clause 9to fileter the result - this is s...
I need to do DELETE more than 1,000,000 records from a table, however, how can I make the database directly delete that records without allowing Rollback.
Thanks!
Experts,
What is the command to use a VMware Server Console vm on a ESX platform? I think it is some kind of command run from the command prompt that allows ESX to see VMware servers?
...
I am trying to install Oracle 11g on a cluster of two window 2008 servers. All the pre and post checks have passed, however, during the installation of clusterware, when come to the page of CL...
I am in the process of cloning an Oracle database (for the first time), following the instruction
on this link:
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#...
I'm trying to build out an Oracle test server in advance of a project that involves supporting a new installation of Oracle and Red Hat.
I have Red Hat 5 built on a Dell PE2650 and it's run...
Hi,
Can someone show the steps required to enable Native Web Services in Oracle 11g, and call a Web Service function over HTTPS?
Many Thanks
HI
I need help to make a plan to design 6 databases in one server
what in need to know is:
- the best SGA size?
- what parameter need to adjust?
- any exrta information to perfect plan?
...
Hi Experts,
I need to read the schema of an Oracle database programmatically with VB.Net 2005. I did the same thing with SQL Server 2000 recently and it was fairly simple. I just queried ...
Ok. Let's make this simple:
What I have:
----------------------------------------------------------------------------------
-new spiffy 8 core / 16gb ram database server, running either 1...
I want to install Oracle 11g R1 on Red Hat Enterprise Linux 5.0 and its physical RAM is 3160 MB so what is the appropriate value for shared memory
I have loaded oracle 11g stored procedures scripts that were modified. How do I retrieve the code from the compiled scripts so I can modify them again.
I am not that familiar with oracle...
I have the piece of code extracted from the SQL function below, why the c_Invoice%ROWCOUNT is always 0? what did I do wrong?
OPEN c_Invoice(pv_team, pv_schedule_date);
UTL_FILE.PUT...
Hello There,
I just installed Oracle developer suite 10g on Windows xp sp2 but when I trying to open Developer Form developer than recieving error 'frm-10039: unable to start up the Form Buil...
Hi,
I am wondering what tools / options I have if I want to monitor a pair of Oracle 11g SE RAC servers to give me an idea of what current load their is on the databases? Ideally setting u...
