Hi,
I am trying to install Oracle9.x Enterprise edition, in "D:\Program Files\Oracle92" directory, with OracleHome name as
"OraHome92". I am getting an error "The path you have specified ("D...
How can resolve the following errors:
ORA-04068: existing state of packages has been discarded
ORA-04064: package body"mv.sbv"has errors
ORA-06508: PL/SQL: could not find program unit bei...
How do I call a Stored Procedure / Stored Function and "get the result" in a C program using OCI ? I am looking for a sample program in OCI Release 8. (I am using oracle 9i)
1. Is it possible to have an JSP webpage that show my user last time and date I drop data into a table, and how would I do do the query....I know how to search oracle with a JSP.
2. Then, I...
I have a series of SQL commands for Oracle 9.i. I need the corresponding set of commands for Oracle 10.1.0. I believe that dr0csys corresponds to ctxsys. I have no idea what dr0inst, oractx...
I logon with sqlplus or a third party tools and issue several sql statements. During that session let say my sid=34 and serial#=134. Now I logon as Sys thru sqlplus and want to find all the sq...
Hi,
The prompt was this when started imp utility (not impdp):
Import: Release 10.1.0.3.0 - Production on Tue Sep 12 18:44:26 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
...
How to check what grants a user has been given in the oracle schema?
Hi,
We are having serious issues for our Prod Db 9.2.0.8.0 patch set 13 hosted on windows 2003 sp2 .
Total Memory-15 GB SGA-8GB
Batches to this server are failing with error ORA-12547: ...
Using the following code:
declare
v_fac_id number;
v_field varchar2(50);
v_result number;
v_script varchar2(1000);
begin
v_fac_id := 1;
v_field := 'v_fac_id';
.
.
.
end;
How c...
Hi everyone,
I am tryin to do an import in oracle 8.1.7.4 in the management console and I get the following error:
IMP-00058: ORACLE error 12638 encountered
ORA-12638: Credential retrie...
Hi,
we have here a server:
operating system: MS Windows NT Server
Oracle 8i
Same days ago the network administrator deleted all user-accounts of the operating system and created new ones...
We are trying to use the Oracle SQL Developer software to access an Oracle database. We successfully create a connection to the database, however we couldn't see any table under "Tables" folde...
I have a 9.2.0.4 db server and the users is getting the following error:
Please advice in detail.
[1/16/04 16:03:34:717 CST] 2f8429b1 WSRdbXaResour E DSRA0304E: XAException occurred. XA...
I'm setting up in a newly created PC environment. I'm installing Oracle 9.2i. When it gets to the phase where it starts up the database I get the error in the title. I gave it a retry, same...
I have this description of what objec auditing is. However, I still don't understand how it should be implemented or what I should change. Here is a description:
Description: Object auditi...
Dumb question I'm sure. I am a SQL Server guy trying to learn Oracle. In SQL server - you can have multiple databases in one instance. They share tempdb, master, etc. Can this be done in O...
Greetings,
My company just made a big purchase with which included Oracle 10g and performance packages. During their visit to our job site, one of the representative informed me that you do...
I create a user in 10g, release 2 for windows:
CREATE USER abc identified by abc
default tablespace abc_TS1
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TEMP
QUOTA UNLIMITED ON abc_TS1
A...
I need to export a schema with all their objects. What command would I issue to do this?
I have 2 Oracle databases running locally on my Windows XP machine, one 9i and one 10g. I just loaded the 10g and I get the error 'ORA-12154: TNS:could not resolve the connect identifier speci...
I am getting this error when I run an asp.net app
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
What steps do I need to take to add a reference to the...
I have a text file that is tab delimited that I need to load into an oracle table. The fields are tab delimited. I don't know what the syntax is for indicating in a control file that a field i...
How can I create a datablock in Forms 6i using a stored procedure?
