I am running a query to create a list of nodes in my database. The data is currently only being pulled from 2 tables. Here is the current query:
SELECT lpad(' ',4*(level-1))||case when nl.n...
Six months ago TSM was setup and installed and RMAN setup to backup database by consultant. Recently been attempting to learn more about how it all works and to ensure that the backups were ac...
Suppose I have a dB that is currently running on an HP/UX machine, for which I have hot and cold backups. Those backup sets contain the necessary DBF files, control files and archive log file...
Hi Gurus,
I want to create a view in Oracle which will get data by calling a fuction named "Comment". Comment has four columns in it and I want the exact same columns in my view.
Please help...
Hi Experts,
I'm trying to understand the pstack output. Below the pstack run on the oracle listener process.
Could please explain me in understanding this in detail....
[oracle@tes...
I have to merge 2 columns from different tables having similar values in a single column.
The columns can have equal values or a null and a value.
When they have equal values the new column ...
Hi,
How identify and resolve fragmentation for
1. table spaces
2. tables
3. indexes
Thanks.
With the following code, Identify gaps in data
Data Given:
RecordID BeginDate EndDate Type
1 1/1/1900 3/3/2003 ...
I have Oracle 9.2.0.8 Standard version so using dataguard is not supported.
I believe I can create a physical Standby database without dataguard at least that is what I see on Metalink. What...
Hi!
We are currently running PeopleSoft EnterpriseOne Version 8.10 on a Sun Solaris 9 (SPARC 64-bit) operating system. We currently have Oracle 9i (9.2.0.1.0) Enterprise Edition installed o...
Hello, I have installed a database with 250 sessions specified in the init file.
I still see a lot of inactive sessions in the database once in a while.
I would like to kill/terminate any se...
Hello -
Can someone please send me a link to where I can find out where we are at with
our current patch level on Oracle database 9i?
Oracle9i Enterprise Edition - 9.2.0.5.0
Thank you.
very urgent
i am using an oracle procedure that have an out parameter of sys_refCursor, BUT i need to order the data with in the cursor by one of the attributes in the cursor. How can this ...
SQL> select distinct object_type from user_objects;
OBJECT_TYPE
------------------
DATABASE LINK
FUNCTION
INDEX
PACKAGE
PACKAGE BODY
PROCEDURE
SEQUENCE
TABLE
TRIGGER
VIEW
desc...
I have an ORACLE query for tuning which is taking a lot of time in the server. I have tried various hints like INDEX, USE_NL, ORDERED etc. but that wouldn't prove to be benificial.Can anyboy ...
I have issued the following query
select last_ddl_time,owner,object_name
from dba_objects
where last_ddl_time > '23-jul-07'
order by last_ddl_time,owner,object_name;
It shows me th...
I need some help for connect a ORACLE Database (version 9i) using ODBC. I get some connection strings for testing a program which connects to a ORACLE Database for update some tables in 2 diff...
I have a web application written in asp connecting to Oracle database, once in a while system will receive this error msg, ORA-12545: Connect failed because target host or object does not exis...
WHAT is the difference between WHEN-NEW-FORM-INSTANCE and PRE_FORM triggers?
While installing oracle 9i, I am getting "Thread: not a zip file (end header not found)" in between, I found this thread while searching in google but did not get the solution, can some one su...
Hi
i have a form was build on Oracle Form Builder 6i , and i have a procedure on the database , and i have a Database link...
now when i try to run that procedure on the SQL Plus ,,, it runs...
Hi,
I have never done oracle backup and restore. How do I Backup oracle database and restore it whith a different name?
Hello experts:
I have a oracle database that is 118,110.0 Mb in size:
DATABASE SIZE
Data Mb Temp Mb Redo Mb Total Mb ...
Hi, gurus
I need to assign a date value 01/01/1900 to replace many invalide dates among 50 columns of an Oracle table. All columns are with date data type, and they have invalid date such as ...
Guys,
I am using the Oracle TIMING function to time how long a bunch of queries take to run, like so.
timing start
query 1
query 2
query 3
query 4
timing stop
This works ...
