hello experts,
Can I do this:
ORACLE_HOME=192.168.0.1/oracleInstallPath?
Why?
oracle 11g is located on tower1
cfg_server is located on tower2
cfg_server is asking to set ORACLE_H...
Experts,
Can someone please provide me a script to backup a Oracle 11g database, using Data Pump.
I would to setup a job for nightly backup.
regards
I receive the following error emails hourly, as if the agent has a hiccup. I've looked on OTN and applied the config changes below to emd.properties (based on http://forums.oracle.com/forums/...
I exported an 11g schema to 9ifile.dmp on a unix machine.
I installed 11g on windows and created a database APPS.
I ftp the file from unix to windows.
I want to import the file to APPS da...
We are planning to deploy Oracle 11g DBMS (STD) on Windows 2008 STD 64bit on VMware ESXi 3.5 .
I could not find anywhere on Oracle website that VMware is supported, only mentions that MS H...
I am supplying a parameter value from the front end.
select * from emp
where decode([parameter],NULL,'~~',
empno) = decode([parameter],NULL,'~~...
The error reads "Checking Oracle Home path for spaces...
Check complete. The overall result of check is: Failed. <<<<
Problem: The Oracle Home you have specified contains spaces ( ) in the p...
I have 2 records in my REFERENCE_CODES table, and the code_value of them are S and N respectively.
If I run the following function, it definitely can find 1 record, because my mv_variable s...
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...
Hello experts. We are looking for a way to backup the DDL or our oracle databases. We really only want the Materialized views, triggers, packages, procedures, and functions.
Does anyone have...
If we looking for sys tem that back up oracle 11 g run on windows 2003 every day
Do we need a computer to connect to network and set up to back up every day Please suggest
A table has a long datatype column
and i need to load the table via sql * loader.
How to build the control file to support long data type .... ?
I'm reading revoke_object_privileges
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_9020.htm#i2065165
However, I do not understand the last dot point as shown be...
I have a table that stores values with a date range validity.
Given a start and ending date, I would like to query the table above and it should return rows with values and the corresponding...
As the title states. Can someone tell me if there is a planned release for Oracle 11g Express Edition? I can't seem to find anything about the site.
We were planning to implement high availablility for our Finance application, initially we thought of using Windows 2008 Enterprise cluster for Oracle 11g, but it seems this solution is not te...
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...
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...
How can I check with port is open in windows 2003 server
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 ...
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?
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 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 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 ...
