How to Install Oracle 10g Rac on Sun Solaris 10 X86 using Vmware
I have the following sql statement
SELECT LEVEL, part_no,component_part,qty_per_assembly
FROM manuf_structure
WHERE part_no = 'UT2850-VHPOS-A' AND eff_phase_out_date IS NULL...
We have a query that is run once a year to move all accounting data to the next fiscal year:
INSERT INTO COST_CD_ACCT
( COST_CD_ACCT.nr_id,
COST_CD_ACCT.suffix_nr_id,
COST_CD_ACCT.gl...
Hi,
I tend to do an RMAN coldback of my DB using a "backup database" command in RMAN and it works fine.
I am trying to use RMAN to backup the archivelogs but it keeps spitting out the f...
Hi guys,
I am trying to use UTL_FILE in Oracle 10g to be able to read BLOB fields that store .PDF, .RTF, and .HTML data. Once retrieved, I want to be able to open them in their native prog...
Hi
I am trying to load bulk of data(millions of data) using dat files with Oracle 10g . I am doing this to get details about how much time it takes to refresh the materialized view when loadi...
I can compile the each procedure individually with no errors, however whenI refresh the package the body displays and X.If I compile the whole package we get 3 errors. If we recompile the bodi...
Hi.
Does Oracle 10g have a Pivot function?
I need to convert table's rows (values) into columns.
Thanks.
hai experts,
i am getting following error. can any one explain how this error come in to the picture.
Starting backup at 04-MAY-08
channel dev1: starting archive log backupset channel ...
I am looking for a way to import an excel spreadsheet into the oracle database / table. What is the best method and what would be the quickest method to achieve this.
Hi,
We are using Oracle 10g. We have an SP that returns a ref cursor with a CLOB column in it. The issue that we face is that whenever the data in the CLOB column exceeds 4000 chars, the co...
Please help me in configuring Embedded PLSQL gateway in Oracle APEX Post installation tasks.
Enter value for imgupg: /export/home/oracle/sobanat/APEX/apex/images
old 47: if '&IMGUPG' ...
I'm trying to perform a decode on a date field. If the field resolves to 12/31/9999, I want to save the date as a NULL. The record is saved in the table as a DATE in the following format: MM/D...
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal ...
Here are my codes:
CREATE OR REPLACE PROCEDURE exec_now (
s CLOB, -- SQL statements
p_lvl INTEGER DEFAULT 0 -- message level
) IS
v_prg VA...
I am running oracle 10g on windows 2003 server. I installed oracle 10g db and then oracle companion (html db and http server). Everything is great until i reboot. Then I get a service failu...
The DB runs on SuSE Linux Ent.Srv 10.0. I am new to Oracle upgrading issues and would appreciate if you help to figure out how to correctly upgrade, according to the subject?
Please take a look at my .profile
/**** .profile *******/
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/usr/local/ ...
I am stuck and I don't know where I am going wrong. any help would be greatly appreciated.
{"ORA-01036: illegal variable name/number\n"}
{"Method may only be called on a Type for which T...
I need to connect to oracle server from ms sql interface 2005. How can this be done.
I'm trying to fire this trigger but I get ORA-04091: table ... is mutating, trigger/function may not see it
since I'm querying the same table the trigger is firing on.
I tried declaring pra...
Hi,
I am working with Oracle 10g express. I am trying to connect to the db via SQLPlus. I get the following error:
ORA-01034:Oracle Not Available
ORA-27101:Shared Memory realm does ...
I have created database link from 10g to 8i. In toad right click and "test database link" it is successful.
When I tried to select a view like <schema_name>.v_view_name@db_link it says tabl...
we are using windows 2003 server 2003 64 edition with a hp proliant 570 server and we are trying to install oracle 10g for wthis windows. after a while give us this error oui-25031
Hi,
Our company has a Oracle database installed on a private network, no outside contact to Internet, etc. We only use two accounts to log into the db. Can I delete the other accoun...
