Hello,
I'm trying to insert a word doc into the database as a long raw. I'm not using Blob's because I can't return them correctly for the users with the application that we use.
I was ...
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...
is there a way to find out ORACLE_HOME directory
using just SQL commands?
I m using Oracle 8i and win2000
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...
I wiped my hard drive and reinstalled Oracle 9i and Toad on my windows xp laptop. I tried to connect to 2 of several remote databases and received the following error in Toad:
ORA-12514: TN...
As you can see below heavy wait times on actually everything not sure where to start on this one, can anybody point me in the right direction?
Event Total waits Waits/s % total Total wait t...
Hi,
Working Oracle 9 & Linux Red Hat. I cannot access any TEM partitions & the above error are displayed.
At the same time the SYSTEM ROLLBACK statements display a new extension with a ...
I am creating hot backup script for my oracle database( archive log mode), my script logical as attached, but I do not know how to copy data file when you are in backup mode inside sqlpus, say...
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...
I am installing Oracle 10g on our server as a test and have run into multiple roadblocks.
The OracleCSService doesn't start and I believe I figured out why. The ocssd.exe file that the ser...
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...
Hello,
i was trying to insert new values into a table which has spatial data .i encountered the following problem ..
could anyone help me out with the problem.
SQL> insert...
I am editing a Unix script that logs into the database and executes a sql script in a certain directory. Rather than execute this sql script I want to be able to run sql statement within the u...
There is some debate on using PL/SQL function calls inside SQL Queries. Despite of the fact that the Explain Plan functionality ignores PL/SQL function calls and that the function calling mec...
I am writing a package to process data into a schema and a requirement to store a timestamp as "no of seconds since 01/01/1970 UCT time" has surfaced.
I am not aware of any packaged procedure...
i want to run a report. for this i create a report object (named report42) pointing towards the "academic_calendar.rdf" report
Now when i use the Run_report_object command in the code
...
Hello,
I need to present date differences (interval?) in years, months, and days instead of just days. I'm looking to do this in simple SQL (instead of Java, PL/SQL, etc.) on the other han...
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 initially installed Oracle 8i Personal Edition and it works fine.
Now, when I install , Oracle Discover Desktop Edition,
if I select the location as ORAHOME81,
it says "the location c:\o...
Hi, All:
Now I want to upgrade from Oracle 8.1.7 to 9.2.0. How and where can I get some documents about this task, especially about the usage of DBUA tools?
Now, I have Oracle 8i install...
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...
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...
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...
A report should count some entries by week since beginning of year. To simplify
the question let's assume that the first calendar week starts on Jan 1. The way
I put it together is more or...
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: ...
