Hi,
We are going to upgrade from oralce 9i to oracle 10g for a peoplesoft database.
I would like to have any documentation or link for any Experience feedback on that subject, to study all...
I am trying to create a Package that will encapsulate all the required parts to successfully call a Web service.
I already have the 'wsdl' HTTP site and it works 100% via a HTML call.
What...
hi,
I have to do validation whether user input(Server Name) is avaliable in List of Oracle 9i(windows) servers. These oracle servers are located in different machines.If user supplied v...
1 CREATE OR REPLACE PROCEDURE TEST_EXCEPTION() IS
2 type array is table of stg_exception%rowtype;
3 l_data array;
4 bulk_errors EXCEPTION;
5 t_errmsg varchar2(4000);
6 t_error...
SP2-0332: Cannot create spool file
I get this error when I run my unix script. I spool to /opt/logs/exception_file and it gives me error SP2-0332:. when I spool just to the file name excepti...
I have an Oracle (9i) cursor that is populated via a dynamic SQL statement. This cursor is part of a function that accepts user-input parameters. What I need to do is return the result set of ...
I have to use a computer with 9i client installed, but I'm connecting to a 10g database. I'm trying to use Oracle Enterprise Manager Console. (I don't need the all the features that 10g woul...
Hi Everyone,
I'm attempting to get data back from an Oracle 9i database that has a stored procedure that accepts 2 in parameter and one out parameter, which is an Oracle sys_refcursor. Whe...
Hi,
Can anyone send me a query which will give me the total size of my oracle database and the space utilzed till date in my oracle database
Cheers,
Suhin
Hi,
I have Visio Pro and am trying to connect to an Oracle DB through ODBC to create a diagram of my database. I can't connect through my ODBC I set up..
Is there a way to verify I'm con...
I am trying to create a view in Oracle, inside the view there is a column with null value, but I want the column to be varchar2(32) data type, I try to use cast but the data type still remain ...
1.How to tune oracle sql query?
2. If database is hang, what is the step by step procedure?
3. Explain :- Full table scan?
Hi, I have enabled auditing in an Oracle 9i instance, but the sys.aud$ table is still showing zero rows. I have set the value of audit_trail = TRUE. This has worked fine for me in other Ora...
Hi,
I want to select the top 10 machines who access my program (Canvas). The following code will select all of the machines, group them and order them. The machines also have different names ...
I am getting the following error:
ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
when trying to connect to an oracle database oracle 9i
...
Hi All,
I have a question regarding how to delete rows.Here is the question:
1.I have a table with around 11,000 rows.
2.Table sql statement is :
CREATE TABLE M_10
( ID1 NUMBER(6,0...
SELECT * FROM
TABLE1 a
INNER JOIN TABLE2 b ON (a.KEY_ID=b.KEY_ID)
doesnt this work on 8i???
what could be easy solution?..i know the option of writing a,b where a.key_id=b.key_id..
...
I am getting the below error when I was trying to bring one of data files back to online
ORA-01113:file 12 needs media recovery
ORa-01110 data file 12: C:\Ora92\oradata\oracle9\example3.dbf
...
Hi There,
I have a corporate application that I am trying to extract data from. The data is stored in an Oracle 9i Enterprise database (Release 9.2.0.6.0, PL/SQL Release 9.2.0.6.0, CORE 9.2...
Any recommendations on migrating a DB2 v8 database on AIX to Oracle 10g or 9i on HP-UX? It looks like the Oracle Migration Workbench only supports up to DB2 v7 on Windows. Is there a plugin av...
Hi,
My production database was on Oracle 9.2.0.1 On Sun Solaris 5.8.
Cataog is on Oracle 10.1.0.5.0 On Sun Solaris 5.9.
I've lost my production database .
I've the catalog database...
I am creating a C#.net web page that calls an Oracle stored procedure. If I have an output from the stored procedure I receive the following error: ORA-06502: PL/SQL: numeric or value error: c...
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
System: Microsoft Windows Serv...
Hi,
OS/windows 2003
Database/Oracle9i
-----
I face this RAMN error this , but my database is working well there is no error on database base
Rman is looking this archive log file A...
What SQL can I use to get the following output?
SID SERIAL# ACTION STATUS
---------- ---------- -------------------------------- --------
21...
