Experts,
I need to check and see if any accounts on each (3) instance have access to the RepAdmin account. How do I check this setting?
Thanks, MissyMadi
Hi, guys,
I need to transfer data from Microsoft Access 2003 into Oracle 10g standard. I know it coud be done if I save data as .CSV file. What to do next?
I have never used Oracle 10G Data Pump. I want to use it in the following scenario
I have a Source Table with 50 Million Lines of Data.
I have a Destination Table with the Same Structure a...
PROCEDURE price_list_additions(p_old_price_list_id IN price_list_dtl.price_list_hdr_id%TYPE,
p_new_price_list_id IN price_list_dtl.price_lis...
I get the following error:
I get an error when other then.
PROCEDURE select_all_price_list_hdr(cur_OUT IN OUT t_cursor,
p_status OUT varchar2...
ORA-00936 missing expression.
PROCEDURE get_grade_code_dtl_id (p_grade_name IN grade_code_dtl.grade_name%TYPE,
p_grade_code_dtl_id OUT grad...
I have an inner query where it has to search through the list of IDs (using IN parameter). If the size of list of IDs is more than 1000, sql gives error of exceeding the maximum number of e...
Trying to update table of 30,000 rows from a table of about 1500 rows.
update table-a set row_status = '2'
where
data_src_pk1 = '422'
and course_id like '2073%'
and table-a...
HI
I want to patch a ORACLE database from 10.2.0.1 to 10.2.0.3 but I want to know the most critical bugs that the patch can fix. I want to be sure that mi aplication won´t be outline for th...
HI,
We have an XP box with Oracle 10g installed. We were presented with a piece of software from Symantic "Symantic Enpoint Solution" that we must install on the same PC as wher...
folks i have three colums
id description status
id1 car appr
id2 house comp
how do i show the rowcount iof all the columns in each colum ,and how do i show the count of rows with statu...
I need to setup something like SQL server log shipping for my Oracle 10g database. I have the PRODUCTION oracle server hosted at a co-location. We have a secondary server at HQ with an oracle ...
We are using Oracle Database 10g, the Text Search feature is not enabled, could anyone please help me on hw to enable text search on the Oracle database 10g?
I need a query
I have 3 Tables.
Table A
=============
ACCOUNT_ID
USER_ID
Table B
=============
ACCOUNT_ID
USER_NAME
Table C
==========
USER_ID
USER_NAME
I want to u...
Hi Guys!
I'm running a box (win 2003) in a development envirorment with Oracle 9i database and a 10g database (just installed it). When I installed the ora_home for 10g i shut down all the ...
Dear Experts,
I have the following scenario:
create table t1(val number, carg varchar2(10));
insert into t1 values(10,'ST');
insert into t1 values(3,'RF');
create table t2(id number, ...
What is the cost of RAC with Oracle 10g Enterprise edition?
I would like to know cost of clusterware software including supporting software with oracle 10g for both windows and HP ux for 2 n...
Hi,
I've tried applying the 10.2.0.3 patch to an existing installation of Oracle Express Edition. But Oracle universal installer does not seem to recognize the oracle home directory.
Alter...
SELECT first_name FROM CUSTOMER, ORDERS, ORDER_INSTRUMENTS
WHERE CUSTOMER.CUSTOMER_ID = ORDERS.CUSTOMER_ID AND ORDERS.ID = ORDER_INSTRUMENTS.ORDER_ID AND ORDER_INSTRUMENTS.TOTAL_AMT = 1299.9...
I have two oracle instances running on the same machine. One of these instances is cranking out archived logs at the rate of about 200 MB per minute. Naturally, this quickly fills my flash r...
I have an OS authenticated user account that is granted DBA privs -- username is OPS$ORACLE. OPS$ORACLE, having dba role can select on dba views, obviously. However, I am trying to write som...
We have got ASP.NET 2.0 application that connects to Oracle 10g Rel2 via Oracle Data Provider for .NET (download from Oracle).
Q1. It is not clear to me whether we need to install also Or...
Hi Experts,
I'm running Oracle 10g R2 on Sun OS. I created a job but it's never run. However, when I created a scheduler job , it worked well. Could you please tell me what's problem with my ...
I'm not sure there is a simple answer to this question, but I was hoping to get feedback on what happens to Oracle when Windows Server is rebooted or shut-down. I know you can specify via rege...
If it keeps it in the SGA what part ? Default buffer cache ?
