Hi friends
I need help related to procedure returning ref_cursor. I want to perform minus operation between two procedure return ref cursor to find difference.
example :
select pkg_emp.get...
http://www.experts-exchange.com/Database/Oracle/Q_23252044.html
How will I recover the following:
Oracle 9.2.0.5 database.
Backup steps..
1. Alter system switch logfile;
2. ALTER DATABASE BACKUP CONTROLFILE TO $ctrlbck'
3. All tablespaces but into ho...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23456848.html
Zones:
Oracle 9.xDate Answered: 06/16/2008 Grade: A Views: 29
Hello all,
I am having problems with the growth of indexes in my database... one of my index tablespace lose 30MB+ data on daily basis and this is not normal.. .this rate is accelerating... i disc...
http://www.experts-exchange.com/Database/Oracle/Q_23318471.html
I have a simple query bringing data from a huge table ord_order_services and a small table gen_items
select *
from ord_order_services s, gen_items g
where s.item_no = g.item_no and
g.p...
http://www.experts-exchange.com/Database/Oracle/Q_23358698.html
I have a select query which currently has the RULE hint. It runs fast. I am trying to move to the CBO and
I have run dbms_stats on the tables in this query.
With the RULE hint, the optimiser use...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23556731.html
Zones:
Oracle 9.xDate Answered: 07/11/2008 Grade: A Views: 0
I have a 9.2.0.5 live db on a Sunfire v440. Ultimately I need to get this to 10g but I view this as something that will take quite some time planning and testing. In the meantime I would like to pu...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23585756.html
Hi All,
I have a database.. which is growing.. .sometimes i get performance issues also, i was wondering if rebuilding large tables will benefit in this situation..
I rebuilt selected tables...
http://www.experts-exchange.com/Database/Oracle/Q_23343974.html
Hello,
I have strange behavior with select and update statment.
WHen i run the update statment:
::SEE UPDATE SCRIPT::
If i run the select statment...with the same condetion and values i g...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23898181.html
Zones:
PL / SQLDate Asked: 11/12/2008 Points: 200 Comments: 4
