Hi experts,
our international company inherited a hudge system powered by Oracle 8.1.7 - Win32 W2K server installation.
There is a database created in headquarters which we have to use i...
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...
Hi,
Is there a way to manually set an oracle 9 database system date without changing the Operating System date? and If there is a way, what are the ramifications from doing so?
Thank yo...
PROBLEM:
tables with foreign keys are locked when inserting into the parent table in Oracle 9i
Note: use the SQL below as an example and select lock data from v$lock
create table k1 (f1...
We have a multiple page report and need to print one piece of text only at the bottom of the last page. In reports designer we are able to put the text on the bottom of every page or after th...
Is there a way to execute a unix script from within a PL/SQL trigger?
sjl
Hi ,
I need to enable oracle xa support for my 9.2.0.6 database. I think that for that ,at the db side 2 scripts need to be run right?
ie. initjvm.sql and initxa.sql. what is the order h...
I was looking at the syntax for logging in to RMAN and I am confused. Can someone clarify this for me. I want to use the catalog feature to store RMAN repository information in a database.
...
Hi
I am using SQLPlus script to pull data from a table and spool to a text file. The app I need the spool file for expects certain data in the first line, which is gotten from the table by...
I have recently upgraded my 9i database to the UTF-8 character set. Now when I try to use SQL*Loader to load a text file containing non-standard symbols such as copyright ©, trademark , etc....
Hi,
How do I save an oracle report (Built by Oracle Developper 6 / Report Builder) in Excel Format ?
All that it shows is Options to save as 'PDF', 'HTML', TXT, 'RDF', 'Postscript' etc. Th...
I am trying to connect to an Oracle database over VPN. Ultimately I need to create an ODBC datasource so that I can connect Crystal Reports to the database. I have used some previously poste...
When i try to install Oracle Jinitiator 1.1.8.16 on Win XP SP1 on client PC Win XP SP1 after the first message box "InstallShield Self-Extracting EXE" saying " This will install Oracle Jiniti...
hey i'm running oracle 9i on win2k machine.
my oracle help tells me, that varchar2's have a max. length of 32535 bytes, but
it allows me only varchar2's with max. length of 4000 bytes. do i ...
How to import the text file into the oracle 9i database, the text file is available in the different machine and database in different.
When i try to retrive the data from Doc_Document using the below query i am getting an error ORA-00997: illegal use of LONG datatype.
select utl_raw.cast_to_varchar2( dbms_lob.substr( doc_doc...
Is it possible to create a trigger that fires when a materialized view (snapshot) is refreshed?
Will a simple before/after insert trigger work?
And are both the ROW level and statement level...
I have a simple data block based on few fields of database table,
With each record I want to place a button which is enabled or disabled based on value of first field,
For example, lets say ...
Hi there,
I am running two 8.1.7.4 databases on win 2k server's. One is the primary and one the standby.
I have recently created a repository for management console on the primary datab...
I'm trying to create a view in Oracle 8i which uses bind variables but when I enter the following statement
****************************
SELECT * FROM MY_TABLE
WHERE HOURS = :hour_v...
I have a form and i have a push button clicking on which i invoke a url .i did this using fnd_utilities.now i want to adjust the settings of the browser window.i want to hide address bar,file ...
I wanted to clear the block and add new data alert button pressed is 1. It clears the block and allow me to save the new record . But when we requery the old data comes back. What am I missin...
I'm trying to create a database dump of a remote 10G database. Using exp, I can get some of the objects, but the schema uses new 10G functionality that is not supported by exp (binary doubles...
Is it possible to run sqlplus from a DOS prompt without performing an Oracle (v8.1) installation ie does anyone have a list of the required files and paths required.
Have copied the BIN di...
I am transferring data from an 8.17 databse to a 10g database and get the following error, ORA-30036: Unable to extend segment by 4 in undo tablespace 'UNDOTBS1' I am using the following stat...
